public string Data_SelectByGD(string cxdata, string BEGIN_DATE, string END_DATE)
{
token = appClass.CRM_Gettoken();
CRM_BC_PMLIST model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BC_PMLISTList>(cxdata);
CRM_BC_PMLISTList[] data = crmModels.BC_PMLIST.SelectByGDandParam(model, BEGIN_DATE, END_DATE, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public string Data_SelectKHbyDXM(string cxdata) //根据大箱码找到发给哪个客户
{
token = appClass.CRM_Gettoken();
CRM_BC_PMLIST model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BC_PMLIST>(cxdata);
CRM_BC_KH[] data = crmModels.BC_PMLIST.SelectKHbyDXM(model, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public string Data_SelectKHbyMCP(string cxdata) //根据Matnr、Charg、喷码找到发给哪个客户
{
token = appClass.CRM_Gettoken();
CRM_BC_PMLIST model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BC_PMLIST>(cxdata);
model.PM = model.PM.ToUpper();
CRM_BC_KH[] data = crmModels.BC_PMLIST.SelectKHbyMCP(model, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public string Data_SelectMATNRbyCP(string cxdata)
{
token = appClass.CRM_Gettoken();
CRM_BC_PMLIST model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BC_PMLIST>(cxdata);
model.PM = model.PM.ToUpper();
CRM_BC_PMLIST[] data = crmModels.BC_PMLIST.SelectMATNRbyCHARGandPM(model, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public string Data_Select_PM(string cxdata, string BEGIN_DATE, string END_DATE)
{
//暂时没用过
token = appClass.CRM_Gettoken();
CRM_BC_PMLIST model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BC_PMLIST>(cxdata);
model.PMTYPE = 1;
CRM_BC_PMLIST[] data = crmModels.BC_PMLIST.SelectByModel(model, BEGIN_DATE, END_DATE, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public string Delete_PMbyGD(string aufnr)
{
token = appClass.CRM_Gettoken();
CRM_BC_PMLIST cxmodel = new CRM_BC_PMLIST();
cxmodel.AUFNR = aufnr;
CRM_BC_PMLIST[] cxresult = crmModels.BC_PMLIST.SelectByModel(cxmodel, "", "", token);
string type = "";
if (cxresult[0].PMTYPE == 1)
{
type = "F";
}
else if (cxresult[0].PMTYPE == 2)
{
type = "B";
}
ZSL_BCST100 data = crmModels.BarCode.GET_ZBCFUN_PO_RECEIPT(aufnr, type, token);
if (data.Type != "S")
{
webmsg.KEY = 0;
webmsg.MSG = data.Message;
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
else
{
int i = crmModels.BC_PMLIST.DeleteByGD(aufnr, token);
if (i < 0)
{
webmsg.KEY = 0;
webmsg.MSG = "删除失败！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
else
{
webmsg.KEY = 1;
webmsg.MSG = "删除成功！";
return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg));
}
}
}
public CRM_BC_KH[] SelectKHbyDXM(CRM_BC_PMLIST model, string ptoken)
{
return(client.SelectKHbyDXM(model, ptoken));
}
public CRM_BC_PMLIST[] SelectMATNRbyCHARGandPM(CRM_BC_PMLIST model, string ptoken)
{
return(client.SelectMATNRbyCHARGandPM(model, ptoken));
}
public CRM_BC_PMLISTList[] SelectByGDandParam(CRM_BC_PMLIST model, string BEGIN_DATE, string END_DATE, string ptoken)
{
return(client.SelectByGDandParam(model, BEGIN_DATE, END_DATE, ptoken));
}
public CRM_BC_PMLIST[] SelectByModel(CRM_BC_PMLIST model, string BEGIN_DATE, string END_DATE, string ptoken)
{
return(client.SelectByModel(model, BEGIN_DATE, END_DATE, ptoken));
}
public int Create(CRM_BC_PMLIST model, string ptoken)
{
return(client.Create(model, ptoken));
}
public string Data_Insert_PM(string data, string isTuiHuo)
{
token = appClass.CRM_Gettoken();
try
{
CRM_BC_PMLIST model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BC_PMLIST>(data);
model.CJR = appClass.CRM_GetStaffid();
CRM_BC_PMLISTList[] xianyouData = crmModels.BC_PMLIST.SelectByGD(model.AUFNR, token);
if (xianyouData.Length != 0) //已经有该工单的数据
{
if (xianyouData[0].CHARG != model.CHARG)
{
return("已存在该工单，且日期唛不一致");
}
if (xianyouData[0].PM == "" && xianyouData[xianyouData.Length - 1].PM == "") //数据库里有该工单的信息，但箱码还未生成喷码
{
int error = crmModels.BC_PMLIST.UpdatePM(token); //生成喷码
if (error != 0)
{
return("喷码生成失败，请重试");
}
}
else //该工单的箱码已经生成了喷码
{
MODEL_ZBCFUN_TM_READ TMmodel = crmModels.BarCode.GET_ZBCFUN_TM_READ(model.AUFNR, "F", token);
if (TMmodel.ET_TM.Length == 0)
{
return("该工单没有所属箱码");
}
List <ZSL_BCT100> ET_TM = TMmodel.ET_TM.ToList();
//ET_TM = (from o in ET_TM orderby (o.DXM.Substring(2,o.DXM.Length-2)) select o).ToList();
ET_TM = ET_TM.OrderBy(u => u.TPM.Substring(2, u.TPM.Length - 2)).ThenBy(u => u.DXM.Substring(2, u.DXM.Length - 2)).ToList();
string PM = "";
if (isTuiHuo == "1") //如果是退货的话喷码统一为ZAA
{
PM = "ZAA";
}
string TPM_temp = "";
int isexist = 0; //变成1表示当前行是这回刚增进去的，所以其对应的托码整个都要增进去
for (int x = 0; x < ET_TM.Count; x++) //按箱码进行循环
{
CRM_BC_PMLIST cxmodel = new CRM_BC_PMLIST();
if (ET_TM[x].TPM != TPM_temp) //当托码变化时，去数据库看下这个托码是否已经存在
{
isexist = 0;
cxmodel.AUFNR = model.AUFNR;
cxmodel.TPM = ET_TM[x].TPM;
cxmodel.PMTYPE = 1;
CRM_BC_PMLIST[] cxresult = crmModels.BC_PMLIST.SelectByModel(cxmodel, "", "", token);
if (cxresult.Length != 0 && isexist == 0) //已经有这个托码了，就跳过
{
continue;
}
else //这个托码还没生成喷码
{
isexist = 1;
model.DXM = ET_TM[x].DXM;
model.TPM = ET_TM[x].TPM;
model.PM = PM;
model.PMTYPE = 1; //根据工单
int i = crmModels.BC_PMLIST.Create(model, token);
if (i <= 0)
{
return("生成失败！");
}
}
}
else
{
if (isexist == 1)
{
model.DXM = ET_TM[x].DXM;
model.TPM = ET_TM[x].TPM;
model.PM = PM;
model.PMTYPE = 1; //根据工单
int i = crmModels.BC_PMLIST.Create(model, token);
if (i <= 0)
{
return("生成失败！");
}
}
else
{
continue;
}
}
TPM_temp = ET_TM[x].TPM;
}
}
}
else //数据库里没有该工单的数据
{
MODEL_ZBCFUN_TM_READ TMmodel = crmModels.BarCode.GET_ZBCFUN_TM_READ(model.AUFNR, "F", token);
if (TMmodel.ET_TM.Length == 0)
{
return("该工单没有所属箱码");
}
List <ZSL_BCT100> ET_TM = TMmodel.ET_TM.ToList();
//ET_TM = (from o in ET_TM orderby (o.DXM.Substring(2,o.DXM.Length-2)) select o).ToList();
ET_TM = ET_TM.OrderBy(u => u.TPM.Substring(2, u.TPM.Length - 2)).ThenBy(u => u.DXM.Substring(2, u.DXM.Length - 2)).ToList();
string PM = "";
if (isTuiHuo == "1") //如果是退货的话喷码统一为ZAA
{
PM = "ZAA";
}
for (int x = 0; x < ET_TM.Count; x++)
{
model.DXM = ET_TM[x].DXM;
model.TPM = ET_TM[x].TPM;
model.PM = PM;
model.PMTYPE = 1; //根据工单
int i = crmModels.BC_PMLIST.Create(model, token);
if (i <= 0)
{
return("生成失败！");
}
}
//if (isTuiHuo == "0") //不是退货的话需要生成喷码
//{
// int error = crmModels.BC_PMLIST.UpdatePM(token); //生成喷码
// if (error != 0)
// {
// return "喷码生成失败，请重试";
// }
//}
}
}
catch (Exception e)
{
return(e.Message);
}
return("生成成功！");
}
