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