public void GetParamCon(TableHistoryItem item, bool isOld)
{
string content = isOld ? item.old_value : item.col_value;
switch (item.col_name)
{
case "product_mode":
content = QueryParaName(content, "product_mode");
break;
case "product_status":
content = QueryParaName(content, "product_status");
break;
case "price_status":
content = QueryParaName(content, "price_status");
break;
case "user_level":
content = QueryParaName(content, "UserLevel");
break;
case "cate_id":
content = QueryParaName(content, "product_cate");
break;
case "site_id":
content = QuerySiteName(content);
break;
case "user_id":
content = QuerySiteName(content);
break;
case "product_start":
case "product_end":
case "event_start":
case "event_end":
content = content.Trim() == "0" ? "" : BLL.gigade.Common.CommonFunction.GetNetTime(long.Parse(content)).ToString("yyyy/MM/dd HH:mm:ss");
break;
}
if (isOld)
{
item.old_value = content;
}
else
{
item.col_value = content;
}
}
//add by wwei0216w 2015/1/22
/// <summary>
/// 根據批次號獲得該彼此相關記錄
/// </summary>
/// <param name="th">條件</param>
/// <returns>IEnumerable<IGrouping<string,TableHistoryItemCustom>></returns>
public List<TableHistoryItemCustom> GetHistoryInfoByConditon(TableHistory th)
{
try
{
List<TableHistoryItemCustom> result = new List<TableHistoryItemCustom>();
//根據批次獲得符合條件的歷史操作記錄集合
DataTable dt = _tableHistoryItemDao.GetHistoryInfoByCondition(th);
foreach (DataRow dr in dt.Rows) {
if (result.FindIndex(p=>p.table_name == dr["table_name"].ToString())>=0)
continue;
TableHistoryItemCustom thic = new TableHistoryItemCustom();
thic.batchno = dr["batchno"].ToString();
thic.functionname = dr["functionName"].ToString();
thic.pk_name = dr["PK_name"].ToString();
thic.pk_value = dr["PK_value"].ToString();
thic.table_name = dr["table_name"].ToString();
foreach (DataRow dr1 in dt.Rows) {
if(dr1["table_name"].ToString() != dr["table_name"].ToString())
continue;
TableHistoryItem thi = new TableHistoryItem();
thi.col_chsname = dr1["col_chsName"].ToString();
thi.col_name = dr1["col_name"].ToString();
thi.col_value = dr1["col_value"].ToString();
thi.old_value = dr1["old_value"].ToString();
thi.rowid = Int32.Parse(dr1["rowid"].ToString());
thi.tablehistoryid = Int32.Parse(dr1["rowid"].ToString());
thi.type = Int32.Parse(dr1["type"].ToString());
thic.historyItem.Add(thi);
}
result.Add(thic);
}
return result;
}
catch (Exception ex)
{
throw new Exception("TableHistoryItemMgr-->GetHistoryInfoByConditon" + ex.Message, ex);
}
}