public static string InitOrder(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { B_MeasureOrder bco = new B_MeasureOrder(); if (bmob.Exists(" and osid='" + sid + "'")) { bco = bmob.Query(" and osid='" + sid + "'"); bco.bplist = bmpb.QueryList(" and sid='" + bco.sid + "' order by id"); } else { B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'"); if (bso != null) { bco.acity = bso.acity; bco.address = bso.address; bco.aprovince = bso.aprovince; bco.customer = bso.customer; bco.gzname = bso.gzname; bco.telephone = bso.telephone; bco.mremark = ""; List <B_MeasureProduction> lbp = new List <B_MeasureProduction>(); List <Sys_MeasureProduction> lsp = smpb.QueryList(""); if (lsp != null) { foreach (Sys_MeasureProduction smp in lsp) { B_MeasureProduction bp = new B_MeasureProduction(); bp.pcname = smp.mpname; bp.pcnum = 0; lbp.Add(bp); } } bco.bplist = lbp; } } r = js.Serialize(bco); } else { r = iv.badstr; } return(r); }
public static string SalePayOperator(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'"); VPayOrder vpo = new VPayOrder(); VOrderMoney vm = bomb.DoorOrderMoney(sid, bso.sdiscount, bso.gdiscount, 1); CB_OrderFlow cof = bwfb.QueryAttrExWorkFlow(sid, "bj"); vpo.code = bso.scode; vpo.customer = bso.customer; vpo.dname = bso.dname; vpo.dcode = bso.citycode; vpo.settlment = "";// bso.sname; vpo.bjr = cof != null?cof.maker:""; vpo.yingshou = vm.godhjmoney.ToString(); vpo.yishou = vm.pmoney.ToString(); vpo.weishou = (vm.godhjmoney - vm.pmoney).ToString(); vpo.telephone = bso.telephone; r = js.Serialize(vpo); } else { r = iv.badstr; } return(r); }
public static string ProductionOrder(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { VProduceOrder vpo = new VProduceOrder(); B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'"); CB_OrderFlow cof = bwfb.QueryAttrExWorkFlow(sid, "sc"); B_OrderFacotory bof = bofb.Query(" and sid='" + sid + "'"); vpo.code = bso.scode; vpo.ycode = bso.oscode; vpo.customer = bso.customer; vpo.address = bso.address; vpo.dname = bso.dname; vpo.otype = bso.otype; vpo.fname = bof == null?"":bof.dname; vpo.scdate = cof.edate; vpo.overdate = bof == null?"":CommonBll.GetBdate(bof.overdate); vpo.bz = bso.remark; r = js.Serialize(vpo); } else { r = iv.badstr; } return(r); }
public static string BatchSetlment(string sid) { string r = ""; string bads = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { string[] asid = sid.Split(';'); for (int i = 0; i < asid.Length; i++) { if (cbsb.UpState(asid[i], "isetlment", 2) > 0) { r = "S"; } else { B_SaleOrder bso = bsob.Query(" and sid='" + asid[i] + "'"); bads = bads + bso.scode + ";"; } } if (bads != "") { r = bads; } } else { r = iv.badstr; } return(r); }
public static string SetOrderCode(string sid, string otype) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r = "F"; bool iscode = false; B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'"); if (bso != null) { if (bso.scode == "") { iscode = true; } if (bocb.SetOrderCode(sid, otype, iv.u.dcode.Substring(0, 8), "", bso.citycode, iscode)) { r = "S"; } else { r = "F"; } } } else { r = iv.badstr; } return(r); }
public static string InitOrder(string sid, string zsid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { B_SaleOrder bco = new B_SaleOrder(); if (sid != "") { bco = bsob.Query(" and sid='" + sid + "'"); r = js.Serialize(bco); } else { if (zsid != "") { B_Orders bo = bob.Query(" and sid='" + zsid + "'"); Sys_DepmentDpt sdd = sddb.Query(" and dcode='" + bo.dcode + "'"); bco.city = bo.city; bco.citycode = bo.citycode; bco.dname = bo.dname; bco.dcode = bo.dcode; bco.zsid = bo.sid; bco.customer = bo.customer; bco.telephone = bo.telephone; bco.address = bo.address; bco.community = bo.community; bco.zcode = bo.zcode; bco.stelephone = sdd != null ? sdd.dcontact : ""; bco.maker = iv.u.ename; } r = js.Serialize(bco); } } else { r = iv.badstr; } return(r); }
public static string SetDiscount(string sid, string dv) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r = "F"; B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'"); if (bso != null) { if (bsob.SetGDiscount(sid, Convert.ToDecimal(dv))) { r = "S"; } } B_YqSaleOrder ybso = ybsob.Query(" and sid='" + sid + "'"); if (ybso != null) { if (ybsob.SetGDiscount(sid, Convert.ToDecimal(dv))) { r = "S"; } } B_AfterSaleOrder baso = basob.Query(" and sid='" + sid + "'"); if (bso != null) { r = "S"; //if (basob.SetGDiscount(sid, Convert.ToDecimal(dv))) //{ //} } } 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 FixOrder(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { VFixOrder vfo = new VFixOrder(); B_SaleOrder bso = bsob.Query(" and osid='" + sid + "'"); B_OrderFacotory bof = bofb.Query(" and sid='" + sid + "'"); CB_OrderState cos = cosb.Query(" and sid='" + sid + "'"); string zt = ""; if (cos != null) { if (cos.ifixed == 0) { zt = "未安装"; } if (cos.ifixed == 1) { zt = "部分安装"; } if (cos.ifixed == 2) { zt = "已安装"; } } vfo.code = bso.scode; vfo.ycode = bso.oscode; vfo.wcode = bso.wcode; vfo.otype = bso.otype; vfo.customer = bso.customer; vfo.telephone = bso.telephone; vfo.address = bso.address; vfo.dname = bso.dname; vfo.city = bso.city; vfo.gzname = bso.gzname; vfo.gztelephone = bso.gztelephone; vfo.azzt = zt; vfo.bz = bso.remark; r = js.Serialize(vfo); } else { r = iv.badstr; } return(r); }
public static string QuerySaleOrder(string ycode) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { B_SaleOrder bso = bsob.Query(" and ccode='" + ycode + "'"); r = js.Serialize(bso); } else { r = iv.badstr; } return(r); }
public static string QueryOrder(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { B_SaleChangeOrder bsco = new B_SaleChangeOrder(); B_SaleChangeOrder bco = bscob.Query(" and sid='" + sid + "'"); if (bco != null) { bsco = bco; if (bgpcb.Exists(" and sid='" + sid + "'")) { bsco.hasproduction = "1"; } } else { B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'"); if (bso != null) { bsco.scode = ""; bsco.oscode = bso.scode; bsco.e_city = bso.city; bsco.dname = bso.dname; bsco.customer = bso.customer; bsco.telephone = bso.telephone; bsco.address = bso.address; bsco.otype = "木门更改单"; bsco.mname = bso.mname; bsco.sname = "";// bso.sname; bsco.cdate = DateTime.Now.ToString(); bsco.maker = ""; bsco.creason = ""; bsco.osid = sid; bsco.sid = ""; } } r = js.Serialize(bsco); } else { r = iv.badstr; } return(r); }
public static string OutnHouseOrder(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { VInHouseOrder vpo = new VInHouseOrder(); B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'"); B_OrderFacotory bof = bofb.Query(" and sid='" + sid + "'"); CB_OrderState cos = cosb.Query(" and sid='" + sid + "'"); int bnum = bohrb.GetRecordCount(" sid='" + sid + "'"); string zt = ""; if (cos != null) { if (cos.istoredeliver == 0) { zt = "未发库"; } if (cos.istoredeliver == 1) { zt = "部分发库"; } if (cos.istoredeliver == 2) { zt = "全部发库"; } } vpo.code = bso.scode; vpo.ycode = bso.oscode; vpo.customer = bso.customer; vpo.address = bso.address; vpo.dname = bso.dname; vpo.fname = bof == null ? "" : bof.dname; vpo.bz = bso.remark; vpo.city = bso.city; vpo.telephone = bso.telephone; vpo.bnum = bnum.ToString(); vpo.zt = zt; r = js.Serialize(vpo); } else { r = iv.badstr; } return(r); }
public static string InitOrder(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { B_DrawProductionOrder ino = new B_DrawProductionOrder(); B_DrawProductionOrder bco = bmppob.Query(" and sid='" + sid + "'"); if (bco == null) { B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'"); if (bso != null) { ino.sid = ""; ino.osid = bso.sid; ino.cityname = bso.city; ino.citycode = bso.citycode; ino.shopname = bso.dname; ino.shopcode = bso.dcode; } else { ino.osid = ""; ino.cityname = ""; ino.citycode = ""; ino.shopname = ""; ino.shopcode = ""; } } else { ino = bco; } r = js.Serialize(ino); } else { r = iv.badstr; } return(r); }
public static string LoadSaleOrder(string sid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { B_SaleOrder bco = bsob.Query(" and sid='" + sid + "'"); if (bco != null) { B_CustormOrder bdj = bcob.Query(" and csid='" + bco.csid + "'"); CB_OrderFlow cof = cofb.Query(" and sid='" + sid + "' and state=1 and wcode='0003'"); if (cof != null) { //bco.state = true; } bco.ztimg = bosb.QueryOrderStateImg(sid); r = js.Serialize(bco); } else { Sys_Depment sd = sdb.Query(" and dcode='" + iv.u.dcode + "'"); B_SaleOrder kco = new B_SaleOrder(); if (sd != null) { if (sd.dattr == "cs") { Sys_DepmentDpt sdd = sddb.Query(" and dcode='" + sd.dcode + "'"); kco.city = sd.dpname; kco.citycode = sd.dpcode; kco.dname = sd.dname; kco.dcode = sd.dcode; kco.stelephone = sdd != null ? sdd.dcontact : ""; } else if (sd.dattr == "dm") { Sys_DepmentDpt sdd = sddb.Query(" and dcode='" + sd.dcode.Substring(0, sd.dcode.Length - 4) + "'"); kco.city = sd.dpname; kco.citycode = sd.dpcode; kco.dname = sd.dname; kco.dcode = sd.dcode; kco.stelephone = sdd != null ? sdd.dcontact : ""; } else { kco.city = ""; kco.citycode = ""; kco.dname = ""; kco.dcode = ""; } } kco.maker = iv.u.ename; r = js.Serialize(kco); } } else { r = iv.badstr; } return(r); }
public static string SavePackage(string sid, string qremark, string rowid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { string scode = ""; string precode = ""; B_InHouseOrder bpqo = new B_InHouseOrder(); B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'"); if (bso != null) { scode = bso.scode; } bpqo.cdate = DateTime.Now.ToString(); bpqo.maker = iv.u.ename; bpqo.icode = scode + "-" + precode + bihob.QueryIorderNum(" and sid='" + sid + "'").ToString(); bpqo.isid = CommonBll.GetSid(); bpqo.ps = qremark; bpqo.state = 1; bpqo.sid = sid; List <B_InhousePackage> lq = new List <B_InhousePackage>(); string[] arrow = rowid.ToString().Split(';'); if (arrow.Length > 0) { foreach (string id in arrow) { B_PackageCode bgp = bpcb.Query(" and id=" + id + ""); if (bgp != null) { bpdb.UpPackageState(sid, bgp.id.ToString(), "insdate"); B_InhousePackage bpi = new B_InhousePackage(); bpi.cdate = DateTime.Now.ToString(); bpi.isid = bpqo.isid; bpi.pid = bgp.id; bpi.sid = sid; bpi.maker = iv.u.ename; bpi.sid = sid; lq.Add(bpi); } } } if (bihob.SaveQualityOrder(bpqo, lq)) { List <B_PackageCode> lbp = bpcb.QueryList(" and sid='" + sid + "' and id not in (select pid from B_InhousePackage where isid in (select isid from B_InHouseOrder where sid='" + sid + "'))"); if (lbp == null) { cosb.UpState(sid, "istoreget", 2); } r = "S"; } else { r = "F"; } } else { r = iv.badstr; } return(r); }
public static string ProductionInHouse(string sid, string psid, string remark) { string r = ""; int zt = 0; StringBuilder where = new StringBuilder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { string scode = ""; B_AfterSaleOrder ba = basb.Query(" and sid='" + sid + "'"); B_SaleOrder bo = bsob.Query(" and sid='" + sid + "'"); if (bo != null) { scode = bo.scode; } if (ba != null) { scode = ba.scode; } B_InHouseOrder bio = new B_InHouseOrder(); bio.isid = CommonBll.GetSid(); bio.sid = sid; bio.maker = iv.u.ename; bio.ps = remark; bio.state = 0; bio.cdate = DateTime.Now.ToString(); string[] arr = psid.Split(';'); if (bhpb.InUpdate(arr, bio.isid)) { bosb.UpState(sid, "istoreget", 1); if (!bhpb.Exist(" and istate=0 and sid='" + sid + "'")) { zt = 1; bosb.UpState(sid, "istoreget", 2); } if (!bihob.Exists(" and sid='" + sid + "'") && zt == 1) { bio.icode = scode; } else { List <B_InHouseOrder> bihl = bihob.QueryList(" and sid='" + sid + "'"); int n = bihl == null ? 1 : bihl.Count; bio.icode = scode + "-" + n.ToString().PadLeft(2, '0'); } bihob.Add(bio); r = "S"; } else { r = "F"; } } else { r = iv.badstr; } return(r); }
public static string SaveQualityProduction(string sid, string qtype, string qremark, string rowid) { string r = ""; SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { string scode = ""; string precode = ""; B_PartQualityOrder bpqo = new B_PartQualityOrder(); B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'"); if (qtype == "s") { bpqo.qstate = 1; } if (qtype == "f") { bpqo.qstate = -1; precode = "F"; } if (bso != null) { scode = bso.scode; } bpqo.cdate = DateTime.Now.ToString(); bpqo.maker = iv.u.ename; bpqo.qcode = scode + "-" + precode + bpqob.QueryQorderNum(" and sid='" + sid + "' and qstate=" + bpqo.qstate + "").ToString(); bpqo.qsid = CommonBll.GetSid(); bpqo.remark = qremark; bpqo.sid = sid; List <B_PartQualityItems> lq = new List <B_PartQualityItems>(); string[] arrow = rowid.ToString().Split(';'); if (arrow.Length > 0) { foreach (string id in arrow) { string idv = ""; string etype = ""; B_PartQualityItems bpi = new B_PartQualityItems(); if (id.IndexOf('-') > -1) { string [] ids = id.Split('-'); idv = ids[0]; etype = ids[1]; } else { idv = id; } B_GroupProduction bgp = bgpb.Query(" and id=" + idv + ""); if (bgp != null) { bpi.cdate = DateTime.Now.ToString(); //if (bgp.ptype == "ms") //{ // B_ProductionItem li = bpib.Query(" and psid='" + bgp.psid + "' and e_ptype='" + etype + "'"); // bpi.deep = li.deep; // bpi.gnum = bgp.gnum; // bpi.height = li.height; // bpi.maker = iv.u.ename; // bpi.pcode = li.pcode; // bpi.pname = li.pname; // bpi.pnum = (int)li.pnum; // bpi.psid = li.psid; // bpi.qsid = bpqo.qsid; // bpi.sid = sid; // bpi.width = li.width; // lq.Add(bpi); //} //else //{ bpi.deep = bgp.deep; bpi.gnum = bgp.gnum; bpi.height = bgp.height; bpi.maker = iv.u.ename; bpi.pcode = bgp.icode; bpi.pname = bgp.iname; bpi.pnum = (int)bgp.inum; bpi.psid = bgp.psid; bpi.qsid = bpqo.qsid; bpi.sid = sid; bpi.width = bgp.width; lq.Add(bpi); //} } } } if (bpqob.SaveQualityOrder(bpqo, lq)) { List <B_GroupProduction> lbpi = bgpb.QueryList(" and sid='" + sid + "' and substring(icode,9,3)<>'004' and psid not in (select psid from B_PartQualityItems where qsid in(select qsid from B_PartQualityOrder where sid='" + sid + "' and qstate=1) ) order by gnum"); if (lbpi == null) { cosb.UpState(sid, "iquality", 2); cosb.UpState(sid, "ifactorydeliver", 2); } r = "S"; } else { r = "F"; } } 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)); }