C# HyoaClass.Hyoa_global.GetDataTable_BASE方法代码示例

 //查询
 protected void Button_Save_Click(object sender, EventArgs e)
 {
     string ls_return = "";
     if (txtsql.Value == "")
     {
         ls_return = "请填写查询语句";
     }
     if (ddldbconn.SelectedValue == "")
     {
         ls_return = "请选择连接";
     }
     HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
     DataTable dt = new DataTable();
     if (ddldbconn.SelectedValue == "base")
     {
         dt = Hyoa_global.GetDataTable_BASE(txtsql.Value);
     }
     if (ddldbconn.SelectedValue == "pro")
     {
         dt = Hyoa_global.GetDataTable(txtsql.Value);
     }
     if (ddldbconn.SelectedValue == "user")
     {
         dt = Hyoa_global.GetDataTable_USER(txtsql.Value);
     }
     if (dt.Rows.Count > 0)
     {
         ls_return += "<table border=1 width='100%'>";
         ls_return += "<tr>";
         for (int j = 0; j < dt.Columns.Count; j++)
         {
             ls_return += "<td>" + dt.Columns[j].ToString() + "</td>";
         }
         ls_return += "</tr>";
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             ls_return += "<tr>";
             for (int j = 0; j < dt.Columns.Count; j++)
             {
                 ls_return += "<td>"+dt.Rows[i][dt.Columns[j].ToString()].ToString()+"</td>";
             }
             ls_return += "</tr>";
         }
         ls_return += "</table>";
     }
     lbljg.Text = ls_return;
 }

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

        if (!IsPostBack)
        {
            String lstableid = "";
            String lsmid = "";
            String lsstartdate = "";
            String lsenddate = "";
            string strSql = "";
            if (this.Request.QueryString["strSql"] != null)
            {
                strSql = Request.QueryString["strSql"].ToString();
            }
            if (this.Request.QueryString["tableid"] != null)
            {
                lstableid = Request.QueryString["tableid"].ToString();
            }
            if (this.Request.QueryString["mid"] != null)
            {
                lsmid = Request.QueryString["mid"].ToString();
            }
            if (this.Request.QueryString["startdate"] != null)
            {
                lsstartdate = Request.QueryString["startdate"].ToString();
            }
            if (this.Request.QueryString["enddate"] != null)
            {
                lsenddate = Request.QueryString["enddate"].ToString();
            }
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
            //得到这个模块对应有哪些字段
            //if (field_type == "文本" || field_type == "多行文本" || field_type == "文本加按钮" || field_type == "多行文本加按钮" || field_type == "日期" || field_type == "数值" || field_type == "对话框列表" || field_type == "复选框" || field_type == "单选框" || field_type == "口令" || field_type == "编辑器")
            String lssqlfield = "select * from hyt_flowfield where hy_tableid='" + lstableid + "' and hy_mudelid='" + lsmid + "' and hy_ifhiddle='否' and (hy_fieldtype='文本' or hy_fieldtype='多行文本' or hy_fieldtype='文本加按钮' or hy_fieldtype='多行文本加按钮' or hy_fieldtype='日期' or hy_fieldtype='数值' or hy_fieldtype='对话框列表' or hy_fieldtype='复选框' or hy_fieldtype='单选框' or hy_fieldtype='口令' or hy_fieldtype='编辑器') order by hy_sort";

            //Response.Write(lssqlfield);
            //return;

            DataTable dtfield = Hyoa_global.GetDataTable_BASE(lssqlfield);
            String lsfieldid = "";
            String lsfieldname = "";
            String lsfieldidsub = "";
            String lsfieldnamesub = "";
            String lstableidsub = "";
            String lsmudelidsub = "";
            if (dtfield.Rows.Count > 0)
            {
                for (int i = 0; i < dtfield.Rows.Count; i++)
                {
                    if (lsfieldid == "")
                    {
                        lsfieldid = "hyc_" + dtfield.Rows[i]["hy_fieldid"].ToString();
                        lsfieldname = dtfield.Rows[i]["hy_fieldname"].ToString();
                    }
                    else
                    {
                        lsfieldid += "," + "hyc_" + dtfield.Rows[i]["hy_fieldid"].ToString();
                        lsfieldname += "," + dtfield.Rows[i]["hy_fieldname"].ToString();
                    }

                }
            }
            else
            {
                this.Response.Write("<script>alert('目录配置有问题，请联系管理员！');window.close();</script>");
                return;
            }
            if (lsfieldid != "")
            {
                //判断当前表中是否有子表如果有的话，就将对应的表得到。只能输出一个子表，不考虑二个及以上的情况。
                String lssqlsub = "select * from hyt_flowfield where hy_tableid='" + lstableid + "' and hy_mudelid='" + lsmid + "' and hy_fieldtype='IFRAME列表'";
                DataTable dtsub = Hyoa_global.GetDataTable_BASE(lssqlsub);
                String ls_defaultvalue = "";

                if (dtsub.Rows.Count > 0)
                {
                    ls_defaultvalue = dtsub.Rows[0]["hy_defaultvalue"].ToString();
                    lstableidsub = ls_defaultvalue.Substring(ls_defaultvalue.IndexOf("tableid=") + 8, ls_defaultvalue.IndexOf("&listid=") - ls_defaultvalue.IndexOf("tableid=") - 8);
                    lsmudelidsub = ls_defaultvalue.Substring(ls_defaultvalue.IndexOf("mid=") + 4, ls_defaultvalue.IndexOf("&tableid") - ls_defaultvalue.IndexOf("mid=") - 4);
                    String lssqlsubfield = "select * from hyt_flowfield where hy_tableid='" + lstableidsub + "' and hy_mudelid='" + lsmudelidsub + "' order by hy_sort";
                    DataTable dtsubfield = Hyoa_global.GetDataTable_BASE(lssqlsubfield);
                    for (int ii = 0; ii < dtsubfield.Rows.Count; ii++)
                    {
                        if (lsfieldidsub == "")
                        {
                            lsfieldidsub = "hyc_" + dtsubfield.Rows[ii]["hy_fieldid"].ToString();
                            lsfieldnamesub = dtsubfield.Rows[ii]["hy_fieldname"].ToString();
                        }
                        else
                        {
                            lsfieldidsub += "," + "hyc_" + dtsubfield.Rows[ii]["hy_fieldid"].ToString();
                            lsfieldnamesub += "," + dtsubfield.Rows[ii]["hy_fieldname"].ToString();
                        }
                    }
                }
            }

            //得到应用数据
//.........这里部分代码省略.........

 //合同办理状态  完成
 protected void btn_wc_Click(object sender, EventArgs e)
 {
     HyoaClass.Hyoa_global db = new HyoaClass.Hyoa_global();
     string sql = "";
     DataTable dt = new DataTable();
     sql = "update hyt_blzt set hy_state='已完成' where DOCID='" + this.txtdocid.Value + "'";
     db.ExcuteSQL(sql);
     string sqlSelect = " select * from hyt_listconfig where hy_mudelid='" + this.hy_mudelid.Text + "' and hy_tableid='" + this.hy_tableid.Text + "' ";
     dt.Clear();
     dt = db.GetDataTable_BASE(sqlSelect);
     string url = "";
     if (dt.Rows.Count > 0)
     {
         url = "list_flc.aspx?mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&listid=" + dt.Rows[0]["id"].ToString() + "&rnd=" + System.Guid.NewGuid().ToString();
         Response.Write("<script>alert('已完成');window.location='" + this.txturl.Value + "'</script>");
     }
 }

//.........这里部分代码省略.........
            //降序
            Array.Reverse(arrayValue);
            Array.Reverse(arrayName);
            //重新将值放到新的集合中
            IDictionary<string, DateTime> dicSorted = new Dictionary<string, DateTime>();
            for (int i = 0; i < arrayName.Length; i++)
            {
                dicSorted.Add(arrayName[i], dic[arrayName[i]]);
            }
            //定义一个数组 通过循环 将key放入数组中
            string[] Docid = new string[dicSorted.Count];
            int j = 0;
            foreach (string lsDocid in dicSorted.Keys)
            {
                Docid[j] = lsDocid;
                j++;
            }
            //取集合前六个的值  通过数组中存储的key对集合进行删除操作
            if (Docid.Length > 5)
            {
                for (int i = 5; i < Docid.Length; i++)
                {
                    dicSorted.Remove(Docid[i]);
                }
            }
            //对集合前六个合同进行数据加工 输出到前台
            foreach (string lsDocid in dicSorted.Keys)
            {
                string lsTitle = "";
                string[] lsData = lsDocid.Split('#');
                sqlSelect = " select * from hyc_" + lsData[1] + " where docid ='" + lsData[0] + "' ";
                DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
                sqlSelect = " select hy_name from hyt_tableconfig where id='" + lsData[1] + "' ";
                DataTable dt2 = Hyoa_global.GetDataTable_BASE(sqlSelect);
                if (dt.Rows.Count > 0 && dt2.Rows.Count > 0)
                {
                    lsTitle = "[" + dt2.Rows[0]["hy_name"].ToString() + "]-" + dt.Rows[0]["hyc_jfmc"].ToString();
                    if (lsTitle.Length > 20)
                        lsTitle = lsTitle.Substring(0, 20) + "...";

                    ls_temp += "<tr>";
                    ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
                    ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
                    ls_temp += "<tbody>";
                    ls_temp += "<tr>";
                    ls_temp += "<td width=\"72%\">&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"#\" onclick=\" var path='main_look.aspx?op=modify&mid=" + dt.Rows[0]["hy_mudelid"].ToString() + "&tableid=" + dt.Rows[0]["hy_tableid"].ToString() + "&docid=" + dt.Rows[0]["docid"].ToString() + " ';window.open(path) \" >&middot;" + lsTitle + "</a></td>";
                    ls_temp += "<td width=\"28%\" align=\"right\">";
                    ls_temp += "<font color=\"#056ea5\">" + System.DateTime.Parse(dt.Rows[0]["hy_djsj"].ToString()).ToShortDateString().ToString() + "</font>&nbsp;&nbsp;&nbsp;&nbsp;</td>";
                    ls_temp += "</tr>";
                    ls_temp += "</tbody>";
                    ls_temp += "</table>";
                    ls_temp += "</td>";
                    ls_temp += "</tr>";
                }
            }
            if (ls_temp == "")
            {
                ls_temp += "<tr>";
                ls_temp += "<td height=\"22\" background=\"hyhtml/desk/line.gif\">";
                ls_temp += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">";
                ls_temp += "<tbody>";
                ls_temp += "<tr>";
                ls_temp += "<td width=\"100%\">&nbsp;&nbsp;&nbsp;&nbsp;暂无记录！</td>";
                ls_temp += "</tr>";
                ls_temp += "</tbody>";
                ls_temp += "</table>";

    private void DataPlay()
    {
        //label清空
        int count = 1;
        string[] lsTableId = new string[] { "Tablesyyhfwxy", "Tablejdhazfwht", "TableVODfwxy", "Tableffpdfwht", "TableDVBazfwdght", "Tablejwdsjsxy", "Tablejwdscsxy", "Tablekdjrht", "Tablesjcsfwht", "Tablesjgdcsfwht", "Tablesjtxyyhzxy" };
        for (int i = 0; i < lsTableId.Length; i++)
        {
            string sqlSelect = " select * from hyc_" + lsTableId[i] + "  where 1=1 ";
            if (this.txt_tjz_s.Value != "")
            {
                sqlSelect += " and hy_djsj >= '" + this.txt_tjz_s.Value + "' ";
            }
            if (this.txt_tjz_e.Value != "")
            {
                sqlSelect += " and hy_djsj <='" + this.txt_tjz_e.Value + "'  ";
            }
            sqlSelect += " order by hy_djsj desc ";
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
            DataTable dt = Hyoa_global.GetDataTable(sqlSelect);

            if (dt.Rows.Count > 0)
            {
                for (int j = 0; j < dt.Rows.Count; j++)
                {
                    sqlSelect = " select * from hyc_Tablefpbd where hyc_fptt='" + dt.Rows[j]["hyc_jfmc"].ToString() + "' ";
                    if (this.txt_tjz_s.Value != "")
                    {
                        sqlSelect += " and hy_djsj >= '" + this.txt_tjz_s.Value + "' ";
                    }
                    if (this.txt_tjz_e.Value != "")
                    {
                        sqlSelect += " and hy_djsj <='" + this.txt_tjz_e.Value + "'  ";
                    }
                    DataTable dt2 = Hyoa_global.GetDataTable(sqlSelect);
                    sqlSelect = " select hy_name  from hyt_tableconfig where id='" + lsTableId[i] + "'  ";
                    DataTable dt3 = Hyoa_global.GetDataTable_BASE(sqlSelect);

                    strShow.Append("<tr onmouseover=\"this.className='tr-over'\" onmouseout=\"this.className='TrList'\" class=\"TrList\">");
                    strShow.Append("<td width=\"5%\" class=\"TdcellHead\"><p align=\"center\">" + count + "</p></td>");
                    if (dt3.Rows.Count > 0)
                    {
                        strShow.Append("<td width=\"25%\" class=\"TdcellHead\"><p align=\"center\">" + dt3.Rows[0]["hy_name"].ToString() + "</p></td>");
                    }
                    else
                    {
                        strShow.Append("<td width=\"25%\" class=\"TdcellHead\"><p align=\"center\"></p></td>");
                    }

                    strShow.Append("<td width=\"30%\" class=\"TdcellHead\"><p align=\"center\">" + dt.Rows[j]["hyc_jfmc"].ToString() + "</p></td>");
                    strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"center\">" + dt.Rows[j]["hyc_htje"].ToString() + "</p></td>");
                    if (dt.Rows[j]["hyc_htje"].ToString() !="")
                    {
                        htjeTotal += Convert.ToDouble(dt.Rows[j]["hyc_htje"].ToString());
                    }
                    strShow.Append("</tr>");
                    count++;
                }
            }
        }
        strShow.Append("<tr onmouseover=\"this.className='tr-over'\" onmouseout=\"this.className='TrList'\" class=\"TrList\">");
        strShow.Append("<td width=\"5%\" class=\"TdcellHead\"><p align=\"center\">合计</p></td>");
        strShow.Append("<td width=\"25%\" class=\"TdcellHead\"><p align=\"center\">"+(count-1)+"个合同</p></td>");
        strShow.Append("<td width=\"30%\" class=\"TdcellHead\"><p align=\"center\"></p></td>");
        strShow.Append("<td width=\"10%\" class=\"TdcellHead\"><p align=\"left\">合同金额合计：" + htjeTotal + "</p></td></tr>");
        this.lb_show.Text += strShow.ToString();
    }

    //////////置为文档已读状态
    ////////private void UpdateReadFlag()
    ////////{
    ////////    HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
    ////////    Hyoa_flowmain.UpdateReadFlag(this.txtdocid.Value, Session["hyuid"].ToString());
    ////////}
    //保存
    protected void Button_Save_Click(object sender, EventArgs e)
    {
        if (this.Session["hyuid"].ToString() == "")
            this.Response.Redirect("../login.aspx");

        string ls_tip = "保存成功！";

        //新文档时
        //新建时先进行一次保存
        HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
        //HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
        if (this.txtop.Value == "add")
        {
            //Hyoa_flowmain.DOCID = this.txtdocid.Value;
            //Hyoa_flowmain.hy_mudelid = this.hy_mudelid.Text;
            //Hyoa_flowmain.hy_tableid = this.hy_tableid.Text;
            //Hyoa_flowmain.hy_flowid = this.hy_flowid.Text;
            //Hyoa_flowmain.hy_flowname = this.hy_flowname.Text;
            //Hyoa_flowmain.hy_curtacheid = this.hy_curtacheid.Text;
            //Hyoa_flowmain.hy_curtachename = this.hy_curtachename.Text;
            //Hyoa_flowmain.hy_curclrid = this.hy_curclrid.Text;
            //Hyoa_flowmain.hy_curclrname = this.hy_curclrname.Text;
            //Hyoa_flowmain.hy_djrid = this.hy_djrid.Text;
            //Hyoa_flowmain.hy_djrname = this.hy_djrname.Text;
            //Hyoa_flowmain.hy_djrbmid = this.hy_djrbmid.Text;
            //Hyoa_flowmain.hy_djrbmname = this.hy_djrbmname.Text;
            //Hyoa_flowmain.hy_djsj = this.hy_djsj.Text;

            //Hyoa_flowmain.hy_bt = this.hy_bt.Text;

            //Hyoa_flowmain.hy_iftx = this.hy_iftx.Text;
            //Hyoa_flowmain.hy_zhtxsj = this.hy_zhtxsj.Text;
            //Hyoa_flowmain.hy_readuserlist = this.hy_readuserlist.Text;

            //Hyoa_flowmain.Insert();
            //动态插入数据
            //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
            string lssqlfield = "SELECT * FROM hyt_flowfield WHERE (hy_tableid = 'Tabledcxt') AND (hy_mudelid = 'Mudeldcxt')";
            DataTable dtfield = Hyoa_global.GetDataTable_BASE(lssqlfield); //得到所有配置域
            string lssqlinsert = "";
            string lssqlinsert1 = "";
            string lssqlinsert2 = "";
            string lssqlinsert3 = "";
            string lssqlinsert4 = "";
            string lssqlinsert5 = "";
            lssqlinsert1 = "insert into hyc_" + this.hy_tableid.Text + "(";
            lssqlinsert2 = "DOCID,hy_mudelid,hy_tableid,hy_flowid,hy_flowname,hy_curtacheid,hy_curtachename,hy_curclrid,hy_curclrname,hy_djrid,hy_djrname,hy_djrbmid,hy_djrbmname,hy_djsj,hy_bt,hy_iftx,hy_zhtxsj,hy_readuserlist";
            lssqlinsert3 = ") values (";
            lssqlinsert4 = "'" + this.txtdocid.Value + "'";
            lssqlinsert4 += ",'" + this.hy_mudelid.Text + "'";
            lssqlinsert4 += ",'" + this.hy_tableid.Text + "'";
            lssqlinsert4 += ",'" + this.hy_flowid.Text + "'";
            lssqlinsert4 += ",'" + this.hy_flowname.Text + "'";
            lssqlinsert4 += ",'" + this.hy_curtacheid.Text + "'";
            lssqlinsert4 += ",'" + this.hy_curtachename.Text + "'";
            lssqlinsert4 += ",'" + this.hy_curclrid.Text + "'";
            lssqlinsert4 += ",'" + this.hy_curclrname.Text + "'";
            lssqlinsert4 += ",'" + this.hy_djrid.Text + "'";
            lssqlinsert4 += ",'" + this.hy_djrname.Text + "'";
            lssqlinsert4 += ",'" + this.hy_djrbmid.Text + "'";
            lssqlinsert4 += ",'" + this.hy_djrbmname.Text + "'";
            if (Session["conntype"].ToString() == "SQL")
            {
                lssqlinsert4 += ",'"+this.hy_djsj.Text + "'";
            }
            if (Session["conntype"].ToString() == "ORACLE")
            {
                lssqlinsert4 += ",to_date('" + this.hy_djsj.Text + "','YYYY-MM-DD HH24:MI:SS')";
            }
            lssqlinsert4 += ",'" + this.hy_bt.Text + "'";
            lssqlinsert4 += ",'" + this.hy_iftx.Text + "'";
            lssqlinsert4 += ",'" + this.hy_zhtxsj.Text + "'";
            lssqlinsert4 += ",'" + this.hy_readuserlist.Text+"'";
            lssqlinsert5 = ")";
            for (int ii = 0; ii < dtfield.Rows.Count; ii++)
            {
                lssqlinsert2 += "," + "hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString();

                if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "文本" || dtfield.Rows[ii]["hy_fieldtype"].ToString() == "多行文本")
                {
                    TextBox txt1 = (TextBox)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString());
                    lssqlinsert4 += ",'" + txt1.Text + "'";
                }
                if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "日期")
                {
                    TextBox txt1 = (TextBox)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString());
                    if (Session["conntype"].ToString() == "SQL")
                    {
                        lssqlinsert4 += ",'" + txt1.Text + "'";
                    }
                    if (Session["conntype"].ToString() == "ORACLE")
                    {
                        lssqlinsert4 += ",to_date('" + txt1.Text + "','YYYY-MM-DD HH24:MI:SS')";
//.........这里部分代码省略.........

    //加载主表单    Written by xf 20110515
    private void DataPlay()
    {
        if (this.Request.QueryString["op"] != null)
        {
            HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
            this.txtop.Value = this.Request.QueryString["op"].ToString();           //新增还是修改

            //新文档
            if (this.Request.QueryString["op"] == "add")
            {
                //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
                //文档ID
                this.txtdocid.Value = Hyoa_global.GetRandom();

                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();
                this.hy_djsj.Text = System.DateTime.Now.ToString();
                this.txthyc_nf.Text = System.DateTime.Now.ToString("yyyy");
                this.txthyc_djsj.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
                this.txthyc_lxks.Text = this.Session["hydeptname"].ToString();
                this.txthyc_lxr.Text = this.Session["hyuname"].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);
                        //Response.Write("<script>alert('"+dt.Rows.Count.ToString()+"')</script>");
                        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";
                                this.txtSystemYdRight.Value = "0";
                            }
                            else
                            {
                                Response.Write("<script>alert('您无权进行此项操作，请联系管理员！');</script>");
                            }
                        }
                        dt.Clear();
                        this.td_nextstep.Visible = true; //提交
                        this.td_submit.Visible = true; //保存
                    }
                }
                //加载页面
                WebOpen(this.hy_mudelid.Text, this.hy_tableid.Text, this.hy_flowid.Text, this.hy_curtacheid.Text, this.txtSystemClRight.Value, this.txtSystemYdRight.Value, "0");
            }
            //旧文档
            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();

                    //HyoaClass.Hyoa_flowmain flowmain = new HyoaClass.Hyoa_flowmain();
                    //DataTable dt = flowmain.Getflowmain(this.txtdocid.Value);
                    //HyoaClass.Hyoa_global Hyoa_global=new HyoaClass.Hyoa_global ();
                    string lssql = "select * from hyc_Tabledcxt where DOCID='" + this.txtdocid.Value + "'";
                    DataTable dt = Hyoa_global.GetDataTable(lssql);
                    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();

                        string lssqlfield = "SELECT * FROM hyt_flowfield WHERE (hy_tableid = 'Tabledcxt') AND (hy_mudelid = 'Mudeldcxt')";
                        DataTable dtfield = Hyoa_global.GetDataTable_BASE(lssqlfield); //得到所有配置域
                        for (int ii = 0; ii < dtfield.Rows.Count; ii++)
                        {
//.........这里部分代码省略.........