/// <summary>
/// 获得数据列表
/// </summary>
public IList <GroupInfo> GetList(string strWhere)
{
using (DBServer db = new DBServer())
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select group_id, group_name, group_subjectionId, group_subjectionName, group_subjectionIds, group_display, Group_level");
strSql.Append(" FROM [elink_group] ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(string.Format(" where {0}", strWhere));
}
List <GroupInfo> list = new List <GroupInfo>();
using (DataTable table = db.GetDataTable(CommandType.Text, strSql.ToString()))
{
foreach (DataRow row in table.Rows)
{
GroupInfo model = new GroupInfo();
model.Group_id = Convert.ToInt32(row["Group_id"]);
model.Group_name = Convert.ToString(row["group_name"]);
model.Group_subjectionId = (int)row["Group_subjectionId"];
model.Group_subjectionName = Convert.ToString(row["group_subjectionName"]);
model.Group_subjectionIds = Convert.ToString(row["group_subjectionIds"]);
model.Group_display = Convert.ToInt32(row["Group_display"]);
model.Group_level = Convert.ToInt32(row["Group_level"]);
list.Add(model);
}
table.Clear();
table.Dispose();
return(list);
}
}
}
/// <summary>
/// 存储过程读取
/// </summary>
public IList <GroupInfo> GetList(int PageNo, int PageSize, string strWhere, out int TotalPageNo)
{
using (DBServer db = new DBServer())
{
TotalPageNo = 0;
strWhere = string.IsNullOrEmpty(strWhere) ? string.Empty : strWhere;
SqlParameter[] SqlParam =
{
db.MakeParam("@tblName", SqlDbType.VarChar, 100, ParameterDirection.Input, "[elink_group]"),
db.MakeParam("@fldName", SqlDbType.VarChar, 100, ParameterDirection.Input, "group_id"),
db.MakeParam("@fldOut", SqlDbType.VarChar, 1000, ParameterDirection.Input, "group_id,group_name,group_subjectionId,group_subjectionName,group_subjectionIds,group_display"),
db.MakeInParam("@PageSize", SqlDbType.Int, 4, PageSize),
db.MakeInParam("@PageIndex", SqlDbType.Int, 4, PageNo),
db.MakeInParam("@OrderType", SqlDbType.Int, 4, 1),
db.MakeParam("@strWhere", SqlDbType.VarChar, 500, ParameterDirection.Input, strWhere)
};
List <GroupInfo> list = new List <GroupInfo>();
using (DataTable table = db.GetDataTable(CommandType.StoredProcedure, "Usp_Paged", SqlParam))
{
foreach (DataRow row in table.Rows)
{
GroupInfo model = new GroupInfo();
model.Group_id = (int)row["Group_id"];
model.Group_name = Convert.ToString(row["group_name"]);
model.Group_subjectionId = (int)row["Group_subjectionId"];
model.Group_subjectionName = Convert.ToString(row["group_subjectionName"]);
model.Group_subjectionIds = Convert.ToString(row["group_subjectionIds"]);
model.Group_display = (int)row["Group_display"];
list.Add(model);
}
TotalPageNo = this.TotalPageNo(strWhere);
table.Clear();
table.Dispose();
return(list);
}
}
}
