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