public static ArrayList QueryMaterialListCategoryByBdcode(string btype, string mpcode) { ArrayList r = new ArrayList(); Sys_MaterialCategoryBll sub = new Sys_MaterialCategoryBll(); T_StatisticsBll tsb = new T_StatisticsBll(); List <Sys_MaterialCategory> lsr = new List <Sys_MaterialCategory>(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); lsr = sub.QueryList(" and mcpcode='" + mpcode + "' and dcode='" + iv.u.dcode.Substring(0, 8) + "'"); if (lsr != null) { foreach (Sys_MaterialCategory s in lsr) { ArrayList al = new ArrayList(); if (tsb.BaseExists("Sys_RBrandsMaterial", " and pbcode='" + btype + "' and mpcode like'" + s.mccode + "%' ")) { al.Add(s.mccode); al.Add(s.mcname); al.Add(s.mcstate); r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList CustQueryListMaterialCategoryByType(string mtype, string mpcode) { ArrayList r = new ArrayList(); Sys_MaterialCategoryBll sub = new Sys_MaterialCategoryBll(); List <Sys_MaterialCategory> lsr = new List <Sys_MaterialCategory>(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); lsr = sub.QueryList(" and mtype='" + mtype + "' and mcpcode='" + mpcode + "' and dcode='" + iv.u.dcode.Substring(0, 8) + "'"); if (lsr != null) { foreach (Sys_MaterialCategory s in lsr) { ArrayList al = new ArrayList(); al.Add(s.mccode); al.Add(s.mcname); al.Add(s.mcstate); r.Add(al); } } } else { r.Add(iv.badstr); } return(r); }
public static string SaveMaterialCategory(string btype, string mcode, string mname, string mid, string mpcode, string mpname, string mtype) { string r = ""; Sys_MaterialCategoryBll sub = new Sys_MaterialCategoryBll(); Sys_MaterialCategory smc = new Sys_MaterialCategory(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { smc.mccode = mcode; smc.mcpcode = mpcode; smc.mcname = mname; smc.mcpname = mpname; smc.maker = iv.u.ename; smc.cdate = DateTime.Now.ToString(); smc.mtype = mtype; smc.btype = btype; if (iv.u.rcode != "xtgl") { smc.dcode = iv.u.dcode.Substring(0, 8); } else { smc.dcode = ""; } if (mid == "0") { if (sub.Add(smc) > 0) { r = "S"; } else { r = "F"; } } else { if (sub.Update(smc)) { r = "S"; } else { r = "F"; } } } else { r = iv.badstr; } return(r); }
public static string InitMaterial(string mccode, string mcode) { string r = ""; Sys_MaterialBll smb = new Sys_MaterialBll(); Sys_MaterialCategoryBll smcb = new Sys_MaterialCategoryBll(); Sys_Material sm = new Sys_Material(); Sys_MaterialCategory smc = new Sys_MaterialCategory(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { smc = smcb.Query(" and mccode='" + mccode + "'"); if (mcode == "") { if (smc != null) { sm.mccode = smc.mccode; sm.mcname = smc.mcname; } else { sm.mccode = ""; sm.mcname = ""; } sm.mcode = mccode + smb.CreateCode(mccode).ToString().PadLeft(3, '0'); sm.mname = ""; sm.mstate = true; sm.id = 0; } else { sm = smb.Query(" and mcode='" + mcode + "'"); } r = js.Serialize(sm); } else { r = iv.badstr; } return(r); }
public static string DelMaterialCategory(string mcode) { string r = ""; Sys_MaterialCategoryBll sdb = new Sys_MaterialCategoryBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { if (sdb.Delete(mcode)) { r = "S"; } else { r = "F"; } } else { r = iv.badstr; } return(r); }