/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public IList <EyouSoft.Model.MArticleClass> GetList(int PageSize, int PageIndex, ref int RecordCount, EyouSoft.Model.MArticleClass Search)
{
IList <EyouSoft.Model.MArticleClass> list = new List <EyouSoft.Model.MArticleClass>();
string tableName = "tbl_TravelArticleClass";
string fileds = "ClassId, ClassName,IsSystem,SortRule";
StringBuilder query = new StringBuilder();
query.Append(" 1=1 ");
if (Search != null)
{
if ((int)Search.IsSystem >= 0)
{
query.AppendFormat(" AND IsSystem={0}", (int)Search.IsSystem);
}
if (!string.IsNullOrEmpty(Search.ClassName))
{
query.AppendFormat(" AND ClassName like '%{0}%' ", Search.ClassName);
}
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), "IsSystem desc,SortRule desc,ClassId desc ", null))
{
while (dr.Read())
{
EyouSoft.Model.MArticleClass model = new EyouSoft.Model.MArticleClass();
model.ClassId = dr.GetInt32(dr.GetOrdinal("ClassId"));
model.ClassName = !dr.IsDBNull(dr.GetOrdinal("ClassName")) ? dr.GetString(dr.GetOrdinal("ClassName")) : "";
model.IsSystem = !dr.IsDBNull(dr.GetOrdinal("IsSystem")) ? (ArticleType)dr.GetInt32(dr.GetOrdinal("IsSystem")) : (ArticleType)0;
model.SortRule = !dr.IsDBNull(dr.GetOrdinal("SortRule")) ? dr.GetInt32(dr.GetOrdinal("SortRule")) : 0;
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EyouSoft.Model.MArticleClass GetModel(int ClassId)
{
EyouSoft.Model.MArticleClass model = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("select ClassId, ClassName,IsSystem,SortRule ");
strSql.Append(" from tbl_TravelArticleClass ");
strSql.Append(" where ClassId=@ClassId ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "ClassId", System.Data.DbType.Int32, ClassId);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
model = new EyouSoft.Model.MArticleClass();
model.ClassId = dr.GetInt32(dr.GetOrdinal("ClassId"));
model.ClassName = !dr.IsDBNull(dr.GetOrdinal("ClassName")) ? dr.GetString(dr.GetOrdinal("ClassName")) : "";
model.IsSystem = !dr.IsDBNull(dr.GetOrdinal("IsSystem")) ? (ArticleType)dr.GetInt32(dr.GetOrdinal("IsSystem")) : (ArticleType)0;
model.SortRule = !dr.IsDBNull(dr.GetOrdinal("SortRule")) ? dr.GetInt32(dr.GetOrdinal("SortRule")) : 0;
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(EyouSoft.Model.MArticleClass model)
{
if (!string.IsNullOrEmpty(model.ClassName) && model.ClassId > 0)
{
return(dal.Update(model) == 0 ? false : true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model"></param>
public bool Add(EyouSoft.Model.MArticleClass model)
{
if (!string.IsNullOrEmpty(model.ClassName))
{
return(dal.Add(model) == 0 ? false : true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(EyouSoft.Model.MArticleClass model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbl_TravelArticleClass(");
strSql.Append("ClassName,IsSystem,SortRule");
strSql.Append(") values (");
strSql.Append("@ClassName,@IsSystem,@SortRule");
strSql.Append(") ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "ClassName", System.Data.DbType.String, model.ClassName);
this._db.AddInParameter(cmd, "IsSystem", DbType.Int32, model.IsSystem);
this._db.AddInParameter(cmd, "SortRule", System.Data.DbType.Int32, model.SortRule);
return(DbHelper.ExecuteSql(cmd, this._db));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(EyouSoft.Model.MArticleClass model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbl_TravelArticleClass set ");
strSql.Append(" ClassName = @ClassName,IsSystem=@IsSystem,SortRule=@SortRule ");
strSql.Append(" where ClassId=@ClassId ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "ClassId", System.Data.DbType.Int32, model.ClassId);
this._db.AddInParameter(cmd, "ClassName", System.Data.DbType.String, model.ClassName);
this._db.AddInParameter(cmd, "IsSystem", DbType.Int32, model.IsSystem);
this._db.AddInParameter(cmd, "SortRule", System.Data.DbType.Int32, model.SortRule);
return(DbHelper.ExecuteSql(cmd, this._db));
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public IList <EyouSoft.Model.MArticleClass> GetList(int top, EyouSoft.Model.MArticleClass Search)
{
IList <EyouSoft.Model.MArticleClass> list = new List <EyouSoft.Model.MArticleClass>();
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(" select {0} ", top > 0 ? string.Format(" top {0} ", top) : string.Empty);
strSql.Append(" ClassId, ClassName,IsSystem,SortRule ");
strSql.Append(" from tbl_TravelArticleClass where 1=1");
if (Search != null)
{
if ((int)Search.IsSystem >= 0)
{
strSql.AppendFormat(" AND IsSystem={0}", (int)Search.IsSystem);
}
if (!string.IsNullOrEmpty(Search.ClassName))
{
strSql.AppendFormat(" and ClassName like '%{0}%' ", Search.ClassName);
}
}
strSql.Append(" order by IsSystem desc, SortRule desc,ClassId desc ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
EyouSoft.Model.MArticleClass model = new EyouSoft.Model.MArticleClass();
model.ClassId = dr.GetInt32(dr.GetOrdinal("ClassId"));
model.ClassName = !dr.IsDBNull(dr.GetOrdinal("ClassName")) ? dr.GetString(dr.GetOrdinal("ClassName")) : "";
model.IsSystem = !dr.IsDBNull(dr.GetOrdinal("IsSystem")) ? ( ArticleType)dr.GetInt32(dr.GetOrdinal("IsSystem")) : ( ArticleType)0;
model.SortRule = !dr.IsDBNull(dr.GetOrdinal("SortRule")) ? dr.GetInt32(dr.GetOrdinal("SortRule")) : 0;
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 获得分页数据列表
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <returns></returns>
public IList <EyouSoft.Model.MArticleClass> GetList(int PageSize, int PageIndex, ref int RecordCount, EyouSoft.Model.MArticleClass Search)
{
return(dal.GetList(PageSize, PageIndex, ref RecordCount, Search));
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <returns></returns>
public IList <EyouSoft.Model.MArticleClass> GetList(EyouSoft.Model.MArticleClass Search)
{
return(dal.GetList(0, Search));
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public IList<EyouSoft.Model.MArticleClass> GetList(int top, EyouSoft.Model.MArticleClass Search)
{
IList<EyouSoft.Model.MArticleClass> list = new List<EyouSoft.Model.MArticleClass>();
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(" select {0} ", top > 0 ? string.Format(" top {0} ", top) : string.Empty);
strSql.Append(" ClassId, ClassName,IsSystem,SortRule ");
strSql.Append(" from tbl_TravelArticleClass where 1=1");
if (Search != null)
{
if ((int)Search.IsSystem >= 0)
{
strSql.AppendFormat(" AND IsSystem={0}", (int)Search.IsSystem);
}
if (!string.IsNullOrEmpty(Search.ClassName))
{
strSql.AppendFormat(" and ClassName like '%{0}%' ", Search.ClassName);
}
}
strSql.Append(" order by IsSystem desc, SortRule desc,ClassId desc ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
EyouSoft.Model.MArticleClass model = new EyouSoft.Model.MArticleClass();
model.ClassId = dr.GetInt32(dr.GetOrdinal("ClassId"));
model.ClassName = !dr.IsDBNull(dr.GetOrdinal("ClassName")) ? dr.GetString(dr.GetOrdinal("ClassName")) : "";
model.IsSystem = !dr.IsDBNull(dr.GetOrdinal("IsSystem")) ? ( ArticleType)dr.GetInt32(dr.GetOrdinal("IsSystem")) : ( ArticleType)0;
model.SortRule = !dr.IsDBNull(dr.GetOrdinal("SortRule")) ? dr.GetInt32(dr.GetOrdinal("SortRule")) : 0;
list.Add(model);
}
}
return list;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EyouSoft.Model.MArticleClass GetModel(int ClassId)
{
EyouSoft.Model.MArticleClass model = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("select ClassId, ClassName,IsSystem,SortRule ");
strSql.Append(" from tbl_TravelArticleClass ");
strSql.Append(" where ClassId=@ClassId ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "ClassId", System.Data.DbType.Int32, ClassId);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
model = new EyouSoft.Model.MArticleClass();
model.ClassId = dr.GetInt32(dr.GetOrdinal("ClassId"));
model.ClassName = !dr.IsDBNull(dr.GetOrdinal("ClassName")) ? dr.GetString(dr.GetOrdinal("ClassName")) : "";
model.IsSystem = !dr.IsDBNull(dr.GetOrdinal("IsSystem")) ? (ArticleType)dr.GetInt32(dr.GetOrdinal("IsSystem")) : (ArticleType)0;
model.SortRule = !dr.IsDBNull(dr.GetOrdinal("SortRule")) ? dr.GetInt32(dr.GetOrdinal("SortRule")) : 0;
}
}
return model;
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public IList<EyouSoft.Model.MArticleClass> GetList(int PageSize, int PageIndex, ref int RecordCount, EyouSoft.Model.MArticleClass Search)
{
IList<EyouSoft.Model.MArticleClass> list = new List<EyouSoft.Model.MArticleClass>();
string tableName = "tbl_TravelArticleClass";
string fileds = "ClassId, ClassName,IsSystem,SortRule";
StringBuilder query = new StringBuilder();
query.Append(" 1=1 ");
if (Search != null)
{
if ((int)Search.IsSystem >= 0)
{
query.AppendFormat(" AND IsSystem={0}", (int)Search.IsSystem);
}
if (!string.IsNullOrEmpty(Search.ClassName))
{
query.AppendFormat(" AND ClassName like '%{0}%' ", Search.ClassName);
}
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), "IsSystem desc,SortRule desc,ClassId desc ", null))
{
while (dr.Read())
{
EyouSoft.Model.MArticleClass model = new EyouSoft.Model.MArticleClass();
model.ClassId = dr.GetInt32(dr.GetOrdinal("ClassId"));
model.ClassName = !dr.IsDBNull(dr.GetOrdinal("ClassName")) ? dr.GetString(dr.GetOrdinal("ClassName")) : "";
model.IsSystem = !dr.IsDBNull(dr.GetOrdinal("IsSystem")) ? (ArticleType)dr.GetInt32(dr.GetOrdinal("IsSystem")) : (ArticleType)0;
model.SortRule = !dr.IsDBNull(dr.GetOrdinal("SortRule")) ? dr.GetInt32(dr.GetOrdinal("SortRule")) : 0;
list.Add(model);
}
}
return list;
}
