checkbox的复选框查询

最新推荐文章于 2020-03-27 15:30:43 发布

iteye_8644

最新推荐文章于 2020-03-27 15:30:43 发布

阅读量633

点赞数

文章标签：数据库开发工具 java

本文介绍了一个用于筛选中标状态的前后端实现方案。通过三个复选框（未中标、中标、撤销发布），用户可以灵活选择不同的中标状态进行过滤。后端根据用户的选择动态构建SQL查询条件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前台： <td nowrap align="right"> 中标状态： </td> <td colspan="2"> <table> <tr> <td> <asp:CheckBox ID="cb_notBidding" runat="server" Text="未中标" /> </td> <td> <asp:CheckBox ID="cb_haveBidding" runat="server" Text="中标" /> </td> <td> <asp:CheckBox ID="cb_cancelPublish" runat="server" Text="撤销发布" /> </td> </tr> </table> </td> 后台： string winState = string.Empty; if (cb_notBidding.Checked) { winState = " and ("; filter += winState + string.Format(V_IB3_IBINFOLST.Col_WINSTATEID + "= '{0}'", Convert.ToInt32(SHIB3.Business.Text.EvaluateIBResult.Fail)); } if (cb_haveBidding.Checked) { if (winState == " and (") { winState = " or "; } else if (winState == " or ") { winState = " or "; } else { winState = " and ("; } filter += winState + string.Format(V_IB3_IBINFOLST.Col_WINSTATEID + "= '{0}'", Convert.ToInt32(SHIB3.Business.Text.EvaluateIBResult.Win)); } if (cb_cancelPublish.Checked) { if (winState == " and (") { winState = " or "; } else if (winState == " or ") { winState = " or "; } else { winState = " and ("; } filter += winState + string.Format(V_IB3_IBINFOLST.Col_WINSTATEID + "= '{0}'", Convert.ToInt32(SHIB3.Business.Text.EvaluateIBResult.UdoRelease)); } if (!string.IsNullOrEmpty(winState)) { filter += ")"; }