编写搜索功能的一点点体会

最新推荐文章于 2024-07-19 13:39:06 发布

yaoyao159

最新推荐文章于 2024-07-19 13:39:06 发布

阅读量651

点赞数

分类专栏： .Net学习笔记文章标签： dataset asp hyperlink server string delete

本文链接：https://blog.csdn.net/yaoyao159/article/details/5221864

版权

.Net学习笔记专栏收录该内容

10 篇文章 0 订阅

订阅专栏

还是之前的系统（说是说项目管理系统，不过说是计划管理系统可能更容易理解吧，呵呵），需要有查询功能。要做查询，最主要是用户需要查哪些信息，再写SQL语句啦，不然就要做无用啦。

还有一点要注意么，就是能用列表表示出来的，就尽量用列表表示出来，尽量减少用户的输入量，呵呵。

又来贴代码了，嘻嘻

查询页面asp页面，查询条件--状态、级别、分类、负责人都是用dropdownlist控件直接绑定数据库的信息（像这些信息，基本都是一样的，在系统中也是要多次用到，最好就用一个参数表把信息存在数据库中）

实现根据关键字/关键字+列表（or的关系，选中列表的信息都会显示出来）/列表（同样的，也是or的关系）/全部信息（没有输入，也没有选择列表项）

.cs代码：

