public string Data_Select_ProductByID(int PRODUCTID) { token = appClass.CRM_Gettoken(); CRM_PRODUCT_PRODUCT data = crmModels.PRODUCT_PRODUCT.ReadByID(PRODUCTID, token); string netpath = System.Configuration.ConfigurationManager.AppSettings["NETPATH"]; if (data.ML != "") { string[] p = data.ML.Split('\\'); int count = p.Length - 1; string path = p[count - 2] + @"/" + p[count - 1] + @"/" + p[count]; data.ML = netpath + path; } return(Newtonsoft.Json.JsonConvert.SerializeObject(data)); }
public string Data_Select_ProductByParam(string cxdata) { token = appClass.CRM_Gettoken(); CRM_PRODUCT_PRODUCT model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_PRODUCT_PRODUCT>(cxdata); CRM_PRODUCT_PRODUCT[] data = crmModels.PRODUCT_PRODUCT.ReadByParam(model, 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 string Data_Insert_Product(string data) { token = appClass.CRM_Gettoken(); CRM_PRODUCT_PRODUCT model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_PRODUCT_PRODUCT>(data); model.CJR = appClass.CRM_GetStaffid(); model.ISACTIVE = 1; int i = crmModels.PRODUCT_PRODUCT.Create(model, token); webmsg.KEY = i; if (i > 0) { webmsg.MSG = "新增成功"; } else { webmsg.MSG = "新增失败!"; } return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); }
public string Data_Insert_ProductImg(int PRODUCTID) //上传产品照片 { var file = Request.Files[0]; string date = DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss.fff"); string fileName = "cp_" + date; 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 Path_Data = FileSavePath + @"\upload\img" + @"\CP\" + fileName + "." + name[count]; string Path = FileSavePath2 + @"\\upload\\img" + @"\\CP\\" + fileName + "." + name[count]; string netpath = System.Configuration.ConfigurationManager.AppSettings["NETPATH"] + @"img\/" + @"CP\/" + fileName + "." + name[count]; file.SaveAs(Path); FileInfo fi = new FileInfo(Path); if (fi.Exists == true) { if (PRODUCTID != 0) { token = appClass.CRM_Gettoken(); CRM_PRODUCT_PRODUCT data = crmModels.PRODUCT_PRODUCT.ReadByID(PRODUCTID, token); data.ML = Path_Data; crmModels.PRODUCT_PRODUCT.Update(data, token); } string json = "{\"code\":0,\"res\":\"" + netpath + "\",\"locapath\":\"" + Path + "\"}"; return(json); } else { return(""); } }
public string Data_Update_Product(string data) { token = appClass.CRM_Gettoken(); CRM_PRODUCT_PRODUCT model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_PRODUCT_PRODUCT>(data); model.XGR = appClass.CRM_GetStaffid(); if (model.ML == "") { model.ML = crmModels.PRODUCT_PRODUCT.ReadByID(model.PRODUCTID, token).ML; } int i = crmModels.PRODUCT_PRODUCT.Update(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 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)); } }
public CRM_PRODUCT_PRODUCT[] ReadByParam(CRM_PRODUCT_PRODUCT model, string ptoken) { return(client.ReadByParam(model, ptoken)); }
public int Update(CRM_PRODUCT_PRODUCT model, string ptoken) { return(client.Update(model, ptoken)); }