public string Data_Delete_OrderTT(int ORDERTTID)
{
token = appClass.CRM_Gettoken();
CRM_ORDER_TT TTdata = crmModels.ORDER_TT.ReadTTbyID(ORDERTTID, token);
if (TTdata.ISACTIVE != 10)
{
webmsg.KEY = 0;
webmsg.MSG = "当前状态不可删除！";
}
else
{
int i = crmModels.ORDER_TT.DeleteTT(ORDERTTID, "delete", token);
webmsg.KEY = i;
if (i > 0)
{
webmsg.MSG = "删除成功！";
}
else
{
webmsg.MSG = "删除失败！";
}
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
public string Data_Select_OrderTTbyID(int ORDERTTID)
{
token = appClass.CRM_Gettoken();
CRM_ORDER_TT data = crmModels.ORDER_TT.ReadTTbyID(ORDERTTID, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public ActionResult Order_HJ(int ORDERTTID)
{
token = appClass.CRM_Gettoken();
CRM_ORDER_TT TTdata = crmModels.ORDER_TT.ReadTTbyID(ORDERTTID, token);
ViewBag.TTdata = TTdata;
return(View());
}
public ActionResult SH_Order_Part(string cxdata)
{
token = appClass.CRM_Gettoken();
CRM_ORDER_TT model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_ORDER_TT>(cxdata);
CRM_ORDER_TT[] data = crmModels.ORDER_TT.ReadTTbyParam(model, appClass.CRM_GetStaffid(), 0, 0, token);
ViewBag.TTdata = data;
return(View());
}
public string Data_Select_OrderTTbyParam(string cxdata)
{
token = appClass.CRM_Gettoken();
CRM_ORDER_TT model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_ORDER_TT>(cxdata);
//string SAPSN = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token).STAFFNO;
//CRM_KH_KH KHuser = crmModels.KH_KH.ReadBySAPSN(SAPSN, token);
model.CJR = appClass.CRM_GetStaffid();
CRM_ORDER_TT[] data = crmModels.ORDER_TT.ReadTTbyParam(model, 0, 0, 0, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public ActionResult Update_Order(int ORDERTTID)
{
token = appClass.CRM_Gettoken();
CRM_ORDER_TT TTdata = crmModels.ORDER_TT.ReadTTbyID(ORDERTTID, token);
//string SAPSN = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token).STAFFNO;
//CRM_KH_KH[] data = crmModels.KH_KH.ReadSDFbyPKH(SAPSN, token);
//ViewBag.SDF = data;
if (TTdata.ISACTIVE == 10)
{
Auto_UpdateOrder(ORDERTTID, true);
}
DateTime now = DateTime.Now;
ViewBag.startdate = now.AddMonths(-1).ToString("yyyy-MM-dd");
ViewBag.enddate = now.ToString("yyyy-MM-dd");
return(View());
}
public string Data_Update_OrderTT(string data)
{
//现在没有用，如果要用的话得先用逻辑ID查出整个结构体，然后把修改的值改进去，再去更新
token = appClass.CRM_Gettoken();
CRM_ORDER_TT model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_ORDER_TT>(data);
model.XGR = appClass.CRM_GetStaffid();
int i = crmModels.ORDER_TT.UpdateTT(model, token);
webmsg.KEY = i;
if (i > 0)
{
webmsg.MSG = "修改成功！";
}
else
{
webmsg.MSG = "修改失败！";
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
public string Data_SH_Order(int ORDERTTID, string BEIZ2)
{
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_SOInfo order = new SAP_SOInfo();
order.Header = new SAP_SOHeaderInfo();
order.Header.SalesOrganization = TTdata.XSZZ;
order.Header.DistributionChannel = TTdata.FXQD;
order.Header.Division = TTdata.CPZ;
order.Header.SoldToParty = TTdata.SDFID;
order.Header.ShipToParty = TTdata.SHIPID;
order.Header.CustomerPO = DateTime.Now.ToString("yyyyMMdd") + TTdata.ORDERTTID.ToString().PadLeft(6, '0');
order.Header.CustomerPODate = DateTime.Now.ToString("yyyy-MM-dd");
order.Items = new SAP_SOItemInfo[MXdata.Length];
for (int k = 0; k < MXdata.Length; k++)
{
order.Items[k] = new SAP_SOItemInfo();
order.Items[k].Material = MXdata[k].CPPH;
order.Items[k].Quantity = MXdata[k].DDSL;
order.Items[k].SalesUnit = MXdata[k].DDDW;
}
string result = crmModels.SAP_ORDER.Create(order, token);
if (result == "")
{
webmsg.KEY = 0;
webmsg.MSG = "订单提交SAP失败！";
TTdata.SUCCESS = -1;
}
else
{
webmsg.KEY = 1;
webmsg.MSG = "审核成功！";
TTdata.SUCCESS = 1;
TTdata.SAPORDER = result;
crmModels.ORDER_TT.UpdateOrderIsactive(ORDERTTID, 50, token);
TTdata.SHR = appClass.CRM_GetStaffid();
TTdata.SHSJ = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
TTdata.BEIZ2 = BEIZ2;
crmModels.ORDER_TT.UpdateTT(TTdata, token);
}
CRM_ORDER_TT ordermodel = new CRM_ORDER_TT();
ordermodel.ORDERTTID = ORDERTTID;
ordermodel.SUCCESS = TTdata.SUCCESS;
ordermodel.SAPORDER = result;
ordermodel.KHPO = order.Header.CustomerPO;
int l = crmModels.ORDER_TT.UpdateOrder_SAPORDER(ordermodel, token);
if (l <= 0)
{
webmsg.KEY = 0;
webmsg.MSG = "回传订单失败！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
CRM_PRODUCT_WARN[] warn = crmModels.PRODUCT_WARN.ReadByKHIDandPRODUCTID(TTdata.KHID, 0, token);
for (int m = 0; m < warn.Length; m++)
{
for (int n = 0; n < MXdata.Length; n++)
{
if (warn[m].PRODUCTID == MXdata[n].PRODUCTID)
{
//warn[m].SYSL = warn减去预警
}
}
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
public ActionResult WX_SH_Order()
{
string Account = System.Configuration.ConfigurationManager.AppSettings["apiAccount"];
string Secret = System.Configuration.ConfigurationManager.AppSettings["apiSecret"];
CRM_LoginInfo login = crmModels.CRM_Login.Login(Account, Secret, "", "", 1, 0);
string token = login.TokenInfo.access_token;
Session["token"] = token;
Session["NAME"] = " ";
//CRM_HG_STAFF staffdata1 = crmmodel.HG_STAFF.ReadBySTAFFID(login.TokenInfo.STAFFID, login.TokenInfo.access_token);
int StaffID = 0;
string code = Request.QueryString["code"];
string state = Request.QueryString["state"];
//code = "Cto7s7NeQaw-fgHCGM-UYhK_C0WcyMauTPTEshPCIEM";
//state = "QY";
string openid = "";
string userid = "";
PublicController otherController = DependencyResolver.Current.GetService <PublicController>();
//string result = otherController.ToExcel(data, 4, token);
if (code != null) //有code
{
if (state == "WX") //微信公众号登录
{
Session["state"] = "WX";
string[] data = otherController.GetWebToken(code);
if (data[0] == "ok") //成功获取openid
{
openid = data[1];
Session["openid"] = openid;
CRM_WX_OPENID openidModel = new CRM_WX_OPENID();
openidModel.OPENID = openid;
CRM_WX_OPENID[] openidData = crmModels.WX_OPENID.ReadByParam(openidModel, token);
if (openidData.Length == 0)
{
ViewBag.MSG = "您没有权限";
return(View("Error"));
}
StaffID = openidData[0].STAFFID;
CRM_HG_STAFF staffdata = crmModels.HG_STAFF.ReadBySTAFFID(StaffID, token);
string appid = System.Configuration.ConfigurationManager.AppSettings["AppID"];
CRM_LoginInfo tokeninfo = crmModels.CRM_Login.Login("", "", openid, appid, 0, 1);
if (tokeninfo.TokenInfo.access_token == null)
{
ViewBag.MSG = "获取token失败";
return(View("Error"));
}
else
{
Session["MENUINFO"] = tokeninfo.JURISDICTION_GROUP;
Session["STAFFID"] = StaffID;
Session["NAME"] = staffdata.STAFFNAME;
Session["USERLX"] = staffdata.USERLX;
}
}
else //获取openid失败
{
ViewBag.MSG = data[1];
return(View("Error"));
}
}
else if (state == "QY") //企业微信登录
{
Session["state"] = "QY";
string[] data = otherController.GetQYwebToken(code);
if (data[0] == "ok") //成功获取userid或openid
{
userid = data[1];
Session["openid"] = userid;
CRM_WX_OPENID openidModel = new CRM_WX_OPENID();
openidModel.OPENID = userid;
CRM_WX_OPENID[] openidData = crmModels.WX_OPENID.ReadByParam(openidModel, token);
if (openidData.Length == 0)
{
ViewBag.MSG = "您没有权限";
return(View("Error"));
}
StaffID = openidData[0].STAFFID;
CRM_HG_STAFF staffdata = crmModels.HG_STAFF.ReadBySTAFFID(StaffID, token);
string corpid = System.Configuration.ConfigurationManager.AppSettings["CorpID"];
CRM_LoginInfo tokeninfo = crmModels.CRM_Login.Login("", "", userid, corpid, 0, 1);
if (tokeninfo.TokenInfo.access_token == null)
{
ViewBag.MSG = "获取token失败";
return(View("Error"));
}
else
{
Session["MENUINFO"] = tokeninfo.JURISDICTION_GROUP;
Session["STAFFID"] = StaffID;
Session["NAME"] = staffdata.STAFFNAME;
Session["USERLX"] = staffdata.USERLX;
}
}
else //获取userid或openid失败
{
ViewBag.MSG = data[1];
return(View("Error"));
}
}
else //不太可能发生的情况
{
ViewBag.MSG = "登录失败";
return(View("Error"));
}
}
else //没有code
{
ViewBag.MSG = "请退出并重新登录";
return(View("Error"));
}
//StaffID = 35;
CRM_ORDER_TT model = new CRM_ORDER_TT();
model.ISACTIVE = 20;
CRM_ORDER_TT[] OrderData = crmModels.ORDER_TT.ReadTTbyParam(model, StaffID, 0, 0, token);
ViewBag.TTdata = OrderData;
return(View());
}
public string Data_Submit_Order(int ORDERTTID, string SHIPID, string SHIPADD, string FKSJ)
{
token = appClass.CRM_Gettoken();
CRM_ORDER_TT TTdata = crmModels.ORDER_TT.ReadTTbyID(ORDERTTID, token);
CRM_ORDER_MX[] MXdata = crmModels.ORDER_TT.ReadMXbyTTID(ORDERTTID, token);
for (int k = 0; k < MXdata.Length; k++)
{
if (MXdata[k].DDSL == 0)
{
webmsg.KEY = 0;
webmsg.MSG = "订单中存在数量为0的行项目！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
}
TTdata.SHIPID = SHIPID;
TTdata.SHIPADD = SHIPADD;
TTdata.FKSJ = FKSJ;
TTdata.TJR = appClass.CRM_GetStaffid();
TTdata.TJSJ = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
int j = crmModels.ORDER_TT.UpdateTT(TTdata, token);
if (j <= 0)
{
webmsg.KEY = 0;
webmsg.MSG = "更新订单失败！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
int i = crmModels.ORDER_TT.UpdateOrderIsactive(ORDERTTID, 20, token);
if (i <= 0)
{
webmsg.KEY = 0;
webmsg.MSG = "更新提交失败！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
string WXres = "";
try
{
CRM_WX_OPENIDList[] OPENID = crmModels.WX_OPENID.ReadByORDERTTID(TTdata.ORDERTTID, token);
for (int x = 0; x < OPENID.Length; x++)
{
if (OPENID[x].WXDLCS == CorpID)
{
WX_MSG wxmsg = new WX_MSG();
wxmsg.touser = OPENID[x].OPENID;
wxmsg.toparty = "";
wxmsg.totag = "";
wxmsg.msgtype = "text";
wxmsg.agentid = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["Agentid"]);
wxmsg.text = new TEXT();
string address = System.Configuration.ConfigurationManager.AppSettings["SHorder_QY"];
wxmsg.text.content = "您的客户：" + TTdata.SDFNAME + "于" + TTdata.TJSJ + "提交了一个销售订单，请及时查收哦。<a href=\"" + address + "\">点这里进入审核界面</a>";
wxmsg.safe = 0;
WXres = WeiXinMSG(wxmsg);
}
}
}
catch//(Exception e)
{
//webmsg.KEY = 0;
//webmsg.MSG = WXres;
//return Newtonsoft.Json.JsonConvert.SerializeObject(webmsg);
}
webmsg.KEY = 1;
webmsg.MSG = "提交成功！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
public int UpdateTT_BJ(CRM_ORDER_TT model, string ptoken)
{
return(client.UpdateTT_BJ(model, ptoken));
}
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));
}
public int UpdateOrder_SAPORDER(CRM_ORDER_TT model, string ptoken)
{
return(client.UpdateOrder_SAPORDER(model, ptoken));
}
public CRM_ORDER_TT[] ReadTTbyParam(CRM_ORDER_TT model, int STAFFID, int forCopy, int isGun, string ptoken)
{
return(client.ReadTTbyParam(model, STAFFID, forCopy, isGun, ptoken));
}
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 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 int CreateTT(CRM_ORDER_TT model, string ptoken)
{
return(client.CreateTT(model, ptoken));
}