commfkeypage.aspx.cs

通过配置表中的各列支持绝大部分的基础数据

            }
            ht.Style["Align"]="center";
            this.Panel_Edit.Controls.Add(ht);
            ht.Visible =true;
            //结束
            ret=true;
            Panel_Edit.Visible =true;
            return ret;
        }
        #endregion

        #region 初始化dg界面
        public bool init_dg(string tablename)
        {
            this.Panel_DG.Visible =false;
            DataSet ds=new DataSet();
            string sql=sql=db.OccurSqlDisplayCn(ViewState["tablename"].ToString().Trim(),true,this.Page,0,true);
            if(ViewState["sql"]==null)
            {
                ViewState["sql"]=sql;
            }
            if(ViewState["Quary_sql"]==null)
            {
                ViewState["Quary_sql"]=ViewState["sql"].ToString();
            }
            ds=db.GetDataSet(ViewState["Quary_sql"].ToString(),this.Page);
            if(ds==null)
            {
                return false;
            }
            cdg.Init(dg,tablename,ds,true,column_cnt,this.Page);
            this.dg.DataSource=ds;
            dg.DataBind();
            ViewState["sql"]=sql;
            dg.Visible=true;
            this.Panel_DG.Visible =true;
            return true;
        }
        #endregion

        #endregion

        #region 事件
        #region 级联下拉框按钮事件
        void Relax_Click(object sender, System.EventArgs e)
        {
            //            Hashtable hs_par=new Hashtable();
            //            Hashtable hs_sub=new Hashtable();
            //            string str_par,str_sub;
            //            str_par=((DropDownList)sender).ID.Trim().Substring(5);//txt_ctrlname获得txt_后的字符串
            //            str_sub=db.Judge_Fkey_IsRec(ViewState["tablename"].ToString(),str_par);
            //            hs_par = db.GetColumnInfo(ViewState["tablename"].ToString(),str_par,this.Page);
            //            hs_sub = db.GetColumnInfo(ViewState["tablename"].ToString(),str_sub,this.Page);
            //            bool enblerelax=true;
            //            if(ViewState["act"].ToString()=="S")
            //            {
            //                enblerelax=false;
            //            }
            //            db.RelaxDdlProcess((DropDownList)sender,hs_par["FTABLE"].ToString(),(DropDownList)ctrl_list[int.Parse(hs_sub["COL_ID"].ToString())-1],hs_sub["FTABLE"].ToString(),((DropDownList)sender).SelectedValue.Trim(),enblerelax);
            //            ViewState["act"]="S";
            if(!this.IsPostBack)//不是在页面重载时
            {
                ddl_process((DropDownList)sender,true);
            }
            else
            {
                ddl_process((DropDownList)sender,false);
            }
        }

        void ddl_process(DropDownList sender,bool auto)
        {
            Hashtable hs_par=new Hashtable();
            Hashtable hs_sub=new Hashtable();
            string str_par,str_sub;
            str_par=((DropDownList)sender).ID.Trim().Substring(5);//txt_ctrlname获得txt_后的字符串
            string[] arr_sub;
            arr_sub=db.Judge_Fkey_IsRec(ViewState["tablename"].ToString(),str_par);
            for(int i=0;i<arr_sub.Length;i++)
            {
                str_sub=arr_sub[i];
                hs_par = db.GetColumnInfo(ViewState["tablename"].ToString(),str_par,this.Page);
                hs_sub = db.GetColumnInfo(ViewState["tablename"].ToString(),str_sub,this.Page);
                bool enblerelax=true;
                //            if(auto==true)
                //            {
                //                enblerelax=true;
                //            }
                //            else
                //            {
                //                 enblerelax=false;
                //            }
                int old_index=0;
                if(((DropDownList)this.Page.FindControl("edit_"+hs_sub["NAME_EN"].ToString())).SelectedIndex>=0)
                {
                    old_index=((DropDownList)this.Page.FindControl("edit_"+hs_sub["NAME_EN"].ToString())).SelectedIndex;
                }
                db.RelaxDdlProcess((DropDownList)sender,hs_par["FTABLE"].ToString(),(DropDownList)ctrl_list[int.Parse(hs_sub["COL_ID"].ToString())-1],hs_sub["FTABLE"].ToString(),((DropDownList)sender).SelectedValue.Trim(),enblerelax);
                //            ViewState["act"]="S";
                try
                {
                    ((DropDownList)this.Page.FindControl("edit_"+hs_sub["NAME_EN"].ToString())).SelectedIndex=old_index;
                }
                catch
                {
                }
            }
        }
        #endregion

        #region 清除
        private void ibtn_clr_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            if(this.Session["system"]==null)
            {
                db.Msgbox("非法登陆!","警告",this.Page);
                this.Dispose();
            }
            if(bdl.BaseDataTextBoxClear(this.Page,ViewState["tablename"].ToString().Trim())==false)
            {
                db.Msgbox("清空失败！","操作",this.Page);
                return;
            }
            this.Panel_Edit.Visible =true;
            this.hid_act.Text="C";
            ViewState["Act"]="C";
            ViewState["Quary_sql"]=ViewState["sql"].ToString();
        }

        #endregion

        #region 查询
        private void ibtn_qry_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            if(this.Session["system"]==null)
            {
                db.Msgbox("非法登陆!","警告",this.Page);
                this.Dispose();
            }
            ViewState["act"]="Q";
            string table=ViewState["tablename"].ToString().Trim();
            ArrayList al=new ArrayList();
            Hashtable ret=new Hashtable();//edit_panel中有值元素的集合
            al=db.GetColumnInfo(table,this.Page);//获得列信息
            for(int i=0;i<al.Count;i++)//遍历页面中所有edit_元素
            {
                string str_id=((Hashtable)al[i])["NAME_EN"].ToString().Trim();//获得字段名
                string val=db.GetControlValue(this.Page,"edit_"+str_id); //调用GetControlValue获得该字段在edit_panel值
                //                string val=db.GetControlValue(this.Page,BaseData.ctrl_list,"edit_"+str_id); //改从空间列表中找 2006-04-01
                if(val==""||val==null)//如果为空，不计
                {
                    continue;
                }
                ret.Add(str_id,val);//如果有值，加入集合
				
            }
            string sql=bdl.OccurSqlQuery(table,ret,ViewState["sql"].ToString(),this.Page);//产生有值列的sql
            if(sql=="")
            {
                db.Msgbox("查询失败","操作",this.Page);
                return;
            }
            //sql=sql.Replace("[","").Replace("]","");
            ViewState["Quary_sql"]=sql;
            //sql=sql.Replace("[","").Replace("]","");
            this.dg.AllowPaging=false;
            this.dg.DataSource =db.GetDataSet(sql);
            this.dg.DataBind();
            this.dg.Visible =true;
        }
        #endregion

        #endregion

        #region 自定义函数
        bool gopage(int page,string sql)
        {
            return this.gopage(page,sql,true);
        }

        

     


        bool gopage(int page,string sql,bool isload)
        {
            if(page<1)
            {
                page=1;
            }
            //            if(page>dg.PageCount)
            //            {
            //                page=dg.PageCount;
            //            }
            DataSet ds=new DataSet();
            ds=db.GetDataSet(sql,this.Page);
            if(ds==null)
            {
                return false;
            }
            //            dg.DataSource =ds;
            //            dg.CurrentPageIndex =page-1;
            //            dg.DataBind();
            //            cdg.Init(dg,ViewState["tablename"].ToString().Trim(),ds,this.Page);
            //            this.lbl_currpage.Text =page.ToString();
            //			if(isload==false)
            //			{
            ViewState["page"]=page;
            //			}
            //            this.lbl_pagecnt.Text =this.dg.PageCount.ToString();
            
            return true;
        }
        #endregion

        #region 获得/设置页面上各个控件的值
        void GetPageData()
        {
            ArrayList al=new ArrayList();
            for(int i=0;i<this.ctrl_list.Count;i++)
            {
                string val=db.GetControlValue(this.Page,((System.Web.UI.Control)this.ctrl_list[i]).ID);
                al.Add(val);
            }
            ViewState["ContralsValue"]=al;
        }

        void SetPageData()
        {
            if(ViewState["ContralVal"]==null)
            {
                return;
            }
            ArrayList cv_al=new ArrayList();
            cv_al=(ArrayList)ViewState["ContralVal"];
        }
        #endregion 

      

        private void dg_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            ArrayList al=new ArrayList();
            int refcol=0;
            al=db.GetColumnInfo(Request["tablename"].Trim(),this.Page);
            for(int i=0;i<al.Count;i++)
            {
                if(((Hashtable)al[i])["NAME_EN"].ToString().Trim()==this.Request["col"].Trim())
                {
                    refcol=int.Parse(((Hashtable)al[i])["COL_ID"].ToString())-1;
                }
            }
            string refval;
            refval=e.Item.Cells[refcol].Text.Trim();
            
            if(refval.Trim()=="")
            {
                refval=((System.Web.UI.WebControls.LinkButton)e.Item.Cells[refcol].Controls[0]).Text.Trim();
            }
            db.Close_PopWindow(refval+","+((System.Web.UI.WebControls.LinkButton)e.Item.Cells[1].Controls[0]).Text.Trim(),this.Page);
        }
	}
}