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 = "其它錯誤，請洽系統管理員!!" }));
}
}
public ActionResult qryEquip(string cRoleID)
{
CodeRoleTreaItemDao codeRoleTreaItemDao = new CodeRoleTreaItemDao();
try
{
List <CodeRoleEquipModel> roleEquipList = codeRoleTreaItemDao.qryForRoleMgr(cRoleID);
Log log = new Log();
log.CFUNCTION = "角色維護-金庫設備查詢";
log.CACTION = "Q";
log.CCONTENT = "cRoleID:" + cRoleID + "|totCnt:" + roleEquipList.Count;
LogDao.Insert(log, Session["UserID"].ToString());
return(Json(new { success = true, roleEquipList = roleEquipList }));
}
catch (Exception e)
{
logger.Error("[qryEquip]:" + e.ToString());
return(Json(new { success = false, err = "其它錯誤，請洽系統管理員!!" }));
}
}
public ActionResult updateRole(RoleMgrModel roleMgrModel, String authFunc
, List <CodeRoleEquipModel> equipData, List <CodeRoleItemModel> itemData, List <CodeRoleItemModel> formAplyData)
{
string roleId = StringUtil.toString(roleMgrModel.cRoleID);
bool bChgRole = false;
bool bChgFunc = false;
bool bChgEquip = false;
bool bChgItem = false;
bool bChgFormAply = false;
bool bNewRole = false;
CodeRoleDao codeRoleDao = new CodeRoleDao();
CODE_ROLE codeRoleO = new CODE_ROLE();
bool bDupRoleName = codeRoleDao.dupRoleName(StringUtil.toString(roleMgrModel.cRoleID),
StringUtil.toString(roleMgrModel.roleAuthType), StringUtil.toString(roleMgrModel.cRoleName));
if (bDupRoleName)
{
return(Json(new { success = false, errors = "相同角色群組下,不能建置相同的角色名稱!!" }, JsonRequestBehavior.AllowGet));
}
//比對是否有異動"角色資訊"
if ("".Equals(roleId))
{
bNewRole = true;
bChgRole = true;
SysSeqDao sysSeqDao = new SysSeqDao();
var cId = sysSeqDao.qrySeqNo("F1", "").ToString();
roleId = "F1" + cId.ToString().PadLeft(8, '0');
}
else
{
codeRoleO = codeRoleDao.qryRoleByKey(roleId);
if (!(
StringUtil.toString(roleMgrModel.cRoleName).Equals(StringUtil.toString(codeRoleO.ROLE_NAME)) &&
StringUtil.toString(roleMgrModel.isDisabled).Equals(StringUtil.toString(codeRoleO.IS_DISABLED)) &&
StringUtil.toString(roleMgrModel.vMemo).Equals(StringUtil.toString(codeRoleO.MEMO))
))
{
bChgRole = true;
}
}
//比對是否有異動"授權功能"
List <FuncRoleModel> funcList = new List <FuncRoleModel>();
string[] funcData = authFunc.Split('|');
if ("F".Equals(roleMgrModel.roleAuthType))
{
CodeRoleFunctionDao CodeRoleFunctionDao = new CodeRoleFunctionDao();
List <FuncRoleModel> roleFuncListO = CodeRoleFunctionDao.qryForRoleMgr(roleId);
foreach (string item in funcData)
{
if (!"".Equals(StringUtil.toString(item)))
{
FuncRoleModel funcRoleModel = new FuncRoleModel();
funcRoleModel.cRoleId = roleId;
funcRoleModel.cFunctionID = item;
if (roleFuncListO.Exists(x => x.cFunctionID == item))
{
funcRoleModel.execAction = "";
}
else
{
bChgFunc = true;
funcRoleModel.execAction = "A";
}
funcList.Add(funcRoleModel);
}
}
foreach (FuncRoleModel oItem in roleFuncListO)
{
if (!funcList.Exists(x => x.cFunctionID == oItem.cFunctionID))
{
bChgFunc = true;
FuncRoleModel funcRoleModel = new FuncRoleModel();
funcRoleModel.cRoleId = roleId;
funcRoleModel.cFunctionID = oItem.cFunctionID;
funcRoleModel.execAction = "D";
funcList.Add(funcRoleModel);
}
}
}
//比對是否有異動"金庫設備權限"
List <CodeRoleEquipModel> equipList = new List <CodeRoleEquipModel>();
CodeRoleTreaItemDao codeRoleTreaItemDao = new CodeRoleTreaItemDao();
if ("E".Equals(roleMgrModel.roleAuthType))
{
List <CodeRoleEquipModel> roleEquipListO = codeRoleTreaItemDao.qryForRoleMgr(roleId);
if (equipData != null)
{
foreach (CodeRoleEquipModel item in equipData)
{
CodeRoleEquipModel codeRoleEquipModel = new CodeRoleEquipModel();
codeRoleEquipModel.roleId = roleId;
codeRoleEquipModel.treaEquipId = StringUtil.toString(item.treaEquipId);
//codeRoleEquipModel.controlMode = StringUtil.toString(item.controlMode);
codeRoleEquipModel.custodyMode = StringUtil.toString(item.custodyMode);
codeRoleEquipModel.custodyOrder = StringUtil.toString(item.custodyOrder);
codeRoleEquipModel.custodyModeB = "";
codeRoleEquipModel.custodyOrderB = "";
codeRoleEquipModel.execAction = "";
if (roleEquipListO.Exists(x => x.treaEquipId == item.treaEquipId))
{
CodeRoleEquipModel itemO = roleEquipListO.Find(x => x.treaEquipId == item.treaEquipId);
if (!(
//item.controlMode.Equals(itemO.controlMode) &&
item.custodyMode.Equals(itemO.custodyMode) && item.custodyOrder.Equals(itemO.custodyOrder)))
{
codeRoleEquipModel.execAction = "U";
codeRoleEquipModel.custodyModeB = itemO.custodyMode;
codeRoleEquipModel.custodyOrderB = itemO.custodyOrder;
bChgEquip = true;
}
}
else
{
codeRoleEquipModel.execAction = "A";
bChgEquip = true;
}
equipList.Add(codeRoleEquipModel);
}
}
foreach (CodeRoleEquipModel oItem in roleEquipListO)
{
if (equipList != null)
{
if (!equipList.Exists(x => x.treaEquipId == oItem.treaEquipId))
{
bChgEquip = true;
CodeRoleEquipModel codeRoleEquipModel = new CodeRoleEquipModel();
codeRoleEquipModel.roleId = roleId;
codeRoleEquipModel.treaEquipId = StringUtil.toString(oItem.treaEquipId);
codeRoleEquipModel.controlMode = StringUtil.toString(oItem.controlMode);
codeRoleEquipModel.custodyMode = StringUtil.toString(oItem.custodyMode);
codeRoleEquipModel.custodyOrder = StringUtil.toString(oItem.custodyOrder);
codeRoleEquipModel.execAction = "D";
equipList.Add(codeRoleEquipModel);
}
}
else
{
bChgEquip = true;
CodeRoleEquipModel codeRoleEquipModel = new CodeRoleEquipModel();
codeRoleEquipModel.roleId = roleId;
codeRoleEquipModel.treaEquipId = StringUtil.toString(oItem.treaEquipId);
codeRoleEquipModel.controlMode = StringUtil.toString(oItem.controlMode);
codeRoleEquipModel.custodyMode = StringUtil.toString(oItem.custodyMode);
codeRoleEquipModel.custodyOrder = StringUtil.toString(oItem.custodyOrder);
codeRoleEquipModel.execAction = "D";
equipList.Add(codeRoleEquipModel);
}
}
}
//比對是否有異動"存取項目權限"
CodeRoleItemDao codeRoleItemDao = new CodeRoleItemDao();
List <CodeRoleItemModel> itemList = new List <CodeRoleItemModel>();
if ("I".Equals(roleMgrModel.roleAuthType))
{
List <CodeRoleItemModel> itemDataO = codeRoleItemDao.qryForRoleMgr(roleId, "1");
if (itemData != null)
{
foreach (CodeRoleItemModel item in itemData)
{
CodeRoleItemModel codeRoleItemModel = new CodeRoleItemModel();
codeRoleItemModel.roleId = roleId;
codeRoleItemModel.itemId = StringUtil.toString(item.itemId);
codeRoleItemModel.authType = "1";
if (itemDataO.Exists(x => x.itemId == item.itemId))
{
codeRoleItemModel.execAction = "";
}
else
{
bChgItem = true;
codeRoleItemModel.execAction = "A";
}
itemList.Add(codeRoleItemModel);
}
}
foreach (CodeRoleItemModel oItem in itemDataO)
{
if (itemList != null)
{
if (!itemList.Exists(x => x.itemId == oItem.itemId))
{
bChgItem = true;
CodeRoleItemModel codeRoleItemModel = new CodeRoleItemModel();
codeRoleItemModel.roleId = roleId;
codeRoleItemModel.itemId = StringUtil.toString(oItem.itemId);
codeRoleItemModel.authType = "1";
codeRoleItemModel.execAction = "D";
itemList.Add(codeRoleItemModel);
}
}
else
{
bChgItem = true;
CodeRoleItemModel codeRoleItemModel = new CodeRoleItemModel();
codeRoleItemModel.roleId = roleId;
codeRoleItemModel.itemId = StringUtil.toString(oItem.itemId);
codeRoleItemModel.authType = "1";
codeRoleItemModel.execAction = "D";
itemList.Add(codeRoleItemModel);
}
}
}
//比對是否有異動"表單申請權限"
List <CodeRoleItemModel> formAplyList = new List <CodeRoleItemModel>();
if ("A".Equals(roleMgrModel.roleAuthType))
{
List <CodeRoleItemModel> formAplyDataO = codeRoleItemDao.qryForRoleMgr(roleId, "2");
if (formAplyData != null)
{
foreach (CodeRoleItemModel item in formAplyData)
{
CodeRoleItemModel codeRoleItemModel = new CodeRoleItemModel();
codeRoleItemModel.roleId = roleId;
codeRoleItemModel.itemId = StringUtil.toString(item.itemId);
codeRoleItemModel.authType = "2";
if (formAplyDataO.Exists(x => x.itemId == item.itemId))
{
codeRoleItemModel.execAction = "";
}
else
{
bChgFormAply = true;
codeRoleItemModel.execAction = "A";
}
formAplyList.Add(codeRoleItemModel);
}
}
foreach (CodeRoleItemModel oItem in formAplyDataO)
{
if (formAplyList != null)
{
if (!formAplyList.Exists(x => x.itemId == oItem.itemId))
{
bChgFormAply = true;
CodeRoleItemModel codeRoleItemModel = new CodeRoleItemModel();
codeRoleItemModel.roleId = roleId;
codeRoleItemModel.itemId = StringUtil.toString(oItem.itemId);
codeRoleItemModel.authType = "2";
codeRoleItemModel.execAction = "D";
formAplyList.Add(codeRoleItemModel);
}
}
else
{
bChgFormAply = true;
CodeRoleItemModel codeRoleItemModel = new CodeRoleItemModel();
codeRoleItemModel.roleId = roleId;
codeRoleItemModel.itemId = StringUtil.toString(oItem.itemId);
codeRoleItemModel.authType = "2";
codeRoleItemModel.execAction = "D";
formAplyList.Add(codeRoleItemModel);
}
}
}
if (bChgRole == false && bChgFunc == false && bChgEquip == false && bChgItem == false && bChgFormAply == false)
{
return(Json(new { success = false, errors = "未異動畫面資料，將不進行修改覆核作業!!" }, JsonRequestBehavior.AllowGet));
}
/*------------------ DB處理 begin------------------*/
string strConn = DbUtil.GetDBTreasuryConnStr();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
SqlTransaction transaction = conn.BeginTransaction("Transaction");
try
{
roleMgrModel.cRoleID = roleId;
AuthApprDao authApprDao = new AuthApprDao();
AUTH_APPR authAppr = new AUTH_APPR();
authAppr.AUTH_APLY_TYPE = "R";
authAppr.APPR_STATUS = "1";
authAppr.APPR_MAPPING_KEY = roleId;
authAppr.CREATE_UID = Session["UserID"].ToString();
//新增"覆核資料檔"
string aplyNo = authApprDao.insert(authAppr, conn, transaction);
//異動"角色資料檔"覆核狀態
if (bNewRole == false)
{
updateRole(roleMgrModel, codeRoleO, conn, transaction);
}
//處理角色資料檔的異動
if (bChgRole)
{
//新增"角色資料異動檔"
CodeRoleHisDao codeRoleHisDao = new CodeRoleHisDao();
CODE_ROLE_HIS codeRoleHis = new CODE_ROLE_HIS();
codeRoleHis.APLY_NO = aplyNo;
codeRoleHis.ROLE_ID = StringUtil.toString(roleMgrModel.cRoleID);
codeRoleHis.ROLE_NAME = StringUtil.toString(roleMgrModel.cRoleName);
codeRoleHis.ROLE_AUTH_TYPE = StringUtil.toString(roleMgrModel.roleAuthType);
codeRoleHis.IS_DISABLED = StringUtil.toString(roleMgrModel.isDisabled);
codeRoleHis.MEMO = StringUtil.toString(roleMgrModel.vMemo);
if (codeRoleO != null)
{
codeRoleHis.ROLE_NAME_B = StringUtil.toString(codeRoleO.ROLE_NAME);
codeRoleHis.IS_DISABLED_B = StringUtil.toString(codeRoleO.IS_DISABLED);
codeRoleHis.MEMO_B = StringUtil.toString(codeRoleO.MEMO);
}
else
{
codeRoleHis.ROLE_NAME_B = "";
codeRoleHis.IS_DISABLED_B = "";
codeRoleHis.MEMO_B = "";
}
if (bNewRole)
{
codeRoleHis.EXEC_ACTION = "A";
}
else
{
codeRoleHis.EXEC_ACTION = "U";
}
codeRoleHisDao.insert(codeRoleHis, conn, transaction);
}
//處理功能角色資料檔的異動
if (bChgFunc)
{
CodeRoleFuncHisDao codeRoleFuncHisDao = new CodeRoleFuncHisDao();
foreach (FuncRoleModel func in funcList)
{
codeRoleFuncHisDao.insert(aplyNo, "Treasury", func, conn, transaction);
//if (!"".Equals(func.execAction)) {
// codeRoleFuncHisDao.insert(aplyNo, "Treasury", func, conn, transaction);
//}
}
}
//處理角色金庫設備資料檔的異動
if (bChgEquip)
{
CodeRoleTreaItemHisDao codeRoleTreaItemHisDao = new CodeRoleTreaItemHisDao();
foreach (CodeRoleEquipModel equip in equipList)
{
codeRoleTreaItemHisDao.insert(aplyNo, equip, conn, transaction);
//if (!"".Equals(equip.execAction))
//{
// codeRoleTreaItemHisDao.insert(aplyNo, equip, conn, transaction);
//}
}
}
//處理角色存取項目資料檔的異動(存取項目)
if (bChgItem)
{
CodeRoleItemHisDao codeRoleItemHisDao = new CodeRoleItemHisDao();
foreach (CodeRoleItemModel item in itemList)
{
codeRoleItemHisDao.insert(aplyNo, item, conn, transaction);
//if (!"".Equals(item.execAction))
//{
// codeRoleItemHisDao.insert(aplyNo, item, conn, transaction);
//}
}
}
//處理角色存取項目資料檔的異動(表單申請)
if (bChgFormAply)
{
CodeRoleItemHisDao codeRoleItemHisDao = new CodeRoleItemHisDao();
foreach (CodeRoleItemModel item in formAplyList)
{
codeRoleItemHisDao.insert(aplyNo, item, conn, transaction);
//if (!"".Equals(item.execAction))
//{
// codeRoleItemHisDao.insert(aplyNo, item, conn, transaction);
//}
}
}
transaction.Commit();
/*------------------ DB處理 end------------------*/
return(Json(new { success = true, aplyNo = aplyNo }));
}
catch (Exception e)
{
transaction.Rollback();
logger.Error("[updateRole]其它錯誤：" + e.ToString());
return(Json(new { success = false, errors = "其它錯誤，請洽系統管理員!!" }, JsonRequestBehavior.AllowGet));
}
}
}
/// <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;
}
}
}
}
}
public ActionResult qryRoleAuth(string roleAuthType, string roleId)
{
List <authItem> rows = new List <authItem>();
switch (roleAuthType)
{
case "F":
List <RoleFuncHisModel> rowsF = new List <RoleFuncHisModel>();
CodeRoleFunctionDao codeRoleFuncDao = new CodeRoleFunctionDao();
rowsF = codeRoleFuncDao.qryForAppr(roleId);
foreach (RoleFuncHisModel d in rowsF)
{
authItem authItem = new authItem();
authItem.authId = d.cFunctionID;
authItem.authDesc = StringUtil.toString(d.cFunctionName);
rows.Add(authItem);
}
break;
//var jsonDataF = new { success = true, rows = rowsF };
//return Json(jsonDataF, JsonRequestBehavior.AllowGet);
case "E":
List <CodeRoleEquipModel> rowsE = new List <CodeRoleEquipModel>();
CodeRoleTreaItemDao codeRoleTreaItemDao = new CodeRoleTreaItemDao();
rowsE = codeRoleTreaItemDao.qryForRoleMgr(roleId);
foreach (CodeRoleEquipModel d in rowsE)
{
authItem authItem = new authItem();
authItem.authId = d.treaEquipId;
authItem.authDesc = StringUtil.toString(d.equipName) + "；" + StringUtil.toString(d.controlModeDesc)
+ "；" + StringUtil.toString(d.custodyModeDesc) + "；" + StringUtil.toString(d.custodyOrder);
rows.Add(authItem);
}
break;
//var jsonDataE = new { success = true, rows = rowsE };
//return Json(jsonDataE, JsonRequestBehavior.AllowGet);
case "I":
case "A":
List <CodeRoleItemModel> rowsI = new List <CodeRoleItemModel>();
CodeRoleItemDao codeRoleItemDao = new CodeRoleItemDao();
rowsI = codeRoleItemDao.qryForAppr(roleId, roleAuthType == "I" ? "1" : "2");
foreach (CodeRoleItemModel d in rowsI)
{
authItem authItem = new authItem();
authItem.authId = d.itemId;
authItem.authDesc = StringUtil.toString(d.itemDesc);
rows.Add(authItem);
}
break;
//var jsonDataI = new { success = true, rows = rowsI };
//return Json(jsonDataI, JsonRequestBehavior.AllowGet);
}
var jsonData = new { success = true, rows };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
return(Json(new { success = false, err = "其它錯誤，請洽系統管理員!!" }));
}