/**
* 刪除角色金庫設備資料檔
**/
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;
}
}
}
}
}
