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