public static string SaveWjProduction(string sid, ArrayList prow)
{
string r = "";
List <B_GroupProduction> lbp = new List <B_GroupProduction>();
List <B_ProductionItem> lbpi = new List <B_ProductionItem>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
foreach (object[] o in prow)
{
if (Convert.ToInt32(o[1].ToString()) > 0)
{
B_GroupProduction bgp = new B_GroupProduction();
Sys_InventoryDetail d = sidb.Query(" and icode='" + o[0].ToString() + "'");
bgp.sid = sid;
bgp.psid = CommonBll.GetSid();
bgp.gnum = 1;
bgp.icode = d.icode;
bgp.iname = d.iname;
bgp.inum = Convert.ToInt32(o[1].ToString());
bgp.ps = o[2].ToString();
lbp.Add(bgp);
B_ProductionItem bpi = new B_ProductionItem();
bpi.sid = bgp.sid;
bpi.psid = bgp.psid;
bpi.pname = bgp.iname;
bpi.pcode = bgp.icode;
bpi.mname = "";
bpi.ptype = bgp.itype;
bpi.height = 0;
bpi.width = 0;
bpi.deep = 0;
bpi.pnum = bgp.inum;
bpi.e_ptype = "";
bpi.maker = bgp.maker;
bpi.cdate = DateTime.Now.ToString();
lbpi.Add(bpi);
}
}
if (bgpb.SaveList(lbp, sid, 1) > 0)
{
bpitb.SaveItemList(lbpi);
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string LabelStrA(string sid, string gnum)
{
string r = "";
string city = "", code = "";
B_SaleOrderBll bsob = new B_SaleOrderBll();
B_AfterSaleOrderBll basob = new B_AfterSaleOrderBll();
B_ProductionItemBll bpit = new B_ProductionItemBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
var o = bsob.Query(" and sid='" + sid + "'");
if (o != null)
{
city = o.city;
code = o.scode;
}
var ao = basob.Query(" and sid='" + sid + "'");
if (ao != null)
{
city = ao.city;
code = ao.scode;
}
B_GroupProduction bp = bgpb.Query(" and sid='" + sid + "' and gnum=" + gnum + " and icode like '01%'");
B_GroupProduction bl = bgpb.Query(" and sid='" + sid + "' and gnum=" + gnum + " and icode like '05%'");
if (bp != null)
{
string c1 = "", c2 = "", blname = "";
if (bl != null)
{
blname = bl.iname;
}
B_ProductionItem ms1 = bpit.Query(" and psid='" + bp.psid + "' and ptype='m' and e_ptype='f' ");
if (ms1 != null)
{
c1 = ms1.height + "*" + ms1.width;
}
B_ProductionItem ms2 = bpit.Query(" and psid='" + bp.psid + "' and ptype='m' and e_ptype='s' ");
if (ms2 != null)
{
c2 = ms2.height + "*" + ms2.width;
}
r = "BqPrint://?BH=" + code + "&CP=" + bp.iname + "&WZ=" + bp.place + "&CC1=" + c1 + "&CC2=" + c2 + "&CZ=" + bp.mname + "&XH=" + bp.gnum + "&SJ=" + bp.locks + "&BL=" + blname + "&KX=" + bp.direction + "&CS=" + city + "&DT=" + DateTime.Now.ToString() + "&HY=" + bp.locktype + "&LX=PAdoor&ZX=" + gnum + "&IID=" + bp.id + "";
}
}
else
{
r = "";
}
return(r);
}
public static string SaveItemProduction(string sid, string gnum, ArrayList itemlist)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
List <B_ProductionItem> uplbi = new List <B_ProductionItem>();
List <B_ProductionItem> inlbi = new List <B_ProductionItem>();
foreach (object[] o in itemlist)
{
object[] b = o;
B_ProductionItem bpi = new B_ProductionItem();
bpi.pname = b[1].ToString();
bpi.pcode = b[2].ToString();
bpi.height = Convert.ToInt32(b[3].ToString());
bpi.width = Convert.ToInt32(b[4].ToString());
bpi.deep = Convert.ToInt32(b[5].ToString());
bpi.pnum = Convert.ToInt32(b[6].ToString());
bpi.ptype = b[7].ToString();
bpi.e_ptype = b[9].ToString();
bpi.e_ptypeex = b[10].ToString();
bpi.addattr = b[11].ToString();
if (b[0].ToString() != "")
{
bpi.id = Convert.ToInt32(b[0].ToString());
uplbi.Add(bpi);
}
else
{
inlbi.Add(bpi);
}
}
if (bpib.InsertAddUpdateItems(sid, Convert.ToInt32(gnum), uplbi, inlbi) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string AfterSaveItemProduction(ArrayList itemlist)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
List <B_ProductionItem> ebi = new List <B_ProductionItem>();
List <B_ProductionItem> dbi = new List <B_ProductionItem>();
Hashtable dht = new Hashtable();
Hashtable eht = new Hashtable();
ArrayList darr = new ArrayList();
foreach (object[] o in itemlist)
{
object[] b = o;
B_ProductionItem bpi = bpib.Query(" and id=" + Convert.ToInt32(b[0].ToString()) + "");
if (bpi != null)
{
int pnum = Convert.ToInt32(b[5].ToString());
if (pnum > 0)
{
if (!eht.Contains(bpi.psid))
{
eht.Add(bpi.psid, bpi.psid);
}
bpi.height = Convert.ToInt32(b[2].ToString());
bpi.width = Convert.ToInt32(b[3].ToString());
bpi.deep = Convert.ToInt32(b[4].ToString());
bpi.pnum = Convert.ToInt32(b[5].ToString());
ebi.Add(bpi);
}
else
{
if (!dht.Contains(bpi.psid))
{
dht.Add(bpi.psid, bpi.psid);
}
dbi.Add(bpi);
}
}
foreach (string key in dht.Keys)
{
if (!eht.Contains(key))
{
darr.Add(key);
}
}
}
if (bpib.AfterUpdateItems(ebi, dbi, darr) > 0)
{
r = "S";
}
else
{
r = "F";
}
dht.Clear();
eht.Clear();
}
else
{
r = iv.badstr;
}
return(r);
}
public void ProcessRequest(HttpContext context)
{
ApiReturns ar = new ApiReturns();
PackageMessage pm = new PackageMessage();
string psid = "";
string agr = "";
int pid = 0;
if (context.Request.QueryString["psid"] != null)
{
psid = context.Request.QueryString["psid"].ToString();
}
if (context.Request.QueryString["m"] != null)
{
agr = context.Request.QueryString["m"].ToString();
}
if (psid != "" && agr != "")
{
switch (agr)
{
case "get":
#region //获取包装
pid = Convert.ToInt32(psid.Replace("P", ""));
DataRow bp = bpb.ViewQuery(" and bzid='" + pid + "'");
if (bp != null)
{
B_SaleOrder o = bsb.Query(" and osid='" + bp["sid"].ToString() + "'");
B_AfterSaleOrder ao = basb.Query(" and sid='" + bp["sid"].ToString() + "'");
B_GroupProduction gp = bgpb.Query(" and psid='" + bp["bsid"].ToString() + "'");
if (o != null)
{
pm.city = o.city;
pm.code = o.scode;
pm.customer = o.customer;
}
if (ao != null)
{
pm.city = ao.city;
pm.code = ao.scode;
pm.customer = ao.customer;
}
pm.mname = gp.mname;
pm.pname = gp.iname;
pm.size = gp.height.ToString() + "*" + gp.width.ToString() + "*" + gp.deep.ToString();
pm.direction = gp.direction;
pm.osort = "";// bgpb.QueryPackageGnum(" and psid in (select bsid from View_B_Package where bzid='"+pid+"')");
pm.pdate = bsb.QueryProductDate(bp["sid"].ToString());
if (bp != null)
{
pm.ptype = bp["btype"].ToString();
pm.packnum = bpb.PackageNum(bp["sid"].ToString()).ToString();
pm.curpacknum = bp["bnum"].ToString();
if (gp.icode.Substring(0, 2) == "02" || gp.icode.Substring(0, 2) == "06" || gp.icode.Substring(0, 2) == "07")
{
if (pm.ptype == "门套" || pm.ptype == "套板")
{
B_ProductionItem mt = bpib.Query(" and psid='" + gp.psid + "' and e_ptype='mt'");
string mtszie = "";
if (mt != null)
{
mtszie = mt.height.ToString() + "*" + mt.width.ToString() + "*" + mt.deep.ToString();
}
B_ProductionItem lb = bpib.Query(" and psid='" + gp.psid + "' and e_ptype='lb'");
string lbszie = "";
if (lb != null)
{
lbszie = lb.height.ToString() + "*" + lb.width.ToString() + "*" + lb.deep.ToString();
}
if (gp.icode.Substring(0, 2) == "02")
{
if (mtszie != "" && lbszie != "")
{
pm.size2 = mtszie + ";" + lbszie;
}
else
{
pm.size2 = mtszie + lbszie;
}
}
}
else
{
pm.size2 = bp["height"].ToString() + "*" + bp["width"].ToString() + "*" + bp["deep"].ToString();;
}
}
else
{
if (gp.icode.Substring(0, 2) == "01")
{
pm.size2 = bp["height"].ToString() + "*" + bp["width"].ToString() + "*" + bp["deep"].ToString();
}
else
{
pm.size2 = "";
}
}
pm.pcode = "B" + bp["bzid"].ToString();
ar.msg = "S";
bpb.UpPackageState(bp["sid"].ToString(), Convert.ToInt32(bp["bnum"].ToString()), "bz", "1");
bpdb.UpPackageState(bp["sid"].ToString(), bp["bzid"].ToString(), "bdate");
cbsb.UpState(bp["sid"].ToString(), "ipackage", 1);
ar.o = pm;
}
else
{
ar.msg = "订单不错在";
}
}
else
{
ar.msg = "产品不错在";
}
#endregion
break;
case "instore":
#region //包装入库
pid = Convert.ToInt32(psid.Replace("B", ""));
DataRow zbrk = bpb.ViewQuery(" and bzid=" + pid + "");
if (zbrk != null)
{
if (bpb.UpPackageState(zbrk["sid"].ToString(), Convert.ToInt32(zbrk["bnum"].ToString()), "zbrk", "1"))
{
#region //包装入库插入待SAP导入表
CB_InSapRecord cisr = new CB_InSapRecord();
cisr.sid = pid.ToString();
cisr.stype = "bzrk";
cisr.istate = 0;
cisr.cdate = DateTime.Now.ToString();
cisrb.Add(cisr);
#endregion
bpdb.UpPackageState(zbrk["sid"].ToString(), zbrk["bzid"].ToString(), "insdate");
if (bpb.Exists(" and sid='" + zbrk["sid"].ToString() + "' and zbrk=0"))
{
}
else
{
cbsb.UpState(zbrk["sid"].ToString(), "istoreget", 2);
//订单入库销售订单 和销售返修单
BaseSet.WorkFlowManage.EventBtnDo.UnUserFireEventBtn(zbrk["sid"].ToString(), "0062", "1", "入库");
BaseSet.WorkFlowManage.EventBtnDo.UnUserFireEventBtn(zbrk["sid"].ToString(), "0118", "1", "入库");
#region //订单入库插入待SAP导入表
CB_InSapRecord cor = new CB_InSapRecord();
cor.sid = zbrk["sid"].ToString();
cor.stype = "ork";
cor.istate = 0;
cor.cdate = DateTime.Now.ToString();
cisrb.Add(cor);
#endregion
}
ar.msg = "S";
}
else
{
ar.msg = "入库失败";
}
}
else
{
ar.msg = "包装不错在";
}
#endregion
break;
case "outstore":
#region //包装出库
//pid = Convert.ToInt32(psid.Replace("B", ""));
// DataRow zbck = bpb.ViewQuery(" and bzid=" + pid + "");
//if (zbck != null)
//{
// if (bpb.UpPackageState(zbck["sid"].ToString(), Convert.ToInt32(zbck["bnum"].ToString()), "zbck", "1"))
// {
// bpdb.UpPackageState(zbck["sid"].ToString(), zbck["bzid"].ToString(), "outsdate");
// ar.msg = "S";
// }
// else
// {
// ar.msg = "出库失败";
// }
//}
//else
//{
// ar.msg = "包装不错在";
//}
#endregion
#region //订单出库
B_SaleOrder bso = bsb.Query(" and scode='" + psid + "'");
if (bso != null)
{
bpb.UpPackageState(bso.sid, "zbck", "1");
bpdb.UpPackageState(bso.sid, "outsdate");
ar.msg = "S";
CB_InSapRecord cisr = new CB_InSapRecord();
cisr.sid = bso.sid;
cisr.stype = "ock";
cisr.istate = 0;
cisr.cdate = DateTime.Now.ToString();
cisrb.Add(cisr);
}
B_AfterSaleOrder abso = basb.Query(" and scode='" + psid + "'");
if (abso != null)
{
bpb.UpPackageState(abso.sid, "zbck", "1");
bpdb.UpPackageState(abso.sid, "outsdate");
ar.msg = "S";
CB_InSapRecord cisr = new CB_InSapRecord();
cisr.sid = abso.sid;
cisr.stype = "ock";
cisr.istate = 0;
cisr.cdate = DateTime.Now.ToString();
cisrb.Add(cisr);
}
#endregion
break;
case "incity":
pid = Convert.ToInt32(psid.Replace("B", ""));
DataRow csrk = bpb.ViewQuery(" and bzid=" + pid + "");
if (csrk != null)
{
if (bpb.UpPackageState(csrk["sid"].ToString(), Convert.ToInt32(csrk["bnum"].ToString()), "csrk", "1"))
{
bpdb.UpPackageState(csrk["sid"].ToString(), csrk["bzid"].ToString(), "incdate");
ar.msg = "S";
}
else
{
ar.msg = "入库失败";
}
}
else
{
ar.msg = "包装不错在";
}
break;
case "outcity":
pid = Convert.ToInt32(psid.Replace("B", ""));
DataRow csck = bpb.ViewQuery(" and bzid=" + pid + "");
if (csck != null)
{
if (bpb.UpPackageState(csck["sid"].ToString(), Convert.ToInt32(csck["bnum"].ToString()), "csck", "1"))
{
bpdb.UpPackageState(csck["sid"].ToString(), csck["bzid"].ToString(), "outcdate");
ar.msg = "S";
}
else
{
ar.msg = "出库失败";
}
}
else
{
ar.msg = "包装不错在";
}
break;
}
}
else
{
ar.msg = "参数错误";
ar.o = null;
}
context.Response.Write(js.Serialize(ar));
}
