public DataTable GetVendorChangeLog(TableChangeLogQuery query, out int totalCount)
{
try
{
DataTable _dt = _tclDao.GetVendorChangeLog(query, out totalCount);
_dt.Columns.Add("kuser_name");
_dt.Columns.Add("muser_name");
if (_dt.Rows.Count > 0)
{
foreach (DataRow item in _dt.Rows)
{
Dao.ManageUserDao _muDao = new Dao.ManageUserDao(connStr);
if (!string.IsNullOrEmpty(item["kuser"].ToString()) && item["kuser"].ToString() != "0")
{
item["kuser_name"] = _muDao.GetManageUser(new Model.ManageUser { user_id = Convert.ToUInt32(item["kuser"].ToString()) }).FirstOrDefault().user_username;
}
if (!string.IsNullOrEmpty(item["muser"].ToString()) && item["muser"].ToString() != "0")
{
item["muser_name"] = _muDao.GetManageUser(new Model.ManageUser { user_id = Convert.ToUInt32(item["muser"].ToString()) }).FirstOrDefault().user_username;
}
}
}
return _dt;
}
catch (Exception ex)
{
throw new Exception("TableChangeLogMgr-->GetVendorChangeLog-->" + ex.Message, ex);
}
}
public DataTable GetChangeLogList(ProductCommentQuery query, out int totalCount)
{
try
{
DataTable _dt = _proCommentDao.GetChangeLogList(query, out totalCount);
_dt.Columns.Add("user_name");
if (_dt.Rows.Count > 0)
{
foreach (DataRow item in _dt.Rows)
{
Dao.ManageUserDao _muDao = new Dao.ManageUserDao(connStr);
if (!string.IsNullOrEmpty(item["create_user"].ToString()) && item["create_user"].ToString() != "0")
{
item["user_name"] = _muDao.GetManageUser(new Model.ManageUser { user_id = Convert.ToUInt32(item["create_user"].ToString()) }).FirstOrDefault().user_username;
}
}
}
return _dt;
//return _proCommentDao.GetChangeLogList(query, out totalCount);
}
catch (Exception ex)
{
throw new Exception("ProductCommentMgr.GetChangeLogList-->" + ex.Message, ex);
}
}