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