团购网站系统说明书(10)

using (tgNetEntities3 en = new tgNetEntities3()) {

int j = en.tgNetBLogInfo.Where(n => n.buyerID == i).Count(); if(j != 0) {

var sel = en.tgNetBLogInfo.Where(n => n.buyerID == i).First(); sel.upsw = s; en.SaveChanges(); } } }

[OperationContract]

public void ModifySellerPasswod(int i, string s) {

using (tgNetEntities3 en = new tgNetEntities3()) {

int j = en.tgNetSLogInfo.Where(n => n.sellerID == i).Count(); if (j != 0) {

var sel = en.tgNetSLogInfo.Where(n => n.sellerID == i).First(); sel.upsw = s; en.SaveChanges(); } } }

[OperationContract]

public void ModifyBuyerInf(int i, string a,string b,string c,string d) {

using (tgNetEntities3 en = new tgNetEntities3()) {

int j = en.tgNetBLogInfo.Where(n => n.buyerID == i).Count(); if(j != 0) {

var sel = en.tgNetBLogInfo.Where(n => n.buyerID == i).First(); //sel.upsw = s; sel.bname = b; sel.bphone = c; sel.brealname = d; sel.uemail = a; en.SaveChanges(); } } }

[OperationContract]

46

public void ModifySellInf(int i, string a, string b, string c) {

using (tgNetEntities3 en = new tgNetEntities3()) {

int j = en.tgNetSLogInfo.Where(n => n.sellerID == i).Count(); if (j != 0) {

var sel = en.tgNetSLogInfo.Where(n => n.sellerID == i).First(); //sel.upsw = s; sel.sname = b; sel.sphone = c; //sel.brealname = d; sel.uemail = a; en.SaveChanges(); } } }

[OperationContract] public DateTime GetTime() {

DateTime ServiceTime = DateTime.Now; return ServiceTime; }

[OperationContract]

public void SetBSInf(int i)//设置购物信息表 {

//List BS = new List(); using (tgNetEntities3 en = new tgNetEntities3()) {

//var sel = en.tgNetBCar.Sum(n=>n.tgprc);

var sel = en.tgNetBCar.Where(n => n.buyerID == i); foreach (var e in sel) {

tgNetBSInfo bs = new tgNetBSInfo(); //tgBSInfo bs = new BSInfo(); bs.buyerID = (int)e.buyerID; bs.pname = e.pname; bs.prc = (float)e.prc; bs.tgprc = (float)e.tgprc; //bs.pdisc = e.pdisc;. //BS.Add(bs);

en.AddTotgNetBSInfo(bs); en.SaveChanges();

47

}

} }

[OperationContract]

public bool AddPrd(tgNetBCarsType s,int i) {

using (tgNetEntities3 en = new tgNetEntities3()) {

//int count = en.tgNetBCar.Where(n => n.pid == s.tpid).Where(n => n.buyerID == s.tbuyerID).Count(); //if (count != 0) //{

// return false; //}

tgNetBCar st = new tgNetBCar(); st.pname = s.tpname;

st.photoPath = s.tphotoPath; st.pnum = s.tpnum; st.prc = s.tprc; st.seller = s.tseller; st.sellerID = s.tsellerID; st.tgprc = s.ttgprc; st.buyerID = s.tbuyerID; st.pid = s.tpid; st.pdisc = s.tpdisc; en.tgNetBCar.AddObject(st);

//var a = en.tgNetTgInfo.Where(n => n.pid == s.tpid).First(); //a.tgRealNum = a.tgRealNum + 1; en.SaveChanges();

var sel = en.tgNetBLogInfo.Where(n => n.buyerID == i).First(); //加入交易记录表a

tgNetBSInfo bs = new tgNetBSInfo(); bs.buyerID = s.tbuyerID; bs.pname = s.tpname; bs.prc = s.tprc; bs.tgprc = s.ttgprc; bs.sellerID = s.tsellerID; bs.bgrade = sel.bgrade; bs.pnum = 1; bs.sgrade = 0;

en.AddTotgNetBSInfo(bs); en.SaveChanges(); return true;

48

} }

[OperationContract]

public List GetPrd(string a) {

List list = new List(); using (tgNetEntities3 en = new tgNetEntities3()) {

foreach (var e in en.tgNetPrd) {

if (e.parea == a) {

tgNetPrdType p = new tgNetPrdType(); p.spid = e.pid; p.spname = e.pname; p.sprc = (float)e.prc; p.spsize = e.psize; p.sptgnum = (int)e.ptgnum; p.spremark = e.premark; p.sseller = e.seller;

p.tsellerid = (int)e.sellerID; p.stgprc = (float)e.tgprc;

p.spDownTime = (DateTime)e.pDnTime; p.sphotoPath = e.photoPath; p.spUpTime = (DateTime)e.pUpTime; p.tpdisc = e.pdisc; list.Add(p); } } }

return list; }

[OperationContract]

public List GetProvince() {

List list = new List();

using (tgNetEntities3 en = new tgNetEntities3()) {

foreach (var e in en.tgNetPro) {

list.Add(e.pvcName); }

return list;

49

} }

[OperationContract]

public List GetCity(int r) {

List list = new List();

using (tgNetEntities3 en = new tgNetEntities3()) {

foreach (var e in en.tgNetCity) {

if (r == e.pvcID) {

list.Add(e.cityName); } }

return list; } }

[OperationContract]

public List GetPrdData() {

List list = new List(); using (tgNetEntities3 en = new tgNetEntities3()) {

foreach (var e in en.tgNetPrd) {

tgNetPrdType st = new tgNetPrdType(); st.spid = e.pid;

st.ttgRealNum = (int)(en.tgNetTgInfo.First().tgRealNum); st.spname = e.pname; st.spnum = (int)e.pnum; st.sprc = (float)e.prc; st.sptgnum = (int)e.ptgnum; st.spsize = e.psize; st.sptgnum = (int)e.ptgnum; st.tsellerid = (int)e.sellerID; st.sptype = e.ptype;

st.spUpTime = (DateTime)e.pUpTime; st.stgprc = (float)e.tgprc;

st.spDownTime = (DateTime)e.pDnTime; st.spremark = e.premark; st.sseller = e.seller; st.tpdisc = e.pdisc;

st.sphotoPath = e.photoPath;

50