/// <summary> /// GetList 获取数据集 /// </summary> /// <param name="dataParams">dataParams 查询参数</param> /// <returns>返回 数据集</returns> public IList <Os.Brain.iBxg.Core.Entity.News> GetList(params DbParameter[] dataParams) { if (DataActions.select != this.Action) { return(null); } IList <Os.Brain.iBxg.Core.Entity.News> returnList = new List <Os.Brain.iBxg.Core.Entity.News>(); Os.Brain.iBxg.Core.Entity.News _model = null; Database db = DatabaseFactory.CreateDatabase(Os.Brain.iBxg.Core.Entity.News.CONN); DbCommand dbc = db.GetStoredProcCommand("News_Get"); if (null != dataParams) { dbc.Parameters.AddRange(dataParams); } using (IDataReader dr = db.ExecuteReader(dbc)) { while (dr.Read()) { _model = new Os.Brain.iBxg.Core.Entity.News(); LoadFromReader(dr, _model); returnList.Add(_model); } } return(returnList); }
/// <summary> /// GetItem 获取单个实体 /// </summary> /// <param name="ids">ids 主键值</param> /// <returns>返回 空或实体</returns> public Os.Brain.iBxg.Core.Entity.News GetItem(string ids) { #region DEBUG Debug.WriteLine(string.Format(TSQL.DEBUG_START_LINE, "Os.Brain.iBxg.Core.Dal.GetItem START")); Debug.WriteLine(string.Format(TSQL.SELECT_ITEM, "[dbo].[News]", "[News_Serial]", "@News_Serial")); Debug.WriteLine(string.Format(TSQL.DEBUG_END_LINE, "Os.Brain.iBxg.Core.Dal.GetItem END")); #endregion if (DataActions.select != this.Action) { return(null); } Os.Brain.iBxg.Core.Entity.News _model = null; Database db = DatabaseFactory.CreateDatabase(Os.Brain.iBxg.Core.Entity.News.CONN); DbCommand dbc = db.GetSqlStringCommand(string.Format(TSQL.SELECT_ITEM, "[dbo].[News]", "[News_Serial]", "@News_Serial")); db.AddInParameter(dbc, "@News_Serial", DbType.Int32, ids); using (IDataReader dr = db.ExecuteReader(dbc)) { if (dr.Read()) { _model = new Os.Brain.iBxg.Core.Entity.News(); LoadFromReader(dr, _model); } } return(_model); }
/// <summary> /// Edit 编辑(新增,修改)一条数据 /// </summary> /// <param name="model">model 实体</param> /// <returns>返回 实体主键</returns> public object Edit(Os.Brain.iBxg.Core.Entity.News model) { if (DataActions.insert == this.Action) { return(model.Insert()); } if (DataActions.update == this.Action) { return(model.Update()); } if (DataActions.delete == this.Action) { return(model.Delete()); } return(null); }
protected void LoadFromReader1(IDataReader dr, Os.Brain.iBxg.Core.Entity.News model) { if (dr != null && !dr.IsClosed) { model.News_Serial = (int)dr["News_Serial"]; model.News_ID = dr["News_ID"].ToString(); model.News_Titel = dr["News_Titel"].ToString(); model.News_Color = dr["News_Color"].ToString(); model.News_Summary = dr["News_Summary"].ToString(); model.News_Img = dr["News_Img"].ToString(); model.News_IsEncode = (bool)dr["News_IsEncode"]; model.News_Price = (int)dr["News_Price"]; model.News_Hits = (int)dr["News_Hits"]; model.News_Content = dr["News_Content"].ToString(); model.News_AddTime = (DateTime)dr["News_AddTime"]; model.News_AddUser = dr["News_AddUser"].ToString(); model.News_Order = (int)dr["News_Order"]; model.News_IsDel = (bool)dr["News_IsDel"]; } }
/// <summary> /// GetList 获取分页数据集 /// </summary> /// <param name="pageSize">pageSize 每页条数</param> /// <param name="currPage">currPage 当前页码</param> /// <param name="recordCount">recordCount 总记录数</param> /// <param name="dataParams">dataParams 查询参数</param> /// <returns>返回 数据集</returns> public IList <Os.Brain.iBxg.Core.Entity.News> GetList(int pageSize, int currPage, out int recordCount, params DbParameter[] dataParams) { recordCount = 0; if (DataActions.select != this.Action) { return(null); } IList <Os.Brain.iBxg.Core.Entity.News> returnList = new List <Os.Brain.iBxg.Core.Entity.News>(); Os.Brain.iBxg.Core.Entity.News _model = null; Database db = DatabaseFactory.CreateDatabase(Os.Brain.iBxg.Core.Entity.News.CONN); DbCommand dbc = db.GetStoredProcCommand("News_Get"); if (null != dataParams) { dbc.Parameters.AddRange(dataParams); } db.AddInParameter(dbc, "@PageIndex", DbType.Int32, currPage); db.AddInParameter(dbc, "@PageSize", DbType.Int32, pageSize); db.AddOutParameter(dbc, "@RecordCount", DbType.Int32, 4); using (IDataReader dr = db.ExecuteReader(dbc)) { while (dr.Read()) { _model = new Os.Brain.iBxg.Core.Entity.News(); LoadFromReader(dr, _model); returnList.Add(_model); } } recordCount = (int)dbc.Parameters["@RecordCount"].Value; return(returnList); }
/// <summary> /// Edit 编辑(新增,修改)一条数据 /// </summary> /// <param name="model">model 实体</param> /// <returns>returns 实体主键</returns> public object Edit(Os.Brain.iBxg.Core.Entity.News model) { return(this.dal.Edit(model)); }
protected void LoadFromReader(IDataReader dr, Os.Brain.iBxg.Core.Entity.News model) { if (dr != null && !dr.IsClosed) { if (!dr.IsDBNull(0)) { model.News_Serial = dr.GetInt32(0); } if (!dr.IsDBNull(1)) { model.News_ID = dr.GetString(1); } if (!dr.IsDBNull(2)) { model.News_Titel = dr.GetString(2); } if (!dr.IsDBNull(3)) { model.News_Color = dr.GetString(3); } if (!dr.IsDBNull(4)) { model.News_Summary = dr.GetString(4); } if (!dr.IsDBNull(5)) { model.News_Img = dr.GetString(5); } if (!dr.IsDBNull(6)) { model.News_IsEncode = dr.GetBoolean(6); } if (!dr.IsDBNull(7)) { model.News_Price = dr.GetInt32(7); } if (!dr.IsDBNull(8)) { model.News_Hits = dr.GetInt32(8); } if (!dr.IsDBNull(9)) { model.News_Content = dr.GetString(9); } if (!dr.IsDBNull(10)) { model.News_AddTime = dr.GetDateTime(10); } if (!dr.IsDBNull(11)) { model.News_AddUser = dr.GetString(11); } if (!dr.IsDBNull(12)) { model.News_Order = dr.GetInt32(12); } if (!dr.IsDBNull(13)) { model.News_IsDel = dr.GetBoolean(13); } } }