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