public JsonResult InitAccount(string dcode, string acode) { JsonData d = new JsonData(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sbk_Account sal = new Sbk_Account(); if (acode != "") { sal = sab.Query(" and acode='" + acode + "'"); } else { Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'"); sal.id = 0; sal.dcode = sd == null ? "" : sd.dcode; sal.dname = sd == null ? "" : sd.dname; sal.acode = sab.CreateCode().ToString().PadLeft(4, '0'); sal.aname = "A" + DateTime.Now.ToString("yyyyMMdd") + sal.acode; } d.d = js.Serialize(sal); } else { d.d = iv.badstr; } return(Json(d)); }
public JsonResult SetCredit(string acode, string aname, string cnum) { JsonData d = new JsonData(); string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sbk_Account sal = sab.Query(" and acode='" + acode + "'"); if (sal != null) { decimal unum = Convert.ToDecimal(cnum) - sal.credit; if (sab.SetCredit(acode, unum)) { r = "S"; } else { r = "F"; } } else { r = "F"; } } else { r = iv.badstr; } d.d = r; return(Json(d)); }
public static ArrayList QueryPayOrderList(string account, string bdate, string edate) { ArrayList r = new ArrayList(); StringBuilder where = new StringBuilder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); if (bdate != null) { where.AppendFormat(" and cdate>='{0}'", CommonBll.GetBdate(bdate)); } else { where.AppendFormat(" and cdate>='{0}'", CommonBll.GetBdate()); } if (edate != null) { where.AppendFormat(" and cdate<'{0}'", CommonBll.GetEdate(edate)); } else { where.AppendFormat(" and cdate<'{0}'", CommonBll.GetEdate()); } if (account != "") { where.AppendFormat(" and sacode='{0}'", account); } where.AppendFormat(" order by cdate desc"); List <B_ExchangeRecord> blr = barb.QueryList(where.ToString()); if (blr != null) { foreach (B_ExchangeRecord ba in blr) { ArrayList al = new ArrayList(); Sbk_Account sa = sab.Query(" and acode='" + ba.sacode + "'"); al.Add(ba.sacode); al.Add(sa != null?sa.aname:""); al.Add(ba.oscode); al.Add(ba.otype); al.Add(ba.emoney); al.Add(ba.umoney); al.Add(ba.cdate); r.Add(al); } } } else { r.Add(iv.badstr); } return(r); }
public JsonResult SavePAccount(string id, string pbank, string pbcode, string pcode, string pperson, string pname, string sacode, string telephone) { JsonData d = new JsonData(); Sbk_PaymentAccount sa = new Sbk_PaymentAccount(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sbk_Account ska = skb.Query(" and acode='" + sacode + "'"); sa.pname = pname; sa.pcode = pcode; sa.pbank = pbank; sa.pbcode = pbcode; sa.pperson = pperson; sa.sacode = sacode; sa.saname = ska.aname; sa.dcode = iv.u.dcode; sa.telephone = telephone; sa.maker = iv.u.ename; sa.cdate = DateTime.Now.ToString(); if (id == "0") { if (sab.Add(sa) > 0) { d.d = "S"; } else { d.d = "F"; } } else { sa.id = Convert.ToInt32(id); if (sab.Update(sa)) { d.d = "S"; } else { d.d = "F"; } } } else { d.d = iv.badstr; } return(Json(d)); }
public JsonResult SaveAccount(string acode, string aname, string atype, string dcode, string dname, string id, string manager, string telephone) { JsonData d = new JsonData(); Sbk_Account sa = new Sbk_Account(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { sa.acode = acode; sa.aname = aname; sa.atype = atype; sa.dcode = dcode; sa.dname = dname; sa.manager = manager; sa.telephone = telephone; sa.maker = iv.u.ename; sa.cdate = DateTime.Now.ToString(); if (id == "0") { if (sab.Add(sa) > 0) { d.d = "S"; } else { d.d = "F"; } } else { if (sab.Update(sa)) { d.d = "S"; } else { d.d = "F"; } } } else { d.d = iv.badstr; } return(Json(d)); }