LYZHGD_3.0/还原代码/JAnCallCenter/WorkSearch/workSearch.a...

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.IO;
using JAnCallCenter.BaseClass;
using System.Data;

namespace JAnCallCenter.WorkSearch
{
    public partial class workSearch : BasePage
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            AjaxPro.Utility.RegisterTypeForAjax(typeof(workSearch));
            if (!IsPostBack)
            {
                DBSearchContation();
            }
        }
        //提取信息    绑定信息
        [AjaxPro.AjaxMethod]
        public string LoadingData(string pageIndex, string strWhere)
        {
            string strPath = "~/WorkSearch/_controls/workSearch.ascx";
            Control uc_ControlRegistList = LoadControl(strPath);
            Repeater rpt_RegistList = (Repeater)uc_ControlRegistList.FindControl("rptItems");

            DBUtility.Pagination pagination = new DBUtility.Pagination();//分页的类
            if (!string.IsNullOrEmpty(pageIndex))
            {
                pagination.Sequence = int.Parse(pageIndex);
            }
            else
            {
                pagination.Sequence = 1;
            }
            pagination.ItemUnit = "条记录";
            pagination.SortSentence = "order by AddTime desc";
            pagination.Primarykey = "VIEW_WORKBASE.Id";
            pagination.SearchField = "View_WorkBase.*";
            pagination.TableName = "VIEW_WORKBASE";
            pagination.PageSize = 10;
            pagination.UrlStr = "";
            if (!string.IsNullOrEmpty(strWhere))
            {
                pagination.SearchSentence = " and 1=1 " + strWhere;
            }
            else
            {
                pagination.SearchSentence = " and 1=1 ";
            }
            pagination.ImagesPath = "/_grid/imgs/";
            try
            {
                rpt_RegistList.DataSource = pagination.GetDataTable();
                rpt_RegistList.DataBind();

                StringBuilder strbuder = new StringBuilder();
                StringWriter strWriter = new StringWriter(strbuder);
                HtmlTextWriter strText = new HtmlTextWriter(strWriter);

                pagination.GoPageBarStyle1();//分页条样式

                uc_ControlRegistList.GetType().GetProperty("PaginationBar").SetValue(uc_ControlRegistList, pagination.PageBar, null);
                rpt_RegistList.RenderControl(strText);//将服务器控件内容输出

                return strbuder.ToString();
            }
            catch (Exception ex)
            {
                Common.SysLog.WriteLog(ex);

                return ex.Message.ToString();
            }
        }
        //绑定查询信息
        protected void DBSearchContation()
        {
            DataTable dt = new DataTable();

            #region   //绑定受理坐席人员
            dt = DBUtility.DbHelperOra.Query("select * from view_gg_czyb where zxbz=0 and hwbz=0").Tables[0];
            if (dt.Rows.Count > 0)
            {
                drpControlUser.Items.Add(new ListItem("-全部-", "0"));
                drpControlUser.SelectedIndex = 0;
                foreach (DataRow dr in dt.Rows)
                {

                    if (DBNull.Value != dr["userdesc"])
                    {
                        drpControlUser.Items.Add(new ListItem(dr["userdesc"].ToString(), dr["id"].ToString()));

                    }

                }
            }
            #endregion
            #region//绑定工单种类
            //JAnCallCenter.BLL.GG_DMNR bllGD = new JAnCallCenter.BLL.GG_DMNR();
            //dt = bllGD.GetList("FJDID='ZXFL' and bz=0").Tables[0];
            //if (dt.Rows.Count > 0)
            //{
            //    drpWorkSort.Items.Add(new ListItem("请选择分类", "0"));
            //    foreach (DataRow dr in dt.Rows)
            //    {
            //        drpWorkSort.Items.Add(new ListItem(dr["name"].ToString(), dr["id"].ToString()));
            //    }
            //}
            #endregion

            dt.Clear();
            dt.Dispose();
        }
    }
}