protected void Page_Load(object sender, EventArgs e) { //DapperBLL.Instabce.InsertRecord(new CICUser { UserName ="******", Password="******", Email="*****@*****.**", PhoneNumber="18818572279" }); CICUser user = DapperBLL.Instabce.GetUserInfo(new CICUser { UserName = "******" }); this.userName.Value = user.UserName; this.password.Value = user.Password; this.email.Value = user.Email; this.phoneNumber.Value = user.PhoneNumber; }
public CICUser GetUserInfo(CICUser userInfo) { CICUser user = new CICUser(); using (IDbConnection conn = HelpClassLib.DataBase.OraHelper.GetSqlConnection()) { string strSql = @" SELECT c.UserId,c.Username, c.PasswordHash AS Password,c.Email, c.PhoneNumber,c.IsFirstTimeLogin,c.AccessFailedCount, c.CreationDate,c.IsActive FROM CICUser c where c.userName = :userName "; user = conn.Query <CICUser>(strSql, userInfo, null, true, null, CommandType.Text).FirstOrDefault(); } return(user); }
/// <summary> /// 插入一条记录 /// </summary> /// <param name="recordModel"></param> /// <returns></returns> public bool InsertRecord <T>(T recordModel) { string strSql = @" INSERT INTO CICUser(Username,PasswordHash,Email,PhoneNumber) VALUES(:UserName, :Password,:Email, :PhoneNumber )"; bool isTrue = false; using (IDbConnection conn = HelpClassLib.DataBase.OraHelper.GetSqlConnection()) { CICUser user = new CICUser(); user.UserName = "******"; user.Password = "******"; user.Email = "*****@*****.**"; user.PhoneNumber = "13795666243"; isTrue = conn.Execute(strSql, recordModel) > 0; } return(isTrue); }
public bool InsertRecord(CICUser userInfo) { return(dal.InsertRecord(userInfo)); }
public CICUser GetUserInfo(CICUser userInfo) { return(dal.GetUserInfo(userInfo)); }