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