c#页面查询、数据显示
page :
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="QueryxxxxInfos.ascx.cs" Inherits="DotNetNuke.Modules.HRAddUser.QueryxxxxInfos" %> <asp:Panel ID="panMain" runat="server"> <table> <tr> <td> <table> <tr> <td> <asp:Label ID="Label2" runat="server" Text="xx名称:"></asp:Label></td> <asp:TextBox ID="tbxToxxName" runat="server" Width="220px"></asp:TextBox></td> <asp:Label ID="Label2" runat="server" Text="xxx信息:"></asp:Label></td> <asp:TextBox ID="tbxToxxxColumn" runat="server" Width="220px"></asp:TextBox></td> <td> </tr> <!-- <tr> <td> <asp:Label ID="Label7" runat="server" Text="xxx情况:"></asp:Label></td> <td> <asp:DropDownList ID="ddlxxxxState" runat="server"> <asp:ListItem Selected="True" Text="全部" Value="全部"></asp:ListItem> <asp:ListItem Text="未xxx" Value="未xxx"></asp:ListItem> <asp:ListItem Text="已xxx" Value="已xxx"></asp:ListItem> </asp:DropDownList> </td> </tr>--> <tr> <td> <asp:Button ID="btnselect" runat="server" OnClick="btnselect_Click" Text="查询" /> </td> </tr> </table> </td> </tr> <tr> <td> <asp:GridView ID="gridxxxPages" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" CssClass="GridFont" GridLines="Vertical" PageSize="20" Width="2500px"> <PagerSettings Mode="NumericFirstLast" /> <FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> <Columns> <asp:BoundField DataField="DataTableColumns" HeaderText="名称" ItemStyle-Width="3%"/> <asp:BoundField DataField="DataTableColumns" HeaderText="日期" DataFormatString="{0:yyyy-MM-dd}" /> <asp:BoundField DataField="DataTableColumns" HeaderText="xxx信息" /> </Columns> <RowStyle BackColor="#EEEEEE" ForeColor="Black" /> <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> <HeaderStyle BackColor="#C0C0FF" Font-Bold="True" ForeColor="White" /> <AlternatingRowStyle BackColor="Gainsboro" /> </asp:GridView> </td> </tr> <tr> <td><asp:Label ID="lblMessage" runat="server" ForeColor="Red"></asp:Label></td> </tr> </table> </asp:Panel>
controller:
using System; using System.Data; using System.Web.UI.WebControls; using DotNetNuke.Services.Localization; using DotNetNuke.Security; namespace DotNetNuke.Modules.DataCon { /// <summary> /// xxxx查询界面 /// </summary> public partial class QueryxxxPageInfos : DotNetNuke.Entities.Modules.PortalModuleBase, DotNetNuke.Entities.Modules.IActionable { private DotNetNuke.Modules.DataCon.DataController Dac = new DataController(); private DataTable dtxxxPage; string sWhere = "" ; protected void Page_Load(object sender, EventArgs e) { FillDG(); if (!IsPostBack) { FillUI(); } } private void FillDG() { sWhere = " where 1=1 "; if (tbxToxxName.Text != "") { sWhere += " and xxxxName like '%" + tbxToxxName.Text + "%'"; } if (tbxToxxxColumn.Text != "") { sWhere += " and xxxxColumn like '%" + tbxToxxxColumn.Text + "%'"; } sWhere += " order by xxxPageID "; dtxxxPage = new DataTable(); dtxxxPage = Dac.GetxxxPage(sWhere); } private void FillUI() { gridxxxPages.DataSource = dtxxxPage; gridxxxPages.DataBind(); } protected void btnselect_Click(object sender, EventArgs e) { FillDG(); FillUI(); } #region IActionable 成员 DotNetNuke.Entities.Modules.Actions.ModuleActionCollection DotNetNuke.Entities.Modules.IActionable.ModuleActions { get { Entities.Modules.Actions.ModuleActionCollection Actions = new Entities.Modules.Actions.ModuleActionCollection(); Actions.Add(GetNextActionID(), Localization.GetString(Entities.Modules.Actions.ModuleActionType.AddContent, LocalResourceFile), Entities.Modules.Actions.ModuleActionType.AddContent, "", "", EditUrl(), false, SecurityAccessLevel.Edit, true, false); return Actions; } } #endregion } }
datainfo:
/// <summary> /// 获取xxxxx表 /// </summary> /// <param name="swhere"></param> /// <returns></returns> public DataTable GetxxxInfo(string swhere) { DataTable dataMKPro = new DataTable(); string CommandText = "select ...... from tablename " + swhere; dataMKPro = sqlAccess.ExecuteTable(CommandText); return dataMKPro; }