public static ArrayList QueryList(string ptcode) { ArrayList r = new ArrayList(); Sys_AgentFeeBll srb = new Sys_AgentFeeBll(); List <Sys_AgentFee> lsf = new List <Sys_AgentFee>(); Sys_InventoryCategoryBll sicb = new Sys_InventoryCategoryBll(); Sys_DepmentBll sdb = new Sys_DepmentBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); lsf = srb.QueryList(" and acode='" + ptcode + "'"); if (lsf != null) { foreach (Sys_AgentFee s in lsf) { ArrayList al = new ArrayList(); Sys_InventoryCategory sic = sicb.Query(" and iccode='" + s.icode + "'"); Sys_Depment dt = sdb.Query(" and dcode='" + s.acode + "'"); al.Add(s.id); al.Add(dt == null?"":dt.dname); al.Add(sic == null?"":sic.icname); al.Add(s.fmoney); al.Add(s.tfmoney); r.Add(al); } } } else { r.Add(iv.badstr); } return(r); }
public static string SaveFee(string ptcode, string pcode, string fff, string fid, string tfff) { string r = ""; Sys_AgentFeeBll srb = new Sys_AgentFeeBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_AgentFee sr = new Sys_AgentFee(); sr.acode = ptcode; sr.icode = pcode; sr.fmoney = Convert.ToInt32(fff); sr.cdate = DateTime.Now.ToString(); sr.tfmoney = Convert.ToInt32(tfff); sr.maker = iv.u.ename; if (fid == "0") { if (!srb.Exists(" and acode='" + ptcode + "' and icode='" + pcode + "'")) { if (srb.Add(sr) > 0) { r = "S"; } else { r = "F"; } } else { r = "T"; } } else { sr.id = Convert.ToInt32(fid); if (srb.Update(sr)) { r = "S"; } else { r = "F"; } } } else { r = iv.badstr; } return(r); }
public static string GetProduceFee(string ptcode, string pcode) { string r = ""; Sys_AgentFeeBll srb = new Sys_AgentFeeBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r = srb.GetProductionFee(ptcode, pcode); } else { r = iv.badstr; } return(r); }
public static string InitFee(string ptcode, string pcode, string id) { string r = ""; Sys_AgentFee sr = new Sys_AgentFee(); Sys_AgentFeeBll srb = new Sys_AgentFeeBll(); Sys_InventoryCategoryBll sicb = new Sys_InventoryCategoryBll(); Sys_DepmentBll sdb = new Sys_DepmentBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_InventoryCategory ic = new Sys_InventoryCategory(); Sys_Depment dt = new Sys_Depment(); if (id == "0" || id == "") { ic = sicb.Query(" and iccode='" + pcode + "'"); dt = sdb.Query(" and dcode='" + ptcode + "'"); sr.acode = ptcode; sr.aname = dt.dname; sr.iname = ic.icname; sr.icode = pcode; sr.id = 0; r = js.Serialize(sr); } else { sr = srb.Query(" and id=" + id + ""); sr.iname = sicb.Query(" and iccode='" + sr.icode + "'").icname; sr.aname = sdb.Query(" and dcode='" + sr.acode + "'").dname; r = js.Serialize(sr); } } else { r = iv.badstr; } return(r); }
public static string DelFee(string fid) { string r = ""; Sys_AgentFeeBll srb = new Sys_AgentFeeBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { if (srb.Delete(" and id=" + fid + "")) { r = "S"; } else { r = "F"; } } else { r = iv.badstr; } return(r); }