/// <summary>
/// 分页获取数据列表
/// </summary>
public List <Entity.PlanEntity> getpage(int pageSize, int pageNum, out int count, string str)
{
string select, table, where, order;
select = " * ";
table = "[OA_Plan] ";
StringBuilder sb = new StringBuilder();
sb.Append(" ( 1 = 1 ) " + str);
where = sb.ToString();
order = "Pwid";
string sql = "exec Pagination @select, @table, @where, @orderField, @orderType, @pageSize, @pageNum ";
SqlParameter[] paras =
{
new SqlParameter("@select", select),
new SqlParameter("@table", table),
new SqlParameter("@where", where),
new SqlParameter("@orderField", order),
new SqlParameter("@orderType", '1'),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@pageNum", pageNum)
};
DataSet ds = DbHelperSQL.Query(sql, paras);
count = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
List <Entity.PlanEntity> list = new List <Entity.PlanEntity>();
Entity.PlanEntity model;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new Entity.PlanEntity();
if (ds.Tables[0].Rows[i]["Pwid"].ToString() != "")
{
model.Pwid = int.Parse(ds.Tables[0].Rows[i]["Pwid"].ToString());
}
model.Locked = ds.Tables[0].Rows[i]["Locked"].ToString();
model.Pwtitle = ds.Tables[0].Rows[i]["Pwtitle"].ToString();
model.Pwdate = Convert.ToDateTime(ds.Tables[0].Rows[i]["Pwdate"].ToString());
model.Manager = ds.Tables[0].Rows[i]["Manager"].ToString();
model.Uid = Convert.ToInt32(ds.Tables[0].Rows[i]["Uid"].ToString());
model.Pwpath = ds.Tables[0].Rows[i]["Pwpath"].ToString();
list.Add(model);
}
return(list);
}
public static PlanEntity Detailplan(string Id)
{
PlanEntity planEntity = new Entity.PlanEntity();
using (fitnessEntities dbe = new fitnessEntities())
{
plan plan = dbe.plans.Where(o => o.plan_id.Equals(Id)).SingleOrDefault();
planEntity.plan_id = plan.plan_id;
planEntity.plan_name = plan.plan_name;
planEntity.plan_cost = plan.plan_cost;
planEntity.plan_period = plan.plan_period;
}
return(planEntity);
}
public static List <PlanEntity> Getplans()
{
List <PlanEntity> plans = new List <Entity.PlanEntity>();
using (fitnessEntities dbe = new fitnessEntities())
{
PlanEntity planEntity;
var planList = dbe.plans.ToList();
foreach (var plan in planList)
{
planEntity = new Entity.PlanEntity();
planEntity.plan_id = plan.plan_id;
planEntity.plan_name = plan.plan_name;
planEntity.plan_cost = plan.plan_cost;
planEntity.plan_period = plan.plan_period;
plans.Add(planEntity);
}
}
return(plans);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public List<Entity.PlanEntity> getpage(int pageSize, int pageNum, out int count, string str)
{
string select, table, where, order;
select = " * ";
table = "[OA_Plan] ";
StringBuilder sb = new StringBuilder();
sb.Append(" ( 1 = 1 ) " + str);
where = sb.ToString();
order = "Pwid";
string sql = "exec Pagination @select, @table, @where, @orderField, @orderType, @pageSize, @pageNum ";
SqlParameter[] paras ={
new SqlParameter("@select", select),
new SqlParameter("@table", table),
new SqlParameter("@where", where),
new SqlParameter("@orderField", order),
new SqlParameter("@orderType", '1'),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@pageNum", pageNum)
};
DataSet ds = DbHelperSQL.Query(sql, paras);
count = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
List<Entity.PlanEntity> list = new List<Entity.PlanEntity>();
Entity.PlanEntity model;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new Entity.PlanEntity();
if (ds.Tables[0].Rows[i]["Pwid"].ToString() != "")
{
model.Pwid = int.Parse(ds.Tables[0].Rows[i]["Pwid"].ToString());
}
model.Locked = ds.Tables[0].Rows[i]["Locked"].ToString();
model.Pwtitle = ds.Tables[0].Rows[i]["Pwtitle"].ToString();
model.Pwdate = Convert.ToDateTime(ds.Tables[0].Rows[i]["Pwdate"].ToString());
model.Manager = ds.Tables[0].Rows[i]["Manager"].ToString();
model.Uid = Convert.ToInt32(ds.Tables[0].Rows[i]["Uid"].ToString());
model.Pwpath = ds.Tables[0].Rows[i]["Pwpath"].ToString();
list.Add(model);
}
return list;
}
