if (j != 0) {
var sel = en.tgNetBSInfo.Where(n => n.buyerID == i); foreach (var e in sel) {
TradeInfType st = new TradeInfType(); st._listID = e.listID; st._pnum = (int)e.pnum; st._pname = e.pname; st._prc = (float)e.prc; //st._seller = e.seller; //st._pdisc = e.p
//st._photoPath = e.photoPath; st._tgprc = (float)e.tgprc; list.Add(st); }
return list; } else {
return null; } } }
[OperationContract]
public void AddCommList(int i, int j,int l)//将?sellerID、?ébuyerID和¨alistID填??充?到ì?评¨¤论?表à¨a中D {
using (tgNetEntities3 en = new tgNetEntities3()) {
tgNetComm comm = new tgNetComm(); comm.buyerID = i; comm.sellerID = j; comm.listID = l; //comm.commContent = s; //comm.mark = int.Parse(t); en.AddTotgNetComm(comm); en.SaveChanges(); } }
[OperationContract]
public void AddComm(int i,string s,string t) {
41
using (tgNetEntities3 en = new tgNetEntities3()) {
int j = en.tgNetComm.Where(n => n.listID == i).Count(); if (j != 0) {
var comm = en.tgNetComm.Where(n => n.listID == i).First(); //tgNetComm comm = new tgNetComm(); //comm.buyerID = c.buyerid; //comm.sellerID = c.sellerid; comm.commContent = s; comm.mark = t;
//en.AddTotgNetComm(comm); en.SaveChanges(); } } }
[OperationContract]
public string GetRestMoney(int i) {
using (tgNetEntities3 en = new tgNetEntities3()) {
//var sel = en.tgNetBCar.Sum(n=>n.tgprc);
int j = en.tgNetBCar.Where(n => n.buyerID == i).Count(); if (j != 0) {
var sel = en.tgNetBCar.Where(n => n.buyerID == i); int s = (int)sel.Sum(n => n.tgprc);
var sel_1 = en.tgNetBSInfo.Where(n => n.buyerID == i).First(); int r = (int)sel_1.bgrade; sel_1.sgrade += s; sel_1.bgrade = r - s;
//en.AddTotgNetBSInfo(sel_1); en.SaveChanges();
string t = (r - s).ToString(); return t; } else {
return null; } } }
[OperationContract]
42
public string GetBGrade(int i) {
using (tgNetEntities3 en = new tgNetEntities3()) {
//var sel = en.tgNetBCar.Sum(n=>n.tgprc);
//var sel = en.tgNetBCar.Where(n => n.buyerID == i); //int s = (int)sel.Sum(n => n.tgprc);
int j = en.tgNetBSInfo.Where(n => n.buyerID == i).Count(); if (j != 0) {
var sel_1 = en.tgNetBSInfo.Where(n => n.buyerID == i).First(); int r = (int)sel_1.bgrade; //string t = (r - s).ToString(); return r.ToString(); } else {
return null; } } }
[OperationContract]
public string GetBuyerCom(int i)//显?示o?买¨°家¨°的ì?评¨¤论? {
using (tgNetEntities3 en = new tgNetEntities3()) {
//var sel = en.tgNetBCar.Sum(n=>n.tgprc);
//var sel = en.tgNetBCar.Where(n => n.buyerID == i); //int s = (int)sel.Sum(n => n.tgprc);
int j = en.tgNetComm.Where(n => n.buyerID == i).Count(); if (j != 0) {
var sel_1 = en.tgNetComm.Where(n => n.buyerID == i).First(); return sel_1.commContent; } else {
return null; } } }
[OperationContract]
43
public string GetSellerCom(int i)//显示卖家的评论 {
using (tgNetEntities3 en = new tgNetEntities3()) {
//var sel = en.tgNetBCar.Sum(n=>n.tgprc);
//var sel = en.tgNetBCar.Where(n => n.buyerID == i); //int s = (int)sel.Sum(n => n.tgprc);
int j = en.tgNetSResponce.Where(n => n.sellerID == i).Count(); if (j != 0) {
var sel_1 = en.tgNetSResponce.Where(n => n.sellerID == i).First(); return sel_1.commContent; } else {
return null; } } }
[OperationContract]//充?值|ì
public void SetBGrade(int i,float f) {
using (tgNetEntities3 en = new tgNetEntities3()) {
//var sel = en.tgNetBCar.Sum(n=>n.tgprc);
//var sel = en.tgNetBCar.Where(n => n.buyerID == i); //int s = (int)sel.Sum(n => n.tgprc);
var sel_1 = en.tgNetBSInfo.Where(n => n.buyerID == i).First(); sel_1.bgrade = f; en.SaveChanges(); } }
//[OperationContract]//充?值|ì
//public void SetBGrade(int i, float f) //{
// using (tgNetEntities3 en = new tgNetEntities3()) // {
// //var sel = en.tgNetBCar.Sum(n=>n.tgprc);
// //var sel = en.tgNetBCar.Where(n => n.buyerID == i); // //int s = (int)sel.Sum(n => n.tgprc);
// var sel_1 = en.tgNetBSInfo.Where(n => n.buyerID == i).First(); // sel_1.bgrade = f; // en.SaveChanges();
44
// } //}
[OperationContract]
public void AddTradeInf(int i, string s) {
using (tgNetEntities3 en = new tgNetEntities3()) {
//tgNetComm comm = new tgNetComm(); //tgNetBSInfo b = new tgNetBSInfo(); //tgNetBCar c = new tgNetBCar();
int a = en.tgNetBCar.Where(n => n.buyerID == i).Count(); int b = en.tgNetBSInfo.Where(n => n.buyerID == i).Count();
if (a != 0) {
if (b != 0) {
var sel = en.tgNetBCar.Where(n => n.buyerID == i).First(); var sel_1 = en.tgNetBSInfo.Where(n => n.buyerID == i).First(); //tgNetBSInfo sel_1 = new tgNetBSInfo(); //TradeInfType sel_1; sel_1.baddress = s;
//sel_1.bgrade = sel_1.bgrade; sel_1.pname = sel.pname; sel_1.pnum = (int)sel.pnum; sel_1.prc = (float)sel.prc; sel_1.tgprc = (float)sel.tgprc; sel_1.buyerID = sel.buyerID; sel_1.sellerID = sel.sellerID; //sel.status = \已°?购o买¨°\ //en.AddTotgNetBSInfo(sel_1);
var sel_2 = en.tgNetBCar.Where(n => n.buyerID == i); foreach (var e in sel_2) {
e.status = \已购买\; }
en.SaveChanges(); } } } }
[OperationContract]
public void ModifyPasswod(int i,string s) {
45