public static BoardModel Get(uint idx) { using (var db = new MySqlDapperHelper()) { string sql = @" SELECT A.idx ,A.title ,A.contents ,A.reg_user ,A.reg_username ,A.reg_date ,A.view_Cnt ,A.status_flag FROM t_board A WHERE A.idx = @idx "; return(db.QuerySingle <BoardModel>(sql, new { idx = idx })); } }
internal UserModel GetLoginUser() { //this.User_Name //this.Password string sql = @" SELECT user_seq ,user_name ,email ,password FROM t_user WHERE user_name = @user_name "; UserModel user; using (var db = new MySqlDapperHelper()) { user = db.QuerySingle <UserModel>(sql, this); } if (user == null) { throw new Exception("사용자가 존재하지 않습니다"); } if (user.Password != this.Password) { throw new Exception("비밀번호가 틀립니다"); //비밀번호 틀린 횟수 -- update } return(user); }