public string RecordOrderInfo(int shopid, int userid, string orderno, string comsumer, string itemno, int siteid, double price, double amount, double total, string itemurl) { wgiAdUnionSystem.Model.wgi_orders model = new wgiAdUnionSystem.Model.wgi_orders(); model.cash = Convert.ToDecimal(total); model.companyid = shopid; model.consumer = comsumer; model.ischeck = 0; model.itemamount = Convert.ToDecimal(amount); model.itemno = itemno; model.itemprice = Convert.ToDecimal(price); //model.orderid = orderid; model.orderno = orderno; model.reason = ""; model.siteid = siteid; model.time = DateTime.Now;//或传入 model.userid = userid; //计算佣金 model.pay = Convert.ToDecimal(22); //添加订单记录 new wgiAdUnionSystem.BLL.wgi_orders().Add(model); //把佣金计入广告主 wgiAdUnionSystem.BLL.wgi_sitehost bll = new wgiAdUnionSystem.BLL.wgi_sitehost(); wgiAdUnionSystem.Model.wgi_sitehost host= bll.GetModel(userid); decimal newBlance= Convert.ToDecimal(host.balance) + Convert.ToDecimal(model.pay); bll.UpdateBlance(userid, newBlance); return newBlance.ToString(); }
/// <summary> /// ��������б� /// </summary> public List<wgiAdUnionSystem.Model.wgi_orders> DataTableToList(DataTable dt) { List<wgiAdUnionSystem.Model.wgi_orders> modelList = new List<wgiAdUnionSystem.Model.wgi_orders>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { wgiAdUnionSystem.Model.wgi_orders model; for (int n = 0; n < rowsCount; n++) { model = new wgiAdUnionSystem.Model.wgi_orders(); if(dt.Rows[n]["orderid"].ToString()!="") { model.orderid=int.Parse(dt.Rows[n]["orderid"].ToString()); } if(dt.Rows[n]["companyid"].ToString()!="") { model.companyid=int.Parse(dt.Rows[n]["companyid"].ToString()); } if(dt.Rows[n]["siteid"].ToString()!="") { model.siteid=int.Parse(dt.Rows[n]["siteid"].ToString()); } model.orderno=dt.Rows[n]["orderno"].ToString(); if(dt.Rows[n]["cash"].ToString()!="") { model.cash=decimal.Parse(dt.Rows[n]["cash"].ToString()); } if(dt.Rows[n]["time"].ToString()!="") { model.time=DateTime.Parse(dt.Rows[n]["time"].ToString()); } model.consumer=dt.Rows[n]["consumer"].ToString(); model.itemno=dt.Rows[n]["itemno"].ToString(); if(dt.Rows[n]["itemprice"].ToString()!="") { model.itemprice=decimal.Parse(dt.Rows[n]["itemprice"].ToString()); } if(dt.Rows[n]["itemamount"].ToString()!="") { model.itemamount=decimal.Parse(dt.Rows[n]["itemamount"].ToString()); } if(dt.Rows[n]["pay"].ToString()!="") { model.pay=decimal.Parse(dt.Rows[n]["pay"].ToString()); } if(dt.Rows[n]["ischeck"].ToString()!="") { model.ischeck=int.Parse(dt.Rows[n]["ischeck"].ToString()); } model.reason=dt.Rows[n]["reason"].ToString(); if(dt.Rows[n]["checktime"].ToString()!="") { model.checktime=DateTime.Parse(dt.Rows[n]["checktime"].ToString()); } modelList.Add(model); } } return modelList; }