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