/// <summary> /// 增加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Eyousoft_yhq.Model.CustomMsg model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO tbl_Recommend (OpenId ,NickName ,Sex ,CommendInfo ) VALUES (@OpenId ,@NickName ,@Sex ,@CommendInfo )"); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "OpenId", System.Data.DbType.String, model.OpenId); this._db.AddInParameter(cmd, "NickName", System.Data.DbType.String, model.NickName); this._db.AddInParameter(cmd, "Sex", System.Data.DbType.String, model.Sex); this._db.AddInParameter(cmd, "CommendInfo", System.Data.DbType.String, model.CommendInfo); return(DbHelper.ExecuteSql(cmd, this._db)); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.CustomMsg> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.serCustomMsg serModel) { IList <Eyousoft_yhq.Model.CustomMsg> list = new List <Eyousoft_yhq.Model.CustomMsg>(); string tableName = "tbl_Recommend"; string fileds = " * "; string orderByString = " IssueTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.CustomMsg model = new Eyousoft_yhq.Model.CustomMsg(); model.Id = dr.GetInt32(dr.GetOrdinal("id")); model.OpenId = dr.GetString(dr.GetOrdinal("OpenId")); model.NickName = dr.GetString(dr.GetOrdinal("NickName")); model.Sex = dr.GetString(dr.GetOrdinal("Sex")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.CommendInfo = dr.GetString(dr.GetOrdinal("CommendInfo")); list.Add(model); } }; return(list); }
/// <summary> /// 获取实体 /// </summary> /// <param name="id">编号</param> /// <returns></returns> public Eyousoft_yhq.Model.CustomMsg GetModel(string id) { Eyousoft_yhq.Model.CustomMsg model = null; string StrSql = "select * from tbl_Recommend where id=@id"; DbCommand dc = this._db.GetSqlStringCommand(StrSql); this._db.AddInParameter(dc, "id", DbType.AnsiStringFixedLength, id); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { model = new Eyousoft_yhq.Model.CustomMsg(); model.Id = dr.GetInt32(dr.GetOrdinal("id")); model.OpenId = dr.GetString(dr.GetOrdinal("OpenId")); model.NickName = dr.GetString(dr.GetOrdinal("NickName")); model.Sex = dr.GetString(dr.GetOrdinal("Sex")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.CommendInfo = dr.GetString(dr.GetOrdinal("CommendInfo")); } } return(model); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList<Eyousoft_yhq.Model.CustomMsg> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.serCustomMsg serModel) { IList<Eyousoft_yhq.Model.CustomMsg> list = new List<Eyousoft_yhq.Model.CustomMsg>(); string tableName = "tbl_Recommend"; string fileds = " * "; string orderByString = " IssueTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.CustomMsg model = new Eyousoft_yhq.Model.CustomMsg(); model.Id = dr.GetInt32(dr.GetOrdinal("id")); model.OpenId = dr.GetString(dr.GetOrdinal("OpenId")); model.NickName = dr.GetString(dr.GetOrdinal("NickName")); model.Sex = dr.GetString(dr.GetOrdinal("Sex")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.CommendInfo = dr.GetString(dr.GetOrdinal("CommendInfo")); list.Add(model); } }; return list; }
/// <summary> /// 获取实体 /// </summary> /// <param name="id">编号</param> /// <returns></returns> public Eyousoft_yhq.Model.CustomMsg GetModel(string id) { Eyousoft_yhq.Model.CustomMsg model = null; string StrSql = "select * from tbl_Recommend where id=@id"; DbCommand dc = this._db.GetSqlStringCommand(StrSql); this._db.AddInParameter(dc, "id", DbType.AnsiStringFixedLength, id); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { model = new Eyousoft_yhq.Model.CustomMsg(); model.Id = dr.GetInt32(dr.GetOrdinal("id")); model.OpenId = dr.GetString(dr.GetOrdinal("OpenId")); model.NickName = dr.GetString(dr.GetOrdinal("NickName")); model.Sex = dr.GetString(dr.GetOrdinal("Sex")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.CommendInfo = dr.GetString(dr.GetOrdinal("CommendInfo")); } } return model; }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Eyousoft_yhq.Model.CustomMsg model) { return(dal.Add(model)); }