C# HyoaClass.Hyoa_tableconfig类代码示例

 protected void btnLogin_Click(object sender, EventArgs e)
 {
     HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
     HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
     DataTable dt = Hyoa_tableconfig.GetTables();
     string sql = "";
     if (dt.Rows.Count > 0)
     {
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             //增加字段,先删除再添加
             sql = "ALTER TABLE hyc_" + dt.Rows[i]["ID"].ToString();
             sql += " ADD hy_clrylist text ";
             Hyoa_global.ExcuteSQL(sql);
             sql = "ALTER TABLE hyc_" + dt.Rows[i]["ID"].ToString();
             sql += " ADD hy_cyrylist text ";
             //Hyoa_global.ExcuteSQL(sql);   //第一次要执行一下添加字段
             //处理数据
             sql = "select * from hyc_" + dt.Rows[i]["ID"].ToString();
             DataTable dt2 = Hyoa_global.GetDataTable(sql);
             if (dt2.Rows.Count > 0)
             {
                 for (int j = 0; j < dt2.Rows.Count; j++)
                 {
                     //先置为,
                     sql = "update hyc_" + dt.Rows[i]["ID"].ToString() + " set hy_clrylist=',',hy_cyrylist=',' where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
                     Hyoa_global.ExcuteSQL(sql);
                     //再根据cl表更新
                     sql = "select * from hyp_flowhistoryinfo_cl where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
                     DataTable dt3 = Hyoa_global.GetDataTable(sql);
                     if (dt3.Rows.Count > 0)
                     {
                         for (int m = 0; m < dt3.Rows.Count; m++)
                         {
                             //得到初始值
                             sql = "select * from hyc_" + dt.Rows[i]["ID"].ToString() + " where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
                             DataTable dt4 = Hyoa_global.GetDataTable(sql);
                             string ls_value = dt4.Rows[0]["hy_clrylist"].ToString() + dt3.Rows[m]["hy_clrid"].ToString() + ",";
                             sql = "update hyc_" + dt.Rows[i]["ID"].ToString() + " set hy_clrylist='" + ls_value + "',hy_cyrylist=',' where DOCID='" + dt2.Rows[j]["DOCID"].ToString() + "'";
                             //Response.Write(sql);
                             Hyoa_global.ExcuteSQL(sql);
                         }
                     }
                 }
             }
         }
     }
     Response.Write("更新完成");
 }

 protected void btndelinfo_Click(object sender, EventArgs e)
 {
     HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
     String[] v_uids = this.txtuids.Value.Split(',');
     for (var i = 0; i < v_uids.Length; i++)
     {
         if (v_uids[i] != "")
         {
             Hyoa_tableconfig.ID = v_uids[i];
             Hyoa_tableconfig.Delete();
         }
     }
     this.txtuids.Value = "";
     //DataPlay(1);
     DataPlay(System.Int32.Parse(this.curpage.Text));
 }

 protected void btndelinfo_Click(object sender, EventArgs e)
 {
     HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
     HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
     String[] v_uids = this.txtuids.Value.Split(',');
     for (var i = 0; i < v_uids.Length; i++)
     {
         if (v_uids[i] != "")
         {
             //先删除SQL中的表
             DelSQLTableByTableid(v_uids[i]);
             //删除配置表
             Hyoa_tableconfig.ID = v_uids[i];
             Hyoa_tableconfig.Delete();
             //删除表字段
             string ls_sql = "delete from hyt_flowfield where hy_tableid='"+v_uids[i]+"'";
             Hyoa_global.ExcuteSQL_BASE(ls_sql);
         }
     }
     this.txtuids.Value = "";
     //DataPlay(1);
     DataPlay(System.Int32.Parse(this.curpage.Text));
 }

 protected void ddlmudelid_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (this.ddlmudelid.SelectedIndex != 0)
     {
         this.ddltableid.Items.Clear();
         //根据模块ID得到表单ID
         HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
         DataTable dt = Hyoa_tableconfig.GetTablesbymudelid(this.ddlmudelid.SelectedValue);
         if (dt.Rows.Count > 0)
         {
             for (var i = 0; i < dt.Rows.Count; i++)
             {
                 this.ddltableid.Items.Insert(i, new ListItem(dt.Rows[i]["hy_name"].ToString(), dt.Rows[i]["ID"].ToString()));
             }
             this.ddltableid.Items.Insert(0, new ListItem("--请选择--", ""));
             this.ddltableid.Attributes.Add("onchange ", "mudelidonchang() ");
         }
     }
     else
     {
         //清空
         this.ddltableid.Items.Clear();
     }
 }

