public void Login(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { string EMP_NO = Data["EMP_NO"].ToString(); string PWD = Data["Password"].ToString(); string BU_NAME = Data["BU_NAME"].ToString(); DataSet res = new DataSet(); Language = Data["Language"].ToString(); MESReturnMessage.Language = Language; LoginReturn lr = new LoginReturn(); MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); MESDataObject.Module.T_c_user GetLoginUser = new MESDataObject.Module.T_c_user(SFCDB, this.DBTYPE); MESDataObject.Module.Row_c_user rcu = (Row_c_user)GetLoginUser.NewRow(); rcu = GetLoginUser.getC_Userbyempno(EMP_NO, SFCDB, this.DBTYPE); if (rcu == null) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000010"; _DBPools["SFCDB"].Return(SFCDB); return; } c_user_info user_info = new c_user_info(); user_info = GetLoginUser.GetLoginUser(EMP_NO, SFCDB); LogicObject.User lu = new LogicObject.User(); if (PWD == rcu.EMP_PASSWORD) { lu.ID = user_info.ID; lu.FACTORY = user_info.FACTORY; lu.BU = user_info.BU_NAME; lu.EMP_NO = user_info.EMP_NO; lu.EMP_LEVEL = user_info.EMP_LEVEL; lu.DPT_NAME = user_info.DPT_NAME; string token1 = DateTime.Now.ToString("yyyyMMddHHmmss"); string token2 = rand.Next(100, 999).ToString(); char[] TokenChars = (token1 + token2).ToArray(); byte[] TokenBytes = Encoding.Default.GetBytes(TokenChars); string TokenBas64 = Convert.ToBase64String(TokenBytes); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000009"; LoginUser = lu; //lr = new LoginReturn() { Token = TokenBas64, User_ID = user.EMP_NO}; lr = new LoginReturn() { Token = TokenBas64, User_ID = LoginUser.EMP_NO, UserInfo = user_info }; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000010"; } StationReturn.Data = lr; _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); }
/// <summary> /// 刪除用戶信息 /// </summary> public void DeleteInformation(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 EMP_NO = ""; List <string> list = new List <string>(); for (int i = 0; i < Data["EMP_NO"].Count(s => s != null); i++) { list.Add(Data["EMP_NO"][i].ToString()); EMP_NO += "'" + Data["EMP_NO"][i].ToString() + "',"; } EMP_NO = EMP_NO.TrimEnd(','); InformationRow = (MESDataObject.Module.Row_c_user)GetInformation.getC_Userbyempno(EMP_NO, SFCDB, DB_TYPE_ENUM.Oracle); if (InformationRow != null) { string strRet = SFCDB.ExecSQL(InformationRow.GetDeleteString(DB_TYPE_ENUM.Oracle)); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "成功刪除用戶信息!"; StationReturn.Data = ""; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "無此用戶信息!"; } this.DBPools["SFCDB"].Return(SFCDB); }
/// <summary> /// 更新用戶信息 /// </summary> public void UpdateInformation(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 EMP_NO = Data["EMP_NO"].ToString(); string EMP_PASSWORD = Data["EMP_PASSWORD"].ToString(); InformationRow = (MESDataObject.Module.Row_c_user)GetInformation.getC_Userbyempno(EMP_NO, SFCDB, DB_TYPE_ENUM.Oracle); if (InformationRow != null) { InformationRow.EMP_PASSWORD = Data["EMP_PASSWORD"].ToString(); string strRet = SFCDB.ExecSQL(InformationRow.GetUpdateString(DB_TYPE_ENUM.Oracle)); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "成功更新用戶信息!"; StationReturn.Data = ""; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "無此用戶信息!"; } this.DBPools["SFCDB"].Return(SFCDB); }
/// <summary> /// 查詢用戶信息 /// </summary> public void SelectInformation(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 EMP_NO = Data["EMP_NO"].ToString(); DataTable dt = GetInformation.SelectC_Userbyempno(EMP_NO, SFCDB, DB_TYPE_ENUM.Oracle); Dictionary <string, string> dic = new Dictionary <string, string>(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Columns.Count; i++) { dic.Add(dt.Columns[i].ColumnName, dt.Rows[0][i].ToString()); } StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "成功取到用戶信息!"; StationReturn.Data = dic; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "無此用戶信息!"; } this.DBPools["SFCDB"].Return(SFCDB); }
/// <summary> /// 取回用戶密碼 /// </summary> public void GetPassword(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); MESDataObject.Module.T_c_user GetPassword = new MESDataObject.Module.T_c_user(SFCDB, DB_TYPE_ENUM.Oracle); MESDataObject.Module.Row_c_user Resetrow = (MESDataObject.Module.Row_c_user)GetPassword.NewRow(); string EMP_NO = Data["EMP_NO"].ToString(); Dictionary <string, string> dic = new Dictionary <string, string>(); Resetrow = GetPassword.getC_Userbyempno(EMP_NO, SFCDB, DB_TYPE_ENUM.Oracle); if (Resetrow != null) { ///缺發送EMAIL 或者短信功能 dic.Add("EMP_PASSWORD", Resetrow.EMP_PASSWORD.ToString()); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "取回成功,密碼已發送至郵箱!"; StationReturn.Data = dic; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "無此用戶!"; } this.DBPools["SFCDB"].Return(SFCDB); }
/// <summary> /// 創建新用戶 /// </summary> /// <param name="requestValue"></param> /// <param name="Data"></param> /// <param name="StationReturn"></param> public void CreateNewUser(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(); UserRow.ID = USER.GetNewID(BU, SFCDB); UserRow.FACTORY = Data["FACTORY"].ToString(); UserRow.BU_NAME = Data["BU_NAME"].ToString(); UserRow.EMP_NO = Data["EMP_NO"].ToString(); UserRow.EMP_PASSWORD = Data["EMP_PASSWORD"].ToString(); UserRow.EMP_NAME = Data["EMP_NAME"].ToString(); UserRow.EMP_LEVEL = Data["EMP_LEVEL"].ToString(); UserRow.DPT_NAME = Data["DPT_NAME"].ToString(); UserRow.POSITION_NAME = Data["POSITION_NAME"].ToString(); UserRow.MAIL_ADDRESS = Data["MAIL_ADDRESS"].ToString(); UserRow.PHONE_NUMBER = Data["PHONE_NUMBER"].ToString(); UserRow.LOCATION = Data["LOCATION"].ToString(); UserRow.LOCK_FLAG = "N"; UserRow.AGENT_EMP_NO = Data["AGENT_EMP_NO"].ToString(); UserRow.CHANGE_PASSWORD_TIME = DateTime.Now; UserRow.EMP_DESC = Data["EMP_DESC"].ToString(); UserRow.EDIT_TIME = DateTime.Now; UserRow.EDIT_EMP = Data["EDIT_EMP"].ToString(); UserRow.EMP_EN_NAME = Data["EMP_EN_NAME"].ToString(); DataTable userstr = new DataTable(); userstr = USER.SelectC_Userbyempno(UserRow.EMP_NO, SFCDB, DB_TYPE_ENUM.Oracle); if (userstr.Rows.Count != 0) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "註冊失敗,已存在該用戶"; } else { string strRet = SFCDB.ExecSQL(UserRow.GetInsertString(DB_TYPE_ENUM.Oracle)); if (strRet == "1") { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "註冊成功!"; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "註冊失敗!"; } } this.DBPools["SFCDB"].Return(SFCDB); }
/// <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 SelectInformation(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, this.DBTYPE); MESDataObject.Module.Row_c_user InformationRow = (MESDataObject.Module.Row_c_user)GetInformation.NewRow(); try { string EMP_NO = Data["EMP_NO"].ToString(); List <c_user_model> LoadUsetInfolsit = new List <c_user_model>(); LoadUsetInfolsit = GetInformation.SelectUserInfomation(EMP_NO, SFCDB); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Data = LoadUsetInfolsit; this.DBPools["SFCDB"].Return(SFCDB); } catch (Exception e) { this.DBPools["SFCDB"].Return(SFCDB); throw e; } }