public void DeleteEditPrivilege(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(); string deleteSQL = ""; SFCDB.BeginTrain(); try { MESDataObject.Module.T_C_USER_PRIVILEGE tcp = new MESDataObject.Module.T_C_USER_PRIVILEGE(SFCDB, this.DBTYPE); MESDataObject.Module.Row_C_USER_PRIVILEGE rcp = (MESDataObject.Module.Row_C_USER_PRIVILEGE)tcp.NewRow(); foreach (string item in Data["PRS"]) { rcp = tcp.getC_PrivilegebyID(item, SFCDB); deleteSQL += rcp.GetDeleteString(this.DBTYPE) + ";\n"; } SFCDB.ExecSQL("Begin\n" + deleteSQL + "End;"); SFCDB.CommitTrain(); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "刪除權限成功!!!"; this.DBPools["SFCDB"].Return(SFCDB); } catch (Exception ex) { SFCDB.RollbackTrain(); StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "刪除權限失!"; StationReturn.Data = ex.Message.ToString(); this.DBPools["SFCDB"].Return(SFCDB); } }
public void CreatUserPrivilege(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); string GEMP_NO = Data["GEMP_NO"].ToString().ToUpper(); string SEMP_NO = Data["SEMP_NO"].ToString().ToUpper(); string EMP_ID = "", P_code = ""; SFCDB.BeginTrain(); try { MESDataObject.Module.T_c_user GetInformation = new MESDataObject.Module.T_c_user(SFCDB, this.DBTYPE); MESDataObject.Module.T_C_USER_PRIVILEGE tcup = new MESDataObject.Module.T_C_USER_PRIVILEGE(SFCDB, this.DBTYPE); MESDataObject.Module.Row_C_USER_PRIVILEGE rcup = (MESDataObject.Module.Row_C_USER_PRIVILEGE)tcup.NewRow(); 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(); DataTable dt = GetInformation.SelectC_Userbyempno(SEMP_NO, SFCDB, this.DBTYPE); EMP_ID = dt.Rows[0]["ID"].ToString(); string insql = ""; if (dt.Rows.Count > 0) { foreach (string item in Data["ID_ITEMS"]) { string p_id = item.Trim('\'').Trim('\"'); rcup.ID = tcup.GetNewID(BU, SFCDB); rcup.SYSTEM_NAME = SystemName; rcup.USER_ID = EMP_ID; rcup.PRIVILEGE_ID = p_id; rcup.EDIT_EMP = GEMP_NO; rcup.EDIT_TIME = DateTime.Now; insql += rcup.GetInsertString(this.DBTYPE) + ";\n"; P_code += p_id + ","; do { rcm = tcm.getC_MenubyID(p_id, SFCDB); if (rcm.PARENT_CODE != "0") { p_id = rcm.PARENT_CODE; if (P_code.IndexOf(rcm.PARENT_CODE) < 0 && tcup.getC_PrivilegebyIDemp(rcm.PARENT_CODE, SEMP_NO, SFCDB) == null) { rcup.ID = tcup.GetNewID(BU, SFCDB); rcup.SYSTEM_NAME = SystemName; rcup.USER_ID = EMP_ID; rcup.PRIVILEGE_ID = rcm.PARENT_CODE; rcup.EDIT_EMP = GEMP_NO; rcup.EDIT_TIME = DateTime.Now; insql += rcup.GetInsertString(this.DBTYPE) + ";\n"; P_code += rcm.PARENT_CODE + ","; } } } while (rcm.PARENT_CODE != "0"); } SFCDB.ExecSQL("Begin\n" + insql + "End;"); SFCDB.CommitTrain(); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "保存成功!!"; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "找不到用戶信息!"; StationReturn.Data = ""; } this.DBPools["SFCDB"].Return(SFCDB); } catch (Exception ex) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "刪權限失敗!!"; StationReturn.Data = ex.Message.ToString(); this.DBPools["SFCDB"].Return(SFCDB); } }