/** * 刪除角色金庫設備資料檔 **/ public int Delete(CODE_ROLE_TREA_ITEM roleEquip, SqlConnection conn, SqlTransaction transaction) { string sql = @"delete CODE_ROLE_TREA_ITEM where 1=1 and ROLE_ID = @ROLE_ID and TREA_EQUIP_ID = @TREA_EQUIP_ID "; SqlCommand command = conn.CreateCommand(); command.Connection = conn; command.Transaction = transaction; try { command.CommandText = sql; command.Parameters.AddWithValue("@ROLE_ID", StringUtil.toString(roleEquip.ROLE_ID)); command.Parameters.AddWithValue("@TREA_EQUIP_ID", StringUtil.toString(roleEquip.TREA_EQUIP_ID)); int cnt = command.ExecuteNonQuery(); return(cnt); } catch (Exception e) { throw e; } }
/** * 修改角色金庫設備資料檔 **/ public int Update(CODE_ROLE_TREA_ITEM roleEquip, SqlConnection conn, SqlTransaction transaction) { string sql = @" update CODE_ROLE_TREA_ITEM set CUSTODY_MODE = @CUSTODY_MODE , CUSTODY_ORDER = @CUSTODY_ORDER , LAST_UPDATE_UID = @LAST_UPDATE_UID , LAST_UPDATE_DT = @LAST_UPDATE_DT where ROLE_ID = @ROLE_ID and TREA_EQUIP_ID = @TREA_EQUIP_ID "; SqlCommand command = conn.CreateCommand(); command.Connection = conn; command.Transaction = transaction; try { command.CommandText = sql; command.Parameters.AddWithValue("@ROLE_ID", StringUtil.toString(roleEquip.ROLE_ID)); command.Parameters.AddWithValue("@TREA_EQUIP_ID", StringUtil.toString(roleEquip.TREA_EQUIP_ID)); command.Parameters.AddWithValue("@CUSTODY_MODE", StringUtil.toString(roleEquip.CUSTODY_MODE)); command.Parameters.AddWithValue("@CUSTODY_ORDER", roleEquip.CUSTODY_ORDER); command.Parameters.AddWithValue("@LAST_UPDATE_UID", StringUtil.toString(roleEquip.LAST_UPDATE_UID)); command.Parameters.AddWithValue("@LAST_UPDATE_DT", DateTime.Now); int cnt = command.ExecuteNonQuery(); return(cnt); } catch (Exception e) { throw e; } }
/** * 將角色金庫設備資料檔的各欄位組成一字串,for Log **/ public String logContent(CODE_ROLE_TREA_ITEM roleEquip) { String content = ""; content += StringUtil.toString(roleEquip.ROLE_ID) + '|'; content += StringUtil.toString(roleEquip.TREA_EQUIP_ID) + '|'; content += StringUtil.toString(roleEquip.CUSTODY_MODE) + '|'; content += roleEquip.CUSTODY_ORDER + '|'; content += StringUtil.toString(roleEquip.LAST_UPDATE_UID) + '|'; content += roleEquip.LAST_UPDATE_DT; return(content); }
public CODE_ROLE_TREA_ITEM getRoleEquipByKey(string roleId, string treaEquipId) { using (new TransactionScope( TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted })) { using (dbTreasuryEntities db = new dbTreasuryEntities()) { CODE_ROLE_TREA_ITEM roleEquip = db.CODE_ROLE_TREA_ITEM.Where(x => x.ROLE_ID == roleId && x.TREA_EQUIP_ID == treaEquipId).FirstOrDefault(); return(roleEquip); } } }
/// <summary> /// 處理角色設備異動 /// </summary> /// <param name="roleId"></param> /// <param name="aplyNO"></param> /// <param name="conn"></param> /// <param name="transaction"></param> private void procRoleEquipHis(string roleId, string aplyNo, SqlConnection conn, SqlTransaction transaction) { CodeRoleTreaItemHisDao codeRoleTreaItemHisDao = new CodeRoleTreaItemHisDao(); List <CodeRoleEquipModel> cRoleEquipList = codeRoleTreaItemHisDao.qryByAplyNo(aplyNo); if (cRoleEquipList != null) { if (cRoleEquipList.Count > 0) { CodeRoleTreaItemDao codeRoleTreaItemDao = new CodeRoleTreaItemDao(); foreach (CodeRoleEquipModel d in cRoleEquipList) { CODE_ROLE_TREA_ITEM dEquip = new CODE_ROLE_TREA_ITEM(); Log log = new Log(); switch (d.execAction) { case "A": dEquip.ROLE_ID = roleId; dEquip.TREA_EQUIP_ID = StringUtil.toString(d.treaEquipId); dEquip.CUSTODY_MODE = StringUtil.toString(d.custodyMode); dEquip.CUSTODY_ORDER = Convert.ToInt16(d.custodyOrder); dEquip.LAST_UPDATE_UID = Session["UserID"].ToString(); dEquip.LAST_UPDATE_DT = DateTime.Now; //新增資料 codeRoleTreaItemDao.Insert(dEquip, conn, transaction); //新增LOG log.CFUNCTION = "角色管理(金庫設備)-新增"; log.CACTION = "A"; log.CCONTENT = codeRoleTreaItemDao.logContent(dEquip); LogDao.Insert(log, Session["UserID"].ToString()); break; case "U": dEquip = codeRoleTreaItemDao.getRoleEquipByKey(roleId, d.treaEquipId); //新增LOG log.CCONTENT = codeRoleTreaItemDao.logContent(dEquip); log.CFUNCTION = "角色管理(金庫設備)-修改"; log.CACTION = "U"; LogDao.Insert(log, Session["UserID"].ToString()); dEquip.CUSTODY_MODE = StringUtil.toString(d.custodyMode); dEquip.CUSTODY_ORDER = Convert.ToInt16(d.custodyOrder); dEquip.LAST_UPDATE_UID = Session["UserID"].ToString(); dEquip.LAST_UPDATE_DT = DateTime.Now; //修改資料 codeRoleTreaItemDao.Update(dEquip, conn, transaction); break; case "D": dEquip = codeRoleTreaItemDao.getRoleEquipByKey(roleId, d.treaEquipId); //新增LOG log.CCONTENT = codeRoleTreaItemDao.logContent(dEquip); log.CFUNCTION = "角色管理(金庫設備)-刪除"; log.CACTION = "D"; LogDao.Insert(log, Session["UserID"].ToString()); //刪除資料 codeRoleTreaItemDao.Delete(dEquip, conn, transaction); break; default: break; } } } } }