public static int shenhe(string djbh, int jine, int gysid) { erpsystemEntities1 xe = new erpsystemEntities1(); var v = from p in xe.t_store_advance where p.Bill_advance == djbh select p; var s = (from p in xe.funds where p.ID == gysid select p).First(); string je = s.CurAdvRecv; var sum = int.Parse(je) + jine; s.CurAdvRecv = sum.ToString(); if (v.Count() > 0) { t_store_advance td = v.First(); td.Audit_status = 1; td.Compound_human_ID = 2; } return(xe.SaveChanges()); }
public static int xz(t_store_advance tsa, List <t_store_advancepay> list) { erpsystemEntities1 xe = new erpsystemEntities1(); tsa.Single_person_ID = 1; xe.t_store_advance.Add(tsa); if (list != null) { int i = 0; foreach (var item in list) { item.Bill_advancepay = tsa.Bill_advance; item.Line_advancepay = ++i; xe.t_store_advancepay.Add(item); } } return(xe.SaveChanges()); }
public static int xg(t_store_advance tsa, List <t_store_advancepay> list) { erpsystemEntities1 xe = new erpsystemEntities1(); var v = (from p in xe.t_store_advance where p.Bill_advance == tsa.Bill_advance select p).First(); v.Document_date = tsa.Document_date; v.Supplier_ID = tsa.Supplier_ID; v.Coin_stop = tsa.Coin_stop; v.Settle_accounts1 = tsa.Settle_accounts1; v.Settle_accounts2 = tsa.Settle_accounts2; v.Money1 = tsa.Money1; v.Money2 = tsa.Money2; v.Exchange_rate = tsa.Exchange_rate; v.Deposit_rate = tsa.Deposit_rate; v.Termination_month = tsa.Termination_month; v.Single_person_ID = tsa.Single_person_ID; v.Compound_human_ID = tsa.Compound_human_ID; v.Audit_status = tsa.Audit_status; var s = from c in xe.t_store_advancepay where c.Bill_advancepay == tsa.Bill_advance select c; if (s.Count() > 0) { foreach (var item in s) { xe.t_store_advancepay.Remove(item); } } if (list != null) { foreach (var item in list) { xe.t_store_advancepay.Add(item); } } return(xe.SaveChanges()); }
public static int xz(t_store_advance tsa, List <t_store_advancepay> list) { return(DAL.KW.CaigouyufuService.xz(tsa, list)); }
public ActionResult xz(t_store_advance tsa, List <t_store_advancepay> list) { return(Json(BLL.KW.CaigouyufuManager.xz(tsa, list), JsonRequestBehavior.AllowGet)); }