/// <summary> /// 条件查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) { Business.Users.User tjuser = new Business.Users.User(); DataTable usersj = new DataTable(); if (this.TextBoxXH.Text == "" && this.TextBoxXM.Text == "") { usersj = tjuser.GetUserList(""); } else if (this.TextBoxXH.Text != "" && this.TextBoxXM.Text != "") { string sqltj = " where Sno like '"+this.TextBoxXH.Text+"%' and Name like '"+this.TextBoxXM.Text+"%'"; usersj = tjuser.GetUserList(sqltj); } else if (this.TextBoxXH.Text != "" && this.TextBoxXM.Text == "") { string sqltj = " where Sno like '" + this.TextBoxXH.Text + "%'"; usersj = tjuser.GetUserList(sqltj); } else if (this.TextBoxXH.Text == "" && this.TextBoxXM.Text != "") { string sqltj = " where Name like '" + this.TextBoxXM.Text + "%'"; usersj = tjuser.GetUserList(sqltj); } this.LabelInfo.Text = "共有用户数据" + usersj.Rows.Count + "条"; this.GridView1.DataSource = usersj; GridView1.DataBind(); }
/// <summary> /// 条件查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) { Business.Users.User tjuser = new Business.Users.User(); DataTable usersj = new DataTable(); if (this.TextBoxXH.Text == "" && this.TextBoxXM.Text == "") { usersj = tjuser.GetUserList(""); } else if (this.TextBoxXH.Text != "" && this.TextBoxXM.Text != "") { string sqltj = " where Sno like '" + this.TextBoxXH.Text + "%' and Name like '" + this.TextBoxXM.Text + "%'"; usersj = tjuser.GetUserList(sqltj); } else if (this.TextBoxXH.Text != "" && this.TextBoxXM.Text == "") { string sqltj = " where Sno like '" + this.TextBoxXH.Text + "%'"; usersj = tjuser.GetUserList(sqltj); } else if (this.TextBoxXH.Text == "" && this.TextBoxXM.Text != "") { string sqltj = " where Name like '" + this.TextBoxXM.Text + "%'"; usersj = tjuser.GetUserList(sqltj); } this.LabelInfo.Text = "共有用户数据" + usersj.Rows.Count + "条"; this.GridView1.DataSource = usersj; GridView1.DataBind(); }
/// <summary> /// 数据绑定 /// </summary> public void DataShow() { Business.Users.User userlist = new Business.Users.User(); DataTable usersj = userlist.GetUserList(""); if (usersj.Rows.Count > 0) { this.LabelInfo.Text = "共有用户数据" + usersj.Rows.Count + "条"; this.GridView1.DataSource = usersj; GridView1.DataBind(); } else { this.LabelInfo.Text = "暂无用户数据!"; } }