public string Data_Select_SHIPbySDF(string SAPSN) { token = appClass.CRM_Gettoken(); CRM_KH_XSQYSJ XSQY = crmModels.KH_HZHB.ReadBySAPSN(SAPSN, token); SAP_CompanyInfo[] data = crmModels.SAP_ORDER.ShipToParty(SAPSN, XSQY.XSZZ, XSQY.FXQD, XSQY.CPZ, token); return(Newtonsoft.Json.JsonConvert.SerializeObject(data)); }
public string Data_Insert_OrderMX(int ORDERTTID, int PRODUCTID) { token = appClass.CRM_Gettoken(); //先看看这个产品有没有重复 CRM_ORDER_MX[] MXdata = crmModels.ORDER_TT.ReadMXbyTTID(ORDERTTID, token); for (int i = 0; i < MXdata.Length; i++) { if (MXdata[i].PRODUCTID == PRODUCTID) { webmsg.KEY = 0; webmsg.MSG = "该产品已在订单中!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } } CRM_ORDER_TT TTdata = crmModels.ORDER_TT.ReadTTbyID(ORDERTTID, token); CRM_PRODUCT_PRODUCT CP = crmModels.PRODUCT_PRODUCT.ReadByID(PRODUCTID, token); string SAPSN = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token).STAFFNO; CRM_KH_KH KHuser = crmModels.KH_KH.ReadBySAPSN(SAPSN, token); CRM_PRODUCT_WARN[] Warn = crmModels.PRODUCT_WARN.ReadByKHIDandPRODUCTID(KHuser.KHID, PRODUCTID, token); CRM_KH_XSQYSJ XSQY = crmModels.KH_HZHB.ReadBySAPSN(TTdata.SDFID, token); CRM_ORDER_MX model = new CRM_ORDER_MX(); model.ORDERTTID = ORDERTTID; model.PRODUCTID = PRODUCTID; model.CPPH = CP.CPPH; model.CPMC = CP.CPMC; model.DDDW = CP.DDDW; model.DDSL = 0; model.RATE = CP.RATE; model.BZDW = CP.BZDW; model.BZSL = 0; double price = Convert.ToDouble(crmModels.SAP_ORDER.SAP_Price(CP.CPPH, TTdata.SDFID, XSQY.XSZZ, XSQY.FXQD, token)); if (price == 0) { webmsg.KEY = 0; webmsg.MSG = "该产品没有维护价格,请联系业务员!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } model.PRICE = price; model.AMOUNT = 0; if (Warn.Length != 0) { if (Warn[0].PROWARNID == 0) //没有设置预警 { model.KYSL = 99999; } else { model.KYSL = Warn[0].SYSL; } } else { model.KYSL = 99999; } model.BEIZ = ""; model.ISACTIVE = 1; int ii = crmModels.ORDER_TT.CreateMX(model, token); webmsg.KEY = ii; if (ii > 0) { webmsg.MSG = "添加成功!"; Auto_UpdateOrder(ORDERTTID, false); } else { webmsg.MSG = "添加失败!"; } return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); }
public string Data_Insert_OrderTT(string data) { token = appClass.CRM_Gettoken(); string SAPSN = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token).STAFFNO; CRM_KH_KH KHuser = crmModels.KH_KH.ReadBySAPSN(SAPSN, token); CRM_ORDER_TT cxdata = new CRM_ORDER_TT(); cxdata.ISACTIVE = 10; cxdata.CJR = appClass.CRM_GetStaffid(); CRM_ORDER_TT[] TTdata = crmModels.ORDER_TT.ReadTTbyParam(cxdata, 0, 0, 0, token); if (TTdata.Length != 0) { webmsg.KEY = 0; webmsg.MSG = "存在未提交的订单!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } cxdata.ISACTIVE = 20; TTdata = crmModels.ORDER_TT.ReadTTbyParam(cxdata, 0, 0, 0, token); if (TTdata.Length != 0) { webmsg.KEY = 0; webmsg.MSG = "存在未审核的订单!请联系业务员"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } CRM_ORDER_TT model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_ORDER_TT>(data); //校验付款时间,不可早于当前时间 if (Convert.ToDateTime(model.FKSJ) < DateTime.Now.AddDays(-1)) { webmsg.KEY = 0; webmsg.MSG = "付款时间不可早于当前日期!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } CRM_KH_KH SDF = crmModels.KH_KH.ReadBySAPSN(model.SDFID, token); CRM_KH_XSQYSJ XSQY = crmModels.KH_HZHB.ReadBySAPSN(model.SDFID, token); model.DDLX = 1233; model.KHID = KHuser.KHID; model.KHSAP = KHuser.SAPSN; model.KHNAME = KHuser.MC; model.SDFNAME = SDF.MC; model.TEL = SDF.GSLXDH; model.XSZZ = XSQY.XSZZ; model.FXQD = XSQY.FXQD; model.CPZ = XSQY.CPZ; model.ISACTIVE = 10; model.CJR = appClass.CRM_GetStaffid(); int i = crmModels.ORDER_TT.CreateTT(model, token); webmsg.KEY = i; if (i > 0) { webmsg.MSG = "新增成功!"; } else { webmsg.MSG = "新增失败!"; } return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); }
public bool Auto_UpdateOrder(int ORDERTTID, bool updateMX) { token = appClass.CRM_Gettoken(); //更新订单抬头的信息 CRM_ORDER_TT TTdata = crmModels.ORDER_TT.ReadTTbyID(ORDERTTID, token); CRM_ORDER_MX[] MXdata = crmModels.ORDER_TT.ReadMXbyTTID(ORDERTTID, token); SAP_DiscountInfo[] discount = crmModels.SAP_ORDER.SAP_Discount(TTdata.SDFID, token); double total = 0; double MXzhekou = 0; for (int j = 0; j < MXdata.Length; j++) { total = total + MXdata[j].AMOUNT; MXzhekou = MXzhekou + (double)(Math.Round((decimal)(MXdata[j].AMOUNT * Convert.ToDouble(discount[0].Rate)), 2, MidpointRounding.AwayFromZero)); } TTdata.TOTAL = total; TTdata.DISCOUNT = Convert.ToDouble(discount[0].Available); TTdata.RATE = Convert.ToDouble(discount[0].Rate); //double OrderDiscount = TTdata.TOTAL * Convert.ToDouble(discount[0].Rate); double OrderDiscount = MXzhekou;// * Convert.ToDouble(discount[0].Rate); if (Convert.ToDouble(discount[0].Available) >= OrderDiscount) { TTdata.DISCOUNT_THIS = OrderDiscount; } else { TTdata.DISCOUNT_THIS = Convert.ToDouble(discount[0].Available); } TTdata.DISCOUNT_BALANCE = TTdata.DISCOUNT - TTdata.DISCOUNT_THIS; TTdata.ACTUAL = TTdata.TOTAL - TTdata.DISCOUNT_THIS; TTdata.PREVIOUS_BALANCE = Convert.ToDouble(crmModels.SAP_ORDER.SAP_Balance(TTdata.SDFID, token)); TTdata.PAY = TTdata.ACTUAL - TTdata.PREVIOUS_BALANCE; TTdata.XGR = appClass.CRM_GetStaffid(); int i = crmModels.ORDER_TT.UpdateTT(TTdata, token); if (updateMX) { //更新订单中产品的价格 CRM_KH_XSQYSJ XSQY = crmModels.KH_HZHB.ReadBySAPSN(TTdata.SDFID, token); for (int k = 0; k < MXdata.Length; k++) { CRM_PRODUCT_WARN[] Warn = crmModels.PRODUCT_WARN.ReadByKHIDandPRODUCTID(TTdata.KHID, MXdata[k].PRODUCTID, token); if (Warn.Length != 0) { if (Warn[0].PROWARNID == 0) { //没有设置预警 MXdata[k].KYSL = 99999; } else { MXdata[k].KYSL = Warn[0].SYSL; } } else { MXdata[k].KYSL = 99999; } MXdata[k].PRICE = Convert.ToDouble(crmModels.SAP_ORDER.SAP_Price(MXdata[k].CPPH, TTdata.SDFID, XSQY.XSZZ, XSQY.FXQD, token)); int ii = crmModels.ORDER_TT.UpdateMX(MXdata[k], token); if (ii <= 0) { return(false); } } } if (i > 0) { return(true); } else { return(false); } }
public string Data_Select_OrderTTCopyAndInsert(string TTdata, int FromID) { token = appClass.CRM_Gettoken(); string SAPSN = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token).STAFFNO; CRM_KH_KH KHuser = crmModels.KH_KH.ReadBySAPSN(SAPSN, token); CRM_ORDER_TT cxdata = new CRM_ORDER_TT(); cxdata.ISACTIVE = 10; cxdata.CJR = appClass.CRM_GetStaffid(); CRM_ORDER_TT[] cxTTmodel = crmModels.ORDER_TT.ReadTTbyParam(cxdata, 0, 0, 0, token); if (cxTTmodel.Length != 0) { webmsg.KEY = 0; webmsg.MSG = "存在未提交的订单!请处理"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } cxdata.ISACTIVE = 20; cxTTmodel = crmModels.ORDER_TT.ReadTTbyParam(cxdata, 0, 0, 0, token); if (cxTTmodel.Length != 0) { webmsg.KEY = 0; webmsg.MSG = "存在未审核的订单!请联系业务员"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } CRM_ORDER_TT TTmodel = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_ORDER_TT>(TTdata); //校验付款时间,不可早于当前时间 if (Convert.ToDateTime(TTmodel.FKSJ) < DateTime.Now.AddDays(-1)) { webmsg.KEY = 0; webmsg.MSG = "付款时间不可早于当前日期!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } CRM_KH_KH SDF = crmModels.KH_KH.ReadBySAPSN(TTmodel.SDFID, token); CRM_KH_XSQYSJ XSQY = crmModels.KH_HZHB.ReadBySAPSN(TTmodel.SDFID, token); TTmodel.DDLX = 1233; TTmodel.KHID = KHuser.KHID; TTmodel.KHSAP = KHuser.SAPSN; TTmodel.KHNAME = KHuser.MC; TTmodel.SDFNAME = SDF.MC; TTmodel.TEL = SDF.GSLXDH; TTmodel.XSZZ = XSQY.XSZZ; TTmodel.FXQD = XSQY.FXQD; TTmodel.CPZ = XSQY.CPZ; TTmodel.BEIZ = ""; TTmodel.ISACTIVE = 10; TTmodel.CJR = appClass.CRM_GetStaffid(); int ORDERID = crmModels.ORDER_TT.CreateTT(TTmodel, token); if (ORDERID < 0) { webmsg.KEY = ORDERID; webmsg.MSG = "新建订单失败!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } CRM_ORDER_MX[] Fromdata = crmModels.ORDER_TT.ReadMXbyTTID(FromID, token); for (int i = 0; i < Fromdata.Length; i++) { Fromdata[i].ORDERTTID = ORDERID; int ii = crmModels.ORDER_TT.CreateMX(Fromdata[i], token); webmsg.KEY = ii; if (ii <= 0) { webmsg.KEY = ii; webmsg.MSG = "复制失败!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } } webmsg.KEY = ORDERID; webmsg.MSG = "复制成功!"; Auto_UpdateOrder(ORDERID, false); return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); }