public Row_c_user getC_Userbyempno(string empno, OleExec DB, DB_TYPE_ENUM DBType) { string strSql = $@"select * from c_user where emp_no in ('{empno}') "; DataSet res = DB.ExecSelect(strSql); if (res.Tables[0].Rows.Count > 0) { Row_c_user ret = (Row_c_user)NewRow(); ret.loadData(res.Tables[0].Rows[0]); return(ret); } else { return(null); } }
/// <summary> /// 查詢用戶角色權限 /// </summary> public void SelectUserRolePrivilege(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); MESDataObject.Module.T_c_user User = new MESDataObject.Module.T_c_user(SFCDB, DB_TYPE_ENUM.Oracle); MESDataObject.Module.Row_c_user UserRow = (MESDataObject.Module.Row_c_user)User.NewRow(); string LoginUserEmp = Data["LoginUserEmp"].ToString(); string EditEmp = Data["LoginUserEmp"].ToString(); DataTable StrRes = new DataTable(); // StrRes = UserRow.getC_Rolebyrolename(Role_Name, SFCDB, DB_TYPE_ENUM.Oracle); List <c_role> rolelist = new List <c_role>(); if (StrRes.Rows.Count > 0) { foreach (DataRow item in StrRes.Rows) { rolelist.Add(new c_role { ID = item["ID"].ToString(), SYSTEM_NAME = item["SYSTEM_NAME"].ToString(), ROLE_NAME = item["ROLE_NAME"].ToString(), ROLE_DESC = item["ROLE_DESC"].ToString(), EDIT_EMP = item["EDIT_EMP"].ToString() }); } StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "角色信息"; StationReturn.Data = rolelist; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "無任何角色信息!"; } this.DBPools["SFCDB"].Return(SFCDB); }
/// <summary> /// 加載所有用戶列表 /// </summary> public void LoadInformation(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); MESDataObject.Module.T_c_user GetInformation = new MESDataObject.Module.T_c_user(SFCDB, DB_TYPE_ENUM.Oracle); MESDataObject.Module.Row_c_user InformationRow = (MESDataObject.Module.Row_c_user)GetInformation.NewRow(); string r = Data["PageRow"].ToString() == "" ? "10" : Data["PageRow"].ToString(); string i = Data["PageCount"].ToString() == "" ? "1" : Data["PageCount"].ToString(); int PageRow = Convert.ToInt32(r == "0" ? "10" : r); int PageCount = Convert.ToInt32(i == "0" ? "1" : i); string emp_no = Data["emp_no"].ToString(); string strSql = $@"select * from c_user order by edit_time "; System.Data.DataSet res = SFCDB.ExecSelect(strSql); int MaxPage = res.Tables[0].Rows.Count / PageRow + 1; if (MaxPage >= PageCount) { DataTable dt = GetInformation.SelectC_User(PageRow, PageCount, emp_no, SFCDB, DB_TYPE_ENUM.Oracle); if (dt.Rows.Count > 0) { List <c_user_model> lsit = new List <c_user_model>(); foreach (DataRow item in dt.Rows) { lsit.Add(new c_user_model { ID = item["ID"].ToString(), FACTORY = item["FACTORY"].ToString(), BU_NAME = item["BU_NAME"].ToString(), EMP_NO = item["EMP_NO"].ToString(), EMP_NAME = item["EMP_NAME"].ToString(), EMP_PASSWORD = item["EMP_PASSWORD"].ToString(), EMP_LEVEL = item["EMP_LEVEL"].ToString(), DPT_NAME = item["DPT_NAME"].ToString(), POSITION_NAME = item["POSITION_NAME"].ToString(), MAIL_ADDRESS = item["MAIL_ADDRESS"].ToString(), PHONE_NUMBER = item["PHONE_NUMBER"].ToString(), LOCATION = item["LOCATION"].ToString(), LOCK_FLAG = item["LOCK_FLAG"].ToString(), AGENT_EMP_NO = item["AGENT_EMP_NO"].ToString(), EMP_DESC = item["EMP_DESC"].ToString(), EDIT_EMP = item["EDIT_EMP"].ToString(), EMP_EN_NAME = item["EMP_EN_NAME"].ToString() }); } StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "成功取到用戶信息!"; StationReturn.Data = lsit; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "無此用戶信息!"; } } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "所需分頁數(" + PageCount + ")大於最大分頁(" + MaxPage + ")"; } this.DBPools["SFCDB"].Return(SFCDB); }