奥杰cms源码 - CorpGoodsView

using System;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using BoyunBase;
using SiteCore;

public partial class Part_CorpGoodsView : System.Web.UI.UserControl
{
    private PartAccess pAcs = null;
    private int TotalCount;//数据总数
    private int PageIndex; //页索引
    private int PageCount;//页总数
    private int PageSize;
    private DataTable dt;

    protected void Page_Load( object sender, EventArgs e )
    {
        try {
            if( !IsPostBack ) {
                pAcs = new PartAccess( this );
                if( pAcs.IsReady ) {
                    GetData();
                    PartShow();
                }
            }
        } catch( Exception ex ) {
            Todo.DebugOut( "加载 Part_CorpGoodsView ‘出现异常：" + ex.Message );
        }
    }

    private void GetData()
    {
        ContentAccess ca = new ContentAccess( this, "TableName" );
        string key = Todo.Get( "key", Request ).Trim();

        if( key != "" ) {//条件判断
            dt = ca.Read( "[@GoodsTitle like ‘%" + key + "%‘]", "name" );
            if( dt == null || dt.Rows.Count < 1 ) {
                dt = ca.Read( "[@GoodsTitle like ‘%" + key + "‘]", "name" );
                if( dt == null || dt.Rows.Count < 1 ) {
                    dt = ca.Read( "[@GoodsTitle like ‘" + key + "%‘]", "name" );
                    if( dt == null || dt.Rows.Count < 1 ) {
                        lbMsg.Visible = true;
                        lbMsg.InnerText = "抱歉，没有找到与“" + key + "”相关的供应信息。";
                        return;
                    }
                }
            }
            lbMsg.Visible = true;
            lbMsg.InnerText = "搜索与“" + key + "”相关的供应信息：";
        } else {
            lbMsg.Visible = false;
            dt = ca.Read( "[*]", "name" );
            if( dt == null || dt.Rows.Count < 1 ) return;
        }//进行分页显示

        TotalCount = dt.Rows.Count;
        PageSize = pAcs.GetSettingInt( "PageSize", 12 ); //Todo.GetInt( "PageSize", nvCol, 12 );
        if( PageSize <= 4 ) {
            PageSize = 4;
        } else if( PageSize % 4 != 0 ) {
            PageSize = PageSize - (PageSize % 4) + 4;
        }
        PageCount = Convert.ToInt32( Math.Floor( Convert.ToDouble( TotalCount / PageSize ) ) + 1 );
        PageIndex = 1;

        //要用计算的都放到viewstate中
        Session["Part_CorpGoodsView_Dt"] = dt;
    }

    private void PartShow()//数据显示
    {
        if( dt == null && Session["Part_CorpGoodsView_Dt"] != null ) {
            dt = Session["Part_CorpGoodsView_Dt"] as DataTable;
        }
        if( dt == null || dt.Rows.Count < 1 ) return;

        string detailPage = pAcs.GetSetting( "detailPage" );  // 链接产品页 传递参数给 产品展示 部件
        if( detailPage != "" ) {
            detailPage += "?pid=";
        } else {
            detailPage = "";
        }

        string timeFormat = pAcs.GetSetting( "timeFormat" );
        bool isOpenNew = pAcs.GetSettingBool( "isOpenNew" );
        string target = "";
        if( isOpenNew ) target = "_blank";
        else target = "_self";

        Todo.AddDataCol( "Target", dt );
        Todo.AddDataCol( "IssueTimeStr", dt );
        Todo.AddDataCol( "LinkUrl", dt );
        foreach( DataRow dr in dt.Rows ) {
            if( detailPage != "" )
                dr["LinkUrl"] = detailPage + Todo.Get( "Id", dr );
            else
                dr["LinkUrl"] = "";
            //dr["ThumbPath"] = Todo.Get( "ThumbPath", dr ); //pAcs.ToRelUrl();
            dr["IssueTimeStr"] = Todo.TimeFormat( Todo.Get( "IssueTime", dr ), timeFormat );
            dr["Target"] = target;
        }

        rptGoodsList.DataSource = dt;
        rptGoodsList.DataBind();

    }
}