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())); } 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_sortfield"].ToString(), dt.Rows[0]["hy_tableid"].ToString()); //if(dt_flowfield.Rows.Count>0) // this.searchsort.Items.Insert(0, new ListItem(dt_flowfield.Rows[0]["hy_fieldname"].ToString(), dt.Rows[0]["hy_sortfield"].ToString())); //this.ddlsorttype.SelectedValue = dt.Rows[0]["hy_sorttype"].ToString(); ls_xszd = dt.Rows[0]["hy_xszd"].ToString(); ls_xszdid = dt.Rows[0]["hy_xszdid"].ToString(); } dt.Clear(); //HyoaClass.Hyoa_listsearchfield Hyoa_listsearchfield = new HyoaClass.Hyoa_listsearchfield(); //DataTable dt5 = Hyoa_listsearchfield.Getlistsearchfieldsbylistid(this.txtdocid.Value); //if (dt5.Rows.Count > 0) //{ // for (int m = 0; m < dt5.Rows.Count; m++) // { // this.searchselect.Items.Insert(m, new ListItem(dt5.Rows[m]["hy_field"].ToString(), dt5.Rows[m]["hy_fieldid"].ToString())); // } //} string[] lv_xszd = ls_xszd.Split(','); string[] lv_xszdid = ls_xszdid.Split(','); for (int jj = 0; jj < lv_xszd.Length; jj++) { this.searchselect.Items.Insert(jj, new ListItem(lv_xszd[jj], lv_xszdid[jj])); } } } } }