//查询
protected void Button1_Click(object sender, EventArgs e)
{
string name = this.txtId.Text;
string xingm = this.txtName.Text;
QPS.NEW.BLL.Orderform of = new QPS.NEW.BLL.Orderform();
if (name != "" && xingm != "")
{
ds = of.SelectList(Convert.ToInt32(name), xingm);
}
else
{
if (name != "")
{
ds = of.SelectList(Convert.ToInt32(name));
}
else if (xingm != "")
{
ds = of.SelectList(xingm);
}
}
//ds = of.SelectList("id = '" + name + "' or (select UserName From Users where id= o.Userid) = '" + xingm + "' ");
dgExamProj.DataSource = ds;
dgExamProj.DataBind();
}
//查询
protected void Button3_Click(object sender, EventArgs e)
{
string Rname = this.TextRname.Text;
//string zhuangt = this.TextType.Text;
QPS.NEW.BLL.Orderform of = new QPS.NEW.BLL.Orderform();
ds = of.SelectList("(select Name from Room where id=o.roomid)= '" + Rname + "' ");
dgExamProj.DataSource = ds;
dgExamProj.DataBind();
}
//查询
protected void Button1_Click(object sender, EventArgs e)
{
string name = this.txtId.Text;
string xingm = this.txtName.Text;
QPS.NEW.BLL.Orderform of = new QPS.NEW.BLL.Orderform();
if (name != "" && xingm != "")
{
ds = of.SelectList(Convert.ToInt32(name), xingm);
}
else
{
if (name != "")
{
ds = of.SelectList( Convert.ToInt32(name));
}
else if (xingm != "")
{
ds = of.SelectList(xingm);
}
}
//ds = of.SelectList("id = '" + name + "' or (select UserName From Users where id= o.Userid) = '" + xingm + "' ");
dgExamProj.DataSource = ds;
dgExamProj.DataBind();
}
//查询
protected void Button3_Click(object sender, EventArgs e)
{
string Rname = this.TextRname.Text;
//string zhuangt = this.TextType.Text;
QPS.NEW.BLL.Orderform of = new QPS.NEW.BLL.Orderform();
ds = of.SelectList("(select Name from Room where id=o.roomid)= '" + Rname + "' ");
dgExamProj.DataSource = ds;
dgExamProj.DataBind();
}
