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