public Result <bool> UpState(CombineResponsePushModel model, int type)
{
var result = new Result <bool>()
{
HasError = false
};
try
{
var sql = "";
if (type == 0)//失败
{
sql = $"update EPC_CombineResponse set PushNum = PushNum+1 where Id=@Id and StatusId=0";
}
if (type == 1)//成功
{
sql = $"update EPC_CombineResponse set StatusId=1 where Id=@Id and StatusId=0";
}
using (var conn = OpenConnection("Yanwen_EPC"))
{
result.Data = conn.Execute(sql, new { model.Id }) > 0;
if (!result.Data)
{
result.HasError = true;
result.ErrorMsg = $"更新状态没有成功！Id[{model.Id}]单号[{model.Number}]";
return(result);
}
}
}
catch (Exception e)
{
result.HasError = true;
result.ErrorMsg = "更新状态出错！详情：" + e.Message;
return(result);
}
return(result);
}
/// <summary>
/// 修改推送状态是否成功
/// </summary>
/// <param name="t"></param>
/// <param name="type">0 修改失败 1修改成功</param>
/// <param name="json">json数据</param>
/// <param name="msg">首要错误信息</param>
public void ErrorLog(CombineResponsePushModel t, int type, string json, string msg)
{
if (!string.IsNullOrWhiteSpace(msg))
{
Logger.Error(msg);
PushDataDal.Instance.SavePushMessage(new PushMessageModel {
Type = "0", TaskId = t.Id, Number = t.Number, Msg = msg, Table = "EPC_CombineResponse", Rjson = json, Fjson = "", Node = "TMS-Input"
});
}
var badState = PushDataDal.Instance.UpState(t, type);
if (badState.HasError)
{
Logger.Error($"单号[{t.Number}]修改推送状态时出错" + badState.ErrorMsg);
return;
}
if (type == 1)
{
Logger.Info($"单号[{t.Number}]推送成功");
PushDataDal.Instance.SavePushMessage(new PushMessageModel {
Type = "0", TaskId = t.Id, Number = t.Number, Msg = msg, Table = "EPC_CombineResponse", Rjson = json, Fjson = "", Node = "TMS-Input"
});
}
}
/// <summary>
/// 类型转换
/// </summary>
/// <param name="model"></param>
/// <param name="orders"></param>
/// <param name="item"></param>
/// <param name="exchangeNumber"></param>
/// <returns></returns>
public EpcCombineModel ConversionModel(EpcCombineResponseModel model, List <string> orders, CombineResponsePushModel item, string exchangeNumber)
{
var reslut = new EpcCombineModel {
};
reslut.ExchangeNumber = exchangeNumber;
reslut.BarCode = model.barcode;
reslut.CombineId = item.Number;
reslut.Weight = EpcDal.Instance.GetEpcCombineWeight(orders, item.Parameter, item.Parameter1);
reslut.carrier = model.carrier;
reslut.Piece = orders.Count;
reslut.pdf_10_en_url = model.pdf_10_en_url;
reslut.pdf_10_lcl_url = model.pdf_10_lcl_url;
reslut.pdf_a4_en_url = model.pdf_a4_en_url;
reslut.pdf_a4_lcl_url = model.pdf_a4_lcl_url;
reslut.label_format = model.label_format;
reslut.PackageLabelsType = item.Parameter;
return(reslut);
}
