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