public JsonResult qryUserRole(string userId)
{
CodeUserRoleDao CodeUserRoleDao = new CodeUserRoleDao();
List <CodeUserRoleModel> rows = CodeUserRoleDao.qryByUserID(userId);
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
Dictionary <string, string> userNameMap = new Dictionary <string, string>();
OaEmpDao oaEmpDao = new OaEmpDao();
string createUid = "";
foreach (CodeUserRoleModel d in rows)
{
createUid = StringUtil.toString(d.createUid);
if (!"".Equals(createUid))
{
if (!userNameMap.ContainsKey(createUid))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, createUid, dbIntra);
}
d.createUid = createUid + " " + userNameMap[createUid];
}
}
}
var jsonData = new { success = true, roleList = rows };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadData(string codeRole, string roleAuthType, string isDIsabled, string vMemo, string cUpdUserID)
{
CodeRoleDao codeRoleDao = new CodeRoleDao();
OaEmpDao oaEmpDao = new OaEmpDao();
List <RoleMgrModel> rows = new List <RoleMgrModel>();
rows = codeRoleDao.roleMgrQry(codeRole, roleAuthType, isDIsabled, vMemo, cUpdUserID);
Dictionary <string, string> userNameMap = new Dictionary <string, string>();
string userUId = "";
string userFId = "";
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions
{
IsolationLevel = IsolationLevel.ReadUncommitted
}))
{
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
foreach (RoleMgrModel role in rows)
{
userUId = StringUtil.toString(role.cUpdUserID);
userFId = StringUtil.toString(role.freezeUid);
if (!"".Equals(userUId))
{
if (!userNameMap.ContainsKey(userUId))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, userUId, dbIntra);
}
role.cUpdUserID = userUId + " " + userNameMap[userUId];
}
if (!"".Equals(userFId))
{
if (!userNameMap.ContainsKey(userFId))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, userFId, dbIntra);
}
role.freezeUid = userFId + " " + userNameMap[userFId];
}
}
}
}
var jsonData = new { success = true, rows };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadData(String cReviewType)
{
AuthApprDao authApprDao = new AuthApprDao();
List <AuthReviewModel> rows = new List <AuthReviewModel>();
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions
{
IsolationLevel = IsolationLevel.ReadUncommitted
}))
{
using (dbTreasuryEntities db = new dbTreasuryEntities())
{
try
{
//查出待覆核的資料
rows = authApprDao.qryAuthReview("R", "1", db);
}
catch (Exception e)
{
logger.Error("其它錯誤：" + e.ToString());
return(Json(new { success = false, err = "其它錯誤，請洽系統管理員!!" }));
}
}
}
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
Dictionary <string, string> userNameMap = new Dictionary <string, string>();
OaEmpDao oaEmpDao = new OaEmpDao();
string createUid = "";
foreach (AuthReviewModel d in rows)
{
createUid = StringUtil.toString(d.createUid);
if (!"".Equals(createUid))
{
if (!userNameMap.ContainsKey(createUid))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, createUid, dbIntra);
}
d.createUid = createUid + " " + userNameMap[createUid];
}
}
}
var jsonData = new { success = true, rows };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
/**
* 查詢出所有使用者資料(for畫面下拉選單使用)
**/
public SelectList loadSelectList()
{
dbTreasuryEntities context = new dbTreasuryEntities();
List <UserMgrModel> result1 = (from user in context.CODE_USER
select new UserMgrModel
{
cUserID = user.USER_ID.Trim()
}
).ToList();
OaEmpDao oaEmpDao = new OaEmpDao();
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
foreach (UserMgrModel user in result1)
{
try
{
user.cUserName = user.cUserID + " " + StringUtil.toString(oaEmpDao.qryByUsrId(user.cUserID, dbIntra).EMP_NAME);
}
catch (Exception e)
{
}
}
}
var items = new SelectList
(
items: result1,
dataValueField: "cUserID",
dataTextField: "cUserName",
selectedValue: (object)null
);
return(items);
}
/// <summary>
/// 取中文姓名
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public ActionResult getUserName(string userId)
{
string userName = "";
OaEmpDao oaEmpDao = new OaEmpDao();
V_EMPLY2 emp = new V_EMPLY2();
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
emp = oaEmpDao.qryByUsrId(userId, dbIntra);
if (emp != null)
{
userName = StringUtil.toString(emp.EMP_NAME);
}
}
if ("".Equals(userName))
{
return(Json(new { success = false, err = "無此帳號資料，不可新增!!" }));
}
else
{
return(Json(new { success = true, userName = userName }));
}
}
///// <summary>
///// 開啟使用者修改明細畫面
///// </summary>
///// <param name="aplyNo"></param>
///// <returns></returns>
//public ActionResult detailUser(string cReviewSeq)
//{
// try
// {
// using (DbAccountEntities db = new DbAccountEntities())
// {
// CodeUserHisDao codeUserHisDao = new CodeUserHisDao();
// AuthReviewUserModel userData = codeUserHisDao.qryByNowHis(cReviewSeq, db);
// string[] cDateTime = userData.cCrtDateTime.Split(' ');
// userData.cCrtDateTime = DateUtil.formatDateTimeDbToSc(cDateTime[0] + " " + cDateTime[1], "DT");
// ViewBag.bHaveData = "Y";
// ViewBag.cReviewSeq = cReviewSeq;
// return View(userData);
// }
// }
// catch (Exception e)
// {
// ViewBag.bHaveData = "N";
// return View();
// }
//}
/// <summary>
/// 開啟使用者修改明細畫面
/// </summary>
/// <param name="aplyNo"></param>
/// <returns></returns>
public ActionResult detailUser(string aplyNo, string userId)
{
try
{
string execAction = "";
AuthApprDao AuthApprDao = new AuthApprDao();
AUTH_APPR authAppr = new AUTH_APPR();
if (!"".Equals(StringUtil.toString(aplyNo)))
{
authAppr = AuthApprDao.qryByKey(aplyNo);
ViewBag.bView = "N";
}
else
{
authAppr = AuthApprDao.qryByFreeRole(userId);
if (authAppr != null)
{
aplyNo = StringUtil.toString(authAppr.APLY_NO);
}
ViewBag.bView = "Y";
}
AuthReviewUserModel userData = new AuthReviewUserModel();
userData.aplyNo = aplyNo;
userData.userId = authAppr.APPR_MAPPING_KEY;
userData.createUid = authAppr.CREATE_UID;
OaEmpDao oaEmpDao = new OaEmpDao();
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
try
{
userData.createUid = userData.createUid == null ? "" : StringUtil.toString(oaEmpDao.qryByUsrId(userData.createUid, dbIntra).EMP_NAME);
userData.userName = userData.userId == null ? "" : StringUtil.toString(oaEmpDao.qryByUsrId(userData.userId, dbIntra).EMP_NAME);
}
catch (Exception e)
{
}
}
userData.createDt = authAppr.CREATE_DT.ToString();
SysCodeDao sysCodeDao = new SysCodeDao();
Dictionary <string, string> dicExecAction = sysCodeDao.qryByTypeDic("EXEC_ACTION");
Dictionary <string, string> dicYNFlag = sysCodeDao.qryByTypeDic("YN_FLAG");
CodeUserHisDao codeUserHisDao = new CodeUserHisDao();
CODE_USER_HIS codeUserHis = codeUserHisDao.qryByAplyNo(aplyNo);
if (codeUserHis != null)
{
execAction = StringUtil.toString(codeUserHis.EXEC_ACTION);
}
if ("".Equals(execAction))
{
CodeUserDao codeUserDao = new CodeUserDao();
CODE_USER codeUser = new CODE_USER();
codeUser = codeUserDao.qryUserByKey(authAppr.APPR_MAPPING_KEY);
userData.isMailB = StringUtil.toString(codeUser.IS_MAIL);
userData.isDisabledB = StringUtil.toString(codeUser.IS_DISABLED);
userData.memoB = StringUtil.toString(codeUser.MEMO);
}
else
{
if ("A".Equals(execAction))
{
userData.isMail = StringUtil.toString(codeUserHis.IS_MAIL);
userData.isDisabled = StringUtil.toString(codeUserHis.IS_DISABLED);
userData.memo = StringUtil.toString(codeUserHis.MEMO);
}
else
{
userData.isMail = StringUtil.toString(codeUserHis.IS_MAIL);
userData.isDisabled = StringUtil.toString(codeUserHis.IS_MAIL);
userData.memo = StringUtil.toString(codeUserHis.MEMO);
userData.isMailB = StringUtil.toString(codeUserHis.IS_MAIL_B);
userData.isDisabledB = StringUtil.toString(codeUserHis.IS_DISABLED_B);
userData.memoB = StringUtil.toString(codeUserHis.MEMO_B);
}
}
userData.execAction = execAction;
userData.execActionDesc = dicExecAction.ContainsKey(userData.execAction) ? dicExecAction[userData.execAction] : userData.execAction;
userData.isDisabledDesc = dicYNFlag.ContainsKey(userData.isDisabled) ? dicYNFlag[userData.isDisabled] : userData.isDisabled;
userData.isDisabledDescB = dicYNFlag.ContainsKey(userData.isDisabledB) ? dicYNFlag[userData.isDisabledB] : userData.isDisabledB;
userData.isMailDesc = dicYNFlag.ContainsKey(userData.isMail) ? dicYNFlag[userData.isMail] : userData.isMail;
userData.isMailDescB = dicYNFlag.ContainsKey(userData.isMailB) ? dicYNFlag[userData.isMailB] : userData.isMailB;
ViewBag.bHaveData = "Y";
ViewBag.aplyNo = aplyNo;
return(View(userData));
}
catch (Exception e)
{
ViewBag.bHaveData = "N";
return(View());
}
}
/**
* 角色資訊(含功能授權)
**/
public ActionResult detailRole(string cRoleId, string execType)
{
/*---畫面下拉選單初始值---*/
//金庫設備
TreaEquipDao treaEquipDao = new TreaEquipDao();
ViewBag.equipList = treaEquipDao.jqgridSelect();
//存取項目
TreaItemDao treaItemDao = new TreaItemDao();
ViewBag.itemList = treaItemDao.jqgridSelect("");
SysCodeDao sysCodeDao = new SysCodeDao();
//停用註記
var isDisabledList = sysCodeDao.loadSelectList("IS_DISABLED");
ViewBag.isDisabledList = isDisabledList;
//角色群組
var roleAuthTypeList = sysCodeDao.loadSelectList("ROLE_AUTH_TYPE");
ViewBag.roleAuthTypeList = roleAuthTypeList;
//控管模式
var controlList = sysCodeDao.loadSelectList("CONTROL_MODE");
ViewBag.controlList = controlList;
//ViewBag.controlList = sysCodeDao.jqGridList("CONTROL_MODE");
//控管方式
var custodyList = sysCodeDao.loadSelectList("CUSTODY_MODE");
ViewBag.custodyList = custodyList;
//ViewBag.custodyList = sysCodeDao.jqGridList("CUSTODY_MODE");
//入庫作業類型
ViewBag.itemOpTypeList = sysCodeDao.jqGridList("ITEM_OP_TYPE");
//覆核狀態 add by daiyu 20180214
Dictionary <string, string> dicReview = sysCodeDao.qryByTypeDic("DATA_STATUS");
//查詢角色資訊
CodeRoleDao codeRoleDao = new CodeRoleDao();
CODE_ROLE codeRole = new CODE_ROLE();
if (cRoleId != null)
{
codeRole = codeRoleDao.qryRoleByKey(cRoleId);
}
//將值搬給畫面欄位
RoleMgrModel roleMgrModel = new RoleMgrModel();
qryUserFunc(cRoleId); //取得已授權、未授權功能清單
if (!"".Equals(StringUtil.toString(codeRole.ROLE_ID)))
{
roleMgrModel.cRoleID = StringUtil.toString(codeRole.ROLE_ID);
roleMgrModel.cRoleName = StringUtil.toString(codeRole.ROLE_NAME);
roleMgrModel.roleAuthType = StringUtil.toString(codeRole.ROLE_AUTH_TYPE);
roleMgrModel.isDisabled = StringUtil.toString(codeRole.IS_DISABLED);
roleMgrModel.vMemo = StringUtil.toString(codeRole.MEMO);
roleMgrModel.dataStatus = StringUtil.toString(codeRole.DATA_STATUS) == "" ? "" : codeRole.DATA_STATUS + "." + dicReview[codeRole.DATA_STATUS];
roleMgrModel.cCrtDateTime = codeRole.CREATE_DT == null ? "" : DateUtil.DatetimeToString(codeRole.CREATE_DT, "");
roleMgrModel.cUpdDateTime = codeRole.LAST_UPDATE_DT == null ? "" : DateUtil.DatetimeToString(codeRole.LAST_UPDATE_DT, "");
OaEmpDao oaEmpDao = new OaEmpDao();
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
try
{
roleMgrModel.cCrtUserID = codeRole.CREATE_UID == null ? "" : StringUtil.toString(oaEmpDao.qryByUsrId(codeRole.CREATE_UID, dbIntra).EMP_NAME);
}
catch (Exception e)
{
}
try
{
roleMgrModel.cUpdUserID = codeRole.LAST_UPDATE_UID == null ? "" : StringUtil.toString(oaEmpDao.qryByUsrId(codeRole.LAST_UPDATE_UID, dbIntra).EMP_NAME);
}
catch (Exception e)
{
}
}
roleMgrModel.Categories = ViewBag.funcList;
ViewBag.bHaveData = "Y";
//return RedirectToAction("Index", "Home");
return(View(roleMgrModel));
}
else
{
if ("A".Equals(execType))
{
qryUserFunc(""); //取得已授權、未授權功能清單
roleMgrModel.cRoleID = "";
roleMgrModel.cRoleName = "";
roleMgrModel.isDisabled = "N";
roleMgrModel.vMemo = "";
roleMgrModel.cCrtUserID = "";
roleMgrModel.cCrtDateTime = "";
roleMgrModel.cUpdUserID = "";
roleMgrModel.cUpdDateTime = "";
roleMgrModel.dataStatus = "";
roleMgrModel.Categories = ViewBag.funcList;
ViewBag.bHaveData = "Y";
return(View(roleMgrModel));
}
else
{
ViewBag.bHaveData = "N";
return(View("detailRole"));
}
}
}
public ActionResult qryRoleHisData(string cRoleID, string apprStatus, string updDateB, string updDateE)
{
if ("".Equals(StringUtil.toString(cRoleID)))
{
return(Json(new { success = false, err = "角色代號未輸入!!" }));
}
SysCodeDao sysCodeDao = new SysCodeDao();
Dictionary <string, string> dicExecAction = sysCodeDao.qryByTypeDic("EXEC_ACTION");
Dictionary <string, string> dicYNFlag = sysCodeDao.qryByTypeDic("YN_FLAG");
Dictionary <string, string> dicApprStatus = sysCodeDao.qryByTypeDic("APPR_STATUS");
Dictionary <string, string> dicIsDisabled = sysCodeDao.qryByTypeDic("IS_DISABLED");
List <CodeRoleModel> roleHisList = new List <CodeRoleModel>();
List <RoleFuncHisModel> roleFuncHisList = new List <RoleFuncHisModel>();
List <CodeRoleEquipModel> roleEquipHisList = new List <CodeRoleEquipModel>();
List <CodeRoleItemModel> roleRoleItemHisList = new List <CodeRoleItemModel>();
List <CodeRoleItemModel> roleItemHisList = new List <CodeRoleItemModel>();
List <CodeRoleItemModel> roleFormAplyHisList = new List <CodeRoleItemModel>();
CodeRoleHisDao codeRoleHisDao = new CodeRoleHisDao();
CodeRoleFuncHisDao codeRoleFuncHisDao = new CodeRoleFuncHisDao();
CodeRoleTreaItemHisDao codeRoleTreaItemHisDao = new CodeRoleTreaItemHisDao();
CodeRoleItemHisDao codeRoleItemHisDao = new CodeRoleItemHisDao();
try
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions
{
IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted
}))
{
using (dbTreasuryEntities db = new dbTreasuryEntities())
{
roleHisList = codeRoleHisDao.qryForRoleMgrHis(db, cRoleID, apprStatus, updDateB, updDateE);
roleFuncHisList = codeRoleFuncHisDao.qryForRoleMgrHis(db, cRoleID, apprStatus, updDateB, updDateE);
roleEquipHisList = codeRoleTreaItemHisDao.qryForRoleMgrHis(db, cRoleID, apprStatus, updDateB, updDateE);
roleRoleItemHisList = codeRoleItemHisDao.qryForRoleMgrHis(db, cRoleID, apprStatus, updDateB, updDateE);
}
}
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
Dictionary <string, string> userNameMap = new Dictionary <string, string>();
OaEmpDao oaEmpDao = new OaEmpDao();
string apprUid = "";
string userId = "";
//處理角色資訊人員&代碼
if (roleHisList != null)
{
foreach (CodeRoleModel role in roleHisList)
{
role.execActionDesc = dicExecAction.ContainsKey(StringUtil.toString(role.execAction)) ? dicExecAction[StringUtil.toString(role.execAction)]:"";
role.apprStatusDesc = dicApprStatus.ContainsKey(StringUtil.toString(role.apprStatus)) ? dicApprStatus[StringUtil.toString(role.apprStatus)]:"";
role.isDisabledDesc = dicIsDisabled.ContainsKey(StringUtil.toString(role.isDisabled)) ? dicIsDisabled[StringUtil.toString(role.isDisabled)]:"";
role.isDisabledDescB = dicIsDisabled.ContainsKey(StringUtil.toString(role.isDisabledB)) ? dicIsDisabled[StringUtil.toString(role.isDisabledB)]:"";
userId = StringUtil.toString(role.updateUid);
if (!"".Equals(userId))
{
if (!userNameMap.ContainsKey(userId))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, userId, dbIntra);
}
role.updateUid = userNameMap[userId];
}
apprUid = StringUtil.toString(role.apprUid);
if (!"".Equals(apprUid))
{
if (!userNameMap.ContainsKey(apprUid))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, apprUid, dbIntra);
}
role.apprUid = userNameMap[apprUid];
}
}
}
//處理授權功能人員&代碼
if (roleFuncHisList != null)
{
foreach (RoleFuncHisModel d in roleFuncHisList)
{
d.execActionDesc = dicExecAction.ContainsKey(StringUtil.toString(d.execAction)) ? dicExecAction[StringUtil.toString(d.execAction)] : "";
d.apprStatusDesc = dicApprStatus.ContainsKey(StringUtil.toString(d.apprStatus)) ? dicApprStatus[StringUtil.toString(d.apprStatus)] : "";
userId = StringUtil.toString(d.updateUid);
if (!"".Equals(userId))
{
if (!userNameMap.ContainsKey(userId))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, userId, dbIntra);
}
d.updateUid = userNameMap[userId];
}
apprUid = StringUtil.toString(d.apprUid);
if (!"".Equals(apprUid))
{
if (!userNameMap.ContainsKey(apprUid))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, apprUid, dbIntra);
}
d.apprUid = userNameMap[apprUid];
}
}
}
//處理金庫設備人員&代碼
if (roleEquipHisList != null)
{
foreach (CodeRoleEquipModel d in roleEquipHisList)
{
d.execActionDesc = dicExecAction.ContainsKey(StringUtil.toString(d.execAction)) ? dicExecAction[StringUtil.toString(d.execAction)] : "";
d.apprStatusDesc = dicApprStatus.ContainsKey(StringUtil.toString(d.apprStatus)) ? dicApprStatus[StringUtil.toString(d.apprStatus)] : "";
userId = StringUtil.toString(d.updateUid);
if (!"".Equals(userId))
{
if (!userNameMap.ContainsKey(userId))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, userId, dbIntra);
}
d.updateUid = userNameMap[userId];
}
apprUid = StringUtil.toString(d.apprUid);
if (!"".Equals(apprUid))
{
if (!userNameMap.ContainsKey(apprUid))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, apprUid, dbIntra);
}
d.apprUid = userNameMap[apprUid];
}
}
}
//處理"存取項目/表單申請"人員&代碼
if (roleRoleItemHisList != null)
{
foreach (CodeRoleItemModel d in roleRoleItemHisList)
{
d.execActionDesc = dicExecAction.ContainsKey(StringUtil.toString(d.execAction)) ? dicExecAction[StringUtil.toString(d.execAction)] : "";
d.apprStatusDesc = dicApprStatus.ContainsKey(StringUtil.toString(d.apprStatus)) ? dicApprStatus[StringUtil.toString(d.apprStatus)] : "";
userId = StringUtil.toString(d.updateUid);
if (!"".Equals(userId))
{
if (!userNameMap.ContainsKey(userId))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, userId, dbIntra);
}
d.updateUid = userNameMap[userId];
}
apprUid = StringUtil.toString(d.apprUid);
if (!"".Equals(apprUid))
{
if (!userNameMap.ContainsKey(apprUid))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, apprUid, dbIntra);
}
d.apprUid = userNameMap[apprUid];
}
}
roleItemHisList = roleRoleItemHisList.Where(x => x.authType == "1").ToList();
roleFormAplyHisList = roleRoleItemHisList.Where(x => x.authType == "2").ToList();
}
}
return(Json(new { success = true, roleHisList = roleHisList, roleFuncHisList = roleFuncHisList, roleEquipHisList = roleEquipHisList
,
roleItemHisList = roleItemHisList,
roleFormAplyHisList = roleFormAplyHisList }));
}
catch (Exception e)
{
logger.Error("[qryEquip]:" + e.ToString());
return(Json(new { success = false, err = "其它錯誤，請洽系統管理員!!" }));
}
}
/// <summary>
/// 以功能編號為鍵項，查詢功能詳細資訊
/// </summary>
/// <param name="cFuncId"></param>
/// <returns></returns>
public FuncMgrDetailModel qryByKey(String cFuncId)
{
FuncMgrDetailModel funcMgrDetail = new FuncMgrDetailModel();
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions
{
IsolationLevel = IsolationLevel.ReadUncommitted
}))
{
using (dbTreasuryEntities db = new dbTreasuryEntities())
{
//codeFunction = db.CODEFUNCTION.Where(x => x.CFUNCTIONID == cFuncId).FirstOrDefault();
funcMgrDetail = (from main in db.CODE_FUNC
join parent in db.CODE_FUNC on main.PARENT_FUNC_ID equals parent.FUNC_ID into psParent
from xParent in psParent.DefaultIfEmpty()
where main.FUNC_ID == cFuncId
select new FuncMgrDetailModel
{
cFunctionID = main.FUNC_ID.Trim(),
cParentFunctionID = main.PARENT_FUNC_ID.Trim(),
cParentFunctionName = xParent.FUNC_NAME.Trim(),
cFunctionName = main.FUNC_NAME.Trim(),
cFunctionType = "",
iFunctionLevel = main.FUNC_LEVEL,
vFunctionMemo = main.FUNC_MEMO.Trim(),
vFunctionUrl = main.FUNC_URL.Trim(),
iSortBy = main.FUNC_ORDER,
cFlag = main.IS_DISABLED.Trim(),
cCrtUserID = main.CREATE_UID.Trim(),
cCrtUserName = "",
cCrtDate = main.CREATE_DT == null ? "" : SqlFunctions.DateName("year", main.CREATE_DT) + "/" +
SqlFunctions.DatePart("m", main.CREATE_DT) + "/" +
SqlFunctions.DateName("day", main.CREATE_DT).Trim() + " " +
SqlFunctions.DateName("hh", main.CREATE_DT).Trim() + ":" +
SqlFunctions.DateName("n", main.CREATE_DT).Trim() + ":" +
SqlFunctions.DateName("s", main.CREATE_DT).Trim()
,
// cCrtTime = main.CCRTTIME.Trim(),
cUpdUserID = main.LAST_UPDATE_UID == null ? "": main.LAST_UPDATE_UID.Trim(),
cUpdUserName = "",
cUpdDate = main.LAST_UPDATE_DT == null ? "" : SqlFunctions.DateName("year", main.LAST_UPDATE_DT) + "/" +
SqlFunctions.DatePart("m", main.LAST_UPDATE_DT) + "/" +
SqlFunctions.DateName("day", main.LAST_UPDATE_DT).Trim() + " " +
SqlFunctions.DateName("hh", main.LAST_UPDATE_DT).Trim() + ":" +
SqlFunctions.DateName("n", main.LAST_UPDATE_DT).Trim() + ":" +
SqlFunctions.DateName("s", main.LAST_UPDATE_DT).Trim()
// cUpdTime = main.CUPDTIME.Trim()
}).FirstOrDefault();
}
}
//取得新增人員姓名、異動人員姓名
OaEmpDao oaEmpDao = new OaEmpDao();
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
try
{
funcMgrDetail.cCrtUserName = StringUtil.toString(oaEmpDao.qryByUsrId(funcMgrDetail.cCrtUserID, dbIntra).EMP_NAME);
}
catch (Exception e)
{
}
try
{
funcMgrDetail.cUpdUserName = StringUtil.toString(oaEmpDao.qryByUsrId(funcMgrDetail.cUpdUserID, dbIntra).EMP_NAME);
}
catch (Exception e)
{
}
}
return(funcMgrDetail);
}
/// <summary>
/// 開啟角色修改明細畫面
/// </summary>
/// <param name="aplyNo"></param>
/// <returns></returns>
public ActionResult detailRole(string aplyNo, string roleId)
{
try
{
string execAction = "";
AuthApprDao AuthApprDao = new AuthApprDao();
AUTH_APPR authAppr = new AUTH_APPR();
if (!"".Equals(StringUtil.toString(aplyNo)))
{
authAppr = AuthApprDao.qryByKey(aplyNo);
ViewBag.bView = "N";
}
else
{
authAppr = AuthApprDao.qryByFreeRole(roleId);
if (authAppr != null)
{
aplyNo = StringUtil.toString(authAppr.APLY_NO);
}
ViewBag.bView = "Y";
}
AuthReviewRoleModel roleData = new AuthReviewRoleModel();
roleData.aplyNo = aplyNo;
roleData.createUid = authAppr.CREATE_UID;
OaEmpDao oaEmpDao = new OaEmpDao();
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
try
{
roleData.createUid = roleData.createUid == null ? "" : StringUtil.toString(oaEmpDao.qryByUsrId(roleData.createUid, dbIntra).EMP_NAME);
}
catch (Exception e)
{
}
}
roleData.createDt = authAppr.CREATE_DT.ToString();
roleData.roleName = "";
roleData.isDisabled = "";
roleData.memo = "";
roleData.roleNameB = "";
roleData.isDisabledB = "";
roleData.memoB = "";
CodeRoleHisDao CodeRoleHisDao = new CodeRoleHisDao();
CODE_ROLE_HIS codeRoleHis = CodeRoleHisDao.qryByAplyNo(aplyNo);
if (codeRoleHis != null)
{
execAction = StringUtil.toString(codeRoleHis.EXEC_ACTION);
}
if ("".Equals(execAction))
{
CodeRoleDao CodeRoleDao = new CodeRoleDao();
CODE_ROLE codeRole = new CODE_ROLE();
codeRole = CodeRoleDao.qryRoleByKey(authAppr.APPR_MAPPING_KEY);
roleData.roleId = StringUtil.toString(codeRole.ROLE_ID);
roleData.roleAuthType = StringUtil.toString(codeRole.ROLE_AUTH_TYPE);
roleData.roleNameB = StringUtil.toString(codeRole.ROLE_NAME);
roleData.isDisabledB = StringUtil.toString(codeRole.IS_DISABLED);
roleData.memoB = StringUtil.toString(codeRole.MEMO);
}
else
{
roleData.roleId = StringUtil.toString(codeRoleHis.ROLE_ID);
roleData.roleAuthType = StringUtil.toString(codeRoleHis.ROLE_AUTH_TYPE);
if ("A".Equals(execAction))
{
roleData.roleName = StringUtil.toString(codeRoleHis.ROLE_NAME);
roleData.isDisabled = StringUtil.toString(codeRoleHis.IS_DISABLED);
roleData.memo = StringUtil.toString(codeRoleHis.MEMO);
}
else
{
roleData.roleName = StringUtil.toString(codeRoleHis.ROLE_NAME);
roleData.isDisabled = StringUtil.toString(codeRoleHis.IS_DISABLED);
roleData.memo = StringUtil.toString(codeRoleHis.MEMO);
roleData.roleNameB = StringUtil.toString(codeRoleHis.ROLE_NAME_B);
roleData.isDisabledB = StringUtil.toString(codeRoleHis.IS_DISABLED_B);
roleData.memoB = StringUtil.toString(codeRoleHis.MEMO_B);
}
}
SysCodeDao sysCodeDao = new SysCodeDao();
SYS_CODE sysCode = new SYS_CODE();
sysCode = sysCodeDao.qryByKey("ROLE_AUTH_TYPE", StringUtil.toString(roleData.roleAuthType));
if (sysCode != null)
{
roleData.roleAuthTypeDesc = StringUtil.toString(sysCode.CODE_VALUE);
}
sysCode = sysCodeDao.qryByKey("IS_DISABLED", StringUtil.toString(roleData.isDisabledB));
if (sysCode != null)
{
roleData.isDisabledB = StringUtil.toString(sysCode.CODE_VALUE);
}
sysCode = sysCodeDao.qryByKey("IS_DISABLED", StringUtil.toString(roleData.isDisabled));
if (sysCode != null)
{
roleData.isDisabled = StringUtil.toString(sysCode.CODE_VALUE);
}
ViewBag.bHaveData = "Y";
ViewBag.aplyNo = aplyNo;
return(View(roleData));
}
catch (Exception e)
{
ViewBag.bHaveData = "N";
return(View());
}
}
public ActionResult qryUserHisData(string userId, string apprStatus, string updDateB, string updDateE)
{
if ("".Equals(StringUtil.toString(userId)))
{
return(Json(new { success = false, err = "使用者帳號未輸入!!" }));
}
SysCodeDao sysCodeDao = new SysCodeDao();
Dictionary <string, string> dicExecAction = sysCodeDao.qryByTypeDic("EXEC_ACTION");
Dictionary <string, string> dicYNFlag = sysCodeDao.qryByTypeDic("YN_FLAG");
Dictionary <string, string> dicApprStatus = sysCodeDao.qryByTypeDic("APPR_STATUS");
Dictionary <string, string> dicIsDisabled = sysCodeDao.qryByTypeDic("IS_DISABLED");
List <CodeUserHisModel> userHisList = new List <CodeUserHisModel>();
List <UserRoleHisModel> userRoleHisList = new List <UserRoleHisModel>();
CodeUserHisDao codeUserHisDao = new CodeUserHisDao();
CodeUserRoleHisDao codeUserRoleHisDao = new CodeUserRoleHisDao();
try
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions
{
IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted
}))
{
using (dbTreasuryEntities db = new dbTreasuryEntities())
{
userHisList = codeUserHisDao.qryForUserMgrHis(db, userId, apprStatus, updDateB, updDateE);
userRoleHisList = codeUserRoleHisDao.qryForUserMgrHis(db, userId, apprStatus, updDateB, updDateE);
}
}
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
Dictionary <string, string> userNameMap = new Dictionary <string, string>();
OaEmpDao oaEmpDao = new OaEmpDao();
string createUid = "";
string updId = "";
//處理角色資訊人員&代碼
if (userHisList != null)
{
foreach (CodeUserHisModel d in userHisList)
{
d.execActionDesc = dicExecAction.ContainsKey(StringUtil.toString(d.execAction)) ? dicExecAction[StringUtil.toString(d.execAction)] : "";
d.apprStatusDesc = dicApprStatus.ContainsKey(StringUtil.toString(d.apprStatus)) ? dicApprStatus[StringUtil.toString(d.apprStatus)] : "";
d.isDisabledDesc = dicIsDisabled.ContainsKey(StringUtil.toString(d.isDisabled)) ? dicIsDisabled[StringUtil.toString(d.isDisabled)] : "";
d.isDisabledDescB = dicIsDisabled.ContainsKey(StringUtil.toString(d.isDisabledB)) ? dicIsDisabled[StringUtil.toString(d.isDisabledB)] : "";
d.isMailDesc = dicYNFlag.ContainsKey(StringUtil.toString(d.isMail)) ? dicYNFlag[StringUtil.toString(d.isMail)] : "";
d.isMailDescB = dicYNFlag.ContainsKey(StringUtil.toString(d.isMailB)) ? dicYNFlag[StringUtil.toString(d.isMailB)] : "";
updId = StringUtil.toString(d.updateUid);
if (!"".Equals(updId))
{
if (!userNameMap.ContainsKey(updId))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, updId, dbIntra);
}
d.updateUid = userNameMap[updId];
}
}
}
//處理使用者角色異動資訊人員&代碼
if (userRoleHisList != null)
{
foreach (UserRoleHisModel d in userRoleHisList)
{
d.execActionDesc = dicExecAction.ContainsKey(StringUtil.toString(d.execAction)) ? dicExecAction[StringUtil.toString(d.execAction)] : "";
d.apprStatusDesc = dicApprStatus.ContainsKey(StringUtil.toString(d.apprStatus)) ? dicApprStatus[StringUtil.toString(d.apprStatus)] : "";
updId = StringUtil.toString(d.updateUid);
if (!"".Equals(updId))
{
if (!userNameMap.ContainsKey(updId))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, updId, dbIntra);
}
d.updateUid = userNameMap[updId];
}
}
}
}
return(Json(new
{
success = true,
userHisList = userHisList,
userRoleHisList = userRoleHisList
}));
}
catch (Exception e)
{
logger.Error("[qryUserHisData]:" + e.ToString());
return(Json(new { success = false, err = "其它錯誤，請洽系統管理員!!" }));
}
}
private List <UserMgrModel> qryUserData(UserMgrModel userMgrModel)
{
CodeUserDao codeUserDao = new CodeUserDao();
List <UserMgrModel> rows = codeUserDao.qryUserMgr(userMgrModel);
using (DB_INTRAEntities db = new DB_INTRAEntities())
{
OaEmpDao oaEmpDao = new OaEmpDao();
for (int i = 0; i < rows.Count; i++)
{
rows[i] = oaEmpDao.getUserOaData(rows[i], db);
Dictionary <string, string> userNameMap = new Dictionary <string, string>();
if (!"".Equals(StringUtil.toString(rows[i].cCrtUserID)))
{
if (!"".Equals(rows[i].cCrtUserID))
{
if (!userNameMap.ContainsKey(rows[i].cCrtUserID))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, rows[i].cCrtUserID, db);
}
rows[i].cCrtUserID = rows[i].cCrtUserID + " " + userNameMap[rows[i].cCrtUserID];
}
}
if (!"".Equals(StringUtil.toString(rows[i].cUpdUserID)))
{
if (!"".Equals(rows[i].cUpdUserID))
{
if (!userNameMap.ContainsKey(rows[i].cUpdUserID))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, rows[i].cUpdUserID, db);
}
rows[i].cUpdUserID = rows[i].cUpdUserID + " " + userNameMap[rows[i].cUpdUserID];
}
}
if (!"".Equals(StringUtil.toString(rows[i].apprUid)))
{
if (!"".Equals(rows[i].apprUid))
{
if (!userNameMap.ContainsKey(rows[i].apprUid))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, rows[i].apprUid, db);
}
rows[i].apprUid = rows[i].apprUid + " " + userNameMap[rows[i].apprUid];
}
}
if (!"".Equals(StringUtil.toString(rows[i].frezzeUid)))
{
if (!"".Equals(rows[i].frezzeUid))
{
if (!userNameMap.ContainsKey(rows[i].frezzeUid))
{
userNameMap = oaEmpDao.qryUsrName(userNameMap, rows[i].frezzeUid, db);
}
rows[i].frezzeUid = rows[i].frezzeUid + " " + userNameMap[rows[i].frezzeUid];
}
}
}
}
bool bcUserName = StringUtil.isEmpty(userMgrModel.cUserName);
if (!bcUserName)
{
rows = rows.Where(x => x.cUserName == userMgrModel.cUserName).ToList();
}
return(rows);
}
public ActionResult Login(LoginModel loginModel)
{
logger.Info("[AccountController][Login]UserId:" + loginModel.UserId);
bool hasuser = System.Web.HttpContext.Current.User != null;
bool isAuthenticated = hasuser && System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (ModelState.IsValid)
//if (isAuthenticated)
{
logger.Info("[AccountController][Login]IsValid");
this.HttpContext.Response.RemoveOutputCacheItem(Url.Action("MenuByUser", "NavigationController"));
string ADPath = System.Configuration.ConfigurationManager.AppSettings.Get("ADPath");
loginModel.UserId = loginModel.UserId.ToUpper();
DirectoryEntry entry = new DirectoryEntry(ADPath, loginModel.UserId, loginModel.Password);
try
{
string objectSid = (new SecurityIdentifier((byte[])entry.Properties["objectSid"].Value, 0).Value);
//AD驗證成功，檢查該user是否有系統權限
CodeUserDao codeUserDao = new CodeUserDao();
CODE_USER codeUser = codeUserDao.qryUserByKey(loginModel.UserId);
if (codeUser != null)
{
if ("N".Equals(codeUser.IS_DISABLED))
{
Session["UserID"] = loginModel.UserId;
//Session["UserID"] = "A8272";
//Session["UserID"] = "A7040";
//Session["UserID"] = "A0190";
//Session["AgentID"] = codeUser.CAGENTID;
//Session["UserName"] = "";
//Session["UserUnit"] = "";
OaEmpDao oaEmpDao = new OaEmpDao();
try
{
using (DB_INTRAEntities dbIntra = new DB_INTRAEntities())
{
V_EMPLY2 emp = oaEmpDao.qryByUsrId(loginModel.UserId, dbIntra);
if (emp != null)
{
Session["UserName"] = StringUtil.toString(emp.EMP_NAME);
Session["UserUnit"] = StringUtil.toString(emp.DPT_CD);
//Session["UserUnit"] = "VE303";
}
}
}
catch (Exception e)
{
}
writeLog("I", true, loginModel.UserId, codeUser);
LoginProcess(loginModel.UserId, false);
//System.Web.HttpContext context = System.Web.HttpContext.Current;
//SessionIDManager smgr = new SessionIDManager();
//string newId = smgr.CreateSessionID(context);
//string oldId = context.Session.SessionID;
//bool redirected = false;
//bool isAdded = false;
//smgr.SaveSessionID(context, newId, out redirected, out isAdded);
//string guid = Guid.NewGuid().ToString();
//string guid2 = Guid.NewGuid().ToString();
//Session["ASP.NET_SessionId"] = guid;
//// now create a new cookie with this guid value
//Response.Cookies["ASP.NET_SessionId"].Value = guid;
//Response.Cookies["adAuthCookie"].Value = guid2;
//Response.Cookies.Add(new HttpCookie("ASP.NET_SessionId", guid));
//Response.Cookies.Add(new HttpCookie("adAuthCookie", guid2));
return(RedirectToAction("Index", "Home"));
}
}
writeLog("I", false, loginModel.UserId, null);
ModelState.AddModelError("", "找不到這個使用者或登入帳號密碼失敗！");
return(View(loginModel));
}
catch (Exception e)
{
logger.Error("[Login]其它錯誤：" + e.ToString());
writeLog("I", false, loginModel.UserId, null);
//驗證失敗
ModelState.AddModelError("", "找不到這個使用者或登入帳號密碼失敗！");
return(View(loginModel));
}
finally
{
logger.Info("[Login]finally：" + loginModel.UserId);
//entry.Dispose();
}
}
else
{
logger.Info("[Login](ModelState.IsValid=false)：" + loginModel.UserId);
return(View(loginModel));
}
}
/// <summary>
/// 新增使用者
/// </summary>
/// <param name="user"></param>
/// <param name="conn"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public int Create(CODE_USER user, SqlConnection conn, SqlTransaction transaction)
{
using (DB_INTRAEntities db = new DB_INTRAEntities())
{
OaEmpDao oaEmpDao = new OaEmpDao();
V_EMPLY2 emp = new V_EMPLY2();
try
{
emp = oaEmpDao.qryByUsrId(user.USER_ID, db);
if (emp != null)
{
user.USER_UNIT = StringUtil.toString(emp.DPT_CD);
}
}
catch (Exception e)
{
throw e;
}
}
string sql = @"
INSERT INTO [dbo].[CODE_USER]
([USER_ID]
,[USER_UNIT]
,[IS_DISABLED]
,[IS_MAIL]
,[MEMO]
,[DATA_STATUS]
,[CREATE_UID]
,[CREATE_DT]
,[LAST_UPDATE_UID]
,[LAST_UPDATE_DT]
,[APPR_UID]
,[APPR_DT]
)
VALUES
(
@USER_ID
,@USER_UNIT
,@IS_DISABLED
,@IS_MAIL
,@MEMO
,@DATA_STATUS
,@CREATE_UID
,@CREATE_DT
,@LAST_UPDATE_UID
,@LAST_UPDATE_DT
,@APPR_UID
,@APPR_DT
)
";
SqlCommand command = conn.CreateCommand();
command.Connection = conn;
command.Transaction = transaction;
try
{
command.CommandText = sql;
command.Parameters.AddWithValue("@USER_ID", StringUtil.toString(user.USER_ID));
command.Parameters.AddWithValue("@USER_UNIT", StringUtil.toString(user.USER_UNIT));
command.Parameters.AddWithValue("@IS_DISABLED", StringUtil.toString(user.IS_DISABLED));
command.Parameters.AddWithValue("@IS_MAIL", StringUtil.toString(user.IS_MAIL));
command.Parameters.AddWithValue("@MEMO", StringUtil.toString(user.MEMO));
command.Parameters.AddWithValue("@DATA_STATUS", StringUtil.toString(user.DATA_STATUS));
command.Parameters.AddWithValue("@CREATE_UID", StringUtil.toString(user.CREATE_UID));
command.Parameters.Add("@CREATE_DT", System.Data.SqlDbType.DateTime).Value = (System.Object)user.CREATE_DT ?? System.DBNull.Value;
command.Parameters.AddWithValue("@LAST_UPDATE_UID", StringUtil.toString(user.LAST_UPDATE_UID));
command.Parameters.Add("@LAST_UPDATE_DT", System.Data.SqlDbType.DateTime).Value = (System.Object)user.LAST_UPDATE_DT ?? System.DBNull.Value;
command.Parameters.AddWithValue("@APPR_UID", StringUtil.toString(user.APPR_UID));
command.Parameters.Add("@APPR_DT", System.Data.SqlDbType.DateTime).Value = (System.Object)user.APPR_DT ?? System.DBNull.Value;
int cnt = command.ExecuteNonQuery();
return(cnt);
}
catch (Exception e)
{
throw e;
}
}
