/// <summary> /// 用户登录,返回实体 /// </summary> /// <param name="model"></param> /// <returns></returns> public InsuranceUser Login(InsuranceUser model) { #region sql string sql = string.Format(@" SELECT UserId,UserName,UserAccountId,Status,CreateTime,Ip FROM dbo.InsuranceUser WITH (NOLOCK) WHERE 1=1 AND UserName=@0 AND UserPwd=@1 AND Status=1 "); #endregion return(CgtInsuranceDB.GetInstance().FirstOrDefault <InsuranceUser>(sql, model.UserName, model.UserPwd)); }
/// <summary> /// 执行业务 /// </summary> protected override void ExecuteMethod() { var userModel = new InsuranceUser() { UserName = Parameter.UserName, UserPwd = Parameter.UserPwd }; var result = insuranceUserRep.Login(userModel); Result = new ResponseMessageModel() { Data = result }; }