后台代码using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
string connstring = ConfigurationSettings.AppSettings["connstring"];
string opquerynum; protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
SqlConnection con = null;
SqlDataReader dr = null; string strsql = "SELECT OpQueryNum,OpQueryName FROM tbOpQuery where usernum=82";
con = new SqlConnection(connstring);
con.Open();
SqlCommand cmd = new SqlCommand(strsql, con);
dr = cmd.ExecuteReader();
DtQuery.DataSource = dr;
DtQuery.DataTextField = "OpQueryName";
DtQuery.DataValueField = "OpQueryNum";
DtQuery.DataBind();
con.Close(); } //人为的对下拉框进行赋值
} protected void Btnserach_click(object sender, EventArgs e)
{ string strsql1;
string strsql;
SqlConnection con=null;
SqlConnection con1 = null;
SqlDataReader dr1 = null;
SqlDataReader dr2 = null;
string opqueynum = DtQuery.SelectedItem.Text;
strsql1 = "select OpQueryNum from tbOpQuery where OpQueryName='" + opqueynum + "' and usernum=82";
con1 = new SqlConnection(connstring);
con1.Open();
SqlCommand cmd = new SqlCommand(strsql1, con1);
dr2 = cmd.ExecuteReader();
while (dr2.Read())
{
opquerynum = dr2["OpQueryNum"].ToString();
}
strsql = "select * from tbQueryCond where OpQueryNum=" + opquerynum;
con = new SqlConnection(connstring);
con.Open();
SqlCommand cmd1 = new SqlCommand(strsql, con);
dr1 = cmd1.ExecuteReader(); while (dr1.Read())
{
TableRow row = new TableRow();
TableCell cellHead = new TableCell();
TableCell cellbody = new TableCell();
Label LabelAuditing = new Label();
TableCell cellContent = new TableCell();
DropDownList DdlAuditing = new DropDownList();
string Ddltext; LabelAuditing.ID = "LabelAuditing" + dr1["FldNum"].ToString();
LabelAuditing.Text = dr1["FldName"].ToString();
DdlAuditing.ID = "CBAuditing" + dr1["FldNum"].ToString();
DdlAuditing.Items.Add("介于");
DdlAuditing.Items.Add("不介于");
DdlAuditing.Items.Add("大于");
DdlAuditing.Items.Add("小于");
DdlAuditing.Items.Add("等于");
DdlAuditing.Items.Add("不等于");
DdlAuditing.Items.Add("小于等于");
DdlAuditing.Items.Add("为空");
DdlAuditing.Items.Add("不为空");
DdlAuditing.Items.Add("包含");
Ddltext = dr1["Operator"].ToString();
DdlAuditing.AutoPostBack = true;
DdlAuditing.SelectedIndexChanged += new EventHandler(DdlAuditing_SelectedIndexChanged); if (Ddltext.Equals("0"))
{
DdlAuditing.Text = "介于";
} if (Ddltext.Equals("1"))
{
DdlAuditing.Text = "不介于";
}
if (Ddltext.Equals("2"))
{
DdlAuditing.Text = "大于";
}
if (Ddltext.Equals("3"))
{
DdlAuditing.Text = "小于";
}
if (Ddltext.Equals("4"))
{
DdlAuditing.Text = "等于";
}
if (Ddltext.Equals("5"))
{
DdlAuditing.Text = "不等于";
}
if (Ddltext.Equals("6"))
{
DdlAuditing.Text = "小于等于";
}
if (Ddltext.Equals("7"))
{
DdlAuditing.Text = "大于等于";
}
if (Ddltext.Equals("8"))
{
DdlAuditing.Text = "为空";
}
if (Ddltext.Equals("9"))
{
DdlAuditing.Text = "不为空";
}
if (Ddltext.Equals("10"))
{
DdlAuditing.Text = "包含";
}
/* DdlAuditing.Text = JudgeCB(dr1["CBItemIndex"].ToString());
if ((dr1["CBItemIndex"].ToString).equals("0"))
{
CBAuditing.Text = "介于";
}
* */ if (DdlAuditing.Text != "为空" && DdlAuditing.Text != "不为空")
{
TextBox TextAuditing = new TextBox();
TextAuditing.ID = "TextAuditing" + dr1["FldNum"].ToString();
TextAuditing.Height = 18;
cellContent.Controls.Add(TextAuditing);
} TableCell cellContent1 = new TableCell();
if (DdlAuditing.Text == "介于" || DdlAuditing.Text == "不介于")
{
TextBox TextAuditing1 = new TextBox();
TextAuditing1.ID = "TextAuditing1" + dr1["FldNum"].ToString();
cellContent1.Controls.Add(TextAuditing1);
} cellContent1.BorderColor = System.Drawing.Color.FromName("#CCCCCC");
//cellContent1.BackColor = System.Drawing.Color.FromName("#EFEFEF");
cellContent1.BorderWidth = 0;
cellContent1.HorizontalAlign = HorizontalAlign.Left;
cellContent1.Width = 200; cellHead.Controls.Add(LabelAuditing);
cellbody.Controls.Add(DdlAuditing);
//cellHead.BackColor = System.Drawing.Color.FromName("#EFEFEF");
cellHead.BorderWidth = 0;
cellHead.BorderColor = System.Drawing.Color.FromName("#CCCCCC");
cellHead.HorizontalAlign = HorizontalAlign.Left;
cellHead.Width = 260; cellbody.BorderColor = System.Drawing.Color.FromName("#CCCCCC");
//cellbody.BackColor = System.Drawing.Color.FromName("#EFEFEF");
cellbody.BorderWidth = 0;
cellbody.HorizontalAlign = HorizontalAlign.Left;
cellbody.Width = 100; cellContent.BorderColor = System.Drawing.Color.FromName("#CCCCCC");
//cellContent.BackColor = System.Drawing.Color.FromName("#EFEFEF");
cellContent.BorderWidth = 0;
cellContent.HorizontalAlign = HorizontalAlign.Left;
cellContent.Width = 200;
row.Cells.Add(cellHead);
row.Cells.Add(cellbody);
row.Cells.Add(cellContent);
row.Cells.Add(cellContent1); row.Height = 22; this.tabedit.BorderColor = System.Drawing.Color.FromName("#CCCCCC");
this.tabedit.Rows.Add(row);
} if (this.tabedit.Rows.Count > 0)
{
TableRow row1 = new TableRow();
TableCell cellHead1 = new TableCell();
TableCell cellbody1 = new TableCell();
Button btnserach = new Button();
Button btnreset = new Button(); row1.Height =70; btnserach.ID="btnserach";
btnserach.Text="查 询";
btnserach.Width=80;
cellHead1.Controls.Add(btnserach); btnreset.ID="btnreset";
btnreset.Text="重 置";
btnreset.Width=80;
cellbody1.Controls.Add(btnreset); cellHead1.BorderColor = System.Drawing.Color.FromName("#CCCCCC");
//cellbody.BackColor = System.Drawing.Color.FromName("#EFEFEF");
cellHead1.BorderWidth = 0;
cellHead1.HorizontalAlign = HorizontalAlign.Center;
//cellHead1.Width = 200; cellbody1.BorderColor = System.Drawing.Color.FromName("#CCCCCC");
//cellContent.BackColor = System.Drawing.Color.FromName("#EFEFEF");
cellbody1.BorderWidth = 0;
cellbody1.HorizontalAlign = HorizontalAlign.Center;
//cellbody1.Width = 200; row1.Cells.Add(cellHead1);
row1.Cells.Add(cellbody1); this.tabedit.Rows.Add(row1);
}
} protected void DdlAuditing_SelectedIndexChanged(object sender, EventArgs e)
{
//获得触发控件的ID
DropDownList DdlAuditing = (DropDownList)sender;
string id = DdlAuditing.ID.ToString();
Response.Write(id);
}
}
if (!this.Page.IsPostBack)的外面