public void bind() { //级别dropdownlist绑定数据 string sqlProMngLev = "select * from tbProMngPara where ParaName='级别'"; SqlDataAdapter daProMngLev = new SqlDataAdapter(sqlProMngLev, con); DataSet dsProMngLev = new DataSet(); con.Open(); daProMngLev.Fill(dsProMngLev); DdlProLevel.DataSource = dsProMngLev; DdlProLevel.DataTextField = "ParaDtl"; DdlProLevel.DataValueField = "ParaId"; DdlProLevel.DataBind(); DdlProLevel.Items.Insert(0, "请选择");//添加“请选择一项” con.Close(); //分类dropdownlist绑定数据 string sqlProMngSort = "select * from tbProMngPara where ParaName='分类'"; SqlDataAdapter daProMngSort = new SqlDataAdapter(sqlProMngSort, con); DataSet dsProMngSort = new DataSet(); con.Open(); daProMngSort.Fill(dsProMngSort); DdlProSort.DataSource = dsProMngSort; DdlProSort.DataTextField = "ParaDtl"; DdlProSort.DataValueField = "ParaId"; DdlProSort.DataBind(); DdlProSort.Items.Insert(0, "请选择"); con.Close(); //状态dropdownlist绑定数据 string sqlProMngSt = "select * from tbProMngPara where ParaName='状态'"; SqlDataAdapter daProMngSt = new SqlDataAdapter(sqlProMngSt, con); DataSet dsProMngSt = new DataSet(); con.Open(); daProMngSt.Fill(dsProMngSt); DdlProState.DataSource = dsProMngSt; DdlProState.DataTextField = "ParaDtl"; DdlProState.DataValueField = "ParaId"; DdlProState.DataBind(); DdlProState.Items.Insert(0, "请选择"); con.Close(); //负责人dropdownlist绑定数据 string sqlProMngDirector = "select * from tbProMngPara where ParaName='负责人'"; SqlDataAdapter daProMngDirector = new SqlDataAdapter(sqlProMngDirector, con); DataSet dsProMngDirector = new DataSet(); con.Open(); daProMngDirector.Fill(dsProMngDirector); DdlProDirector.DataSource = dsProMngDirector; DdlProDirector.DataTextField = "ParaDtl"; DdlProDirector.DataValueField = "ParaId"; DdlProDirector.DataBind(); DdlProDirector.Items.Insert(0, "请选择"); con.Close();

查询结果显示在另一个页面中，显示每一个项目下的信息，若没有查找到，就会显示提示信息。

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ProSearch.aspx.cs" Inherits="ProSearch" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server"> <title>查询项目信息</title> </head> <body> <form id="form1" runat="server"> <div style="text-align:center" mce_style="text-align:center"> <table id="Table1" runat="server" style="width: 85%" > <tr> <td style="height: 20px;"> <asp:Label ID="LblProTrd" runat="server" Text="查询结果" Width="106px"></asp:Label></td> </tr> <tr> <td style="text-align: center" mce_style="text-align: center"><asp:Label ID="ShwErr" runat="server"></asp:Label> </td> </tr> <tr> <td style="text-align: center" mce_style="text-align: center"> <asp:Label ID="Lbl1" Text="一级项目：" runat="server"></asp:Label> </td> </tr> <tr> <td style="text-align: center" mce_style="text-align: center"> <asp:Label ID="ShwErr1" runat="server"></asp:Label> </td> </tr> <tr> <td style="height: 100%; width: 100%; text-align:center"> <asp:GridView ID="GvPro01" runat="server" AllowPaging="True" AutoGenerateColumns="False" OnPageIndexChanging="GvPro01_PageIndexChanging" OnRowDeleting="GvPro01_RowDeleting" OnRowDataBound="GvPro01_RowDataBound" OnRowUpdating="GvPro01_RowUpdating"> <Columns> <asp:BoundField DataField="Pro01State" HeaderText="状态" /> <asp:BoundField DataField="Pro01ID" HeaderText="项目代码" /> <asp:BoundField DataField="Pro01Name" HeaderText="项目名称" /> <asp:BoundField DataField="Pro01Level" HeaderText="级别" /> <asp:BoundField DataField="Pro01Sort" HeaderText="类别" /> <asp:BoundField DataField="Pro01Director" HeaderText="负责人" /> <asp:BoundField DataField="Pro01FromTime" HeaderText="开始时间"/> <asp:BoundField DataField="Pro01PreEndTime" HeaderText="预计完成"/> <asp:BoundField DataField="Pro01RealEndTime" HeaderText="实际完成"/> <asp:TemplateField HeaderText="子项目"> <ItemTemplate > <asp:HyperLink ID="Pro02Enter" runat="server" Text='Enter' NavigateUrl ='<%# "~/ProSndList.aspx?parent_id="+Eval("Pro01ID") %>'></asp:HyperLink> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <asp:HyperLink ID="Pro01Dtl" runat="server" Text='Detail' NavigateUrl ='<%# "~/ProFstDtl.aspx?dtl_id="+Eval("Pro01ID") %>'></asp:HyperLink> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <asp:LinkButton ID="LinkButtonUpdate" runat="server" CausesValidation="False" CommandName="Update" Text="Edit"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <asp:LinkButton ID="LinkButtonDel" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> <HeaderStyle BackColor="Gray" Font-Bold="True" ForeColor="White" /> </asp:GridView><br> </td> </tr> <tr> <td style="text-align: center" mce_style="text-align: center"> <asp:Label ID="Lbl2" Text="二级项目：" runat="server"></asp:Label> </td> </tr> <tr> <td style="text-align: center" mce_style="text-align: center"> <asp:Label ID="ShwErr2" runat="server"></asp:Label> </td> </tr> <tr> <td style="text-align: center" mce_style="text-align: center"> <asp:GridView ID="GvPro02" runat="server" AllowPaging="True" AutoGenerateColumns="False" OnPageIndexChanging="GvPro02_PageIndexChanging" OnRowDeleting="GvPro02_RowDeleting" OnRowDataBound="GvPro02_RowDataBound" OnRowUpdating="GvPro02_RowUpdating"> <Columns> <asp:BoundField DataField="ID" HeaderText="id" /> <asp:BoundField DataField="Pro02State" HeaderText="状态" /> <asp:BoundField DataField="Pro02ID" HeaderText="项目代码" /> <asp:BoundField DataField="Pro02Name" HeaderText="项目名称" /> <asp:BoundField DataField="Pro02Level" HeaderText="级别" /> <asp:BoundField DataField="Pro02Sort" HeaderText="类别" /> <asp:BoundField DataField="Pro02Director" HeaderText="负责人" /> <asp:BoundField DataField="Pro02FromTime" HeaderText="开始时间"/> <asp:BoundField DataField="Pro02PreEndTime" HeaderText="预计完成"/> <asp:BoundField DataField="Pro02RealEndTime" HeaderText="实际完成"/> <asp:TemplateField HeaderText="子项目"> <ItemTemplate > <asp:HyperLink ID="Pro03Enter" runat="server" Text='Enter' NavigateUrl ='<%# "~/ProTrdList.aspx?Fst_id="+Eval("Pro01ID") +"&Snd_id="+Eval("Pro02ID")%>'></asp:HyperLink> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <asp:HyperLink ID="Pro02Dtl" runat="server" Text='Detail' NavigateUrl ='<%# "~/ProSndDtl.aspx?dtl_id="+Eval("ID") %>'></asp:HyperLink> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <asp:LinkButton ID="LinkButtonUpdate" runat="server" CausesValidation="False" CommandName="Update" Text="Edit"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <asp:LinkButton ID="LinkButtonDel" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> <HeaderStyle BackColor="Gray" Font-Bold="True" ForeColor="White" /> </asp:GridView><br> </td> </tr> <tr> <td style="text-align: center" mce_style="text-align: center"> <table id="Table2" runat="server" style="height:100%; width:100%; text-align:center"> <tr> <td style="height: 100%; width: 100%; text-align:center"> <asp:Label ID="Lbl3" runat="server" Text="三级项目："></asp:Label> </td> </tr> <tr> <td style="height: 100%; width: 100%; text-align:center"> <asp:Label ID="ShwErr3" runat="server"></asp:Label> </td> </tr> <tr> <td style="height: 100%; width: 100%; text-align:center"> <asp:GridView ID="GvPro03" runat="server" AllowPaging="True" AutoGenerateColumns="False" OnPageIndexChanging="GvPro03_PageIndexChanging" OnRowDeleting="GvPro03_RowDeleting" OnRowUpdating="GvPro03_RowUpdating"> <Columns> <asp:BoundField DataField="ID" HeaderText="id" /> <asp:BoundField DataField="Pro03State" HeaderText="状态" /> <asp:BoundField DataField="Pro03ID" HeaderText="项目代码" /> <asp:BoundField DataField="Pro03Name" HeaderText="项目名称" /> <asp:BoundField DataField="Pro03Level" HeaderText="级别" /> <asp:BoundField DataField="Pro03Sort" HeaderText="类别" /> <asp:BoundField DataField="Pro03Director" HeaderText="负责人" /> <asp:BoundField DataField="Pro03FromTime" HeaderText="开始时间"/> <asp:BoundField DataField="Pro03PreEndTime" HeaderText="预计完成"/> <asp:BoundField DataField="Pro03RealEndTime" HeaderText="实际完成"/> <asp:TemplateField> <ItemTemplate> <asp:HyperLink ID="Pro03Dtl" runat="server" Text='Detail' NavigateUrl ='<%# "~/ProTrdDtl.aspx?dtl_id="+Eval("ID") %>'></asp:HyperLink> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <asp:LinkButton ID="LinkButtonUpdate" runat="server" CausesValidation="False" CommandName="Update" Text="Edit"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <asp:LinkButton ID="LinkButtonDel" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" OnClientClick="return confirm('确认要删除吗?')"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> <HeaderStyle BackColor="Gray" Font-Bold="True" ForeColor="White" /> </asp:GridView><br> </td> </tr> <tr> <td style="height: 100%; text-align: center; width: 100%;"> <asp:Button ID="BtnReturn" runat="server" OnClick="BtnReturn_Click" Text="返回首页" /></td> </tr> </table> </td> </tr> </table> </div> </form> </body> </html>

后台代码：

public void bind() { string searchString = Convert.ToString(Request.QueryString["searchcon"]); string searchState = Convert.ToString(Request.QueryString["searchstate"]); string searchSort = Convert.ToString(Request.QueryString["searchsort"]); string searchLevel = Convert.ToString(Request.QueryString["searchlevel"]); string searchDirector = Convert.ToString(Request.QueryString["searchdirector"]); if (searchString == "") { //用户没有输入查询条件，显示全部 if (searchState == "请选择" && searchSort == "请选择" && searchLevel == "请选择" && searchDirector == "请选择") { string sqlPro03All = "select Pro01ID,Pro02ID,Pro03ID,Pro03Name,Pro03Level,Pro03Sort,Pro03Director,Pro03State,replace(CONVERT(Char(10),Pro03FromTime,111),'/','-') as Pro03FromTime,replace(CONVERT(Char(10),Pro03PreEndTime,111),'/','-') as Pro03PreEndTime,replace(CONVERT(Char(10),Pro03RealEndTime,111),'/','-') as Pro03RealEndTime,Pro03Remark,ID from tbPro03"; SqlDataAdapter mydaPro03A = new SqlDataAdapter(sqlPro03All, con); DataSet mydsPro03A = new DataSet(); con.Open(); mydaPro03A.Fill(mydsPro03A, "tbPro03"); GvPro03.DataSource = mydsPro03A; GvPro03.DataKeyNames = new string[] { "ID" };//主键 GvPro03.DataBind(); con.Close(); string sqlPro02All = "select Pro01ID,Pro02ID,Pro02Name,Pro02Level,Pro02Sort,Pro02Director,Pro02State,Pro02AddTime,replace(CONVERT(Char(10),Pro02FromTime,111),'/','-') as Pro02FromTime,replace(CONVERT(Char(10),Pro02PreEndTime,111),'/','-') as Pro02PreEndTime,replace(CONVERT(Char(10),Pro02RealEndTime,111),'/','-') as Pro02RealEndTime,Pro02Remark,ID from tbPro02"; SqlDataAdapter mydaPro02A = new SqlDataAdapter(sqlPro02All, con); DataSet mydsPro02A = new DataSet(); con.Open(); mydaPro02A.Fill(mydsPro02A, "tbPro02"); GvPro02.DataSource = mydsPro02A; GvPro02.DataKeyNames = new string[] { "ID" };//主键 GvPro02.DataBind(); con.Close(); string sqlPro01All = "select Pro01ID,Pro01Name,Pro01Level,Pro01Sort,Pro01Director,Pro01State,Pro01AddTime,replace(CONVERT(Char(10),Pro01FromTime,111),'/','-') as Pro01FromTime,replace(CONVERT(Char(10),Pro01PreEndTime,111),'/','-') as Pro01PreEndTime,replace(CONVERT(Char(10),Pro01RealEndTime,111),'/','-') as Pro01RealEndTime,Pro01Remark from tbPro01"; SqlDataAdapter mydaPro01A = new SqlDataAdapter(sqlPro01All, con); DataSet mydsPro01A = new DataSet(); con.Open(); mydaPro01A.Fill(mydsPro01A, "tbPro01"); GvPro01.DataSource = mydsPro01A; GvPro01.DataKeyNames = new string[] { "Pro01ID" };//主键 GvPro01.DataBind(); con.Close(); if (GvPro02.Rows.Count == 0 && GvPro03.Rows.Count == 0 && GvPro01.Rows.Count == 0) { ShwErr.Text = "查无此信息"; Lbl1.Visible = false; Lbl2.Visible = false; Lbl3.Visible = false; } else { if (GvPro01.Rows.Count != 0) { } else { ShwErr1.Text = "该项目下查无此信息"; } if (GvPro02.Rows.Count != 0) { GvPro02.HeaderRow.Cells[0].Visible = false; int i = 0; for (i = 0; i < GvPro02.Rows.Count; i++) { GvPro02.Rows[i].Cells[0].Visible = false; } } else { ShwErr2.Text = "该项目下查无此信息"; } if (GvPro03.Rows.Count != 0) { GvPro03.HeaderRow.Cells[0].Visible = false; int i = 0; for (i = 0; i < GvPro03.Rows.Count; i++) { GvPro03.Rows[i].Cells[0].Visible = false; } } else { ShwErr3.Text = "该项目下查无此信息"; } } } else { //用户通过下拉列表查询 string sqlPro03 = " select Pro01ID,Pro02ID,Pro03ID,Pro03Name,Pro03Level,Pro03Sort,Pro03Director,Pro03State,replace(CONVERT(Char(10),Pro03FromTime,111),'/','-') as Pro03FromTime,replace(CONVERT(Char(10),Pro03PreEndTime,111),'/','-') as Pro03PreEndTime,replace(CONVERT(Char(10),Pro03RealEndTime,111),'/','-') as Pro03RealEndTime,Pro03Remark,ID from tbPro03 where Pro03Level= '" + searchLevel + "'" + "or Pro03Sort='" + searchSort + "'" + "or Pro03State='" + searchState + "'" + "or Pro03Director='" + searchDirector + "'"; SqlDataAdapter mydaPro03 = new SqlDataAdapter(sqlPro03, con); DataSet mydsPro03 = new DataSet(); con.Open(); mydaPro03.Fill(mydsPro03, "tbPro03"); GvPro03.DataSource = mydsPro03; GvPro03.DataKeyNames = new string[] { "ID" };//主键 GvPro03.DataBind(); con.Close(); string sqlPro01 = "select Pro01ID,Pro01Name,Pro01Level,Pro01Sort,Pro01Director,Pro01State,Pro01AddTime,replace(CONVERT(Char(10),Pro01FromTime,111),'/','-') as Pro01FromTime,replace(CONVERT(Char(10),Pro01PreEndTime,111),'/','-') as Pro01PreEndTime,replace(CONVERT(Char(10),Pro01RealEndTime,111),'/','-') as Pro01RealEndTime,Pro01Remark from tbPro01 where Pro01Level='" + searchLevel + "'" + "or Pro01Sort='" + searchSort + "'" + "or Pro01State='" + searchState + "'" + "or Pro01Director='" + searchDirector + "'"; SqlDataAdapter mydaPro01 = new SqlDataAdapter(sqlPro01, con); DataSet mydsPro01 = new DataSet(); con.Open(); mydaPro01.Fill(mydsPro01, "tbPro01"); GvPro01.DataSource = mydsPro01; GvPro01.DataKeyNames = new string[] { "Pro01ID" };//主键 GvPro01.DataBind(); con.Close(); string sqlPro02 = "select Pro01ID,Pro02ID,Pro02Name,Pro02Level,Pro02Sort,Pro02Director,Pro02State,Pro02AddTime,replace(CONVERT(Char(10),Pro02FromTime,111),'/','-') as Pro02FromTime,replace(CONVERT(Char(10),Pro02PreEndTime,111),'/','-') as Pro02PreEndTime,replace(CONVERT(Char(10),Pro02RealEndTime,111),'/','-') as Pro02RealEndTime,Pro02Remark,ID from tbPro02 where Pro02Level= '" + searchLevel + "'" + "or Pro02Sort='" + searchSort + "'" + "or Pro02State='" + searchState + "'" + "or Pro02Director='" + searchDirector + "'"; SqlDataAdapter mydaPro02 = new SqlDataAdapter(sqlPro02, con); DataSet mydsPro02 = new DataSet(); con.Open(); mydaPro02.Fill(mydsPro02, "tbPro02"); GvPro02.DataSource = mydsPro02; GvPro02.DataKeyNames = new string[] { "ID" };//主键 GvPro02.DataBind(); con.Close(); if (GvPro02.Rows.Count == 0 && GvPro03.Rows.Count == 0 && GvPro01.Rows.Count == 0) { ShwErr.Text = "查无此信息"; Lbl1.Visible = false; Lbl2.Visible = false; Lbl3.Visible = false; } else { if (GvPro01.Rows.Count != 0) { } else { ShwErr1.Text = "该项目下查无此信息"; } if (GvPro02.Rows.Count != 0) { GvPro02.HeaderRow.Cells[0].Visible = false; int i = 0; for (i = 0; i < GvPro02.Rows.Count; i++) { GvPro02.Rows[i].Cells[0].Visible = false; } } else { ShwErr2.Text = "该项目下查无此信息"; } if (GvPro03.Rows.Count != 0) { GvPro03.HeaderRow.Cells[0].Visible = false; int i = 0; for (i = 0; i < GvPro03.Rows.Count; i++) { GvPro03.Rows[i].Cells[0].Visible = false; } } else { ShwErr3.Text = "该项目下查无此信息"; } } } } else { if (searchState == "请选择" && searchSort == "请选择" && searchLevel == "请选择" && searchDirector == "请选择") { string sqlPro03 = " select Pro01ID,Pro02ID,Pro03ID,Pro03Name,Pro03Level,Pro03Sort,Pro03Director,Pro03State,replace(CONVERT(Char(10),Pro03FromTime,111),'/','-') as Pro03FromTime,replace(CONVERT(Char(10),Pro03PreEndTime,111),'/','-') as Pro03PreEndTime,replace(CONVERT(Char(10),Pro03RealEndTime,111),'/','-') as Pro03RealEndTime,Pro03Remark,ID from tbPro03 where Pro03Remark like '%" + searchString + "%'" + "or Pro03Name like '%" + searchString + "%'"; SqlDataAdapter mydaPro03 = new SqlDataAdapter(sqlPro03, con); DataSet mydsPro03 = new DataSet(); con.Open(); mydaPro03.Fill(mydsPro03, "tbPro03"); GvPro03.DataSource = mydsPro03; GvPro03.DataKeyNames = new string[] { "ID" };//主键 GvPro03.DataBind(); con.Close(); string sqlPro01 = "select Pro01ID,Pro01Name,Pro01Level,Pro01Sort,Pro01Director,Pro01State,Pro01AddTime,replace(CONVERT(Char(10),Pro01FromTime,111),'/','-') as Pro01FromTime,replace(CONVERT(Char(10),Pro01PreEndTime,111),'/','-') as Pro01PreEndTime,replace(CONVERT(Char(10),Pro01RealEndTime,111),'/','-') as Pro01RealEndTime,Pro01Remark from tbPro01 where Pro01Remark like '%" + searchString + "%'" + "or Pro01Name like '%" + searchString + "%'"; SqlDataAdapter mydaPro01 = new SqlDataAdapter(sqlPro01, con); DataSet mydsPro01 = new DataSet(); con.Open(); mydaPro01.Fill(mydsPro01, "tbPro01"); GvPro01.DataSource = mydsPro01; GvPro01.DataKeyNames = new string[] { "Pro01ID" };//主键 GvPro01.DataBind(); con.Close(); string sqlPro02 = "select Pro01ID,Pro02ID,Pro02Name,Pro02Level,Pro02Sort,Pro02Director,Pro02State,Pro02AddTime,replace(CONVERT(Char(10),Pro02FromTime,111),'/','-') as Pro02FromTime,replace(CONVERT(Char(10),Pro02PreEndTime,111),'/','-') as Pro02PreEndTime,replace(CONVERT(Char(10),Pro02RealEndTime,111),'/','-') as Pro02RealEndTime,Pro02Remark,ID from tbPro02 where Pro02Remark like '%" + searchString + "%'" + "or Pro02Name like '%" + searchString + "%'"; SqlDataAdapter mydaPro02 = new SqlDataAdapter(sqlPro02, con); DataSet mydsPro02 = new DataSet(); con.Open(); mydaPro02.Fill(mydsPro02, "tbPro02"); GvPro02.DataSource = mydsPro02; GvPro02.DataKeyNames = new string[] { "ID" };//主键 GvPro02.DataBind(); con.Close(); if (GvPro02.Rows.Count == 0 && GvPro03.Rows.Count == 0 && GvPro01.Rows.Count == 0) { ShwErr.Text = "查无此信息"; Lbl1.Visible = false; Lbl2.Visible = false; Lbl3.Visible = false; } else { if (GvPro01.Rows.Count != 0) { } else { ShwErr1.Text = "该项目下查无此信息"; } if (GvPro02.Rows.Count != 0) { GvPro02.HeaderRow.Cells[0].Visible = false; int i = 0; for (i = 0; i < GvPro02.Rows.Count; i++) { GvPro02.Rows[i].Cells[0].Visible = false; } } else { ShwErr2.Text = "该项目下查无此信息"; } if (GvPro03.Rows.Count != 0) { GvPro03.HeaderRow.Cells[0].Visible = false; int i = 0; for (i = 0; i < GvPro03.Rows.Count; i++) { GvPro03.Rows[i].Cells[0].Visible = false; } } else { ShwErr3.Text = "该项目下查无此信息"; } } } else { string sqlPro03 = " select Pro01ID,Pro02ID,Pro03ID,Pro03Name,Pro03Level,Pro03Sort,Pro03Director,Pro03State,replace(CONVERT(Char(10),Pro03FromTime,111),'/','-') as Pro03FromTime,replace(CONVERT(Char(10),Pro03PreEndTime,111),'/','-') as Pro03PreEndTime,replace(CONVERT(Char(10),Pro03RealEndTime,111),'/','-') as Pro03RealEndTime,Pro03Remark,ID from tbPro03 where (Pro03Level= '" + searchLevel + "'" + "or Pro03Sort='" + searchSort + "'" + "or Pro03State='" + searchState + "'" + "or Pro03Director='" + searchDirector + "')" + "and Pro03Remark like '%" + searchString + "%'" + "or Pro03Name like '%" + searchString + "%'"; SqlDataAdapter mydaPro03 = new SqlDataAdapter(sqlPro03, con); DataSet mydsPro03 = new DataSet(); con.Open(); mydaPro03.Fill(mydsPro03, "tbPro03"); GvPro03.DataSource = mydsPro03; GvPro03.DataKeyNames = new string[] { "ID" };//主键 GvPro03.DataBind(); con.Close(); string sqlPro01 = "select Pro01ID,Pro01Name,Pro01Level,Pro01Sort,Pro01Director,Pro01State,Pro01AddTime,replace(CONVERT(Char(10),Pro01FromTime,111),'/','-') as Pro01FromTime,replace(CONVERT(Char(10),Pro01PreEndTime,111),'/','-') as Pro01PreEndTime,replace(CONVERT(Char(10),Pro01RealEndTime,111),'/','-') as Pro01RealEndTime,Pro01Remark from tbPro01 where (Pro01Level='" + searchLevel + "'" + "or Pro01Sort='" + searchSort + "'" + "or Pro01State='" + searchState + "'" + "or Pro01Director='" + searchDirector + "')" + "and Pro01Remark like '%" + searchString + "%'" + "or Pro01Name like '%" + searchString + "%'"; SqlDataAdapter mydaPro01 = new SqlDataAdapter(sqlPro01, con); DataSet mydsPro01 = new DataSet(); con.Open(); mydaPro01.Fill(mydsPro01, "tbPro01"); GvPro01.DataSource = mydsPro01; GvPro01.DataKeyNames = new string[] { "Pro01ID" };//主键 GvPro01.DataBind(); con.Close(); string sqlPro02 = "select Pro01ID,Pro02ID,Pro02Name,Pro02Level,Pro02Sort,Pro02Director,Pro02State,Pro02AddTime,replace(CONVERT(Char(10),Pro02FromTime,111),'/','-') as Pro02FromTime,replace(CONVERT(Char(10),Pro02PreEndTime,111),'/','-') as Pro02PreEndTime,replace(CONVERT(Char(10),Pro02RealEndTime,111),'/','-') as Pro02RealEndTime,Pro02Remark,ID from tbPro02 where (Pro02Level= '" + searchLevel + "'" + "or Pro02Sort='" + searchSort + "'" + "or Pro02State='" + searchState + "'" + "or Pro02Director='" + searchDirector + "')" + "and Pro02Remark like '%" + searchString + "%'" + "or Pro02Name like '%" + searchString + "%'"; SqlDataAdapter mydaPro02 = new SqlDataAdapter(sqlPro02, con); DataSet mydsPro02 = new DataSet(); con.Open(); mydaPro02.Fill(mydsPro02, "tbPro02"); GvPro02.DataSource = mydsPro02; GvPro02.DataKeyNames = new string[] { "ID" };//主键 GvPro02.DataBind(); con.Close(); if (GvPro02.Rows.Count == 0 && GvPro03.Rows.Count == 0 && GvPro01.Rows.Count == 0) { ShwErr.Text = "查无此信息"; Lbl1.Visible = false; Lbl2.Visible = false; Lbl3.Visible = false; } else { if (GvPro01.Rows.Count != 0) { } else { ShwErr1.Text = "该项目下查无此信息"; } if (GvPro02.Rows.Count != 0) { GvPro02.HeaderRow.Cells[0].Visible = false; int i = 0; for (i = 0; i < GvPro02.Rows.Count; i++) { GvPro02.Rows[i].Cells[0].Visible = false; } } else { ShwErr2.Text = "该项目下查无此信息"; } if (GvPro03.Rows.Count != 0) { GvPro03.HeaderRow.Cells[0].Visible = false; int i = 0; for (i = 0; i < GvPro03.Rows.Count; i++) { GvPro03.Rows[i].Cells[0].Visible = false; } } else { ShwErr3.Text = "该项目下查无此信息"; } } } } }

我总觉得我的代码写得有点啰嗦了，嘻嘻，希望各位大侠指教啦。