relveantfile.ascx.cs

Maolz个人展示网站源码,全部的代码,.net

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Linq;
namespace MySite.WebUI.Controls.Tag
{
    using SubSonic.Generated;
    using SubSonic;
    /// <summary>
    /// 和Tag关联的上传文件
    /// </summary>
    public partial class RelveantFile : System.Web.UI.UserControl
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!this.IsPostBack)
                this.AspNetPager1.RecordCount = new Tag(this.TagId).GetFileLogCollection().Count;
        }
        public int? TagId
        {
            get { return new int?(Convert.ToInt32(ViewState["TagId"])); }
            set { ViewState["TagId"] = value; }
        }
        protected void ObjectDataSource1_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
        {
            //if (!e.ExecutingSelectCount)
            //{
            //    e.Arguments.StartRowIndex = this.AspNetPager1.StartRecordIndex;
            //    e.Arguments.MaximumRows = this.AspNetPager1.EndRecordIndex;
            //}
            //if (!e.ExecutingSelectCount)
            //{
            //    e.Arguments.StartRowIndex = this.AspNetPager1.PageSize;
            //    e.Arguments.MaximumRows = this.AspNetPager1.CurrentPageIndex;
            //}
            e.InputParameters["currentPageIndex"] = this.AspNetPager1.CurrentPageIndex;
            e.InputParameters["pageSize"] = this.AspNetPager1.PageSize;
            e.InputParameters["qry"] = _BuildSqlQuery();

        }

        private SqlQuery _BuildSqlQuery()
        {
            //Query qry=new Query(FileLog.Schema);
            //qry.

            //new Select
            //Query qry=new Query(FileLog.Schema)
            //    .IN(FileLog.Columns.PKId,
            //        new Select(FileLogTagMapping.Columns.FileLogId)
            //        .From<FileLogTagMapping>()
            //        .Where(FileLogTagMapping.Columns.TagId)
            //        .IsEqualTo(this.TagId).ExecuteAsCollection<Int32>()
            //        )
            //     .ORDER_BY(FileLog.Columns.PKId,"desc");
            //qry.PageSize=this.AspNetPager1.PageSize;
            //qry.PageIndex=this.AspNetPager1.CurrentPageIndex;
            //return qry;
            SqlQuery qry = new Select()
                .From<FileLog>()
                .Where(FileLog.Columns.PKId)
                .In
                (
                new Select(FileLogTagMapping.Columns.FileLogId)
                .From<FileLogTagMapping>()
                .WhereExpression(FileLogTagMapping.Columns.TagId)
                .IsEqualTo(this.TagId)
                )
                .OrderDesc(FileLog.Columns.PKId);
                //.Paged(this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize);
            return qry;
        }

        protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
        {
            this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
            this.Repeater1.DataBind();
        }
        public TagCollection BindTag(object PKId)
        {
            Repeater re = this.Repeater1.FindControl("Repeater2") as Repeater;
            FileLog fl = new FileLog(PKId);
            return fl.GetTagCollection();
        }
    }
}