public string Data_Report_InvoiceByKHID() { token = appClass.CRM_Gettoken(); CRM_HG_STAFF staff = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token); CRM_KH_KH kehu = crmModels.KH_KH.ReadBySAPSN(staff.STAFFNO, token); CRM_MSG_INVOICEList[] data = crmModels.MSG_INVOICE.ReadByKHID(kehu.KHID, token); return(Newtonsoft.Json.JsonConvert.SerializeObject(data)); }
public ActionResult InvoicePart() { token = appClass.CRM_Gettoken(); CRM_HG_STAFF staff = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token); CRM_KH_KH kehu = crmModels.KH_KH.ReadBySAPSN(staff.STAFFNO, token); CRM_MSG_INVOICEList[] data = crmModels.MSG_INVOICE.ReadByKHID(kehu.KHID, token); ViewBag.data = data; return(View()); }
public string Data_Select_CPLXbyRight() { 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_PRODUCT_PRODUCT[] data = crmModels.PRODUCT_PRODUCT.ReadCPLXByRight(KHuser.KHID, token); string netpath = System.Configuration.ConfigurationManager.AppSettings["NETPATH"]; for (int i = 0; i < data.Length; i++) { if (data[i].ML != "") { string[] p = data[i].ML.Split('\\'); int count = p.Length - 1; string path = p[count - 2] + @"/" + p[count - 1] + @"/" + p[count]; data[i].ML = netpath + path; } } return(Newtonsoft.Json.JsonConvert.SerializeObject(data)); }
public ActionResult Load_CP(string SDF, int CPLX, int ORDERTTID, string CPMC) { token = appClass.CRM_Gettoken(); CRM_KH_KH KHuser = crmModels.KH_KH.ReadBySAPSN(SDF, token); CRM_PRODUCT_PRODUCT[] data = crmModels.PRODUCT_PRODUCT.ReadByRight(KHuser.KHID, SDF, CPLX, ORDERTTID, CPMC, token); string netpath = System.Configuration.ConfigurationManager.AppSettings["NETPATH"]; for (int i = 0; i < data.Length; i++) { if (data[i].ML != "") { string[] p = data[i].ML.Split('\\'); int count = p.Length - 1; string path = p[count - 2] + @"/" + p[count - 1] + @"/" + p[count]; data[i].ML = netpath + path; } } ViewBag.PRODUCT = data; return(View()); }
public ActionResult Insert_Order() { token = appClass.CRM_Gettoken(); CRM_HG_STAFF STAFF = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token); //STAFF为当前用户的数据 ViewBag.STAFF = STAFF; string SAPSN = STAFF.STAFFNO; CRM_KH_KH[] SDF = crmModels.KH_KH.ReadSDFbyPKH(SAPSN, token); ViewBag.SDF = SDF; CRM_KH_KH KH = crmModels.KH_KH.ReadBySAPSN(SAPSN, token); //kh为当前客户的数据 ViewBag.KH = KH; DateTime now = DateTime.Now; ViewBag.startdate = now.AddMonths(-1).ToString("yyyy-MM-dd"); ViewBag.enddate = now.ToString("yyyy-MM-dd"); return(View()); }
public ActionResult Choose_Product(string SDF) { token = appClass.CRM_Gettoken(); //string SAPSN = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token).STAFFNO; CRM_KH_KH KHuser = crmModels.KH_KH.ReadBySAPSN(SDF, token); CRM_PRODUCT_PRODUCT[] data = crmModels.PRODUCT_PRODUCT.ReadCPLXByRight(KHuser.KHID, token); string netpath = System.Configuration.ConfigurationManager.AppSettings["NETPATH"]; for (int i = 0; i < data.Length; i++) { if (data[i].CPLXML != "") { string[] p = data[i].CPLXML.Split('\\'); int count = p.Length - 1; string path = p[count - 2] + @"/" + p[count - 1] + @"/" + p[count]; data[i].CPLXML = netpath + path; } } ViewBag.CPLX = data; return(View()); }
public string Data_DaoRu_Invoice() { token = appClass.CRM_Gettoken(); DaoRuMsg msg = new DaoRuMsg(); try { var file = Request.Files[0]; //string date = DateTime.Now.ToString("yyyyMMddHHmmss"); //string fileName = date + "_" + KHID; string year = DateTime.Now.Year.ToString(); string month = DateTime.Now.Month.ToString(); string gotname = file.FileName; //string[] name = gotname.Split('.'); //int count = name.Length - 1; //string savePath = @"E:\CRM\Areas\CRM\upload\" + year + @"\" + month + @"\" + fileName + "." + name[count]; string savePath = FileSavePath + @"\excel\" + year + @"\" + month + @"\" + gotname; if (Directory.Exists(FileSavePath + @"\excel\" + year + @"\" + month) == false) { Directory.CreateDirectory(FileSavePath + @"\excel\" + year + @"\" + month); } file.SaveAs(savePath); FileInfo fi = new FileInfo(savePath); if (fi.Exists == true) { string[] sheet = { "发票" }; //开始做数据校验 DataTable data1 = ExcelToDataTable(savePath, sheet[0], true); //发票 #region if (data1 != null) { if (data1.Columns.Contains("发票号码") == false || data1.Columns.Contains("发票数量") == false || data1.Columns.Contains("快递单号") == false) { msg.Msg = "请使用发票新增模版!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } else { try { //做数据验证 if (data1.Rows.Count > 0) { for (int i = 0; i < data1.Rows.Count; i++) { bool sap404 = false; if (data1.Rows[i]["客户SAP编号"].ToString() != "" && crmModels.KH_KH.ReadBySAPSN(data1.Rows[i]["客户SAP编号"].ToString(), token).KHID == 0) { sap404 = true; } if (sap404) { msg.Msg = "发票第" + (i + 2) + "行客户SAP编号不存在!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } if (Regex.IsMatch(data1.Rows[i]["发票数量"].ToString(), @"^\d+$") == false) { msg.Msg = "发票第" + (i + 2) + "行发票数量必须为全数字!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } if (data1.Rows[i]["寄送日期"].ToString() != "") { try { DateTime myDT = Convert.ToDateTime(data1.Rows[i]["寄送日期"].ToString()); } catch { msg.Msg = "发票第" + (i + 2) + "行寄送日期格式错误!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } } } } catch (Exception e) { msg.Msg = e.ToString(); return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } } #endregion //能到这儿就说明数据是没问题的了...大概,然后才进行数据库写入 #region //发票 for (int i = 0; i < data1.Rows.Count; i++) { #region CRM_KH_KH KHmodel = crmModels.KH_KH.ReadBySAPSN(data1.Rows[i]["客户SAP编号"].ToString(), token); CRM_MSG_INVOICE model = new CRM_MSG_INVOICE(); model.KHID = KHmodel.KHID; model.FPHM = data1.Rows[i]["发票号码"].ToString().Trim(); model.FPSL = Convert.ToInt32(data1.Rows[i]["发票数量"].ToString().Trim()); model.KDDH = data1.Rows[i]["快递单号"].ToString().Trim(); model.JSRQ = Convert.ToDateTime(data1.Rows[i]["寄送日期"].ToString()).ToString("yyyy-MM-dd"); model.BEIZ = data1.Rows[i]["备注"].ToString().Trim(); model.ISACTIVE = 1; model.CJR = appClass.CRM_GetStaffid(); int id = crmModels.MSG_INVOICE.Create(model, token); if (id <= 0) { msg.Msg = "新增发票的第" + (i + 2) + "行出现问题,请记录当前报错信息并联系管理员"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } #endregion } #endregion msg.Msg = "新增成功!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } else { msg.Msg = "文件读取失败!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } catch (Exception e) { msg.Msg = e.ToString(); return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } }
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_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 string Data_Insert_FXCH_FX(string TPM, string DXM, string CRMID) { token = appClass.CRM_Gettoken(); WebMSG msg = new WebMSG(); if (TPM.Length != 12) { msg.KEY = 0; msg.MSG = "托盘码格式错误"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } //先看看这个托盘码在不在数据库里 Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX[] model = crmModels.BC_CHTT.ReadDXMbyTPM(TPM, token); //这个model是根据传进来的托码在发货表里面找到的数据 if (model.Length == 0) { msg.KEY = 0; msg.MSG = "找不到托盘码"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } DXM[] dxm = Newtonsoft.Json.JsonConvert.DeserializeObject <DXM[]>(DXM); //把扫进来的码统一转换成内盒码,然后看看有没有重复的码 List <DXM> result = new List <DXM>(); for (int i = 0; i < dxm.Length; i++) { if (dxm[i].Dxm.Length != 15) { msg.KEY = 0; msg.MSG = "箱码格式错误"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX modeltmp = new Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX(); modeltmp.DXM = dxm[i].Dxm; Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX[] MXdata = crmModels.BC_CHTT.ReadMXbyParam(modeltmp, token); for (int j = 0; j < MXdata.Length; j++) { //result[result.Count] = new DXM(); //result[result.Count].Dxm = MXdata[j].NHM; DXM temp = new DXM(); temp.Dxm = MXdata[j].NHM; result.Add(temp); } } List <DXM> checkdata = result.Distinct(new DXM.TravelTrafficInfoComparer()).ToList(); if (result.Count != checkdata.Count) { msg.KEY = 0; msg.MSG = "请勿重复输入"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } for (int i = 0; i < dxm.Length; i++) { //int count = crmModels.BC_FXCH.ReadCountByDXM(dxm[i].Dxm, "", token); //if (count != 0) //{ // msg.KEY = 0; // msg.MSG = "该条码已经发货:" + dxm[i].Dxm; // return Newtonsoft.Json.JsonConvert.SerializeObject(msg); //} Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX[] MXdata = crmModels.BC_CHTT.SelectCHMXbyDXM(dxm[i].Dxm, "", token); if (MXdata.Length == 0) { msg.KEY = 0; msg.MSG = "找不到条码:" + dxm[i].Dxm; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } //校验当前人员对应的客户有没有发这箱货的权限 int a = crmModels.BC_FXCH.Verify_IfHaveCHRight(appClass.CRM_GetStaffid(), dxm[i].Dxm, "", token); if (a == 0) { msg.KEY = 0; msg.MSG = "当前人员的客户没有发这箱货的权限:" + dxm[i].Dxm; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } int samecount = 0; for (int j = 0; j < dxm.Length; j++) { if (dxm[i].Dxm == dxm[j].Dxm) { samecount++; } } if (samecount > 1) { msg.KEY = 0; msg.MSG = "该条码重复:" + dxm[i].Dxm; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } CRM_BC_FXCHTT TTmodel = new CRM_BC_FXCHTT(); CRM_KH_KH KHmodel = crmModels.KH_KH.ReadByCRMID(CRMID, token); TTmodel.KHID = KHmodel.KHID; TTmodel.SDFID = crmModels.KH_KH.ReadByCRMID(KHmodel.PKHID.ToString(), token).KHID; TTmodel.BEIZ = ""; TTmodel.CJR = appClass.CRM_GetStaffid(); int TTid = crmModels.BC_FXCH.TTCreate(TTmodel, token); if (TTid == 0) { msg.KEY = 0; msg.MSG = "保存失败"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } for (int j = 0; j < model.Length; j++) { int count = 0; for (int i = 0; i < dxm.Length; i++) { if (model[j].DXM == dxm[i].Dxm) { count++; } } if (count > 0) { continue; } Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX[] MXdata = null; MXdata = crmModels.BC_CHTT.SelectCHMXbyDXM(model[j].DXM, "", token); for (int i = 0; i < MXdata.Length; i++) { CRM_BC_FXCHMX MXmodel = new CRM_BC_FXCHMX(); MXmodel.FXCHTTID = TTid; MXmodel.TPM = MXdata[i].TPM; MXmodel.DXM = MXdata[i].DXM; MXmodel.NHM = MXdata[i].NHM; MXmodel.CHARG = MXdata[i].CHARG; MXmodel.LWEDT = MXdata[i].LWEDT; int MXid = crmModels.BC_FXCH.MXCreate(MXmodel, token); if (MXid == 0) { msg.KEY = 0; msg.MSG = "保存失败,请联系管理员"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } } msg.KEY = 1; msg.MSG = "保存成功"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); }
public int Create(CRM_KH_KH KH_S, string ptoken) { return(client.Create(KH_S, ptoken)); }
public int ModifyKH_KH(CRM_KH_KH KH_S) //修改客户信息 { return(client.ModifyKH_KH(KH_S)); }
public int InsertKH_KH(CRM_KH_KH KH_S) //新增客户信息 { return(client.InsertKH_KH(KH_S)); }
public string Data_Insert_FXCH_ZZK(string JHD) { token = appClass.CRM_Gettoken(); WebMSG msg = new WebMSG(); MODEL_ZBCFUN_JHD_READ JHDdata = Newtonsoft.Json.JsonConvert.DeserializeObject <MODEL_ZBCFUN_JHD_READ>(JHD); //把扫进来的码统一转换成内盒码,然后看看有没有重复的码 for (int i = 0; i < JHDdata.ET_ItemData.Length; i++) { List <DXM> result = new List <DXM>(); for (int j = 0; j < JHDdata.ET_ItemData[i].TM.Length; j++) { if (JHDdata.ET_ItemData[i].TM[j].Barcode.Length == 12) //托码 { //展开成内盒码进行校验 Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX model = new Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX(); model.TPM = JHDdata.ET_ItemData[i].TM[j].Barcode; model.KUNAG = JHDdata.ES_HeadData.ZZKGGKH; Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX[] MXdata = crmModels.BC_CHTT.ReadMXbyParam(model, token); for (int k = 0; k < MXdata.Length; k++) { //result[result.Count] = new DXM(); DXM temp = new DXM(); temp.Dxm = MXdata[k].NHM; result.Add(temp); } //看看是不是已经发货了的条码 CRM_BC_FXCHMX cxmodel = new CRM_BC_FXCHMX(); cxmodel.TPM = JHDdata.ET_ItemData[i].TM[j].Barcode; CRM_BC_FXCHMX[] FHdata = crmModels.BC_FXCH.ReadMXbyParam(cxmodel, token); if (FHdata.Length != 0) { msg.KEY = 0; msg.MSG = JHDdata.ET_ItemData[i].POSNR + "行项目该物流码已发货:" + JHDdata.ET_ItemData[i].TM[j].Barcode; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } else if (JHDdata.ET_ItemData[i].TM[j].Barcode.Length == 15) //箱码 { Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX model = new Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX(); model.DXM = JHDdata.ET_ItemData[i].TM[j].Barcode; model.KUNAG = JHDdata.ES_HeadData.ZZKGGKH; Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX[] MXdata = crmModels.BC_CHTT.ReadMXbyParam(model, token); for (int k = 0; k < MXdata.Length; k++) { //result[result.Count] = new DXM(); DXM temp = new DXM(); temp.Dxm = MXdata[k].NHM; result.Add(temp); } //看看是不是已经发货了的条码 CRM_BC_FXCHMX cxmodel = new CRM_BC_FXCHMX(); cxmodel.DXM = JHDdata.ET_ItemData[i].TM[j].Barcode; CRM_BC_FXCHMX[] FHdata = crmModels.BC_FXCH.ReadMXbyParam(cxmodel, token); if (FHdata.Length != 0) { msg.KEY = 0; msg.MSG = JHDdata.ET_ItemData[i].POSNR + "行项目该物流码已发货:" + JHDdata.ET_ItemData[i].TM[j].Barcode; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } else if (JHDdata.ET_ItemData[i].TM[j].Barcode.Length == 18) //内盒码 { DXM temp = new DXM(); temp.Dxm = JHDdata.ET_ItemData[i].TM[j].Barcode; result.Add(temp); //看看是不是已经发货了的条码 CRM_BC_FXCHMX cxmodel = new CRM_BC_FXCHMX(); cxmodel.NHM = JHDdata.ET_ItemData[i].TM[j].Barcode; CRM_BC_FXCHMX[] FHdata = crmModels.BC_FXCH.ReadMXbyParam(cxmodel, token); if (FHdata.Length != 0) { msg.KEY = 0; msg.MSG = JHDdata.ET_ItemData[i].POSNR + "行项目该物流码已发货:" + JHDdata.ET_ItemData[i].TM[j].Barcode; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } } List <DXM> checkdata = result.Distinct(new DXM.TravelTrafficInfoComparer()).ToList(); if (result.Count != checkdata.Count) { msg.KEY = 0; msg.MSG = JHDdata.ET_ItemData[i].POSNR + "行项目的物流码重复"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } List <ZSL_BCT110> RFCmodel = new List <ZSL_BCT110>(); for (int i = 0; i < JHDdata.ET_ItemData.Length; i++) { for (int j = 0; j < JHDdata.ET_ItemData[i].TM.Length; j++) { Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX[] MXdata = null; if (JHDdata.ET_ItemData[i].TM[j].Barcode.Length == 12) //托码 { Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX model = new Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX(); model.TPM = JHDdata.ET_ItemData[i].TM[j].Barcode; model.KUNAG = JHDdata.ES_HeadData.ZZKGGKH; MXdata = crmModels.BC_CHTT.ReadMXbyParam(model, token); } else if (JHDdata.ET_ItemData[i].TM[j].Barcode.Length == 15) //箱码 { Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX model = new Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX(); model.DXM = JHDdata.ET_ItemData[i].TM[j].Barcode; model.KUNAG = JHDdata.ES_HeadData.ZZKGGKH; MXdata = crmModels.BC_CHTT.ReadMXbyParam(model, token); } else if (JHDdata.ET_ItemData[i].TM[j].Barcode.Length == 18) //内盒码 { Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX model = new Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX(); model.NHM = JHDdata.ET_ItemData[i].TM[j].Barcode; model.KUNAG = JHDdata.ES_HeadData.ZZKGGKH; MXdata = crmModels.BC_CHTT.ReadMXbyParam(model, token); } else { MXdata = new UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX[0]; } for (int k = 0; k < MXdata.Length; k++) { ZSL_BCT110 temp = new ZSL_BCT110(); temp.VBELN = MXdata[k].VBELN; temp.POSNR = MXdata[k].POSNR; temp.NHM = MXdata[k].NHM; temp.DXM = MXdata[k].DXM; temp.TPM = MXdata[k].TPM; temp.VBELNN = JHDdata.ET_ItemData[i].VBELN; temp.POSNRN = JHDdata.ET_ItemData[i].POSNR; temp.MATNR = JHDdata.ET_ItemData[i].MATNR; temp.KUNAG = JHDdata.ES_HeadData.KUNAG; temp.LGORT = JHDdata.ET_ItemData[i].LGORT; temp.WERKS = JHDdata.ET_ItemData[i].WERKS; RFCmodel.Add(temp); } } } //调用过账接口 MES_RETURN RFCresult = crmModels.BarCode.JHD_UPDATE(RFCmodel.ToArray(), appClass.CRM_GetStaffid(), token); if (RFCresult.TYPE == "E") { msg.KEY = 0; msg.MSG = RFCresult.MESSAGE; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } CRM_BC_FXCHTT TTmodel = new CRM_BC_FXCHTT(); CRM_KH_KH KHmodel = crmModels.KH_KH.ReadBySAPSN(JHDdata.ES_HeadData.KUNAG.TrimStart('0'), token); TTmodel.KHID = KHmodel.KHID; TTmodel.SDFID = crmModels.KH_KH.ReadByCRMID(KHmodel.PKHID.ToString(), token).KHID; TTmodel.KUNAG = JHDdata.ES_HeadData.KUNAG; TTmodel.NAMEG = JHDdata.ES_HeadData.NAMEG; TTmodel.VBELN = JHDdata.ES_HeadData.VBELN; TTmodel.ZZKGGKH = JHDdata.ES_HeadData.ZZKGGKH; TTmodel.BEIZ = ""; TTmodel.CJR = appClass.CRM_GetStaffid(); int TTid = crmModels.BC_FXCH.TTCreate(TTmodel, token); if (TTid == 0) { msg.KEY = 0; msg.MSG = "保存失败"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } for (int i = 0; i < JHDdata.ET_ItemData.Length; i++) { for (int j = 0; j < JHDdata.ET_ItemData[i].TM.Length; j++) { Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX[] MXdata = null; if (JHDdata.ET_ItemData[i].TM[j].Barcode.Length == 12) //托码 { Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX model = new Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX(); model.TPM = JHDdata.ET_ItemData[i].TM[j].Barcode; model.KUNAG = JHDdata.ES_HeadData.ZZKGGKH; MXdata = crmModels.BC_CHTT.ReadMXbyParam(model, token); } else if (JHDdata.ET_ItemData[i].TM[j].Barcode.Length == 15) //箱码 { Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX model = new Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX(); model.DXM = JHDdata.ET_ItemData[i].TM[j].Barcode; model.KUNAG = JHDdata.ES_HeadData.ZZKGGKH; MXdata = crmModels.BC_CHTT.ReadMXbyParam(model, token); } else if (JHDdata.ET_ItemData[i].TM[j].Barcode.Length == 18) //内盒码 { Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX model = new Sonluk.UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX(); model.NHM = JHDdata.ET_ItemData[i].TM[j].Barcode; model.KUNAG = JHDdata.ES_HeadData.ZZKGGKH; MXdata = crmModels.BC_CHTT.ReadMXbyParam(model, token); } else { MXdata = new UI.Model.CRM.BC_CHTTService.CRM_BC_CHMX[0]; } for (int k = 0; k < MXdata.Length; k++) { CRM_BC_FXCHMX MXmodel = new CRM_BC_FXCHMX(); MXmodel.FXCHTTID = TTid; MXmodel.TPM = MXdata[k].TPM; MXmodel.DXM = MXdata[k].DXM; MXmodel.NHM = MXdata[k].NHM; MXmodel.CHARG = MXdata[k].CHARG; MXmodel.LWEDT = MXdata[k].LWEDT; MXmodel.VBELN = JHDdata.ET_ItemData[i].VBELN; MXmodel.POSNR = JHDdata.ET_ItemData[i].POSNR; MXmodel.MATNR = JHDdata.ET_ItemData[i].MATNR; MXmodel.MAKTX = JHDdata.ET_ItemData[i].MAKTX; int MXid = crmModels.BC_FXCH.MXCreate(MXmodel, token); if (MXid == 0) { msg.KEY = 0; msg.MSG = "保存失败,请联系管理员"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } } } msg.KEY = 1; msg.MSG = "登记成功"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); }
public int Update(CRM_KH_KH KH_S, string ptoken, bool isKHID) { return(client.Update(KH_S, ptoken, isKHID)); }
public CRM_KH_KH[] ReadByJXS(CRM_KH_KH model, string ptoken) { return(client.ReadByJXS(model, ptoken)); }
public CRM_KH_KH[] Read(CRM_KH_KH keywords, string ptoken) { return(client.ReadByParmas(keywords, ptoken)); }
public int UpdateSFCS(CRM_KH_KH KH, string ptoken) { return(client.UpdateSFCS(KH, ptoken)); }
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_DaoRu_ProductGroup() { token = appClass.CRM_Gettoken(); DaoRuMsg msg = new DaoRuMsg(); try { var file = Request.Files[0]; //string date = DateTime.Now.ToString("yyyyMMddHHmmss"); //string fileName = date + "_" + KHID; string year = DateTime.Now.Year.ToString(); string month = DateTime.Now.Month.ToString(); string gotname = file.FileName; //string[] name = gotname.Split('.'); //int count = name.Length - 1; //string savePath = @"E:\CRM\Areas\CRM\upload\" + year + @"\" + month + @"\" + fileName + "." + name[count]; string savePath = FileSavePath + @"\excel\" + year + @"\" + month + @"\" + gotname; if (Directory.Exists(FileSavePath + @"\excel\" + year + @"\" + month) == false) { Directory.CreateDirectory(FileSavePath + @"\excel\" + year + @"\" + month); } file.SaveAs(savePath); FileInfo fi = new FileInfo(savePath); if (fi.Exists == true) { string[] sheet = { "产品", "产品组", "客户产品组" }; //开始做数据校验 DataTable data1 = ExcelToDataTable(savePath, sheet[0], true); //产品 #region if (data1 != null) { if (data1.Columns.Contains("产品类型") == false || data1.Columns.Contains("产品系列") == false || data1.Columns.Contains("产品型号") == false) { msg.Msg = "请使用产品新增模版!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } else { try { //做数据验证 if (data1.Rows.Count > 0) { for (int i = 0; i < data1.Rows.Count; i++) { int cplx = crmModels.HG_DICT.ReadByDICNAMEandFID(data1.Rows[i]["产品类型"].ToString(), 53, 0, token); if (cplx == 0) { msg.Msg = "产品第" + (i + 2) + "行产品类型不存在!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } int cpxl = crmModels.HG_DICT.ReadByDICNAMEandFID(data1.Rows[i]["产品系列"].ToString(), 54, cplx, token); if (cpxl == 0) { msg.Msg = "产品第" + (i + 2) + "行产品系列不存在!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } int cpxh = crmModels.HG_DICT.ReadByDICNAMEandFID(data1.Rows[i]["产品型号"].ToString(), 55, cpxl, token); if (cpxh == 0) { msg.Msg = "产品第" + (i + 2) + "行产品型号不存在!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } if (data1.Rows[i]["产品名称"].ToString() == "") { msg.Msg = "产品第" + (i + 2) + "行产品名称不可为空!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } if (data1.Rows[i]["产品图片"].ToString() == "") { msg.Msg = "产品第" + (i + 2) + "行产品图片不可为空!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } } } catch (Exception e) { msg.Msg = e.ToString(); return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } } #endregion DataTable data2 = ExcelToDataTable(savePath, sheet[1], true); //产品组 #region if (data2 != null) { if (data2.Columns.Contains("产品组") == false || data2.Columns.Contains("产品品号") == false) { msg.Msg = "请使用产品新增模版!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } else { try { //做数据验证 if (data2.Rows.Count > 0) { for (int i = 0; i < data2.Rows.Count; i++) { int cpz = crmModels.PRODUCT_GROUP.ReadByIDGroupName(data2.Rows[i]["产品组"].ToString(), token); if (cpz == 0) { msg.Msg = "产品组第" + (i + 2) + "行产品组不存在!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } CRM_PRODUCT_PRODUCT cx = new CRM_PRODUCT_PRODUCT(); cx.CPPH = data2.Rows[i]["产品品号"].ToString(); CRM_PRODUCT_PRODUCT[] cp = crmModels.PRODUCT_PRODUCT.ReadByParam(cx, token); if (cp.Length == 0) { msg.Msg = "产品组第" + (i + 2) + "行产品品号不存在!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } if (cp.Length != 1) { msg.Msg = "产品组第" + (i + 2) + "行产品品号存在复数目标!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } } } catch (Exception e) { msg.Msg = e.ToString(); return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } } #endregion DataTable data3 = ExcelToDataTable(savePath, sheet[2], true); //客户产品组 #region if (data3 != null) { if (data3.Columns.Contains("产品组") == false || data3.Columns.Contains("客户编号") == false || data3.Columns.Contains("客户SAP编号") == false) { msg.Msg = "请使用产品新增模版!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } else { try { //做数据验证 if (data3.Rows.Count > 0) { for (int i = 0; i < data3.Rows.Count; i++) { int cpz = crmModels.PRODUCT_GROUP.ReadByIDGroupName(data3.Rows[i]["产品组"].ToString(), token); if (cpz == 0) { msg.Msg = "客户产品组第" + (i + 2) + "行产品组不存在!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } if (data3.Rows[i]["客户编号"].ToString() == "" && data3.Rows[i]["客户SAP编号"].ToString() == "") { msg.Msg = "客户产品组第" + (i + 2) + "行客户编号不可为空!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } if (data3.Rows[i]["客户编号"].ToString() != "") { CRM_KH_KH kh_model = crmModels.KH_KH.ReadByCRMID(data3.Rows[i]["客户编号"].ToString(), token); if (kh_model.KHID == 0) { msg.Msg = "客户产品组第" + (i + 2) + "行客户编号不存在!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } if (data3.Rows[i]["客户SAP编号"].ToString() != "") { CRM_KH_KH kh_model = crmModels.KH_KH.ReadBySAPSN(data3.Rows[i]["客户SAP编号"].ToString(), token); if (kh_model.KHID == 0) { msg.Msg = "客户产品组第" + (i + 2) + "行客户SAP编号不存在!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } } } } catch (Exception e) { msg.Msg = e.ToString(); return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } } #endregion //能到这儿就说明数据是没问题的了...大概,然后才进行数据库写入 #region //产品 for (int i = 0; i < data1.Rows.Count; i++) { #region CRM_PRODUCT_PRODUCT model = new CRM_PRODUCT_PRODUCT(); model.CPLX = crmModels.HG_DICT.ReadByDICNAMEandFID(data1.Rows[i]["产品类型"].ToString().Trim(), 53, 0, token); model.CPXL = crmModels.HG_DICT.ReadByDICNAMEandFID(data1.Rows[i]["产品系列"].ToString().Trim(), 54, model.CPLX, token); model.CPXH = crmModels.HG_DICT.ReadByDICNAMEandFID(data1.Rows[i]["产品型号"].ToString().Trim(), 55, model.CPXL, token); model.CPPH = data1.Rows[i]["产品品号"].ToString().Trim(); model.CPMC = data1.Rows[i]["产品名称"].ToString().Trim(); model.CODE = data1.Rows[i]["条形码"].ToString().Trim(); model.DDDW = data1.Rows[i]["订单单位"].ToString().Trim(); model.BZDW = data1.Rows[i]["标准单位"].ToString().Trim(); model.RATE = Convert.ToInt32(data1.Rows[i]["转换率"].ToString().Trim()); model.ML = FileSavePath + @"\upload\img" + @"\CP\" + data1.Rows[i]["产品图片"].ToString().Trim(); model.ML_MOB = ""; model.BEIZ = ""; model.ISACTIVE = 1; model.CJR = appClass.CRM_GetStaffid(); int id = crmModels.PRODUCT_PRODUCT.Create(model, token); if (id <= 0) { msg.Msg = "新增产品的第" + (i + 2) + "行出现问题,请记录当前报错信息并联系管理员"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } #endregion } //产品组 for (int i = 0; i < data2.Rows.Count; i++) { #region CRM_PRODUCT_PRODUCT cx = new CRM_PRODUCT_PRODUCT(); cx.CPPH = data2.Rows[i]["产品品号"].ToString(); CRM_PRODUCT_PRODUCT[] cp = crmModels.PRODUCT_PRODUCT.ReadByParam(cx, token); int cpz = crmModels.PRODUCT_GROUP.ReadByIDGroupName(data2.Rows[i]["产品组"].ToString(), token); int id = crmModels.PRODUCT_PRODUCTGROUP.Create(cp[0].PRODUCTID, cpz, token); if (id <= 0) { msg.Msg = "新增产品组的第" + (i + 2) + "行出现问题,请记录当前报错信息并联系管理员"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } #endregion } //客户产品组 for (int i = 0; i < data3.Rows.Count; i++) { #region int cpz = crmModels.PRODUCT_GROUP.ReadByIDGroupName(data3.Rows[i]["产品组"].ToString(), token); CRM_KH_KH kh_model = new CRM_KH_KH(); if (data3.Rows[i]["客户编号"].ToString() != "") { kh_model = crmModels.KH_KH.ReadByCRMID(data3.Rows[i]["客户编号"].ToString(), token); } else { kh_model = crmModels.KH_KH.ReadBySAPSN(data3.Rows[i]["客户SAP编号"].ToString(), token); } int id = crmModels.PRODUCT_KHGROUP.Create(kh_model.KHID, cpz, token); if (id <= 0) { msg.Msg = "新增客户产品组的第" + (i + 2) + "行出现问题,请记录当前报错信息并联系管理员"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } #endregion } #endregion msg.Msg = "新增成功!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } else { msg.Msg = "文件读取失败!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } catch (Exception e) { msg.Msg = e.ToString(); return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } }