public static string CommonManPlatList(string msdate, string mtdate, string qtdate, string sid)
{
string r = "";
StringBuilder where = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
string[] sids = sid.Split(';');
if (bppb.CommonManProduce(sids, msdate, mtdate, qtdate))
{
foreach (string id in sids)
{
CB_OrderFlow cof = cbfb.Query(" and sid='" + id + "' order by id asc");
if (cof != null)
{
switch (cof.emcode)
{
case "0001":
EventBtnDo.FireEventBtn(id, "0385", "1", "人工排产");
break;
case "0009":
EventBtnDo.FireEventBtn(id, "0342", "1", "人工排产");
break;
case "0143":
EventBtnDo.FireEventBtn(id, "0416", "1", "人工排产");
break;
case "0163":
EventBtnDo.FireEventBtn(id, "0365", "1", "人工排产");
break;
case "0177":
break;
case "0192":
break;
case "0213":
break;
}
}
}
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string ProductionInHouse(string bcode, string sid, string psids, string remark)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
B_AfterPartInHouseOrder bio = new B_AfterPartInHouseOrder();
if (iv.f)
{
string eco = "";
int pc = bapihob.CreateNum(sid, psids);
if (pc != 0)
{
eco = "-" + pc.ToString().PadLeft(2, '0');
}
B_AfterReModifyOrder bro = barmob.Query(" and sid='" + sid + "'");
bio.sid = CommonBll.GetSid();
bio.osid = sid;
bio.pscode = bro.scode + eco;
bio.scode = bro.scode;
bio.remark = remark;
bio.maker = iv.u.ename;
bio.cdate = DateTime.Now.ToString();
bio.plist = psids;
if (bapihob.Add(bio) > 0)
{
if (!bagpb.Exists(" and sid='" + sid + "' and psid not in (select psid from dbo.B_AfterPartInHouseProduction where osid='" + sid + "')"))
{
cosb.UpState(sid, "istoreget", 2);
cosb.UpState(sid, "iproduce", 2);
EventBtnDo.FireEventBtn(sid, bcode, "1", "产品全部入库");
}
else
{
EventBtnDo.FireEventBtn(sid, bcode, "1", "产品部分入库");
}
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveOrder(string acity, string address, string aprovince, string bcode, string csid, string customer, string emcode, string gzname, string mdate, string mremark, ArrayList plist, string sid, string telephone)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
B_SaleOrder bso = bsob.Query(" and sid='" + sid + "'");
B_MeasureOrder bco = new B_MeasureOrder();
bco.acity = acity;
bco.address = address;
bco.aprovince = aprovince;
bco.customer = customer;
bco.gzname = gzname;
bco.maker = iv.u.ename;
bco.mdate = mdate;
bco.mremark = mremark;
bco.osid = sid;
bco.telephone = telephone;
bco.city = bso.city;
bco.citycode = bso.citycode;
bco.dcode = bso.dcode;
bco.dname = bso.dname;
bco.mname = bso.mname;
bco.cdate = DateTime.Now.ToString();
bco.sdcode = DateTime.Now.ToString("yyyymmddhhMMss");
if (csid == "")
{
bco.sid = CommonBll.GetSid();
}
else
{
bco.sid = csid;
}
List <B_MeasureProduction> lbp = new List <B_MeasureProduction>();
foreach (object[] o in plist)
{
B_MeasureProduction bmp = new B_MeasureProduction();
var p = o;
bmp.cdate = DateTime.Now.ToString();
bmp.maker = iv.u.ename;
bmp.pcname = p[0].ToString();
bmp.pcnum = Convert.ToInt32(p[1].ToString());
bmp.sid = bco.sid;
lbp.Add(bmp);
}
bco.bplist = lbp;
if (bmlb.CheckLimited(bco.dcode, bco.mdate))
{
r = "MOB";
}
else
{
if (csid == "")
{
CB_OrderState cos = new CB_OrderState();
bco.qtimg = qcb.CreateQtCode(System.Web.HttpContext.Current.Server.MapPath("/UpFile/OrderQt/"), CommonBll.GetHost() + "UIClient/SalesBusiness/DistributorOrder/SaleOrderDetail.htm?Sid=" + bco.sid);
if (bmob.Add(bco) > 0)
{
bwfb.CreateWorkFlow(bco.sid, emcode);
cos.sid = bco.sid;
cosb.Add(cos);
r = "S";
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(bco.sid, bcode, "1", " 保存测量单");
}
else
{
if (bmob.Update(bco))
{
r = "S";
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(bco.sid, bcode, "1", " 更改测量单");
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveOrder(string acity, string address, string aprovince, string areason, string asid, string bcode, string customer, string dcode, string emcode, string gofee, string maker, string oscode, string osid, string remark, string sdate, string servfee, string sid, string sscode, string stext, string telephone)
{
string r = "";
B_AfterFreeBackOrder b = new B_AfterFreeBackOrder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'");
Sys_Depment cs = sdb.Query(" and dcode='" + dcode.Substring(0, dcode.Length - 4) + "'");
b.osid = osid;
b.asid = asid;
b.address = address;
b.acity = acity;
b.aprovince = aprovince;
b.customer = customer;
b.telephone = telephone;
b.dcode = dcode;
b.dname = sd.dname;
b.city = cs.dname;
b.citycode = cs.dcode;
b.maker = iv.u.ename;
b.oscode = oscode;
b.sscode = sscode;
b.gofee = Convert.ToDecimal(gofee);
b.servfee = Convert.ToDecimal(servfee);
b.sdate = CommonBll.GetBdate(sdate);
b.stext = stext;
b.remark = remark;
b.scode = "HAS" + DateTime.Now.ToString("yyMM") + bsob.GetOrderNum().ToString().PadLeft(5, '0');
b.areason = areason;
b.telephone = telephone;
b.cdate = DateTime.Now.ToString("yyyy-MM-dd");
if (sid == "")
{
b.sid = CommonBll.GetSid();
if (bsob.Add(b) > 0)
{
r = b.sid;
CB_OrderState cos = new CB_OrderState();
cos.sid = b.sid;
cosb.Add(cos);
bwfb.CreateWorkFlow(b.sid, emcode);
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(b.sid, bcode, "1", "创建售后单");
}
else
{
b.sid = sid;
if (bsob.Update(b))
{
r = b.sid;
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(b.sid, bcode, "1", "更新售后单");
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveOrder(string acity, string address, string aprovince, string azperson, string bcode, string city, string citycode, string clperson, string ctype, string customer, string dcode, string discode, string dname, string emcode, string iscl, string maker, string mname, string otype, string pbdcode, string qytype, string remark, string saletelephone, string sdtype, string sid, string source, string stype, string telephone, string untype, string zcode, string zsid)
{
string r = "";
string saddr = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
B_Orders bo = bob.Query(" and sid='" + zsid + "'");
Sys_CityGetAddress scga = scgab.QueryFrist(" and dcode='" + citycode + "'");
Sys_Brands sbs = sbb.Query(" and pbcode='" + pbdcode + "'");
B_SaleOrder bco = new B_SaleOrder();
if (scga != null)
{
saddr = scga.address;
}
bco.csid = bo != null ? bo.csid : "";
bco.zsid = zsid;
bco.zcode = bo != null?bo.zcode:"";
bco.wcode = "";
bco.oscode = "";
bco.customer = customer;
bco.telephone = telephone;
bco.community = "";
bco.address = address.Replace(",", "，");
bco.dname = dname;
bco.dcode = dcode;
bco.city = city;
bco.citycode = citycode;
bco.gzname = "";
bco.gztelephone = "";
bco.stelephone = saletelephone;
bco.otype = otype;
bco.sendtype = stype;
bco.sdtype = sdtype;
bco.mname = mname;
bco.source = source;
bco.remark = remark.Replace(",", "，");
bco.maker = maker;
bco.cdate = DateTime.Now.ToString();
bco.istax = false;
bco.isdf = false;
bco.iscl = iscl == "0" ? false : true;
bco.colorpane = "";
bco.floor = "";
bco.disactcode = discode;
bco.bdcode = iv.u.dcode.Substring(0, 8);
bco.clperson = clperson;
bco.azperson = azperson;
bco.pbdcode = pbdcode;
bco.pbdname = sbs != null ? sbs.pbname : "";
bco.saddress = aprovince == "" ? saddr : aprovince + acity + address;
bco.qytype = qytype;
bco.ctype = ctype;
bco.untype = untype;
if (bco.citycode.Substring(0, 12) != "000100010008")
{
bco.package = "外地包装";
}
else
{
bco.package = "本地包装";
}
bco.sdcode = "S" + DateTime.Now.ToString("yyMM") + bsob.QueryOrderNum();
if (sid == "")
{
CB_OrderState cos = new CB_OrderState();
bco.sid = CommonBll.GetSid();
bco.qtimg = qcb.CreateQtCode(System.Web.HttpContext.Current.Server.MapPath("/UpFile/OrderQt/"), CommonBll.GetHost() + "/UIClient/QtScan/OrderDetail.htm?Sid=" + bco.sid);
if (bsob.Add(bco) > 0)
{
bwfb.CreateWorkFlow(bco.sid, emcode);
cos.sid = bco.sid;
cosb.Add(cos);
r = bco.sid;
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(bco.sid, bcode, "1", " 保存订单");
}
else
{
bco.sid = sid;
if (bsob.Update(bco))
{
if (bmob.Exists(" and osid='" + sid + "'"))
{
if (!bco.iscl)
{
bmob.Delete(" and osid='" + sid + "'");
}
}
r = bco.sid;
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(bco.sid, bcode, "1", " 更改订单");
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveOrder(string acity, string address, string aprovince, string areason, string bcode, string city, string citycode, string customer, string dcode, string dname, string emcode, string maker, string oscode, string osid, string remark, string sid, string telephone)
{
string r = "";
B_AfterApplyOrder b = new B_AfterApplyOrder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
b.osid = osid;
b.address = address;
b.acity = acity;
b.aprovince = aprovince;
b.customer = customer;
b.dcode = dcode;
b.dname = dname;
b.city = city;
b.citycode = citycode;
b.maker = iv.u.ename;
b.osid = osid;
b.oscode = oscode;
b.remark = remark;
b.areason = areason;
b.telephone = telephone;
b.cdate = DateTime.Now.ToString("yyyy-MM-dd");
if (sid == "")
{
b.scode = "HFS" + DateTime.Now.ToString("yyMM") + bsob.GetOrderNum().ToString().PadLeft(5, '0');
b.sid = CommonBll.GetSid();
if (bsob.Add(b) > 0)
{
r = b.sid;
CB_OrderState cs = new CB_OrderState();
cs.sid = b.sid;
cosb.Add(cs);
bwfb.CreateWorkFlow(b.sid, emcode);
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(b.sid, bcode, "1", "创建售后申请单");
}
else
{
b.sid = sid;
if (bsob.Update(b))
{
r = b.sid;
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(b.sid, bcode, "1", "更新售后申请单");
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveOrder(string acity, string address, string aprovince, string areason, string ascode, string asid, string bcode, string city, string citycode, string customer, string dcode, string dname, string emcode, string isfc, string maker, string oscode, string osid, string otype, string ptype, string remark, string sid, string stype, string telephone)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
B_AfterReModifyOrder ao = new B_AfterReModifyOrder();
if (iv.f)
{
ao.acity = acity;
ao.aprovince = aprovince;
if (acity == "")
{
Sys_CityGetAddress sca = scgab.QueryRefFrist(dcode);
ao.address = sca != null ? sca.address : "";
}
else
{
ao.address = address;
}
Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'");
ao.ascode = ascode.Trim();
ao.asid = asid;
ao.cdate = DateTime.Now.ToString();
ao.city = city;
ao.citycode = citycode;
ao.customer = customer;
ao.dcode = dcode;
ao.dname = dname;
ao.isbf = isfc == "1" ? true : false;
ao.maker = maker;
ao.oscode = oscode;
ao.osid = osid;
ao.otype = otype;
ao.ptype = ptype;
ao.remark = remark;
ao.sendtype = stype;
ao.telephone = telephone;
ao.areason = areason;
ao.qytype = sd != null ? sd.dmattr : "";
if (sid == "")
{
string cnstr = basob.GetOrderNum().ToString().PadLeft(4, '0');
if (cnstr.Length > 4)
{
cnstr = cnstr.Substring(1, cnstr.Length - 1);
}
ao.scode = "HF" + DateTime.Now.ToString("yyMM") + cnstr;
ao.sid = CommonBll.GetSid();
if (basob.Add(ao) > 0)
{
r = ao.sid;
CB_OrderState cs = new CB_OrderState();
cs.sid = ao.sid;
cosb.Add(cs);
bwfb.CreateWorkFlow(ao.sid, emcode);
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(ao.sid, bcode, "1", "创建返修单");
}
else
{
ao.sid = sid;
if (basob.Update(ao))
{
r = ao.sid;
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(ao.sid, bcode, "1", "更新返修单");
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveOrder(string bcode, string city, string citycode, string dcode, string dname, string emcode, string maker, string otype, string remark, string saddress, string sid, string sperson, string stelephone, string wltype)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
B_SaleMaterielOrder bco = new B_SaleMaterielOrder();
bco.acode = "";
bco.aname = "";
bco.bdcode = "";
bco.cdate = DateTime.Now.ToString();
bco.city = city;
bco.citycode = citycode;
bco.dcode = dcode;
bco.dname = dname;
bco.gdiscount = 1;
bco.maker = maker;
bco.otype = otype;
bco.remark = remark;
bco.saddress = saddress;
bco.stelephone = stelephone;
bco.qtimg = "";
bco.sperson = sperson;
bco.wltype = wltype;
bco.bdcode = "00010001";
if (sid == "")
{
bco.sid = CommonBll.GetSid();
if (bsmob.Add(bco) > 0)
{
CB_OrderState cos = new CB_OrderState();
cos.sid = bco.sid;
cosb.Add(cos);
bwfb.CreateWorkFlow(bco.sid, emcode);
r = bco.sid;
}
else
{
r = "F";
}
}
else
{
bco.sid = sid;
if (bsmob.Update(bco))
{
r = bco.sid;
}
else
{
r = "F";
}
}
EventBtnDo.FireEventBtn(bco.sid, bcode, "1", "订单保存");
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveOrder(string address, string azperson, string bcode, string citycode, string cityname, string colorpane, string community, string customer, string emcode, string floor, string gytype, string ismb, string maker, string mname, string mtype, string otype, string qbcode, string remark, string saddress, string saletelephone, string shopcode, string shopname, string sid, string source, string surveyor, string telephone, string ycode)
{
string r = "";
BusiWorkFlowBll bwfb = new BusiWorkFlowBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_Depment sd = sdb.Query(" and dcode='" + citycode + "'");
Sys_Depment cd = sdb.Query(" and dcode='" + iv.u.dcode.Substring(0, 8) + "'");
B_YqSaleOrder bco = new B_YqSaleOrder();
bco.ccode = cd.dabc + DateTime.Now.ToString("yyyyMMddHHmmss");
bco.ycode = ycode;
bco.wcode = "";
bco.customer = customer;
bco.telephone = telephone;
bco.community = "";
bco.address = address.Replace(",", "，");
bco.aname = "";
bco.acode = "";
bco.dname = shopname;
bco.dcode = shopcode;
bco.city = sd != null ? sd.dname : "";
bco.citytype = "";
bco.citycode = citycode;
bco.gzname = "";
bco.gztelephone = "";
bco.saletelephone = saletelephone;
bco.mname = mname;
bco.source = source;
bco.remark = remark.Replace(",", "，");
bco.maker = maker;
bco.wlcompany = "";
bco.cdate = DateTime.Now.ToString();
bco.istax = false;
bco.isdf = false;
bco.lxtype = "";
bco.colorpane = colorpane;
bco.sname = sd.khcode;
bco.floor = floor;
bco.ismb = ismb == "1"?true:false;
bco.iswj = false;
bco.saddress = saddress;
bco.gytype = gytype;
bco.mtype = "yq";
bco.bdcode = iv.u.dcode.Substring(0, 8);
if (sid == "")
{
CB_OrderState cos = new CB_OrderState();
bco.sid = CommonBll.GetSid();
//bco.qtimg = qcb.CreateUrlQtCode("/UpFile/OrderQt/", CommonBll.GetHost() + "SaleOrderDetail.htm?Sid=", bco.sid);
if (bsob.Add(bco) > 0)
{
bwfb.CreateWorkFlow(bco.sid, emcode);
cos.sid = bco.sid;
cosb.Add(cos);
if (!bcb.Exists(" and customer='" + bco.customer + "' and bdcode='" + iv.u.dcode.Substring(0, 8) + "'"))
{
B_Customer bc = new B_Customer();
bc.dname = bco.dname;
bc.dcode = bco.dcode;
bc.customer = bco.customer;
bc.telephone = bco.telephone;
bc.community = bco.community;
bc.address = bco.address;
bc.cdate = DateTime.Now.ToString();
bc.maker = bco.maker;
bc.bdcode = iv.u.dcode.Substring(0, 8);
bcb.Add(bc);
}
r = bco.sid;
}
else
{
r = "F";
}
}
else
{
bco.sid = sid;
if (bsob.Update(bco))
{
r = bco.sid;
}
else
{
r = "F";
}
}
EventBtnDo.FireEventBtn(bco.sid, bcode, "1", "保存订单");
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveOrder(string account, string bcode, string city, string citycode, string emcode, string maker, string paccount, string pdate, string pmethod, string pmoney, string remark, string sid)
{
string r = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sbk_PaymentAccount pa = spab.Query(" and pcode=" + paccount + "");
Sbk_CollectionAccount ca = scab.Query(" and id=" + account + "");
B_CityPayOrder bco = new B_CityPayOrder();
bco.caccount = ca.aname;
bco.cbank = ca.abank;
bco.cperson = ca.aperson;
bco.cbcode = ca.bcode;
bco.ctype = "";
bco.dcode = citycode;
bco.dname = city;
bco.maker = maker;
bco.paccount = pa.pname;
bco.pbank = pa.pbank;
bco.pbcode = pa.pbcode;
bco.sacode = pa.sacode;
bco.pcode = "P" + DateTime.Now.ToString("yyyyMMddHHmmss");
bco.pdate = pdate;
bco.pmethod = pmethod;
bco.pmoney = Convert.ToDecimal(pmoney);
bco.pperson = pa.pperson;
bco.pstate = 0;
bco.remark = remark.Replace(",", "，");
bco.maker = maker;
bco.cdate = DateTime.Now.ToString();
if (sid == "")
{
CB_OrderState cos = new CB_OrderState();
bco.sid = CommonBll.GetSid();
bco.pimg = qcb.CreateQtCode(System.Web.HttpContext.Current.Server.MapPath("/UpFile/OrderQt/"), CommonBll.GetHost() + "UIClient/SalesBusiness/DistributorOrder/SaleOrderDetail.htm?Sid=" + bco.sid);
if (bcpob.Add(bco) > 0)
{
bwfb.CreateWorkFlow(bco.sid, emcode);
cos.sid = bco.sid;
cosb.Add(cos);
r = bco.sid;
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(bco.sid, bcode, "1", " 保存订单");
}
else
{
bco.sid = sid;
if (bcpob.Update(bco))
{
r = bco.sid;
}
else
{
r = "F";
}
EventBtnDo.FireEventBtn(bco.sid, bcode, "1", " 更改订单");
}
}
else
{
r = iv.badstr;
}
return(r);
}
