/// <summary>
/// 返回查询条件下所有总记录数
/// </summary>
/// <param name="strSearch"></param>
/// <param name="classid"></param>
/// <param name="smallclassid"></param>
/// <returns></returns>
private int TotalPageNo(string strWhere)
{
DBServer db = new DBServer();
SqlParameter[] SqlParame =
{
db.MakeParam("@tblName", SqlDbType.VarChar, 100, ParameterDirection.Input, "[elink_group]"),
db.MakeParam("@strWhere", SqlDbType.VarChar, 500, ParameterDirection.Input, strWhere),
db.MakeParam("@fldName", SqlDbType.VarChar, 100, ParameterDirection.Input, "group_id"),
db.MakeParam("@getRec", SqlDbType.Int, 4, ParameterDirection.Input, 1)
};
int intValue = db.ExecuteScalar(CommandType.StoredProcedure, "Usp_Paged", SqlParame);
return(intValue);
}
/// <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);
}
}
}
