public static ArrayList CustQueryListItem()
{
ArrayList r = new ArrayList();
Sys_MaterialBll sub = new Sys_MaterialBll();
List <Sys_Material> lsr = new List <Sys_Material>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
lsr = sub.QueryList(" and mstate='true' and mccode in(select mccode from Sys_MaterialCategory where dcode='" + iv.u.dcode.Substring(0, 8) + "')");
if (lsr != null)
{
foreach (Sys_Material s in lsr)
{
ArrayList al = new ArrayList();
al.Add(s.mcode);
al.Add(s.mname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryTableMaterial(string mcode)
{
ArrayList r = new ArrayList();
Sys_MaterialBll sub = new Sys_MaterialBll();
List <Sys_Material> lsr = new List <Sys_Material>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
lsr = sub.QueryList(" and mccode='" + mcode + "'");
if (lsr != null)
{
foreach (Sys_Material s in lsr)
{
ArrayList al = new ArrayList();
al.Add(s.mcode);
al.Add(s.mname);
al.Add(s.mstate);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryListItemByBrand(string mname, string bcode)
{
ArrayList r = new ArrayList();
Sys_MaterialBll sub = new Sys_MaterialBll();
List <Sys_Material> lsr = new List <Sys_Material>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
lsr = sub.QueryList(" and mstate='true' and mname like'%" + mname + "%' and mname in(select mcode from Sys_RBrandsMaterial where pbcode='" + bcode + "')");
if (lsr != null)
{
foreach (Sys_Material s in lsr)
{
ArrayList al = new ArrayList();
al.Add(s.mcode);
al.Add(s.mname);
r.Add(al);
}
}
}
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);
}
