/// <summary> /// 当配置 /// </summary> /// <param name="model"></param> public static void InTotalPackageTraceInfo(TotalPackageTraceInfoModel model) { Log.Info("LMS开始插入总包号为:{0} 的总包号跟踪信息,事件码:{1}".FormatWith(model.TotalPackageNumber, model.TraceEventCode)); DbUtility dbUtility = new SqlDbUtility(_lmsCon); dbUtility.ExecuteNonQuery(@"INSERT INTO TotalPackageTraceInfos ([TotalPackageNumber],[TraceEventCode],[TraceEventTime],[TraceEventAddress] ,[CreatedBy],[LastUpdatedBy],[TraceEventContent]) VALUES({0},{1},{2},{3},{4},{5},{6})", model.TotalPackageNumber, model.TraceEventCode, model.TraceEventTime, model.TraceEventAddress, model.CreatedBy, model.CreatedBy, ""); Log.Info("LMS完成插入总包号为:{0} 的总包号跟踪信息,事件码:{1}".FormatWith(model.TotalPackageNumber, model.TraceEventCode)); }
/// <summary> /// 获取需要运行增加跟踪信息的总单号 /// </summary> /// <returns></returns> public static List <TotalPackageTraceInfoModel> GetTotalPackageTraceInfo() { DbUtility dbUtility = new SqlDbUtility(_lmsCon); DataTable dt = dbUtility.ExecuteData( @" select ID,TotalPackageNumber,TraceEventCode,TraceEventTime,TraceEventAddress,CreatedBy from TotalPackageTraceInfos tp where IsJob=0 and TraceEventTime<=GETDATE() AND EXISTS(SELECT 1 FROM TotalPackageInfos ti WHERE ti.TotalPackageNumber=tp.TotalPackageNumber AND ti.CreatedOn>'" + StartDate + "')"); var list = new List <TotalPackageTraceInfoModel>(); if (dt != null && dt.Rows.Count > 0) { Log.Info("LMS总包号编辑时间记录总数是" + dt.Rows.Count); for (int i = 0; i < dt.Rows.Count; i++) { var v = new TotalPackageTraceInfoModel(); for (int j = 0; j < dt.Columns.Count; j++) { switch (dt.Columns[j].ColumnName) { case "TotalPackageNumber": v.TotalPackageNumber = dt.Rows[i][j].ToString(); break; case "TraceEventCode": v.TraceEventCode = Int32.Parse(dt.Rows[i][j].ToString()); break; case "TraceEventTime": v.TraceEventTime = DateTime.Parse(dt.Rows[i][j].ToString()); break; case "TraceEventAddress": v.TraceEventAddress = dt.Rows[i][j].ToString(); break; case "CreatedBy": v.CreatedBy = dt.Rows[i][j].ToString(); break; case "ID": v.ID = Int32.Parse(dt.Rows[i][j].ToString()); break; } } list.Add(v); } } Log.Info("LMS总包号编辑时间记录获取完毕!"); return(list); }
/// <summary> /// 插入内部跟踪信息 /// </summary> /// <param name="model"></param> public static bool InsertInTrackingLogInfo(TotalPackageTraceInfoModel model, string shippingMethodConfig) { var result = false; Log.Info("LMS开始插入总包号为:{0} 的内部信息".FormatWith(model.TotalPackageNumber)); DbUtility dbUtility = new SqlDbUtility(_lmsCon); var obj = dbUtility.ExecuteScalar("exec P_TotalPackageNumberJob {0},{1}", model.ID, shippingMethodConfig); if (obj != null && obj.ToString() == "1") { dbUtility.ExecuteNonQuery( "UPDATE TotalPackageTraceInfos SET IsJob=1,LastUpdatedOn=GETDATE() WHERE ID={0}", model.ID); result = true; } Log.Info("LMS完成插入总包号为:{0} 的内部信息".FormatWith(model.TotalPackageNumber)); return(result); }