//.........这里部分代码省略.........
            this.ddlmudelid.Items.Insert(0, "--请选择--");
            this.ddlmudelid.SelectedIndex = 0;
        }

        //加载权限
        HyoaClass.Hyoa_role Hyoa_role = new HyoaClass.Hyoa_role();
        DataTable dtrole = Hyoa_role.Getroles();
        if (dtrole.Rows.Count > 0)
        {
            this.ddlrole.DataSource = dtrole;
            this.ddlrole.DataTextField = "hy_rolename";
            this.ddlrole.DataValueField = "hy_roleid";
            this.ddlrole.DataBind();
            this.ddlrole.Items.Insert(0, "--请选择--");
            this.ddlrole.SelectedIndex = 0;
        }

        this.ddlisenabled.Items.Insert(0, "是");
        this.ddlisenabled.Items.Insert(1, "否");

        if (this.Request.QueryString["op"] != null)
        {
            this.txtop.Value = this.Request.QueryString["op"].ToString();           //新增还是修改

            //判断当前用户是否有保存的权限
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
            if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
            {
                this.btn_submit.Visible = true; //保存
            }
            else
            {
                this.btn_submit.Visible = false; //保存
            }

            HyoaClass.Hyoa_ml Hyoa_ml = new HyoaClass.Hyoa_ml();

            //旧文档
            if (this.Request.QueryString["op"] == "modify")
            {
                if (this.Request.QueryString["id"] != null)
                {
                    //根据id得到信息
                    this.lblid.Value = this.Request.QueryString["id"].ToString();
                    this.txtMLID.Value = this.Request.QueryString["id"].ToString();
                    DataTable dt = Hyoa_ml.Getml(this.lblid.Value);
                    if (dt.Rows.Count > 0)
                    {
                        this.txtname.Value = dt.Rows[0]["MLName"].ToString();
                        this.txtlink.Value = dt.Rows[0]["hy_link"].ToString();
                        this.ddltarget.SelectedValue = dt.Rows[0]["hy_target"].ToString();
                        this.ddlrole.SelectedValue = dt.Rows[0]["hy_role"].ToString();
                        this.txtsort.Value = dt.Rows[0]["hy_sort"].ToString();
                        //模块信息定位
                        for (var i = 0; i < this.ddlmudelid.Items.Count; i++)
                        {
                            if (this.ddlmudelid.Items[i].Value == dt.Rows[0]["hy_mudelid"].ToString())
                            {
                                this.ddlmudelid.SelectedIndex = i;
                            }
                        }
                        //一级目录定位
                        for (var i = 0; i < this.ddlfirstmlid.Items.Count; i++)
                        {
                            if (this.ddlfirstmlid.Items[i].Value == dt.Rows[0]["MLID"].ToString().Substring(0,3))
                            {
                                this.ddlfirstmlid.SelectedIndex = i;
                                this.ddlfirstmlname.SelectedIndex = i;
                            }
                        }

                        if (dt.Rows[0]["hy_ifqy"].ToString() == "是")
                            this.ddlisenabled.SelectedIndex = 0;
                        else
                            this.ddlisenabled.SelectedIndex = 1;

                        //根据模块信息得到对应的选择表单值
                        if (dt.Rows[0]["hy_tableid"] != "" && dt.Rows[0]["hy_tableid"] != null)
                        {
                            this.ddltableid.Items.Clear();
                            //根据模块ID得到表单ID
                            HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
                            DataTable dtgettableid = Hyoa_tableconfig.GetTablesbymudelid(dt.Rows[0]["hy_mudelid"].ToString());
                            if (dtgettableid.Rows.Count > 0)
                            {
                                for (var i = 0; i < dtgettableid.Rows.Count; i++)
                                {
                                    this.ddltableid.Items.Insert(i, new ListItem(dtgettableid.Rows[i]["hy_name"].ToString(), dtgettableid.Rows[i]["ID"].ToString()));
                                }
                                this.ddltableid.Items.Insert(0, new ListItem("--请选择--", ""));
                                //定位
                                this.ddltableid.SelectedValue = dt.Rows[0]["hy_tableid"].ToString();
                            }
                        }
                    }
                    dt.Clear();
                }
            }
        }
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (this.Session["hyuid"].ToString() == "")
            this.Response.Redirect("login.aspx");

        if (!this.IsPostBack)
        {
            //当前用户信息
            this.txtcurloginuserid.Text = Session["hyuid"].ToString();
            this.txtcurloginusername.Text = Session["hyuname"].ToString();
            this.txtcurlogindeptid.Text = Session["hydeptid"].ToString();
            this.txtcurlogindeptname.Text = Session["hydeptname"].ToString();

            if (this.Request.QueryString["pop"] != null)
            {
                string ls_pop = "";
                ls_pop = this.Request.QueryString["pop"].ToString();   //是否弹出窗口
                if (ls_pop.Contains(","))
                    ls_pop = ls_pop.Substring(0, ls_pop.IndexOf(","));

                this.txtifpop.Value = ls_pop;
            }
            if (this.Request.QueryString["mid"] != null)
            {
                string ls_mid = "";
                ls_mid = this.Request.QueryString["mid"].ToString();
                if (ls_mid.Contains(","))
                    ls_mid = ls_mid.Substring(0, ls_mid.IndexOf(","));

                this.hy_mudelid.Text = ls_mid;
            }
            if (this.Request.QueryString["tableid"] != null)
            {
                string ls_tableid = "";
                ls_tableid = this.Request.QueryString["tableid"].ToString();
                if (ls_tableid.Contains(","))
                    ls_tableid = ls_tableid.Substring(0, ls_tableid.IndexOf(","));

                this.hy_tableid.Text = ls_tableid;

                //得到表单名称
                HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
                DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.hy_tableid.Text);
                if (dt_tableconfig.Rows.Count > 0)
                    this.lbltablename.Text = dt_tableconfig.Rows[0]["hy_name"].ToString();

                this.txttablerole.Value = dt_tableconfig.Rows[0]["hy_tablerole"].ToString();
                dt_tableconfig.Clear();
            }
            if (this.Request.QueryString["listid"] != null)
            {
                string ls_listid = "";
                ls_listid = this.Request.QueryString["listid"].ToString();
                if (ls_listid.Contains(","))
                    ls_listid = ls_listid.Substring(0, ls_listid.IndexOf(","));

                this.txtlistid.Text = ls_listid;
            }
            if (this.Request.QueryString["url"] != null)
            {
                //this.txturl.Value = this.Request.QueryString["url"].ToString();     //返回URL
                string ls_url = this.Request.Url.ToString();
                this.txturl.Value = ls_url.Substring(ls_url.LastIndexOf("url=") + 4, ls_url.Length - ls_url.LastIndexOf("url=") - 4);     //返回URL
            }
            else
            {
                //没有URL值的保存后进入列表中,即/list.aspx?mid=clgl&tableid=8b10b316-98d6-4a50-bc15-52745bb119bb
                this.txturl.Value = "list.aspx?mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&listid=" + this.txtlistid.Text;
                getreturnurl(); //特殊返回地址
            }
        }
        DataPlay();
        //add by wjs 20141103 start 给合同加matherid
        if (this.Request.QueryString["motherid"] != null)
        {
            this.hy_motherid.Text = this.Request.QueryString["motherid"].ToString();
        }
        // add by wjs 20141112 在付款流程结束时将提交改为付款
        //最后一环节
        if (this.txtiflasttache.Value == "1" && this.hy_tableid.Text == "Tablefpbd")
        {
            this.btn_nextstep.Value = "付款";
        }
    }

    //加载主表单    Written by xf 20110515
    private void DataPlay()
    {
        txtsavefields.Text = "";
        txtsavefields_sx.Text = "";

        if (this.Request.QueryString["op"] != null)
        {
            this.txtop.Value = this.Request.QueryString["op"].ToString();           //新增还是修改
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();

            #region 新文档
            if (this.Request.QueryString["op"] == "add")
            {
                this.td_ydry.Visible = false; //新文档时，“已读人员”按钮隐藏
                this.txtiffirsttache.Value = "1"; //新文档时，“是否第一环节”置为1

                //文档ID（保存POST到当前页面时，DOCID不重新加载）
                if (!this.IsPostBack)
                {
                    this.txtdocid.Value = Hyoa_global.GetRandom();
                    this.hy_djsj.Text = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                }
                this.hy_djrid.Text = this.Session["hyuid"].ToString();
                this.hy_djrname.Text = this.Session["hyuname"].ToString();
                this.hy_djrbmid.Text = this.Session["hydeptid"].ToString();
                this.hy_djrbmname.Text = this.Session["hydeptname"].ToString();

                HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
                DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
                if (dt_tableconfig.Rows.Count > 0)
                {
                    if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是")
                    {
                        //根据模块ID得到流程信息
                        HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
                        DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text);
                        if (dt.Rows.Count > 0)
                        {
                            //判断当前用户是否有登记权限
                            //得到第一环节ID
                            string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString());
                            if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString()))
                            {
                                this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
                                this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
                                this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString();
                                this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString();
                                this.hy_curclrid.Text = this.Session["hyuid"].ToString();
                                this.hy_curclrname.Text = this.Session["hyuname"].ToString();
                                this.lblcurtachenameshow.Text = dt.Rows[0]["hy_nexttachename"].ToString();
                                this.txtSystemClRight.Value = "1";

                                //-------条件流程start-------
                                HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
                                DataTable dt_firsttache = Hyoa_flowtache.Getflowtachebyflowidtacheid(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid);
                                if (dt_firsttache.Rows.Count > 0)
                                {
                                    if (dt_firsttache.Rows[0]["hy_enablecondition"].ToString() == "是")
                                        ConditionFlow(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid);
                                }
                                //-------条件流程end-------
                            }
                            else
                            {
                                if (this.txtifpop.Value == "")
                                {
                                    this.td_submit.Visible = false;
                                    this.td_nextstep.Visible = false;
                                    Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');window.location='" + this.txturl.Value + "';</script>");
                                    return;
                                }
                                else
                                {
                                    this.td_submit.Visible = false;
                                    this.td_nextstep.Visible = false;
                                    Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');self.close();</script>");
                                    return;
                                }
                            }
                        }
                        dt.Clear();
                        this.td_nextstep.Visible = true; //提交
                    }
                }
                //加载页面
                if (this.hy_tableid.Text == "Tablefpbd")
                {
                        this.td_dc.Visible = true;
                }
                GetMainTableHtml("0", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
                this.td_submit.Visible = true; //保存
                hywebopen_newdoc();     //新文档OPEN时的特殊处理

            }
            #endregion

            #region 旧文档
            if (this.Request.QueryString["op"] == "modify")
            {
//.........这里部分代码省略.........

    //打开文档显示
    private void DataPlay()
    {
        HyoaClass.DAO db = new HyoaClass.DAO();
        StringBuilder sb = new StringBuilder();

        string ls_flag = "0";  //是否为授权人员
        string ls_uid = this.Session["hyuid"].ToString();
        HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
        if (Hyoa_global.isHaveRole("Role_search", ls_uid))
        {
            ls_flag = "1";
        }
        int ls_Container = 1;
        string ls_docids = "";
        string sql1 = "";
        //查询关键字按|分割
        string[] lv_key = ls_keywords.Split('|');

        //读取待查模块的字段
        if (ls_Modelid != "--请选择--")
        {
            sql1 = "select *,(select hy_mudelname from hyt_mudel where hy_mudelid=a.hy_mudelid) as hy_name from hyt_searchconfig a where hy_ifsearch='是' and hy_mudelid='" + ls_Modelid + "'";
            sql1 += " order by hy_sort ";
        }
        else
        {
            sql1 = "select *,(select hy_mudelname from hyt_mudel where hy_mudelid=a.hy_mudelid) as hy_name from hyt_searchconfig a where hy_ifsearch='是'";
            sql1 += " order by hy_sort ";
        }
        //Response.Write(sql1);
        //return;

        DataTable dt = db.GetDataTable(sql1);
        if (dt.Rows.Count > 0)
        {
            //循环查询模块
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string sql2 = "";
                string ls_or = "";
                string ls_mid = dt.Rows[i]["hy_mudelid"].ToString();
                string ls_mname = dt.Rows[i]["hy_name"].ToString();
                string ls_tid = dt.Rows[i]["hy_tableid"].ToString();
                string ls_cid = dt.Rows[i]["hy_columnshowid"].ToString();  //hy_field1,hy_bt,hy_content1
                string ls_xsid = dt.Rows[i]["hy_xszdid"].ToString();
                string ls_kckryid = "+" + dt.Rows[i]["hy_kckryid"].ToString() + "+";

                //根据表单ID得到表单信息
                string ls_tname = "", ls_ifflow = "", ls_ifgk = "", ls_ifxssy = "";
                HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
                DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(ls_tid);
                if (dt_tableconfig.Rows.Count > 0)
                {
                    ls_tname = dt_tableconfig.Rows[0]["hy_name"].ToString(); //表单名称
                    ls_ifflow = dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString();//是否为流程表单
                    ls_ifgk = dt_tableconfig.Rows[0]["hy_ispuballByflowYB"].ToString();  //流程结束后是否公开
                    ls_ifxssy = dt_tableconfig.Rows[0]["hy_ifdisplayall"].ToString();  //是否显示所有记录
                }
                dt_tableconfig.Clear();

                if (ls_flag == "1")
                {
                    //授权查看所有人员
                    sql2 = "select * from hyp_flowmain a where 1=1 ";
                }
                else
                {
                    //某模块是否授权为可查看人员
                    if (ls_kckryid.IndexOf("+" + ls_uid + "+") >= 0)
                    {
                        sql2 = "select * from hyp_flowmain a where 1=1 ";
                    }
                    else
                    {
                        //未授权人员根据表单配置判断模块的数据显示情况
                        if (ls_ifflow == "是")
                        {
                            sql2 = "select * from hyp_flowmain a,hyp_flowhistoryinfo_cl b  where a.DOCID=b.DOCID ";

                            //流程模块
                            if (ls_ifgk == "是")
                            {
                                //流程结束后公开
                                sql2 += " and (','+b.hy_clrid+',' like '%," + ls_uid + ",%' or ','+b.hy_cyrid+',' like '%," + ls_uid + ",%' or a.hy_curtacheid='**' ) ";
                            }
                            if (ls_ifgk == "否")
                            {
                                //流程结束后不公开
                                sql2 += " and (','+b.hy_clrid+',' like '%," + ls_uid + ",%' or ','+b.hy_cyrid+',' like '%," + ls_uid + ",%') ";
                            }
                        }
                        if (ls_ifflow == "否")
                        {
                            //非流程模块
                            if (ls_ifxssy == "是")
                            {
                                //非流程显示所有记录
                                sql2 = "select * from hyp_flowmain a where 1=1 ";
                            }
//.........这里部分代码省略.........

    protected void Page_Load(object sender, EventArgs e)
    {
        if (this.Session["hyuid"].ToString() == "")
            this.Response.Redirect("login.aspx");

        if (!this.IsPostBack)
        {
            //当前用户信息
            this.txtcurloginuserid.Text = Session["hyuid"].ToString();
            this.txtcurloginusername.Text = Session["hyuname"].ToString();
            this.txtcurlogindeptid.Text = Session["hydeptid"].ToString();
            this.txtcurlogindeptname.Text = Session["hydeptname"].ToString();

            if (this.Request.QueryString["pop"] != null)
            {
                string ls_pop = "";
                ls_pop = this.Request.QueryString["pop"].ToString();   //是否弹出窗口
                if (ls_pop.Contains(","))
                    ls_pop = ls_pop.Substring(0, ls_pop.IndexOf(","));

                this.txtifpop.Value = ls_pop;
            }
            if (this.Request.QueryString["mid"] != null)
            {
                string ls_mid = "";
                ls_mid = this.Request.QueryString["mid"].ToString();
                if (ls_mid.Contains(","))
                    ls_mid = ls_mid.Substring(0, ls_mid.IndexOf(","));

                this.hy_mudelid.Text = ls_mid;
            }
            if (this.Request.QueryString["tableid"] != null)
            {
                string ls_tableid = "";
                ls_tableid = this.Request.QueryString["tableid"].ToString();
                if (ls_tableid.Contains(","))
                    ls_tableid = ls_tableid.Substring(0, ls_tableid.IndexOf(","));

                this.hy_tableid.Text = ls_tableid;

                //得到表单名称
                HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
                DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.hy_tableid.Text);
                if (dt_tableconfig.Rows.Count > 0)
                    this.lbltablename.Text = dt_tableconfig.Rows[0]["hy_name"].ToString();

                //是否为流程表单
                this.txtifhaveflow.Value = dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString();
                this.txttablerole.Value = dt_tableconfig.Rows[0]["hy_tablerole"].ToString();
                dt_tableconfig.Clear();
            }
            if (this.Request.QueryString["listid"] != null)
            {
                string ls_listid = "";
                ls_listid = this.Request.QueryString["listid"].ToString();
                if (ls_listid.Contains(","))
                    ls_listid = ls_listid.Substring(0, ls_listid.IndexOf(","));

                this.txtlistid.Text = ls_listid;
            }
            if (this.Request.QueryString["url"] != null)
            {
                //this.txturl.Value = this.Request.QueryString["url"].ToString();     //返回URL
                string ls_url = this.Request.Url.ToString();
                this.txturl.Value = ls_url.Substring(ls_url.LastIndexOf("url=") + 4, ls_url.Length - ls_url.LastIndexOf("url=") - 4);     //返回URL
            }
            else
            {
                //没有URL值的保存后进入列表中,即/list.aspx?mid=clgl&tableid=8b10b316-98d6-4a50-bc15-52745bb119bb
                this.txturl.Value = "list.aspx?mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&listid=" + this.txtlistid.Text;
            }
        }
        DataPlay();
    }

    //保存
    protected void Button_Save_Click(object sender, EventArgs e)
    {
        if (this.Session["hyuid"].ToString() == "")
            this.Response.Redirect("../login.aspx");

        string ls_tip = "保存成功！";

        HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
        HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
        HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();

        //判断目的表单ID是否重复
        DataTable dt_table = Hyoa_tableconfig.GetTable(txttableidbymd.Text);
        if (dt_table.Rows.Count > 0)
        {
            Response.Write("<script>alert('目的表单ID已存在！');</script>");
            return;
        }

        //插入TABLE配置
        DataTable tableconfigdt = Hyoa_tableconfig.GetTablesbymudelid(this.lbmudelidbysource.Text);
        if (tableconfigdt.Rows.Count > 0)
        {
            Hyoa_tableconfig.ID = txttableidbymd.Text;
            Hyoa_tableconfig.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
            Hyoa_tableconfig.hy_name = this.txttablenamebymd.Text;
            Hyoa_tableconfig.hy_onload = tableconfigdt.Rows[0]["hy_onload"].ToString();
            Hyoa_tableconfig.hy_sort = float.Parse(this.txttablesortbymd.Text);
            Hyoa_tableconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
            Hyoa_tableconfig.hy_ifdisplayall = tableconfigdt.Rows[0]["hy_ifdisplayall"].ToString();
            Hyoa_tableconfig.hy_ispuballByflowYB = tableconfigdt.Rows[0]["hy_ispuballByflowYB"].ToString();
            Hyoa_tableconfig.hy_tablerole = tableconfigdt.Rows[0]["hy_tablerole"].ToString();
            Hyoa_tableconfig.hy_ifcomment = tableconfigdt.Rows[0]["hy_ifcomment"].ToString();
            Hyoa_tableconfig.hy_colnum = float.Parse(tableconfigdt.Rows[0]["hy_colnum"].ToString());
            Hyoa_tableconfig.hy_field1 = tableconfigdt.Rows[0]["hy_field1"].ToString();
            Hyoa_tableconfig.hy_field2 = tableconfigdt.Rows[0]["hy_field2"].ToString();
            Hyoa_tableconfig.hy_field3 = tableconfigdt.Rows[0]["hy_field3"].ToString();
            Hyoa_tableconfig.hy_field4 = tableconfigdt.Rows[0]["hy_field4"].ToString();
            Hyoa_tableconfig.hy_field5 = tableconfigdt.Rows[0]["hy_field5"].ToString();
            Hyoa_tableconfig.Insert();
        }

        //插入FIELD配置
        int i;
        DataTable flowfielddt = Hyoa_flowfield.Getflowfieldsbytableid(this.lbtableidbysorce.Text);
        if (flowfielddt.Rows.Count > 0)
        {
            for (i = 0; i < flowfielddt.Rows.Count; i++)
            {
                Hyoa_flowfield.ID = Hyoa_global.GetRandom();
                Hyoa_flowfield.hy_tableid = txttableidbymd.Text;
                Hyoa_flowfield.hy_mudelid = this.ddlmudelidbymd.SelectedValue;
                Hyoa_flowfield.hy_flowid = this.txtflowidbymd.Text;
                Hyoa_flowfield.hy_fieldid = flowfielddt.Rows[i]["hy_fieldid"].ToString();
                Hyoa_flowfield.hy_fieldname = flowfielddt.Rows[i]["hy_fieldname"].ToString();
                Hyoa_flowfield.hy_fieldtype = flowfielddt.Rows[i]["hy_fieldtype"].ToString();
                Hyoa_flowfield.hy_ifreadonly = flowfielddt.Rows[i]["hy_ifreadonly"].ToString();
                Hyoa_flowfield.hy_defaultvaluetype = System.Int32.Parse(flowfielddt.Rows[i]["hy_defaultvaluetype"].ToString());
                Hyoa_flowfield.hy_defaultvalue = flowfielddt.Rows[i]["hy_defaultvalue"].ToString();
                Hyoa_flowfield.hy_optiontype = System.Int32.Parse(flowfielddt.Rows[i]["hy_optiontype"].ToString());
                Hyoa_flowfield.hy_options = flowfielddt.Rows[i]["hy_options"].ToString();
                Hyoa_flowfield.hy_onclick = flowfielddt.Rows[i]["hy_onclick"].ToString();
                Hyoa_flowfield.hy_ondblclick = flowfielddt.Rows[i]["hy_ondblclick"].ToString();
                Hyoa_flowfield.hy_onchange = flowfielddt.Rows[i]["hy_onchange"].ToString();
                Hyoa_flowfield.hy_onkeydown = flowfielddt.Rows[i]["hy_onkeydown"].ToString();
                Hyoa_flowfield.hy_onkeyup = flowfielddt.Rows[i]["hy_onkeyup"].ToString();
                Hyoa_flowfield.hy_sqlfield = flowfielddt.Rows[i]["hy_sqlfield"].ToString();
                Hyoa_flowfield.hy_class = flowfielddt.Rows[i]["hy_class"].ToString();
                Hyoa_flowfield.hy_width = flowfielddt.Rows[i]["hy_width"].ToString();
                Hyoa_flowfield.hy_height = flowfielddt.Rows[i]["hy_height"].ToString();
                Hyoa_flowfield.hy_tdnums = System.Int32.Parse(flowfielddt.Rows[i]["hy_tdnums"].ToString());
                Hyoa_flowfield.hy_config = flowfielddt.Rows[i]["hy_config"].ToString();
                Hyoa_flowfield.hy_sort = float.Parse(flowfielddt.Rows[i]["hy_sort"].ToString());
                Hyoa_flowfield.hy_wordlimit = System.Int32.Parse(flowfielddt.Rows[i]["hy_wordlimit"].ToString());
                Hyoa_flowfield.hy_required = flowfielddt.Rows[i]["hy_required"].ToString();
                Hyoa_flowfield.hy_align = flowfielddt.Rows[i]["hy_align"].ToString();
                Hyoa_flowfield.hy_ifhiddle = flowfielddt.Rows[i]["hy_ifhiddle"].ToString();
                Hyoa_flowfield.hy_ifdbsybt = flowfielddt.Rows[i]["hy_ifdbsybt"].ToString();
                Hyoa_flowfield.hy_field1 = flowfielddt.Rows[i]["hy_field1"].ToString();
                Hyoa_flowfield.hy_field2 = flowfielddt.Rows[i]["hy_field2"].ToString();
                Hyoa_flowfield.hy_field3 = flowfielddt.Rows[i]["hy_field3"].ToString();
                Hyoa_flowfield.hy_field4 = flowfielddt.Rows[i]["hy_field4"].ToString();
                Hyoa_flowfield.hy_field5 = flowfielddt.Rows[i]["hy_field5"].ToString();
                Hyoa_flowfield.Insert();
            }
        }

        //生成SQL/ORACLE中的表
        string sql = "";
        if (Session["conntype"].ToString() == "SQL")
        {
            sql = "select * into hyc_" + txttableidbymd.Text + " from hyc_" + this.lbtableidbysorce.Text + " where 1=0";
        }
        if (Session["conntype"].ToString() == "ORACLE")
        {
            sql = "create table hyc_" + txttableidbymd.Text + " as select * from hyc_" + this.lbtableidbysorce.Text + " where 1=2";
        }
        Hyoa_global.ExcuteSQL(sql);

//.........这里部分代码省略.........

    protected void Page_Load(object sender, EventArgs e)
    {
        if (this.Session["hyuid"].ToString() =="")
            this.Response.Redirect("/login.aspx");

        if (this.Request.QueryString["mid"] != null)
        {
            //得到模块ID
            this.txtmudelid.Value = this.Request.QueryString["mid"].ToString();
        }
        else
        {
            this.Response.Write("<script>alert('模块ID没有传入，请联系管理员！');</script>");
            return;
        }
        if (this.Request.QueryString["tableid"] != null)
        {
            //表的ID
            this.txttableid.Value = this.Request.QueryString["tableid"].ToString();
            //得到表名
            HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
            DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.txttableid.Value);
            if (dt_tableconfig.Rows.Count > 0)
                this.lblcurtachenameshow.Text = dt_tableconfig.Rows[0]["hy_name"].ToString();
        }
        else
        {
            this.Response.Write("<script>alert('表单ID没有传入，请联系管理员！');</script>");
            return;
        }

        if (!IsPostBack)
        {
            //判断是否需要查询（目前一个表单只能对应一个列表，所以直接用表单ID进行查找）
            HyoaClass.Hyoa_listconfig Hyoa_listconfig = new HyoaClass.Hyoa_listconfig();
            DataTable dt_listconfig = Hyoa_listconfig.GetlistconfigByTableid(this.txttableid.Value);
            if (dt_listconfig.Rows.Count > 0)
            {
                if (dt_listconfig.Rows[0]["hy_ifsearch"].ToString() == "是")
                    GetSearchTableHtml();//查询表格动态生成
            }

            DataPlay(1);   //列表区动态生成
            PageListItem();
            EnabledWhatButton();
            if (this.txtmudelid.Value == "kqgl" && this.txttableid.Value == "74e7e280-4fc5-4ccb-be3d-0f995ac2c934")
            {
                this.delcontrol_my.Visible = false;
                this.newcontrol.Visible = false;

            }
            if (this.txtmudelid.Value == "clgl" && this.txttableid.Value == "0b5c53fe-114b-4fa3-8b59-4163b3053504")
            {
                this.exportexcel.Visible = true;
            }

            ///只有管理员岗位能删除（大榭特有）
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
            if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
            {
            }
            else
            {
                this.delcontrol.Visible = false;
                this.delcontrol_my.Visible = false;
            }

        }
    }

    //加载当前表单执行的onload代码      Written by xf 20110621
    public string onloadjs()
    {
        string ls_mid = "";
        if (this.Request.QueryString["mid"] != null)
        {
            ls_mid = this.Request.QueryString["mid"].ToString();
            if (ls_mid.Contains(","))
                ls_mid = ls_mid.Substring(0, ls_mid.IndexOf(","));
        }
        string ls_tableid = "";
        if (this.Request.QueryString["tableid"] != null)
        {
            ls_tableid = this.Request.QueryString["tableid"].ToString();
            if (ls_tableid.Contains(","))
                ls_tableid = ls_tableid.Substring(0, ls_tableid.IndexOf(","));
        }
        string ls_return = "";
        HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
        DataTable dt = Hyoa_tableconfig.GetTablesbymudelidandtableid(ls_mid, ls_tableid);
        if (dt.Rows.Count > 0)
            ls_return = dt.Rows[0]["hy_onload"].ToString();

        return ls_return;
    }

    //加载主表单    Written by xf 20110515
    private void DataPlay()
    {
        txtsavefields.Text = "";
        txtsavefields_sx.Text = "";

        if (this.Request.QueryString["op"] != null)
        {
            this.txtop.Value = this.Request.QueryString["op"].ToString();           //新增还是修改
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
            //旧文档
            if (this.Request.QueryString["op"] == "modify")
            {
                this.td_browseflow.Visible = true;  //查看流程
                if (this.Request.QueryString["docid"] != null)
                {
                    this.txtdocid.Value = this.Request.QueryString["docid"].ToString();
                    string sql = "select * from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "' ";
                    DataTable dt = Hyoa_global.GetDataTable(sql);
                    if (dt.Rows.Count > 0)
                    {
                        this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString();
                        this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString();
                        this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString();
                        this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString();
                        this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString();
                        this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString();
                        this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString();
                        this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString();
                        this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString();
                        this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString();
                        this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString();
                        this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString();
                        this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString();
                        this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString();
                        this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString();
                        this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString();
                        this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString();
                        this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString();
                        this.hy_readdatelist.Text = dt.Rows[0]["hy_readdatelist"].ToString();
                        this.hy_motherid.Text = dt.Rows[0]["hy_motherid"].ToString();
                        this.hy_ifconfirm.Text = dt.Rows[0]["hy_ifconfirm"].ToString();
                        UpdateReadFlag();  //打开时添加阅读情况
                    }
                    dt.Clear();

                    //流程文档
                    if (this.txtifhaveflow.Value == "是")
                    {
                        //流程已结束
                        if (this.hy_curtacheid.Text == "**")
                        {
                            this.lblcurtachenameshow.Text = "流程已结束";
                        }
                        //加载页面
                        GetMainTableHtml("1", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text);
                    }
                    else
                    {
                        this.lblcurtachenameshow.Text = this.lbltablename.Text;
                        //非流程表单
                        this.td_browseflow.Visible = false;

                        //加载主表单页面
                        GetMainTableHtml("1", this.txtSystemClRight.Value, "0", "");

                        //----加载评论页面 s add by xf 2011-11-19-----
                        HyoaClass.Hyoa_tableconfig Hyoa_tableconfig_forpinglun = new HyoaClass.Hyoa_tableconfig();
                        DataTable dt_tableconfig_forpinglun = Hyoa_tableconfig_forpinglun.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text);
                        if (dt_tableconfig_forpinglun.Rows.Count > 0)
                        {
                            if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"] != null)
                            {
                                if (dt_tableconfig_forpinglun.Rows[0]["hy_ifcomment"].ToString() == "是")
                                {
                                    this.tb_nbsp.Visible = true;
                                    this.tb_pltitle.Visible = true;
                                    this.tb_plbody.Visible = true;
                                    this.td_pinglun.Visible = true;
                                    //得到已经评论的内容
                                    HyoaClass.Hyoa_pinglun Hyoa_pinglun = new HyoaClass.Hyoa_pinglun();
                                    DataTable dt_pinglun = Hyoa_pinglun.GetcommentByfatherid(this.txtdocid.Value);
                                    if (dt_pinglun.Rows.Count > 0)
                                    {
                                        //输出评论记录
                                        this.lblbody.Text = "";
                                        for (var i = 0; i < dt_pinglun.Rows.Count; i++)
                                        {
                                            this.lblbody.Text += dt_pinglun.Rows[i]["hy_plbody"].ToString() + "<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
                                            this.lblbody.Text += "（评论人:" + dt_pinglun.Rows[i]["hy_plusername"].ToString() + "&nbsp;&nbsp;&nbsp;所在部门:" + dt_pinglun.Rows[i]["hy_pldeptname"].ToString();
                                            this.lblbody.Text += "&nbsp;&nbsp;&nbsp;评论时间:" + dt_pinglun.Rows[i]["hy_pltime"].ToString() + "&nbsp;&nbsp;&nbsp;IP:" + dt_pinglun.Rows[i]["hy_plip"].ToString();
                                            this.lblbody.Text += "）<br><hr height=1 color=#DEEEFE></hr>";
                                        }
                                    }
                                }
                            }
                        }
                        //----加载评论页面 e-----
                    }

//.........这里部分代码省略.........

//.........这里部分代码省略.........
                        this.txtwidth.Text = dt.Rows[0]["hy_width"].ToString();

                        //加载所有列信息
                        HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
                        DataTable dtflowfield;

                        //dtflowfield = Hyoa_flowfield.Getflowfields();
                        dtflowfield = Hyoa_flowfield.GetflowfieldsbyMudelidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
                        if (dtflowfield.Rows.Count > 0)
                        {
                            this.ddlcolumnshow.DataSource = dtflowfield;
                            this.ddlcolumnshow.DataTextField = "hy_fieldname";
                            this.ddlcolumnshow.DataValueField = "hy_fieldid";
                            this.ddlcolumnshow.DataBind();
                            this.ddlcolumnshow.SelectedIndex = 0;
                        }
                        dtflowfield.Clear();

                        //将列都列出来
                        string[] lv_columnshowselect;
                        string[] lv_columnshowselectid;
                        lv_columnshowselect = dt.Rows[0]["hy_columnshow"].ToString().Split(',');
                        lv_columnshowselectid = dt.Rows[0]["hy_columnshowid"].ToString().Split(',');
                        for (int j = 0; j < lv_columnshowselect.Length; j++)
                        {
                            this.ddlcolumnshowselect.Items.Insert(j, new ListItem(lv_columnshowselect[j], lv_columnshowselectid[j]));
                        }

                        //根据模块信息得到对应的选择表单值
                        if (dt.Rows[0]["hy_tableid"] != "" && dt.Rows[0]["hy_tableid"] != null)
                        {
                            this.ddltableid.Items.Clear();
                            //根据模块ID得到表单ID
                            HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
                            DataTable dtgettableid = Hyoa_tableconfig.GetTablesbymudelid(dt.Rows[0]["hy_mudelid"].ToString());
                            if (dtgettableid.Rows.Count > 0)
                            {
                                for (var i = 0; i < dtgettableid.Rows.Count; i++)
                                {
                                    this.ddltableid.Items.Insert(i, new ListItem(dtgettableid.Rows[i]["hy_name"].ToString(), dtgettableid.Rows[i]["ID"].ToString()));
                                }
                                this.ddltableid.Items.Insert(0, new ListItem("--请选择--", ""));
                                this.ddltableid.Attributes.Add("onchange ", "mudelidonchang() ");
                                //定位
                                this.ddltableid.SelectedValue = dt.Rows[0]["hy_tableid"].ToString();
                            }
                        }

                        //排序的字段
                        //根据模块ID+表单ID+字段ID得到字段中文名
                        DataTable dt_flowfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_sortfield1"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
                        if (dt_flowfield.Rows.Count > 0)
                        {
                            this.searchsort1.Items.Insert(0, new ListItem(dt_flowfield.Rows[0]["hy_fieldname"].ToString(), dt.Rows[0]["hy_sortfield1"].ToString()));
                        }
                        this.ddlsorttype1.SelectedValue = dt.Rows[0]["hy_sorttype1"].ToString();
                        dt_flowfield.Clear();
                        dt_flowfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_sortfield2"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
                        if (dt_flowfield.Rows.Count > 0)
                        {
                            this.searchsort2.Items.Insert(0, new ListItem(dt_flowfield.Rows[0]["hy_fieldname"].ToString(), dt.Rows[0]["hy_sortfield2"].ToString()));
                        }
                        this.ddlsorttype2.SelectedValue = dt.Rows[0]["hy_sorttype2"].ToString();
                        dt_flowfield.Clear();
                        dt_flowfield = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(dt.Rows[0]["hy_mudelid"].ToString(), dt.Rows[0]["hy_sortfield3"].ToString(), dt.Rows[0]["hy_tableid"].ToString());
                        if (dt_flowfield.Rows.Count > 0)

    private void DataPlay()
    {
        //是否启用
        this.ddlifsearch.Items.Insert(0, "是");
        this.ddlifsearch.Items.Insert(1, "否");
        //this.ddlifflowdoc.Items.Insert(0, "是");
        //this.ddlifflowdoc.Items.Insert(1, "否");
        //模块编号
        //加载模块信息
        HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
        DataTable dtmudel = Hyoa_mudel.Getmudels();
        if (dtmudel.Rows.Count > 0)
        {
            this.ddlmudelid.DataSource = dtmudel;
            this.ddlmudelid.DataTextField = "hy_mudelname";
            this.ddlmudelid.DataValueField = "hy_mudelid";
            this.ddlmudelid.DataBind();
            this.ddlmudelid.Items.Insert(0, new ListItem("请选择", "请选择"));
            this.ddlmudelid.SelectedIndex = 0;
            //this.ddlmudelid.Items.Insert(0, new ListItem(lsmudel, lsmudelid));

        }
        //dtmudel.Clear();
        //加载列信息
        HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
        DataTable dtflowfield;

        dtflowfield = Hyoa_flowfield.Getflowfields();
        if (dtflowfield.Rows.Count > 0)
        {
            this.ddlcolumnshow.DataSource = dtflowfield;
            this.ddlcolumnshow.DataTextField = "hy_fieldname";
            this.ddlcolumnshow.DataValueField = "hy_fieldid";
            this.ddlcolumnshow.DataBind();
            this.ddlcolumnshow.SelectedIndex = 0;
        }
        dtflowfield.Clear();

        if (this.Request.QueryString["op"] != null)
        {
            this.txtop.Value = this.Request.QueryString["op"].ToString();           //新增还是修改

            //判断当前用户是否有保存的权限
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
            if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
            {
                this.btn_submit.Visible = true; //保存
            }
            else
            {
                this.btn_submit.Visible = false; //保存
            }

            //旧文档
            if (this.Request.QueryString["op"] == "modify")
            {
                string ls_xszd="";
                string ls_xszdid="";
                if (this.Request.QueryString["id"] != null)
                {
                    //根据id得到信息

                    this.txtdocid.Value = this.Request.QueryString["id"].ToString();
                    HyoaClass.DAO db = new HyoaClass.DAO();
                    string sql = "select * from hyt_searchconfig where ID='" + this.txtdocid.Value + "'";
                    DataTable dt = db.GetDataTable(sql);
                    if (dt.Rows.Count > 0)
                    {
                        this.txtsort.Text = dt.Rows[0]["hy_sort"].ToString();
                        //this.txtwidth.Text = dt.Rows[0]["hy_width"].ToString();
                        if (dt.Rows[0]["hy_ifsearch"].ToString() == "是")
                            this.ddlifsearch.SelectedIndex = 0;
                        else
                            this.ddlifsearch.SelectedIndex = 1;

                        this.ddlmudelid.SelectedValue = dt.Rows[0]["hy_mudelid"].ToString();
                        this.hy_field41_1.Value = dt.Rows[0]["hy_kckry"].ToString();
                        this.hy_field43_1.Value = dt.Rows[0]["hy_kckryid"].ToString();
                        //将列都列出来
                        string[] lv_columnshowselect;
                        string[] lv_columnshowselectid;
                        lv_columnshowselect = dt.Rows[0]["hy_columnshow"].ToString().Split(',');
                        lv_columnshowselectid = dt.Rows[0]["hy_columnshowid"].ToString().Split(',');
                        for (int j = 0; j < lv_columnshowselect.Length; j++)
                        {
                            this.ddlcolumnshowselect.Items.Insert(j, new ListItem(lv_columnshowselect[j], lv_columnshowselectid[j]));
                        }

                        //根据模块信息得到对应的选择表单值
                        if (dt.Rows[0]["hy_tableid"] != "" && dt.Rows[0]["hy_tableid"] != null)
                        {
                            this.ddltableid.Items.Clear();
                            //根据模块ID得到表单ID
                            HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
                            DataTable dtgettableid = Hyoa_tableconfig.GetTablesbymudelid(dt.Rows[0]["hy_mudelid"].ToString());
                            if (dtgettableid.Rows.Count > 0)
                            {
                                for (var i = 0; i < dtgettableid.Rows.Count; i++)
                                {
                                    this.ddltableid.Items.Insert(i, new ListItem(dtgettableid.Rows[i]["hy_name"].ToString(), dtgettableid.Rows[i]["ID"].ToString()));
//.........这里部分代码省略.........