public static ArrayList QueryListMsInventoryCategory(string mscode, string ipcode) { ArrayList r = new ArrayList(); Sys_InventoryCategoryBll sub = new Sys_InventoryCategoryBll(); Sys_AssortBll sab = new Sys_AssortBll(); List <Sys_InventoryCategory> lsr = new List <Sys_InventoryCategory>(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); if (sab.ExistMsBl(mscode, ipcode + "___")) { lsr = sub.QueryList(" and icpcode='" + ipcode + "' and iccode in ( select blcode from Sys_RMsBl where mcode='" + mscode.Substring(0, mscode.Length - 3) + "' and blcode like '" + ipcode + "___') order by isort"); if (lsr != null) { foreach (Sys_InventoryCategory s in lsr) { ArrayList al = new ArrayList(); al.Add(s.iccode); al.Add(s.icname); al.Add(s.icstate); r.Add(al); } } } else { lsr = sub.QueryList(" and icpcode='" + ipcode + "' order by isort"); if (lsr != null) { foreach (Sys_InventoryCategory s in lsr) { ArrayList al = new ArrayList(); al.Add(s.iccode); al.Add(s.icname); al.Add(s.icstate); r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }
public static ArrayList QueryMsRefBlCate(string mscode, string blcode) { ArrayList r = new ArrayList(); Sys_InventoryDetailBll sib = new Sys_InventoryDetailBll(); Sys_InventoryCategoryBll sub = new Sys_InventoryCategoryBll(); List <Sys_InventoryCategory> plsr = new List <Sys_InventoryCategory>(); List <Sys_InventoryCategory> lsr = new List <Sys_InventoryCategory>(); List <Sys_InventoryCategory> lr = new List <Sys_InventoryCategory>(); Sys_AssortBll sab = new Sys_AssortBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); lsr = sub.QueryList(" and iccode='" + blcode + "' order by isort"); plsr = sub.QueryList(" and icpcode='" + blcode + "' order by isort"); if (plsr != null) { lr = plsr; } else { lr = lsr; } if (lr != null) { foreach (Sys_InventoryCategory s in lr) { ArrayList al = new ArrayList(); al.Add(s.iccode); al.Add(s.icname); al.Add(s.icstate); if (sib.Exists(" and icode like '" + s.iccode + "%'")) { if (sab.ExistMsBl(" and bcode like '" + s.iccode + "%' and mcode='" + mscode.Substring(0, mscode.Length - 3) + "'")) { r.Add(al); } } } } } else { r.Add(iv.badstr); } return(r); }