public Model.Custom.TableChangeLogCustom GetVendorChangeDetail(TableChangeLogQuery query)
{
try
{
DataTable _dt = _tclDao.GetVendorChangeDetail(query);
Model.Custom.TableChangeLogCustom _model = new Model.Custom.TableChangeLogCustom();
if (_dt.Rows.Count > 0)
{
Dao.ParametersrcDao _pDao = new Dao.ParametersrcDao(connStr);
List<Model.Parametersrc> _pModel = _pDao.Query(new Model.Parametersrc { ParameterType = "ColumnChange", ParameterCode = "vendor" });
List<Model.Parametersrc> _slist = _pDao.QueryParametersrcByTypes("vendor_type");
if (_pModel.Count > 0)
{
_model.vendor_id = Convert.ToInt32(_dt.Rows[0]["vendor_id"].ToString());
_model.vendor_name_full = _dt.Rows[0]["vendor_name_full"].ToString();
List<Model.TableChangeLog> _list = new List<Model.TableChangeLog>();
foreach (DataRow dr in _dt.Rows)
{
Model.TableChangeLog _log = new Model.TableChangeLog();
_log.change_field = dr["change_field"].ToString();
if (_log.change_field == "vendor_status")
{
string[] status_str = { "", "啟用", "停用", "失格" };
_log.old_value = status_str[Convert.ToInt32(dr["old_value"].ToString())].ToString();
_log.new_value = status_str[Convert.ToInt32(dr["new_value"].ToString())].ToString();
}
else if (_log.change_field == "product_manage")
{
ManageUserMgr mu = new ManageUserMgr(connStr);
List<ManageUser> o_mlist = mu.GetManageUser(new ManageUser { user_id = Convert.ToUInt32(dr["old_value"].ToString()) });
List<ManageUser> n_mlist = mu.GetManageUser(new ManageUser { user_id = Convert.ToUInt32(dr["new_value"].ToString()) });
if (o_mlist.Count > 0)
{
_log.old_value = o_mlist[0].user_username;
}
if (n_mlist.Count > 0)
{
_log.new_value = n_mlist[0].user_username;
}
}
else if (_log.change_field.IndexOf("contact_type") > -1)
{
string[] type_str = { "", "負責人", "業務窗口", "圖/文窗口", "出貨負責窗口", "帳務連絡窗口", "客服窗口", "刪除" };
_log.old_value = type_str[Convert.ToInt32(dr["old_value"].ToString())].ToString();
if (dr["new_value"].ToString() != "")
{
_log.new_value = type_str[Convert.ToInt32(dr["new_value"].ToString())].ToString();
}
else
{
_log.new_value = type_str[0].ToString();
}
}
else if (_log.change_field == "vendor_type")//供應商類型
{
if (_slist.Count > 0)
{
var a_o = dr["old_value"].ToString().Split(',');
var a_n = dr["new_value"].ToString().Split(',');
string l_o = ""; string l_n = "";
for (int i = 0; i < a_o.Length; i++)
{
if (!string.IsNullOrEmpty(a_o[i].ToString()))
{
l_o = l_o + _slist.Find(m => m.ParameterCode == a_o[i].ToString()).parameterName + ",";
}
}
for (int i = 0; i < a_n.Length; i++)
{
if (!string.IsNullOrEmpty(a_n[i].ToString()))
{
l_n = l_n + _slist.Find(m => m.ParameterCode == a_n[i].ToString()).parameterName + ",";
}
}
_log.old_value = l_o.TrimEnd(',');
_log.new_value = l_n.TrimEnd(',');
}
}
else if (_log.change_field == "company_address" || _log.change_field == "invoice_address")//公司地址或發票地址
{
string o_zip = dr["old_value"].ToString().Split('&')[0];
string o_adress = dr["old_value"].ToString().Substring(dr["old_value"].ToString().IndexOf('&') + 1);
string n_zip = dr["new_value"].ToString().Split('&')[0];
string n_adress = dr["new_value"].ToString().Substring(dr["new_value"].ToString().IndexOf('&') + 1);
ZipMgr zip = new ZipMgr(connStr);
_log.old_value = zip.Getaddress(Convert.ToInt32(o_zip)) + o_adress;
_log.new_value = zip.Getaddress(Convert.ToInt32(n_zip)) + n_adress;
}
else
{
_log.old_value = dr["old_value"].ToString();
_log.new_value = dr["new_value"].ToString();
}
if (!string.IsNullOrEmpty(dr["field_ch_name"].ToString()))
{
_log.field_ch_name = dr["field_ch_name"].ToString();
}
else
{
_log.field_ch_name = _pModel.Find(m => m.parameterName == _log.change_field).remark;
}
_list.Add(_log);
}
_model.tclModel = _list;
}
}
return _model;
}
catch (Exception ex)
{
throw new Exception("TableChangeLogMgr-->GetVendorChangeDetail-->" + ex.Message, ex);
}
}
public Model.Custom.TableChangeLogCustom GetChangeLogDetailList(int pk_id,int comment_id_display, string create_time)
{
try
{
DataTable _dt = _proCommentDao.GetChangeLogDetailList( pk_id,create_time);
Model.Custom.TableChangeLogCustom _model = new Model.Custom.TableChangeLogCustom();
if (_dt.Rows.Count > 0)
{
_model.pk_id = Convert.ToInt32(_dt.Rows[0]["pk_id"].ToString());
_model.comment_id_display = comment_id_display;
_model.change_table = _dt.Rows[0]["change_table"].ToString();
List<Model.TableChangeLog> _list = new List<Model.TableChangeLog>();
foreach (DataRow item in _dt.Rows)
{
Model.TableChangeLog _log = new Model.TableChangeLog();
if (item["change_table"].ToString() == "comment_detail")
{
_model.change_table_function = "評價回覆";
if (item["change_field"].ToString() == "answer_is_show")
{
//item["old_value"]=item["old_value"].ToString() == "0" ? "否" : "是";
if (item["old_value"].ToString() == "0")
{
item["old_value"] = "否";
}
if (item["old_value"].ToString() == "1")
{
item["old_value"] = "是";
}
if (item["old_value"].ToString() == "-1")
{
item["old_value"] = "";
}
if (item["new_value"].ToString() == "0")
{
item["new_value"] = "否";
}
if (item["new_value"].ToString() == "1")
{
item["new_value"] = "是";
}
}
if (item["change_field"].ToString() == "send_mail")
{
//item["old_value"]=item["old_value"].ToString() == "0" ? "否" : "是";
if (item["old_value"].ToString() == "0")
{
item["old_value"] = "發送成功";
}
if (item["old_value"].ToString() == "1")
{
item["old_value"] = "否";
}
if (item["old_value"].ToString() == "2")
{
item["old_value"] = "發送失敗";
}
if (item["new_value"].ToString() == "0")
{
item["new_value"] = "發送成功";
}
if (item["new_value"].ToString() == "1")
{
item["new_value"] = "否";
}
if (item["new_value"].ToString() == "2")
{
item["new_value"] = "發送失敗";
}
}
}
else if (item["change_table"].ToString() == "comment_num")
{
_model.change_table_function = "商品評價";
if (item["change_field"].ToString() == "logistics_deliver" || item["change_field"].ToString() == "web_server" || item["change_field"].ToString() == "seller_server" || item["change_field"].ToString() == "product_desc")
{
if (item["new_value"].ToString() == "1")
{
item["new_value"] = "非常不滿意(1分)";
}
else if (item["new_value"].ToString() == "2")
{
item["new_value"] = "不滿意(2分)";
}
else if (item["new_value"].ToString() == "3")
{
item["new_value"] = "一般(3分)";
}
else if (item["new_value"].ToString() == "4")
{
item["new_value"] = "滿意(4分)";
}
else if (item["new_value"].ToString() == "5")
{
item["new_value"] = "非常滿意(5分)";
}
if (item["old_value"].ToString() == "1")
{
item["old_value"] = "非常不滿意(1分)";
}
else if (item["old_value"].ToString() == "2")
{
item["old_value"] = "不滿意(2分)";
}
else if (item["old_value"].ToString() == "3")
{
item["old_value"] = "一般(3分)";
}
else if (item["old_value"].ToString() == "4")
{
item["old_value"] = "滿意(4分)";
}
else if (item["old_value"].ToString() == "5")
{
item["old_value"] = "非常滿意(5分)";
}
}
}
_log.change_field = item["change_field"].ToString();
_log.old_value = item["old_value"].ToString();
_log.new_value = item["new_value"].ToString();
_log.field_ch_name = item["field_ch_name"].ToString();
_list.Add(_log);
}
_model.tclModel = _list;
}
return _model;
}
catch (Exception ex)
{
throw new Exception("ProductCommentMgr.GetChangeLogDetailList-->" + ex.Message, ex);
}
}
