public void SelectEditPrivilege(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); string LoginUserEmp = Data["LoginUserEmp"].ToString().ToUpper(); string EditEmp = Data["EditEmp"].ToString().ToUpper(); List <MESDataObject.Module.PrivilegeEditModel> list = new List <MESDataObject.Module.PrivilegeEditModel>(); try { MESDataObject.Module.T_C_PRIVILEGE tcp = new MESDataObject.Module.T_C_PRIVILEGE(SFCDB, this.DBTYPE); list = tcp.GetUserEditPrivilege(LoginUserEmp, EditEmp, this.LoginUser.EMP_LEVEL, SFCDB); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "?取?限信息成功!"; StationReturn.Data = list; } catch (Exception ex) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "無任何?限信息!"; StationReturn.Data = ex.Message.ToString();; } finally { this.DBPools["SFCDB"].Return(SFCDB); } }
public void UpdateMenu(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); MESDataObject.Module.T_C_MENU tcm = new MESDataObject.Module.T_C_MENU(SFCDB, this.DBTYPE); MESDataObject.Module.Row_C_MENU rcm = (MESDataObject.Module.Row_C_MENU)tcm.NewRow(); string UpdateSQL = ""; SFCDB.BeginTrain(); try { string m_name = Data["MENU_NAME"].ToString(); string m_desc = Data["MENU_DESC"].ToString(); string m_emp = Data["EDIT_EMP"].ToString(); string m_id = Data["ID"].ToString(); rcm = tcm.getC_MenubyID(m_id, SFCDB); rcm.MENU_NAME = m_name; rcm.PAGE_PATH = Data["PAGE_PATH"].ToString(); rcm.STYLE_NAME = Data["STYLE_NAME"].ToString(); rcm.CLASS_NAME = Data["CLASS_NAME"].ToString(); rcm.LANGUAGE_ID = Data["LANGUAGE_ID"].ToString(); rcm.MENU_DESC = m_desc; rcm.EDIT_TIME = DateTime.Now; rcm.EDIT_EMP = m_emp; UpdateSQL += rcm.GetUpdateString(this.DBTYPE) + ";\n"; MESDataObject.Module.T_C_PRIVILEGE tcp = new MESDataObject.Module.T_C_PRIVILEGE(SFCDB, this.DBTYPE); MESDataObject.Module.Row_C_PRIVILEGE rcp = (MESDataObject.Module.Row_C_PRIVILEGE)tcp.NewRow(); rcp = tcp.getC_PrivilegebyMenuID(m_id, SFCDB); rcp.PRIVILEGE_NAME = m_name; rcp.PRIVILEGE_DESC = m_desc; rcp.EDIT_TIME = DateTime.Now; rcp.EDIT_EMP = m_emp; UpdateSQL += rcp.GetUpdateString(this.DBTYPE) + ";\n"; SFCDB.ExecSQL("Begin\n" + UpdateSQL + "End;"); SFCDB.CommitTrain(); this.DBPools["SFCDB"].Return(SFCDB); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "编辑菜單成功!!"; } catch (Exception ex) { SFCDB.RollbackTrain(); this.DBPools["SFCDB"].Return(SFCDB); StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "编辑菜單失敗!!"; StationReturn.Data = ex.Message.ToString(); } }
/// <summary> /// 創建權限對應的ID /// </summary> public void CreatePrivilegeID(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); MESDataObject.Module.T_C_PRIVILEGE RolerPrivilege = new MESDataObject.Module.T_C_PRIVILEGE(SFCDB, DB_TYPE_ENUM.Oracle); MESDataObject.Module.Row_C_PRIVILEGE RolerPrivilegeRow = (MESDataObject.Module.Row_C_PRIVILEGE)RolerPrivilege.NewRow(); string PRIVILEGE_ID = Data["PRIVILEGE_ID"].ToString(); string PRIVILEGE_NAME = Data["PRIVILEGE_NAME"].ToString(); DataTable StrRes = new DataTable(); StrRes = RolerPrivilege.CheckPrivilegeID(PRIVILEGE_ID, PRIVILEGE_NAME, SFCDB, this.DBTYPE); if (StrRes.Rows.Count != 0) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "創建權限ID失敗!"; } else { RolerPrivilegeRow.ID = RolerPrivilege.GetNewID(BU, SFCDB); RolerPrivilegeRow.MENU_ID = Data["MENU_ID"].ToString(); RolerPrivilegeRow.PRIVILEGE_NAME = Data["PRIVILEGE_NAME"].ToString(); RolerPrivilegeRow.PRIVILEGE_DESC = Data["PRIVILEGE_DESC"].ToString(); RolerPrivilegeRow.EDIT_TIME = DateTime.Now; RolerPrivilegeRow.EDIT_EMP = Data["EDIT_EMP"].ToString(); string STRRES = SFCDB.ExecSQL(RolerPrivilegeRow.GetInsertString(this.DBTYPE)); if (STRRES == "1") { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "創建權限ID成功!"; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "權限ID已存在!"; } } this.DBPools["SFCDB"].Return(SFCDB); }
public void DeletetMenu(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); MESDataObject.Module.T_C_MENU tcm = new MESDataObject.Module.T_C_MENU(SFCDB, this.DBTYPE); MESDataObject.Module.Row_C_MENU rcm = (MESDataObject.Module.Row_C_MENU)tcm.NewRow(); string ID = Data["ID"].ToString(); string deleteSQL = ""; SFCDB.BeginTrain(); try { if (tcm.Check_PARENT(ID, SFCDB)) { rcm = tcm.getC_MenubyID(ID, SFCDB); deleteSQL += rcm.GetDeleteString(this.DBTYPE) + ";\n"; MESDataObject.Module.T_C_PRIVILEGE tcp = new MESDataObject.Module.T_C_PRIVILEGE(SFCDB, this.DBTYPE); MESDataObject.Module.Row_C_PRIVILEGE rcp = (MESDataObject.Module.Row_C_PRIVILEGE)tcp.NewRow(); rcp = tcp.getC_PrivilegebyMenuID(ID, SFCDB); deleteSQL += rcp.GetDeleteString(this.DBTYPE) + ";\n"; SFCDB.ExecSQL("Begin\n" + deleteSQL + "End;"); SFCDB.CommitTrain(); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "刪除菜單及其權限成功!!!"; StationReturn.Data = ID; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "要刪除的菜單存在子菜單!!不可刪除!"; } this.DBPools["SFCDB"].Return(SFCDB); } catch (Exception ex) { SFCDB.RollbackTrain(); this.DBPools["SFCDB"].Return(SFCDB); StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "刪除菜單失敗!"; StationReturn.Data = ex.Message.ToString(); } }
/// <summary> /// 查詢權限對應的ID /// </summary> public void SelectPrivilegeID(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { LoginReturn lr = new LoginReturn(); MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); MESDataObject.Module.T_C_PRIVILEGE RolerPrivilege = new MESDataObject.Module.T_C_PRIVILEGE(SFCDB, DB_TYPE_ENUM.Oracle); MESDataObject.Module.Row_C_PRIVILEGE RolerPrivilegeRow = (MESDataObject.Module.Row_C_PRIVILEGE)RolerPrivilege.NewRow(); DataTable TablePrivilege = new DataTable(); TablePrivilege = RolerPrivilege.SelectPrivilegeID(SFCDB, DB_TYPE_ENUM.Oracle); List <Privilegesid> Privilegesid = new List <Privilegesid>(); if (TablePrivilege.Rows.Count > 0) { foreach (DataRow item in TablePrivilege.Rows) { List <string> menu = new List <string>(); Privilegesid.Add(new Privilegesid { PRIVILEGE_ID = item["PRIVILEGE_ID"].ToString(), PRIVILEGE_NAME = item["PRIVILEGE_NAME"].ToString(), PRIVILEGE_DESC = item["PRIVILEGE_DESC"].ToString() }); } } else { Privilegesid.Add(null); } StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "獲取權限目錄OK"; StationReturn.Data = Privilegesid; this.DBPools["SFCDB"].Return(SFCDB); }
public void CreatMenu(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); MESDataObject.Module.T_C_MENU tcm = new MESDataObject.Module.T_C_MENU(SFCDB, this.DBTYPE); MESDataObject.Module.Row_C_MENU rcm = (MESDataObject.Module.Row_C_MENU)tcm.NewRow(); string m_name = Data["MENU_NAME"].ToString(); string m_desc = Data["MENU_DESC"].ToString(); string m_emp = Data["EDIT_EMP"].ToString(); string PARENT_CODE = Data["PARENT_CODE"].ToString(); string UpdateSQL = ""; SFCDB.BeginTrain(); try { if (tcm.Check_MENU_NAME(m_name, SFCDB)) { string m_id = tcm.GetNewID(BU, SFCDB); Dictionary <string, string> id = new Dictionary <string, string>(); id.Add("ID", m_id); rcm.ID = m_id; rcm.SYSTEM_NAME = SystemName; rcm.MENU_NAME = m_name; rcm.PAGE_PATH = Data["PAGE_PATH"].ToString(); rcm.PARENT_CODE = PARENT_CODE; rcm.SORT = tcm.GetmaxSORT(PARENT_CODE, SFCDB); rcm.STYLE_NAME = Data["STYLE_NAME"].ToString(); rcm.CLASS_NAME = Data["CLASS_NAME"].ToString(); rcm.LANGUAGE_ID = Data["LANGUAGE_ID"].ToString(); rcm.MENU_DESC = m_desc; rcm.EDIT_TIME = DateTime.Now; rcm.EDIT_EMP = m_emp; UpdateSQL += rcm.GetInsertString(this.DBTYPE) + ";\n"; MESDataObject.Module.T_C_PRIVILEGE tcp = new MESDataObject.Module.T_C_PRIVILEGE(SFCDB, this.DBTYPE); MESDataObject.Module.Row_C_PRIVILEGE rcp = (MESDataObject.Module.Row_C_PRIVILEGE)tcp.NewRow(); rcp.ID = tcp.GetNewID(BU, SFCDB); rcp.MENU_ID = m_id; rcp.SYSTEM_NAME = SystemName; rcp.PRIVILEGE_NAME = m_name; rcp.PRIVILEGE_DESC = m_desc; rcp.EDIT_TIME = DateTime.Now; rcp.EDIT_EMP = m_emp; rcp.BASECONFIG_FLAG = "Y"; UpdateSQL += rcp.GetInsertString(this.DBTYPE) + ";\n"; SFCDB.ExecSQL("Begin\n" + UpdateSQL + "End;"); SFCDB.CommitTrain(); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "添加菜單成功!!!"; StationReturn.Data = id; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "要建立的菜單已經存在!!"; } this.DBPools["SFCDB"].Return(SFCDB); } catch (Exception ex) { this.DBPools["SFCDB"].Return(SFCDB); SFCDB.RollbackTrain(); StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "建立菜單失敗!"; StationReturn.Data = ex.Message.ToString(); } }