//public void GetMenu(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) //{ // string User_Name = Data["EMP_NO"].ToString(); // MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); // try // { // LogicObject.Privilege lu = new LogicObject.Privilege(); // List<Privileges> pi= lu.GetMenu(User_Name, SFCDB); // StationReturn.Status = StationReturnStatusValue.Pass; // StationReturn.Message = "获取权限列表成功!!!"; // StationReturn.Data = pi; // } // catch(Exception ex) // { // StationReturn.Status = StationReturnStatusValue.Fail; // StationReturn.Message = "获取权限列表失败!!!该用户可能没有任何权限!!!"; // StationReturn.Data = ex.Message; // } // finally // { // this.DBPools["SFCDB"].Return(SFCDB); // } //} public void CreatMenuId(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); LogicObject.User lu = new LogicObject.User(); lu.CreatMenuId(Data, SFCDB, StationReturn); this.DBPools["SFCDB"].Return(SFCDB); }
/// <summary> /// 登錄API /// </summary> /// <param name="requestValue"></param> /// <param name="Data"></param> /// <param name="StationReturn"></param> public void Login(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { string User_Name = Data["User_Name"].ToString();/// EMP_NAME IS EMP_NO string PWD = Data["Password"].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 GetLoginInformation = new MESDataObject.Module.T_c_user(SFCDB, this.DBTYPE); // string strSql = $@" select * from C_USER where EMP_NO='{User_Name}' and EMP_PASSWORD='******' "; //MESDataObject.Module.Row_c_user user = GetPassword.getC_Userbyempno("TEST",SFCDB,this.DBTYPE); DataTable dt = GetLoginInformation.SelectC_Userbyempno(User_Name, SFCDB, this.DBTYPE); List <c_user_model> lsit = new List <c_user_model>(); if (dt.Rows.Count > 0) { 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() } ); } } LogicObject.User lu = new LogicObject.User(); //if (user.EMP_PASSWORD == user.EMP_PASSWORD) if (true) { 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.Message = "登錄成功"; LoginUser = lu; //lr = new LoginReturn() { Token = TokenBas64, User_ID = user.EMP_NO}; lr = new LoginReturn() { Token = TokenBas64, User_ID = LoginUser.EMP_NO }; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "登錄失敗!密碼錯誤或用戶名不存在!!"; } StationReturn.Data = lr; _DBPools["SFCDB"].Return(SFCDB); }