首页 > 代码库 > .net简单页面后台绑定下拉框,按钮,分页 后台cs文件

.net简单页面后台绑定下拉框,按钮,分页 后台cs文件

二、cs文件

using System;
using System.Collections.Generic;
using System.Web.UI;
using System.Web.UI.WebControls;
using BS.EAP.DBAccess;
using System.Data;
using BS.EAP.Authentication;
using BS.EAP.BizMgt.DataQuery;
using System.Web.Security;
using System.Collections;
using BS.EAP.BizMgt.Model;
using System.Text;
using System.Linq;
using System.Web;
using BS.EAP.BizMgt.Action;
using BS.EAP.Account.Model;
using BS.EAP.BizMgt.Common;
using BS.EAP.BizCheck;
using BS.EAP.eForm.Frame;
using BS.EAP.eForm.Web;
using BS.EAP.eForm.Data;
using System.Globalization;
using Oracle.DataAccess.Client;
using Telerik.WebControls;

namespace BS.EAP.Portal.Business.DataQuery
{
    public partial class UpdateMTablesQCols : WebPage
    {
        private IDataBase IDB = DBFactory.GetDBInstance();
        private string appid = "__ALL";
        private string dtid = "__ALL";

        protected void Page_Load(object sender, EventArgs e)
        {
            //this.reportDate.InitDateType = (BS.EAP.BizMgt.Common.ReportDateType)Enum.Parse(typeof(BS.EAP.BizMgt.Common.ReportDateType), "月");

            if (this.CurrentApplication == null)
            {
                Response.Write(string.Format("<script>top.window.location=‘{0}‘</script>", FormsAuthentication.LoginUrl));
                return;
            }
            this.curBizType = this.CurrentApplication.APPID.ToString();
            this.HtmlCurBizType.Value = http://www.mamicode.com/this.curBizType;
            // oQuery = new QueryContext(this.curBizType);

            if (!this.IsPostBack)
            {
                InitPage();
            }
        }

        #region 初始化页面
        /// <summary>
        /// 初始化页面
        /// </summary>
        private void InitPage()
        {
            appid = "__ALL";
            dtid = "__ALL";
            BindDept();
            BindDataTable(appid);
            //根据oQuery绑定curBizType下的表
            BindGV(appid, dtid);

        }

