public JsonResult qryDetail(String cFunctionID)
{
CodeFuncDao codeFunctionDao = new CodeFuncDao();
FuncMgrDetailModel funcDetail = codeFunctionDao.qryByKey(cFunctionID);
var jsonData = new { success = true, funcDetail = funcDetail };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
/// <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);
}
public JsonResult execModify(String cFunctionId, String cFunctionName, int iSortBy, String cFlag, String vFunctionUrl, String vFunctionMemo)
{
CodeFuncDao codeFuncDao = new CodeFuncDao();
if (codeFuncDao.chkFuncName(cFunctionId, cFunctionName) != null)
{
var jsonData = new { success = false, err = "功能名稱：”功能名稱”已存在，請重新輸入!" };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
FuncMgrDetailModel funcO = codeFuncDao.qryByKey(cFunctionId);
CODE_FUNC func = new CODE_FUNC();
func.SYS_CD = "TREASURY";
func.FUNC_ID = cFunctionId;
func.PARENT_FUNC_ID = funcO.cParentFunctionID;
func.FUNC_NAME = StringUtil.toString(cFunctionName);
func.FUNC_LEVEL = funcO.iFunctionLevel;
func.FUNC_MEMO = StringUtil.toString(vFunctionMemo);
func.FUNC_URL = vFunctionUrl;
func.FUNC_ORDER = iSortBy;
func.IS_DISABLED = cFlag;
func.CREATE_UID = funcO.cCrtUserID;
func.CREATE_DT = DateUtil.stringToDatetime(funcO.cCrtDate);
func.LAST_UPDATE_UID = Session["UserID"].ToString();
func.LAST_UPDATE_DT = DateTime.Now;
string strConn = DbUtil.GetDBTreasuryConnStr();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
SqlTransaction transaction = conn.BeginTransaction("Transaction");
try
{
func = codeFuncDao.update(func, conn, transaction);
Log log = new Log();
log.CFUNCTION = "功能維護作業-修改";
log.CACTION = "U";
log.CCONTENT = codeFuncDao.funcLogContent(func);
LogDao.Insert(log, Session["UserID"].ToString());
transaction.Commit();
var jsonData = new { success = true, id = func.FUNC_ID.Trim() };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
transaction.Rollback();
logger.Error("[execModify]其它錯誤：" + e.ToString());
var jsonData = new { success = false, err = "其它錯誤，請洽系統管理員!!" };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
}
}
