public static ArrayList QuerySearingList(string icode, string mname, string pname)
{
ArrayList r = new ArrayList();
Sys_InventoryDetailBll sub = new Sys_InventoryDetailBll();
List <Sys_InventoryDetail> lsr = new List <Sys_InventoryDetail>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
lsr = sub.QueryList(15, " and istate='true' and iccode like '" + icode + "%' and mname='" + mname + "' and iname like '%" + pname + "%'");
if (lsr != null)
{
foreach (Sys_InventoryDetail s in lsr)
{
ArrayList al = new ArrayList();
al.Add(s.icode);
al.Add(s.iname);
al.Add(s.mname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryListCateProduce(string mcode)
{
ArrayList r = new ArrayList();
Sys_InventoryDetailBll sub = new Sys_InventoryDetailBll();
List <Sys_InventoryDetail> lsr = new List <Sys_InventoryDetail>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
lsr = sub.QueryList(" and iccode like'" + mcode + "%'");
if (lsr != null)
{
foreach (Sys_InventoryDetail s in lsr)
{
ArrayList al = new ArrayList();
al.Add(s.icode);
al.Add(s.iname);
al.Add(s.mname);
al.Add(s.iunit);
al.Add(s.isaleprice);
al.Add(s.isupplyprice);
al.Add(s.ipurchaseprice);
al.Add(s.tcprice);
al.Add(s.istate == true ? "启用" : "停用");
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryListItem()
{
ArrayList r = new ArrayList();
Sys_InventoryDetailBll sub = new Sys_InventoryDetailBll();
List <Sys_InventoryDetail> lsr = new List <Sys_InventoryDetail>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
lsr = sub.QueryList(" and istate='true'");
if (lsr != null)
{
foreach (Sys_InventoryDetail s in lsr)
{
ArrayList al = new ArrayList();
al.Add(s.icode);
al.Add(s.iname);
al.Add(s.mname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string GetRefInv(string invcode, string mname)
{
string r = "";
string rcode = "";
Sys_AssortBll srb = new Sys_AssortBll();
Sys_InventoryDetailBll sidb = new Sys_InventoryDetailBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
rcode = srb.GetAssort(invcode.Substring(0, invcode.Length - 3));
if (rcode != "")
{
string[] rv = rcode.Split(';');
Sys_InventoryDetail si = new Sys_InventoryDetail();
Sys_InventoryDetail sid = sidb.Query(" and icode like '" + rv[0] + "%' and mname='" + mname + "'");
if (sid == null)
{
si.icname = "";
si.iccode = "";
}
else
{
si = sid;
}
r = js.Serialize(si);
}
}
else
{
r = 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);
}
public static ArrayList QueryListInventory(string mcode, string plb, string plx)
{
ArrayList r = new ArrayList();
Sys_InventoryDetailBll sub = new Sys_InventoryDetailBll();
Sys_PriceTypeBll srb = new Sys_PriceTypeBll();
List <Sys_InventoryDetail> lsr = new List <Sys_InventoryDetail>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
lsr = sub.QueryList(" and iccode='" + mcode + "' ");
if (lsr != null)
{
foreach (Sys_InventoryDetail s in lsr)
{
ArrayList al = new ArrayList();
decimal[] dprice = new decimal[3];
dprice = srb.GetPrice(plb, s.icode, plx);
al.Add(s.icode);
al.Add(s.iname);
al.Add(s.mname);
al.Add(s.iunit);
if (dprice != null)
{
al.Add(dprice[0]);
al.Add(dprice[1]);
al.Add(dprice[2]);
}
else
{
al.Add(0);
al.Add(0);
al.Add(0);
}
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList CzQueryListInventoryCategory(string ipcode, string mname)
{
ArrayList r = new ArrayList();
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_InventoryDetailBll sidb = new Sys_InventoryDetailBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
lsr = sub.QueryList(" and iccode='" + ipcode + "' order by isort");
plsr = sub.QueryList(" and icpcode='" + ipcode + "' 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 (sidb.Exists(" and icode like '" + s.iccode + "%' and mname='" + mname + "'"))
{
r.Add(al);
}
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string InitInventory(string iccode, string icode)
{
string r = "";
Sys_InventoryDetail sid = new Sys_InventoryDetail();
Sys_InventoryDetailBll sidb = new Sys_InventoryDetailBll();
Sys_InventoryCategory sic = new Sys_InventoryCategory();
Sys_InventoryCategoryBll sicb = new Sys_InventoryCategoryBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
sic = sicb.Query(" and iccode='" + iccode + "'");
if (icode == "")
{
if (sic != null)
{
sid.iccode = sic.iccode;
sid.icname = sic.icname;
sid.iname = sic.icname;
}
else
{
sid.iccode = "";
sid.icname = "";
sid.iname = "";
}
sid.icode = iccode + sidb.CreateCode(iccode).ToString().PadLeft(3, '0');
sid.istate = true;
sid.id = 0;
}
else
{
sid = sidb.Query(" and icode='" + icode + "'");
}
r = js.Serialize(sid);
}
else
{
r = iv.badstr;
}
return(r);
}
public static string DelInventory(string icode)
{
string r = "";
Sys_InventoryDetailBll sdb = new Sys_InventoryDetailBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (sdb.Delete(" and icode='" + icode + "'"))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SetState(string plcode, string t)
{
string r = "";
Sys_InventoryDetailBll sdb = new Sys_InventoryDetailBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
string[] clist = plcode.Split(';');
if (sdb.SetState(clist, t) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SetPrice(string cgp, string ghp, string pcodelist, string plx, string tcp, string xsp)
{
string r = "";
Sys_InventoryDetailBll sdb = new Sys_InventoryDetailBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
string [] clist = pcodelist.Split(';');
if (sdb.SetPrice(clist, plx, xsp, ghp, cgp, tcp) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static ArrayList BatchSaveInventory(string iccode, string plmname, string plsize, string pltype, string plunit)
{
ArrayList r = new ArrayList();
Sys_InventoryDetailBll sidb = new Sys_InventoryDetailBll();
Sys_MaterialBll sub = new Sys_MaterialBll();
List <Sys_Material> lsr = new List <Sys_Material>();
Sys_InventoryCategoryBll sicb = new Sys_InventoryCategoryBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
List <Sys_InventoryCategory> als = new List <Sys_InventoryCategory>();
List <Sys_InventoryDetail> lsid = new List <Sys_InventoryDetail>();
string[] iarr = iccode.Split(';');
if (iarr.Length > 0)
{
foreach (string icv in iarr)
{
List <Sys_InventoryCategory> lic = sicb.QueryList(" and iccode like '" + icv + "%' and icstate='true'");
if (lic != null)
{
foreach (Sys_InventoryCategory sic in lic)
{
if (!als.Contains(sic))
{
als.Add(sic);
}
}
}
}
}
if (als.Count > 0)
{
r.Add("S");
foreach (Sys_InventoryCategory sic in als)
{
string[] arr = plmname.Split(';');
int pcnum = sidb.CreateCode(sic.iccode);
foreach (string cz in arr)
{
if (!sidb.Exists(" and iname='" + sic.icname + "' and mname='" + cz + "'"))
{
Sys_InventoryDetail sid = new Sys_InventoryDetail();
sid.icname = sic.icname;
sid.iccode = sic.iccode;
sid.iname = sic.icname;
sid.icode = sic.iccode + pcnum.ToString().PadLeft(3, '0');
sid.mname = cz;
sid.iunit = plunit;
sid.maker = iv.u.ename;
sid.isaleprice = 0;
sid.isupplyprice = 0;
sid.ipurchaseprice = 0;
sid.iimage = "";
sid.istate = true;
sid.mcode = "";
sid.idef1 = "";
sid.idef2 = true;
sid.idef3 = 0;
sid.psize = plsize;
sid.cdate = DateTime.Now.ToString();
sid.tcprice = 0;
sid.ptype = pltype;
if (sidb.Add(sid) < 0)
{
lsid.Add(sid);
}
pcnum++;
}
else
{
Sys_InventoryDetail fsid = new Sys_InventoryDetail();
fsid.mname = cz;
fsid.iname = sic.icname;
lsid.Add(fsid);
}
}
}
if (lsid.Count > 0)
{
foreach (Sys_InventoryDetail sd in lsid)
{
ArrayList al = new ArrayList();
al.Add(sd.iname);
al.Add(sd.mname);
r.Add(al);
}
}
}
else
{
r.Add("F");
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string SaveInventory(string pbz, string pcprice, string pcode, string pcz, string pcztype, string pgprice, string pid, string plcode, string plname, string pname, string psize, string psprice, string pstate, string ptcprice, string ptype, string punit)
{
string r = "";
string dcode = "00010001";
Sys_InventoryDetailBll sidb = new Sys_InventoryDetailBll();
Sys_InventoryDetail sid = new Sys_InventoryDetail();
Sys_MaterialBll sub = new Sys_MaterialBll();
List <Sys_Material> lsr = new List <Sys_Material>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
sid.icname = plname;
sid.iccode = plcode;
sid.iname = pname;
sid.icode = pcode;
sid.mname = pcz;
sid.iunit = punit;
sid.maker = iv.u.ename;
sid.isaleprice = Convert.ToDecimal(psprice);
sid.isupplyprice = Convert.ToDecimal(pgprice);
sid.ipurchaseprice = Convert.ToDecimal(pcprice);
sid.iimage = "";
sid.istate = pstate == "1" ? true : false;
sid.mcode = "";
sid.idef1 = pbz;
sid.idef2 = true;
sid.idef3 = 0;
sid.psize = psize;
sid.cdate = DateTime.Now.ToString();
sid.tcprice = Convert.ToDecimal(ptcprice);
sid.ptype = ptype;
if (pid == "0")
{
if (pcztype == "a")
{
if (iv.u.dcode != "")
{
dcode = iv.u.dcode;
}
lsr = sub.QueryList(" and mstate='true' and mccode in (select mccode from Sys_MaterialCategory where dcode='" + dcode.Substring(0, 8) + "')");
if (lsr != null)
{
foreach (Sys_Material s in lsr)
{
sid.mname = s.mname;
sid.icode = plcode + sidb.CreateCode(plcode).ToString().PadLeft(3, '0');
if (!sidb.Exists(" and iname='" + pname + "' and mname='" + s.mname + "'"))
{
if (sidb.Add(sid) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = "T";
}
}
}
}
if (pcztype == "b")
{
string[] czarr = pcz.Split(';');
for (int i = 0; i < czarr.Length; i++)
{
sid.mname = czarr[i];
sid.icode = plcode + sidb.CreateCode(plcode).ToString().PadLeft(3, '0');
if (!sidb.Exists(" and iname='" + pname + "' and mname='" + czarr[i] + "'"))
{
if (sidb.Add(sid) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = "T";
}
}
}
}
else
{
if (!sidb.Exists(" and iname='" + pname + "' and mname='" + pcz + "' and icode<>'" + pcode + "'"))
{
if (sidb.Update(sid))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = "T";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