        private void BindDept()
        {
            drpDept.Items.Clear();

            IDataBase oDB = DBFactory.GetDBInstance();
            string sql = "";
            sql = "select app.appid appid, app.appname appname  from sys_application app where app.appid in (‘969c388f-b0e2-4571-9876-4312b6a74a54‘, ‘3a448698-b695-4a5a-b405-df18f44da86f‘, ‘06f74f41-61ff-405a-8c86-bf8edacd945e‘)";

            DataTable dt = oDB.GetDataTable(sql);
            drpDept.Items.Add(new ListItem("全部", "__ALL"));
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    drpDept.Items.Add(new ListItem(dr["appname"].ToString(), dr["appid"].ToString()));
                }

            }
        }
        private void BindDataTable(string appid)
        {
            drpTable.Items.Clear();
            IDataBase oDB = DBFactory.GetDBInstance();
            string strSql = "";
            strSql = string.Format(@" select DTName, DTID from Basic_DataTable where  ((‘__ALL‘ =‘{0}‘ and
                                       appid in (‘969c388f-b0e2-4571-9876-4312b6a74a54‘,
                                                   ‘3a448698-b695-4a5a-b405-df18f44da86f‘,
                                                   ‘06f74f41-61ff-405a-8c86-bf8edacd945e‘)) or
                                       (‘__ALL‘ != ‘{0}‘ and
                                       appid in (‘{0}‘)))
                    and DTType in (‘c544a6c1-e921-448c-8880-0b22cf07cee4‘, ‘26a65507-9aec-481f-a5b6-4959a4cc4933‘) and dtid not in (‘35e05ad7-703b-4b8f-b7d1-02eae769dc15‘,
                   ‘56d300e1-f91f-44e5-936e-b6b445ea16f8‘,  ‘65f31d08-bc1f-43e4-883a-0cfecf4a8282‘, ‘2a6005b6-a513-4317-aaca-1049f83dceb1‘) order by sortno", appid);
            DataTable dt = oDB.GetDataTable(strSql);
            drpTable.Items.Add(new ListItem("全部", "__ALL"));
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                drpTable.Items.Add(new ListItem(dt.Rows[i]["DTNAME"].ToString(), dt.Rows[i]["DTID"].ToString()));
            }
        }

        private void BindGV(string appid, string dtid)
        {
            string strQuery = "";
            strQuery = string.Format(@"select app.appname appname,
                                       db.dtname   dtname,
                                       t.appid     appid,
                                       t.TABLENAME TABLENAME,
                                       t.colnameen ColNameEN,
                                       t.colnamecn ColNameCN
                                  from tablecolsquery t
                                  left join sys_application app
                                    on app.appid = t.appid
                                  left join basic_datatable db
                                    on upper(db.shortcode) = upper(t.tablename)
                                   and db.status = 0
                                 where ((‘__ALL‘ = ‘{0}‘ and
                                       t.appid in (‘969c388f-b0e2-4571-9876-4312b6a74a54‘,
                                                     ‘3a448698-b695-4a5a-b405-df18f44da86f‘,
                                                     ‘06f74f41-61ff-405a-8c86-bf8edacd945e‘)) or
                                       t.appid = ‘{0}‘)
                                   and (db.dtid = ‘{1}‘ or ‘__ALL‘ = ‘{1}‘)
                                 order by t.appid, db.sortno, t.TABLENAME, t.COLUMNID asc", appid, dtid);
            IDataBase idb = DBFactory.GetDBInstance();
            DataTable dtQueryResult = idb.GetDataTable(strQuery);
            Session.Remove("QueryResult");
            Session.Add("QueryResult", dtQueryResult);
            if (dtQueryResult.Rows.Count <= 0)
            {
                dtQueryResult = idb.GetDataTable("select ‘没有数据!‘ dtname from dual");
                this.gvMutiQueResult.Columns.Clear();
                this.gvMutiQueResult.Columns.Add(new BoundField() { DataField = "dtname", HeaderText = "表" });
                this.gvMutiQueResult.DataSource = dtQueryResult;
                this.gvMutiQueResult.DataBind();
            }
            else
            {

                this.gvMutiQueResult.Attributes.Clear();
                this.gvMutiQueResult.Attributes.Add("style", "word-break:keep-all");
                this.gvMutiQueResult.Columns.Clear();
                this.gvMutiQueResult.Columns.Add(new BoundField() { DataField = "appname", HeaderText = "业务" });
                this.gvMutiQueResult.Columns.Add(new BoundField() { DataField = "dtname", HeaderText = "表名" });
                this.gvMutiQueResult.Columns.Add(new BoundField() { DataField = "TABLENAME", HeaderText = "物理表" });
                this.gvMutiQueResult.Columns.Add(new BoundField() { DataField = "ColNameEN", HeaderText = "列名" });
                this.gvMutiQueResult.Columns.Add(new BoundField() { DataField = "ColNameCN", HeaderText = "Comments" });
                this.gvMutiQueResult.DataSource = dtQueryResult;
                this.gvMutiQueResult.DataBind();
            }

        }

        #endregion

        /// <summary>
        /// 存储过程(处理多表查询物理表列字段)
        /// </summary>
        /// <returns></returns>
        private void GetProcedureG(string Reportdate)
        {
            BS.EAP.DBAccess.IDataBase sDB = BS.EAP.DBAccess.DBFactory.GetDBInstance();
            Oracle.DataAccess.Client.OracleParameter[] dataParams = new Oracle.DataAccess.Client.OracleParameter[1];
            dataParams[0] = new Oracle.DataAccess.Client.OracleParameter("v_ReportDate", Oracle.DataAccess.Client.OracleDbType.Varchar2, ParameterDirection.Input);
            dataParams[0].Value = http://www.mamicode.com/Reportdate;
            sDB.GetDataTableBySPInTran("UPDATETABLECOLS", dataParams);
        }

        #region 事件

        protected void BtnUpdate_Click(object sender, EventArgs e)
        {
            //this.queryBtn.Attributes.Add("onclick", "return confirm(‘您确定要更新多表查询列吗?‘);");
            string Reportdate;
            Reportdate = System.DateTime.Now.ToString("yyyyMMdd");
            GetProcedureG(Reportdate);
            ClientScript.RegisterStartupScript(this.GetType(), "refresh", "<script language=\"javascript\">alert(‘更新成功!‘);</script>");
            appid = this.drpDept.SelectedValue.ToString();
            dtid = this.drpTable.SelectedValue.ToString();
            BindGV(appid, dtid);
        }
        protected void BtnQuery_Click(object sender, EventArgs e)
        {
            appid = this.drpDept.SelectedValue.ToString();
            dtid = this.drpTable.SelectedValue.ToString();
            BindGV(appid, dtid);
        }
        protected void gvMutiQueResult_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            appid = this.drpDept.SelectedValue.ToString();
            dtid = this.drpTable.SelectedValue.ToString();
            this.gvMutiQueResult.PageIndex = e.NewPageIndex;
            if (Session["QueryResult"] != null)
            {
                this.gvMutiQueResult.DataSource = (DataTable)Session["QueryResult"];
                this.gvMutiQueResult.DataBind();
            }
            else
            {
                BindGV(appid, dtid);
            }
        }

        protected void drpDept_SelectedIndexChanged(object sender, EventArgs e)
        {
            appid = this.drpDept.SelectedValue.ToString();
            dtid = "__ALL";
            BindDataTable(appid);
            BindGV(appid, dtid);
        }

        protected void drpTable_SelectedIndexChanged(object sender, EventArgs e)
        {
            appid = this.drpDept.SelectedValue.ToString();
            dtid = this.drpTable.SelectedValue.ToString();
            BindGV(appid, dtid);
        }

        public override void VerifyRenderingInServerForm(Control control)
        {
            //base.VerifyRenderingInServerForm(control);
        }
        #endregion


    }
}