public JsonResult execInsert(String cParentFunctionID, String cFunctionName, int iSortBy, String cFlag, String vFunctionUrl, String vFunctionMemo)
{
CodeFuncDao codeFuncDao = new CodeFuncDao();
if (codeFuncDao.chkFuncName("", cFunctionName) != null)
{
var jsonData = new { success = false, err = "功能名稱：”功能名稱”已存在，請重新輸入!" };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
CODE_FUNC func = new CODE_FUNC();
func.SYS_CD = "TREASURY";
func.PARENT_FUNC_ID = cParentFunctionID;
func.FUNC_NAME = cFunctionName;
func.FUNC_LEVEL = 2;
func.FUNC_MEMO = vFunctionMemo;
func.FUNC_URL = vFunctionUrl;
func.FUNC_ORDER = iSortBy;
func.IS_DISABLED = cFlag;
func.CREATE_UID = Session["UserID"].ToString();
string strConn = DbUtil.GetDBTreasuryConnStr();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
SqlTransaction transaction = conn.BeginTransaction("Transaction");
try
{
func = codeFuncDao.insert(func, conn, transaction);
Log log = new Log();
log.CFUNCTION = "功能維護作業-新增";
log.CACTION = "A";
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("[execInsert]其它錯誤：" + e.ToString());
var jsonData = new { success = false, err = "其它錯誤，請洽系統管理員!!" };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
}
}
/// <summary>
/// 修改功能
/// </summary>
/// <param name="func"></param>
/// <param name="conn"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public CODE_FUNC update(CODE_FUNC func, SqlConnection conn, SqlTransaction transaction)
{
string sql = @"update [CODE_FUNC]
set
[FUNC_NAME] = @FUNC_NAME
,[FUNC_MEMO] = @FUNC_MEMO
,[FUNC_URL] = @FUNC_URL
,[FUNC_ORDER] = @FUNC_ORDER
,[IS_DISABLED] = @IS_DISABLED
,[LAST_UPDATE_UID] = @LAST_UPDATE_UID
,[LAST_UPDATE_DT] = @LAST_UPDATE_DT
where FUNC_ID = @FUNC_ID
and SYS_CD = @SYS_CD
";
SqlCommand cmd = conn.CreateCommand();
cmd.Connection = conn;
cmd.Transaction = transaction;
try
{
cmd.CommandText = sql;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@SYS_CD", StringUtil.toString(func.SYS_CD));
cmd.Parameters.AddWithValue("@FUNC_ID", StringUtil.toString(func.FUNC_ID));
cmd.Parameters.AddWithValue("@FUNC_NAME", StringUtil.toString(func.FUNC_NAME));
cmd.Parameters.AddWithValue("@FUNC_MEMO", StringUtil.toString(func.FUNC_MEMO));
cmd.Parameters.AddWithValue("@FUNC_URL", StringUtil.toString(func.FUNC_URL));
cmd.Parameters.AddWithValue("@FUNC_ORDER", func.FUNC_ORDER);
cmd.Parameters.AddWithValue("@IS_DISABLED", StringUtil.toString(func.IS_DISABLED));
cmd.Parameters.AddWithValue("@LAST_UPDATE_UID", StringUtil.toString(func.LAST_UPDATE_UID));
cmd.Parameters.AddWithValue("@LAST_UPDATE_DT", func.LAST_UPDATE_DT);
int cnt = cmd.ExecuteNonQuery();
return(func);
}
catch (Exception e)
{
throw e;
}
}
public String funcLogContent(CODE_FUNC codeFunction)
{
String content = "";
content += StringUtil.toString(codeFunction.SYS_CD) + "|";
content += StringUtil.toString(codeFunction.FUNC_ID) + "|";
content += StringUtil.toString(codeFunction.PARENT_FUNC_ID) + "|";
content += StringUtil.toString(codeFunction.FUNC_NAME) + "|";
content += codeFunction.FUNC_LEVEL + "|";
content += StringUtil.toString(codeFunction.FUNC_MEMO) + "|";
content += StringUtil.toString(codeFunction.FUNC_URL) + "|";
content += codeFunction.FUNC_ORDER + "|";
content += StringUtil.toString(codeFunction.IS_DISABLED) + "|";
content += StringUtil.toString(codeFunction.CREATE_UID) + "|";
content += DateUtil.DatetimeToString(codeFunction.CREATE_DT, "") + "|";
content += StringUtil.toString(codeFunction.LAST_UPDATE_UID) + "|";
content += DateUtil.DatetimeToString(codeFunction.LAST_UPDATE_DT, "");
return(content);
}
/// <summary>
/// 新增功能
/// </summary>
/// <param name="func"></param>
/// <param name="conn"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public CODE_FUNC insert(CODE_FUNC func, SqlConnection conn, SqlTransaction transaction)
{
func.FUNC_ID = qryFuncId();
string sql = @"INSERT INTO [CODE_FUNC]
([SYS_CD]
,[FUNC_ID]
,[PARENT_FUNC_ID]
,[FUNC_NAME]
,[FUNC_LEVEL]
,[FUNC_MEMO]
,[FUNC_URL]
,[FUNC_ORDER]
,[IS_DISABLED]
,[CREATE_UID]
,[CREATE_DT]
)
VALUES
(@SYS_CD
,@FUNC_ID
,@PARENT_FUNC_ID
,@FUNC_NAME
,@FUNC_LEVEL
,@FUNC_MEMO
,@FUNC_URL
,@FUNC_ORDER
,@IS_DISABLED
,@CREATE_UID
,GETDATE()
)
";
SqlCommand cmd = conn.CreateCommand();
cmd.Connection = conn;
cmd.Transaction = transaction;
try
{
cmd.CommandText = sql;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@SYS_CD", StringUtil.toString(func.SYS_CD));
cmd.Parameters.AddWithValue("@FUNC_ID", StringUtil.toString(func.FUNC_ID));
cmd.Parameters.AddWithValue("@PARENT_FUNC_ID", StringUtil.toString(func.PARENT_FUNC_ID));
cmd.Parameters.AddWithValue("@FUNC_NAME", StringUtil.toString(func.FUNC_NAME));
cmd.Parameters.AddWithValue("@FUNC_LEVEL", func.FUNC_LEVEL);
cmd.Parameters.AddWithValue("@FUNC_MEMO", StringUtil.toString(func.FUNC_MEMO));
cmd.Parameters.AddWithValue("@FUNC_URL", StringUtil.toString(func.FUNC_URL));
cmd.Parameters.AddWithValue("@FUNC_ORDER", func.FUNC_ORDER);
cmd.Parameters.AddWithValue("@IS_DISABLED", StringUtil.toString(func.IS_DISABLED));
cmd.Parameters.AddWithValue("@CREATE_UID", StringUtil.toString(func.CREATE_UID));
int cnt = cmd.ExecuteNonQuery();
return(func);
}
catch (Exception e)
{
throw e;
}
}
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));
}
}
}
