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));
}
