protected void PageData()
{
KingTop.Common.Pages page = new KingTop.Common.Pages();
string strWhere = " isdel=0 and nodecode='" + NodeCode + "' ";
string Keywords = Request.QueryString["k"];
if (!string.IsNullOrEmpty(Keywords))
{
strWhere += " and title like '%" + Keywords + "%' ";
Title.Value = Keywords;
}
try
{
int recordCount = 0;
DataSet ds = page.GetPageList("K_U_Common ", "*", "orders desc ", strWhere, Split.CurrentPageIndex, Split.PageSize, out recordCount, 1);
Split.RecordCount = recordCount;
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
rptListInfo.DataSource = ds;
rptListInfo.DataBind();
}
}
}
catch (Exception ex)
{
Utils.AlertMessage(this, ex.Message, "系统提示");
}
}
/// <summary>
/// 获取数据列表，带分页，带搜索
/// </summary>
/// <param name="context"></param>
private void GetList(HttpContext context)
{
KingTop.Common.Pages page = new KingTop.Common.Pages();
string title = Utils.CheckSql(context.Request.Params["sTitle"]);
string username = Utils.CheckSql(context.Request.Params["sUserName"]);
Dictionary <string, object> dt = new Dictionary <string, object>();
int intPageSize = Convert.ToInt32(context.Request.Params["rows"]);
int intCurrentPage = Convert.ToInt32(context.Request.Params["page"]);
int RecordCount = 0;
string strWhere = " isdel=0 and nodecode='" + NodeCode + "' ";
if (title.Length > 0)
{
strWhere += " and title like '%" + title + "%'";
}
if (username.Length > 0)
{
strWhere += " and username='******'";
}
DataSet ds = page.GetPageList("K_U_Common ", "*", " orders desc ", strWhere, intCurrentPage, intPageSize, out RecordCount, 1);
List <KingTop.Model.Common.Common> List = new List <KingTop.Model.Common.Common>();
foreach (DataRow item in ds.Tables[0].Rows)
{
KingTop.Model.Common.Common model = new KingTop.Model.Common.Common();
model.Id = item["Id"].ToString();
model.Title = item["Title"].ToString();
model.UserName = item["UserName"].ToString();
if (item["BigImg"].ToString() != "")
{
model.BigImg = "<img src='/UploadFiles/Images/" + item["BigImg"].ToString() + "' height='60'/>";
}
else
{
model.BigImg = "<img src='/sysadmin/images/NoPic.jpg' height='60' />";
}
model.AddDate = Utils.GetStandardDateTime(item["AddDate"].ToString());
model.FlowState = Utils.GetFlowState(item["FlowState"].ToString());
model.Orders = Utils.ParseInt(item["Orders"].ToString(), 0);
List.Add(model);
}
JavaScriptSerializer js = new JavaScriptSerializer();
dt.Add("total", RecordCount);
dt.Add("rows", List.ToList <object>());//list.ToList<object>());
context.Response.Write(js.Serialize(dt));
context.Response.End();
}
