public JsonResult qryRoleEquipHis(string roleId, string aplyNo)
{
CodeRoleTreaItemHisDao codeRoleTreaItemHisDao = new CodeRoleTreaItemHisDao();
try
{
List <CodeRoleEquipModel> rows = new List <CodeRoleEquipModel>();
rows = codeRoleTreaItemHisDao.qryByAplyNo(aplyNo);
if (rows.Count == 0)
{
CodeRoleTreaItemDao codeRoleTreaItemDao = new CodeRoleTreaItemDao();
rows = codeRoleTreaItemDao.qryForRoleMgr(roleId);
}
var jsonData = new { success = true, rows };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
logger.Error("其它錯誤：" + e.ToString());
return(Json(new { success = false, err = "其它錯誤，請洽系統管理員!!" }));
}
}
/// <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;
}
}
}
}
}