public UserModel GetById(int id) { try { string sql = @"SELECT * FROM `user` WHERE id=@Id;"; return(EntityToModel(MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, new MySqlParameter("@Id", id)))); } catch (Exception ex) { LogHelper.Error(ex); } return(null); }
public UserModel GetByToken(string token) { try { string sql = @"SELECT * FROM `user` WHERE userToken=@Token;"; return(EntityToModel(MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, new MySqlParameter("@Token", token)))); } catch (Exception ex) { LogHelper.Error(ex); } return(null); }
public UserModel GetByMobile(string mobileNum) { try { string sql = "SELECT * FROM `user` WHERE mobileNum = @MobileNum;"; return(EntityToModel(MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, new MySqlParameter("@MobileNum", mobileNum)))); } catch (Exception ex) { LogHelper.Error(ex); } return(null); }
public UserModel GetByUserId(string userId) { try { string sql = @"SELECT * FROM `user` WHERE userId=@UserId;"; DataRow dr = MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, new MySqlParameter("@UserId", userId)); return(EntityToModel(dr)); } catch (Exception ex) { LogHelper.Error(ex); } return(null); }
public SMSCodeModel GetByMobileNum(string mobileNum, DateTime dt) { string sql = "SELECT * FROM `smscode` WHERE `MobileNum` = @MobileNum AND `CreateTime` > @CreateTime ORDER BY `CreateTime` DESC LIMIT 0,1;"; MySqlParameter[] parameters = { new MySqlParameter("@MobileNum", mobileNum), new MySqlParameter("@CreateTime", dt) }; DataRow dr = MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, parameters); return(EntityToModel(dr)); }
public UserModel GetByOpenIdAndUnionId(string openId, string unionId) { try { string sql = @"SELECT * FROM `user` WHERE `openId`=@OpenId AND `unionId`=@UnionId ;"; MySqlParameter[] param = { new MySqlParameter("@OpenId", openId), new MySqlParameter("@UnionId", unionId), }; return(EntityToModel(MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, param))); } catch (Exception ex) { LogHelper.Error(ex); } return(null); }