public SigninUserDataModel QuerySigninUserDataModel(SigninUserParameter parameter) { this.ExecuteSQL = "SELECT userid, username, userpwd, comid, comname,issystem,ismanager FROM sysuser WHERE comid=@comid AND username=@username AND userpwd=@userpwd"; this.DataParameter = new IDbDataParameter[] { new SqlParameter("@username", parameter.UserName), new SqlParameter("@userpwd", parameter.UserPwd), new SqlParameter("@comid", parameter.CompanySerialNum) }; return(this.ExecuteReadSqlToSigninUserDataModel()); }
public RespondWebViewData <RespondSigninUserViewModel> QuerySigninUserViewModel(RequestSigninUserViewModel request) { var userID_g = Guid.NewGuid(); var _tmp = request.UserName.Split(':'); if (_tmp.Length != 2) { return(new RespondWebViewData <RespondSigninUserViewModel>(WebViewErrorCode.SigninInfoError)); } var parameter = new SigninUserParameter { UserName = _tmp[1], UserPwd = request.UserPwd.ToMD5String(), CompanySerialNum = _tmp[0] }; var dataModel = this.mSiginUserDataAccess.QuerySigninUserDataModel(parameter); if (dataModel == null) { return(new RespondWebViewData <RespondSigninUserViewModel>(WebViewErrorCode.UserNameOrPwdError)); } //var companyInfoRequest = new RequestCompanyInfoViewModel //{ // CompanyID = dataModel.CompanySerialNum //}; //var companyInfo = this.mCompanyInfoViewService.GetCompanyInfoViewModel(companyInfoRequest); //var connectionConfig = new DbConnectionConfig //{ // ConnectTimeout = companyInfo.ConnectTimeout, // Database = companyInfo.Database, // Password = companyInfo.Password, // Server = companyInfo.Server, // UserID = companyInfo.UserID //}; var _respond = new RespondWebViewData <RespondSigninUserViewModel> { rows = new RespondSigninUserViewModel { CurrentUser = new SigninUser { CompanySerialNum = dataModel.comid, UserID_g = userID_g, UserID = dataModel.userid, UserName = dataModel.username, IsManager = dataModel.ismanager, IsSystem = dataModel.issystem } } }; this.SaveLoginUserToOnline(new RequestSigninUserViewModel { UserID = dataModel.userid, UserName = dataModel.username, UserID_g = userID_g }); FormsAuthenticationTicketManage.CreateFormsAuthentication(userID_g); HttpContext.Current.Items.Add(BeforeCompileConstDefined.HttpContext_Login_User, _respond.rows.CurrentUser); //由于电脑配置不上mongodb固暂时先屏蔽掉此段mongodb的数据操作 //this.SaveMongoDbData("登录操作", request, _respond, this.GetType()); return(_respond); }