public static int GetCount(string board_type) { return(MySqlDapperHelper.RunGetQueryFromXml <int>("Sql/Board.xml", "GetBoardCount", new { board_type = board_type, }).FirstOrDefault()); }
/* 필요한가? * public string UPDATE_IP { get; set; } * public string UPDATE_USER { get; set; } * public string UPDATE_USERNAME { get; set; } * public DateTime? UPDATE_DATE { get; set; } */ public static BoardModel Get(string board_type, int seq) { return(MySqlDapperHelper.RunGetQueryFromXml <BoardModel>("Sql/Board.xml", "GetBoard", new { board_type = board_type, seq = seq }).FirstOrDefault()); }
public static UserinfoModel GetLogin(string user_id, string pw) { var model = MySqlDapperHelper.RunGetQueryFromXml <UserinfoModel>("Sql/User.xml", "GetUserInfoAll", new { user_id = user_id.ToLower() }).FirstOrDefault(); if (model == null) { throw new Exception("id 없음"); } else { var pwhash = CoreLib.Crypter.HMacSha256.GetHMac(pw.Trim(), model.UNIQUE_ID.ToString()); if (model.PASSWORD != pwhash) { throw new Exception("패스워드가 틀렸습니다"); } return(model); } }
public static IEnumerable <TestModel> GetList(int col1) { return(MySqlDapperHelper.RunGetQueryFromXml <TestModel>("Sql/Home.xml", "GetTestData", new { COL1 = col1 })); }