public int UnGrade(string vendorId, string active, List<TableChangeLog> list)
{
try
{
#region 處理table_change_log 記錄供應商資料異動
ArrayList _list = new ArrayList();
//if (!string.IsNullOrEmpty(update_log))
//{
//
// TableChangeLogDao _logDao = new TableChangeLogDao(connStr);
// string[] arr_col = update_log.Split(':');
// TableChangeLog tcl = new TableChangeLog();
// tcl.change_table = "vendor";
// tcl.change_field = arr_col[0].ToString();
// tcl.field_ch_name = arr_col[3].ToString();
// tcl.create_time = DateTime.Now;
// tcl.create_user = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
// tcl.pk_id = Convert.ToInt32(vendorId);
// tcl.old_value = arr_col[1].ToString();
// tcl.new_value = arr_col[2].ToString();
// tcl.user_type = 2;
// _list.Add(_logDao.insert(tcl));
// _mysqlDao.ExcuteSqls(_list);
//}
if (list != null)
{
foreach (TableChangeLog t in list)
{
TableChangeLogDao _logDao = new TableChangeLogDao(connStr);
t.change_table = "vendor";
_list.Add(_logDao.insert(t));
}
}
#endregion
return _vendorDao.UnGrade(vendorId, active);
}
catch (Exception ex)
{
throw new Exception("VendorMgr-->UnGrade-->" + ex.Message, ex);
}
}
public int Update(VendorQuery model, List<TableChangeLog> list)
{
UserHistoryDao _userhistoryDao = new UserHistoryDao(connStr);
SerialDao _serialDao = new SerialDao(connStr);
model.Replace4MySQL();
int i = 0;
try
{
ArrayList _list = new ArrayList();
model.content = _vendorDao.ReturnHistoryCon(model).ToString();
#region 處理vendor表
_list.Add(_vendorDao.UpdateVendor(model));
#endregion
#region 處理userhistory表
_list.Add(_userhistoryDao.Save(model));
#endregion
#region 處理table_change_log 記錄供應商資料異動
//if (!string.IsNullOrEmpty(update_log))
//{
// update_log = update_log.TrimEnd('#');//去掉最後一個#
// string[] arr_log = update_log.Split('#');//分離每條記錄
// foreach (string item in arr_log)
// {
// TableChangeLogDao _logDao = new TableChangeLogDao(connStr);
// string[] arr_col = item.Split(':');
// TableChangeLog tcl = new TableChangeLog();
// tcl.change_table = "vendor";
// tcl.change_field = arr_col[0].ToString();
// tcl.field_ch_name = arr_col[3].ToString();
// tcl.create_time = model.created;
// tcl.create_user = (int)model.kuser_id;
// tcl.pk_id = (int)model.vendor_id;
// tcl.old_value = arr_col[1].ToString();
// tcl.new_value = arr_col[2].ToString();
// tcl.user_type = model.user_type;
// _list.Add(_logDao.insert(tcl));
// }
//}
if (list != null)
{
foreach (TableChangeLog t in list)
{
TableChangeLogDao _logDao = new TableChangeLogDao(connStr);
t.change_table = "vendor";
t.create_time = model.created;
t.create_user = (int)model.kuser_id;
t.pk_id = (int)model.vendor_id;
t.user_type = model.user_type;
_list.Add(_logDao.insert(t));
}
}
#endregion
if (_mysqlDao.ExcuteSqls(_list))
{
i = 1;
}
return i;
}
catch (Exception ex)
{
throw new Exception("VendorDao-->Update-->" + ex.Message, ex);
}
}
