basedata.aspx.cs

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

                db.Msgbox("超时，请重新登陆！","",this.Page);
                return;
            }
            this.clear_msg();
            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值
                if(val==""||val==null)//如果为空，不计
                {
                    continue;
                }
                ret.Add(str_id,val);//如果有值，加入集合
				
            }
            string sql=bdl.OccurSqlQuery(table,ret,ViewState["sql"].ToString(),this.Page);//产生有值列的sql
            //db.Msgbox(sql,"",this.Page);
            if(sql=="")
            {
                db.Msgbox("查询失败","操作",this.Page);
                return;
            }
            //sql=sql.Replace("[","").Replace("]","");
            ViewState["Quary_sql"]=sql;
            //sql=sql.Replace("[","").Replace("]","");
            this.gopage(1,ViewState["Quary_sql"].ToString());
            //            db.Msgbox(ViewState["Quary_sql"].ToString(),"",this.Page);
        }
        #endregion

        #region 更新

        #region 修改
        private void ibtn_save_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            if(this.Session["system"]==null)
            {
                db.Msgbox("超时，请重新登陆！","",this.Page);
                return;
            }
            this.clear_msg();
            //this.gopage(int.Parse(ViewState["page"].ToString()),ViewState["Quary_sql"].ToString());
            if(new BaseDataLogic(this.Session["system"].ToString(),
                this.Session["IP"].ToString(),
                this.Session["usr"].ToString(),
                this.Session["pwd"].ToString()).BaseDataUpdate(this.Page,ViewState["tablename"].ToString(),"E"))
            {
                this.show_succes("修改成功！");
            }
            else
            {
                db.Msgbox("修改错误!","操作结果",this.Page);
                return;
            }
            this.clear_msg();
            if(bdl.BaseDataTextBoxClear(this.Page,ViewState["tablename"].ToString().Trim(),false)==false)
            {
                db.Msgbox("清空失败！","操作",this.Page);
                return;
            }
            //this.gopage(dg.PageCount,ViewState["sql"].ToString().Trim());
            //			ViewState["Quary_sql"]=ViewState["sql"].ToString();
            this.gopage(int.Parse(ViewState["page"].ToString()),ViewState["Quary_sql"].ToString());
        }

        #endregion 

        #region 删除
        private void ibtn_del_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            if(this.Session["system"]==null)
            {
                db.Msgbox("超时，请重新登陆！","",this.Page);
                return;
            }
            this.clear_msg();
            if(new BaseDataLogic(this.Session["system"].ToString(),
                this.Session["IP"].ToString(),
                this.Session["usr"].ToString(),
                this.Session["pwd"].ToString()).BaseDataUpdate(this.Page,ViewState["tablename"].ToString(),"D"))
            {
                this.show_succes("成功删除！");
            }
            else
            {
                db.Msgbox("删除错误","操作结果",this.Page);
                return;
            }
            this.ibtn_clr_Click(null,null);
            //this.gopage(dg.PageCount,ViewState["sql"].ToString().Trim());
            //			ViewState["Quary_sql"]=ViewState["sql"].ToString()
            try
            {
                this.gopage(int.Parse(ViewState["page"].ToString()),ViewState["Quary_sql"].ToString());
            }
            catch
            {
                this.gopage(1,ViewState["Quary_sql"].ToString());
            }
        }
        #endregion
	
        #region 增加
        private void ibtn_add_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            if(this.Session["system"]==null)
            {
                db.Msgbox("超时，请重新登陆！","",this.Page);
                return;
            }
            this.clear_msg();
            if(new BaseDataLogic(this.Session["system"].ToString(),
                this.Session["IP"].ToString(),
                this.Session["usr"].ToString(),
                this.Session["pwd"].ToString()).BaseDataUpdate(this.Page,ViewState["tablename"].ToString(),"A"))
            {
                this.show_succes("新增成功！");
            }
            else
            {
                db.Msgbox("新增错误!","操作结果",this.Page);
                return;
            }
            this.clear_msg();
            if(bdl.BaseDataTextBoxClear(this.Page,ViewState["tablename"].ToString().Trim(),false)==false)
            {
                db.Msgbox("清空失败！","操作",this.Page);
                return;
            }
            this.gopage(dg.PageCount,ViewState["sql"].ToString().Trim());
            //			ViewState["Quary_sql"]=ViewState["sql"].ToString();
            this.gopage(int.Parse(ViewState["page"].ToString()),ViewState["Quary_sql"].ToString());
        }
        #endregion
        #endregion

        #region 打印
        private void ibtn_prt_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            this.clear_msg();
            if(this.Session["system"]==null)
            {
                db.Msgbox("超时，请重新登陆！","",this.Page);
                return;
            }
            string sql=ViewState["Quary_sql"].ToString();
            db.ExportExcel(this.dg,sql,"",this.Response);
        }
        #endregion

        #region 翻页
        private void imgbtn_first_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            this.gopage(1,ViewState["Quary_sql"].ToString());
            
        }
	

        private void imgbtn_pre_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            this.gopage(int.Parse(ViewState["page"].ToString())-1,ViewState["Quary_sql"].ToString(),false);
        }


        private void imgbtn_next_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            this.gopage(int.Parse(ViewState["page"].ToString())+1,ViewState["Quary_sql"].ToString(),false);
        }


        private void imgbtn_end_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            this.gopage(this.dg.PageCount,ViewState["Quary_sql"].ToString());
        }


        private void imgbtn_go_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            this.gopage(int.Parse(this.txt_page.Text.Trim()),ViewState["Quary_sql"].ToString());
        }
        #endregion
        #endregion

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


        bool gopage(int page,string sql,bool isload)
        {
            this.clear_msg();
            if(this.Session["system"]==null)
            {
                db.Msgbox("超时，请重新登陆！","",this.Page);
                return false;
            }
            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;
            }
            db.Url_Check(ref ds);
            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;
        }


        void clear_msg()
        {
            if(this.Session["system"]==null)
            {
                db.Msgbox("超时，请重新登陆！","",this.Page);
                return;
            }
            this.show_message.Text="";
            this.show_message.ForeColor=Color.Black;
            this.show_message.Visible=false;
        }


        void show_succes(string txt)
        {
            this.show_message.Text=txt;
            this.show_message.ForeColor=Color.Blue;
            this.show_message.Visible=true;
        }
        #endregion
    }
}