public JsonResult GetJst(string icode)
{
ArrayList r = new ArrayList();
JsonData d = new JsonData();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
string msc = icode.Substring(0, icode.Length - 3);
List <Sys_InventoryDetail> lsd = sidb.QueryList(" and icode in (select jscode from Sys_RMsJst where mscode='" + msc + "')");
if (lsd != null)
{
foreach (Sys_InventoryDetail sd in lsd)
{
ArrayList al = new ArrayList();
al.Add(sd.icode);
al.Add(sd.iname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
d.d = js.Serialize(r);
return(Json(d));
}
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 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 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 JsonResult QuerySmProdution(string tccode, string ptype, string ismt)
{
JsonData d = new JsonData();
ArrayList r = new ArrayList();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
List <Sys_InventoryDetail> lp = new List <Sys_InventoryDetail> ();
r.Add(iv.badstr);
if (ptype == "10")
{
if (ismt == "1")
{
lp = sidb.QueryList(" and icode in ( select pcode from Sys_RInventorySetMeal where tcpcode in (select tcblbcode from Sys_SetMealProduction where tccode='" + tccode + "' ) and substring (pcode,1,2)='02' ) and istate=1");
}
else
{
lp = sidb.QueryList("and icode in ( select pcode from Sys_RInventorySetMeal where tcpcode in (select tcblbcode from Sys_SetMealProduction where tccode='" + tccode + "' ) and substring (pcode,1,2)='01' ) and istate=1");
}
}
else
{
lp = sidb.QueryList("and icode in ( select pcode from Sys_RInventorySetMeal where tcpcode in (select tcblbcode from Sys_SetMealProduction where tccode='" + tccode + "' ) and substring (pcode,1,2)='" + ptype + "' ) and istate=1");
}
if (lp != null)
{
foreach (Sys_InventoryDetail id in lp)
{
ArrayList al = new ArrayList();
al.Add(id.iname);
al.Add(id.icode);
al.Add(id.mname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
d.d = js.Serialize(r);
return(Json(d));
}
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);
}