protected void Page_Load(object sender, EventArgs e) { Common.DataContext ctx = new Common.DataContext(); int pageIndex = PubFunc.getPageIndex(); if (pageIndex == 0) { pageIndex = 1; } int pageSize = Pager.PageSize; ctx.CommandType = CommandType.Text; // (SELECT ROW_NUMBER() OVER (ORDER BY usr_User.ID DESC) AS ROWNO, string sql = @"Select [ID],Case ParentId when 0 then [Name] else '|----'+[Name] end [Name],[Type],[ContentType],[ImageUrl],[Code],[ParentId],[Sort],Case ParentId when 0 then ID else ParentId end sortId,[State],[CreateDate],[ModifyDate],[CreatedBy],[ModifiedBy],[Remark],[Ext] from [Channel] where State <> 255 order by sortId"; var dataset = ctx.ExecuteDataSet(sql); if (dataset.Tables.Count <= 0) { return; } var list = dataset.Tables[0].ToList<Model.Channel>(); Common.PubFunc.BindControl(rptList, list); }
protected void Page_Load(object sender, EventArgs e) { Common.DataContext ctx = new Common.DataContext(); int pageIndex = PubFunc.getPageIndex(); if (pageIndex == 0) { pageIndex = 1; } int pageSize = Pager.PageSize; ctx.CommandType = CommandType.Text; // (SELECT ROW_NUMBER() OVER (ORDER BY usr_User.ID DESC) AS ROWNO, string sql = @"Select [ID],Case ParentId when 0 then [Name] else '|----'+[Name] end [Name],[Type],[ContentType],[ImageUrl],[Code],[ParentId],[Sort],Case ParentId when 0 then ID else ParentId end sortId,[State],[CreateDate],[ModifyDate],[CreatedBy],[ModifiedBy],[Remark],[Ext] from [Channel] where State <> 255 order by sortId"; var dataset = ctx.ExecuteDataSet(sql); if (dataset.Tables.Count <= 0) { return; } var list = dataset.Tables[0].ToList <Model.Channel>(); Common.PubFunc.BindControl(rptList, list); }
protected void Page_Load(object sender, EventArgs e) { var ctx = new DataContext(); var ds = ctx.ExecuteDataSet( @"Select top 10 ID,Title,ChannelID,CreateDate from Content Where ChannelCode='Company' And State=0 Order by CreateDate Desc; Select top 10 ID,Title,ChannelID,CreateDate from Content Where ChannelCode='dongtai' And State=0 Order by CreateDate Desc; Select * from Config where state=0;"); if (ds != null) { if (ds.Tables.Count>0) { CompanyContents = ds.Tables[0].ToList<Model.Content>(); } if (ds.Tables.Count > 1) { dtContents = ds.Tables[1].ToList<Model.Content>(); } if (ds.Tables.Count > 2) { Configs = ds.Tables[2].ToList<Model.Config>(); } } }
protected void Page_Load(object sender, EventArgs e) { int pageIndex = PubFunc.getPageIndex(); if (pageIndex == 0) { pageIndex = 1; } int pageSize = Pager.PageSize; ctx.CommandType = CommandType.Text; // (SELECT ROW_NUMBER() OVER (ORDER BY usr_User.ID DESC) AS ROWNO, string sql = @"Select top " + pageSize + " [ID],[LoginName],[Password] ,[Name],[Mob],[Email],[QQ],[Remark],[State],[Ext],[CreateDate],[ModifyDate] from [Admin] where Id not in (SELECT top " + (pageIndex - 1) * pageSize + " [ID] FROM [Admin]" + "Where State <> 255 And " + GetWhereStr() + ") and State <> 255 And " + GetWhereStr() + " order by ID desc;Select count(ID) totalCount from [Admin] Where State <> 255 And " + GetWhereStr(); var dataset = ctx.ExecuteDataSet(sql); if (dataset.Tables.Count <= 0) { return; } var datatable = dataset.Tables[0]; Common.PubFunc.BindControl(rptUserList, datatable); Pager.RecordCount = Convert.ToInt32(dataset.Tables[1].Rows[0]["totalCount"].ToString()); //Pager.SetRewriteUrl(); }
protected void Page_Load(object sender, EventArgs e) { int pageIndex = PubFunc.getPageIndex(); if (pageIndex == 0) { pageIndex = 1; } int pageSize = Pager.PageSize; ctx.CommandType = CommandType.Text; // (SELECT ROW_NUMBER() OVER (ORDER BY usr_User.ID DESC) AS ROWNO, string sql = @"Select top " + pageSize + " [ID],[ChannelID],[ChannelName],[ChannelCode],[Type],[ImageUrls],[Title],substring([ContentText],1,200)+'...' as ContentText,[Url],[Attributes],[CreateDate],[CreatedBy],[ModifyDate],[ModifiedBy],[Remark],[Ext],[State] from [Content] where Id not in (SELECT top " + (pageIndex - 1) * pageSize + " [ID] FROM [Content] Where State <> 255 And " + GetWhereStr() + " Order by ID desc) and State <> 255 And " + GetWhereStr() + " order by ID desc;Select count(ID) totalCount from [Content] Where State <> 255 And " + GetWhereStr() + ";Select Name,ID From Channel Where State<>255"; var dataset = ctx.ExecuteDataSet(sql); if (dataset.Tables.Count <= 0) { return; } var datatable = dataset.Tables[0]; Common.PubFunc.BindControl(rptUserList, datatable); Pager.RecordCount = Convert.ToInt32(dataset.Tables[1].Rows[0]["totalCount"].ToString()); if (!IsPostBack) { ddlChannel.Items.Clear(); ddlChannel.Items.Add(new ListItem("全部", "0")); if (dataset.Tables[2] != null && dataset.Tables[2].Rows.Count > 0) { var channels = dataset.Tables[2].ToList <Model.Channel>(); foreach (var channel in channels) { ddlChannel.Items.Add(new ListItem(channel.Name, channel.ID.ToString())); } } } //Pager.SetRewriteUrl(); }