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));
}
