public string Data_GetBarCodeByGD(string aufnr)
{
token = appClass.CRM_Gettoken();
MODEL_ZBCFUN_TM_READ data = crmModels.BarCode.GET_ZBCFUN_TM_READ(aufnr, "F", token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
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("生成成功！");
}
