DWZ查询
后台：sql： <resultMaps>
<resultMap id="E_AnnoucementResult" class="E_Annoucement">
<result property="mRID" column="RID" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFID" column="FID" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFNumber" column="FNumber" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFTitle" column="FTitle" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFDescription" column="FDescription" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFType" column="FType" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFReleasebyName" column="FReleasebyName" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFReleaseby" column="FReleaseby" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFReleaseUnit" column="FReleaseUnit" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFReleaseUnitName" column="FReleaseUnitName" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFReleaseTime" column="FReleaseTime" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mOrgUnitID" column="OrgUnitID" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mLastUpdateby" column="LastUpdateby" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mLastUpdatetime" column="LastUpdatetime" IsPK="false" IsMandatory="true" DefaultVal="" IsList="false" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mCreateby" column="Createby" IsPK="false" IsMandatory="true" DefaultVal="" IsList="false" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mCreatetime" column="Createtime" IsPK="false" IsMandatory="true" DefaultVal="" IsList="false" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFIsSystem" column="FIsSystem" IsPK="false" IsMandatory="true" DefaultVal="" IsList="false" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="mFStatus" column="FStatus" IsPK="false" IsMandatory="true" DefaultVal="" IsList="false" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
</resultMap>
<resultMap id="E_AnnoucementMasterSlaveResult" class="E_AnnoucementMasterSlave">
<result property="Masterid" column="Masterid" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
<result property="SlaveList" column="SlaveList" IsPK="false" IsMandatory="true" DefaultVal="" IsList="true" IsInserted="false" IsUpdated="false" IsQueryCondition="false" IsFK="false" RelationTable="" RelationTablePK="" IsRedundancyField="false" RegExp="" des=""/>
</resultMap>
</resultMaps>
<!--根据编号 名称 查询公告信息列表 --> <select id="QueryAnnoucement" parameterClass="Hashtable" resultMap="E_AnnoucementResult"> <![CDATA[ SELECT row_number() over(order by an.LastUpdatetime desc ) RID ,an.FID ,an.FNumber ,an.FTitle ,an.FDescription ,an.FType ,p.FName_L1 as FReleasebyName ,an.FReleaseby ,an.FReleaseUnit as FReleaseUnit ,(select FNAME_L1 from T_ORG_ORGUNIT where fid=FReleaseUnit) as FReleaseUnitName ,an.FReleaseTime ,an.FReplyContent ,an.FAuditby ,an.FAuditTime ,an.OrgUnitID ,an.LastUpdateby ,an.LastUpdatetime ,an.Createby ,an.CreateTime ,an.FIsSystem ,an.FStatus FROM t_PO_NM_AnnouncementNotice an , t_srm_user u ,t_org_personnel p WHERE u.fpersonid=p.fid and u.fid=an.freleaseby ]]> <dynamic > <!--<isNotEmpty prepend="AND" property="mLoginOrgID"> <![CDATA[ exists (select 'X' from ( select fid from t_org_orgunit o start with o.fid=#mLoginOrgID# connect by prior o.fid =o.fparentid ) a where a.fid=an.orgunitid) ]]> </isNotEmpty>--> <isNotEmpty prepend="AND" property="mFType"> <![CDATA[ an.FType=#mFType# ]]> </isNotEmpty> <isNotEmpty prepend="AND" property="mFReleaseTimeS"> <![CDATA[ to_char(an.FReleaseTime,'yyyy-MM-dd')>=#mFReleaseTimeS# ]]> </isNotEmpty> <isNotEmpty prepend="AND" property="mFReleaseTimeE"> <![CDATA[ to_char(an.FReleaseTime,'yyyy-MM-dd') <=#mFReleaseTimeE# ]]> </isNotEmpty> <isNotEmpty prepend="AND" property="mFTitle"> <![CDATA[ an.FTitle like '%$mFTitle$%' ]]> </isNotEmpty> <isNotEmpty prepend="AND" property="mFStatus"> <![CDATA[ an.FStatus like '%$mFStatus$%' ]]> </isNotEmpty> </dynamic> <![CDATA[order by an.LastUpdatetime desc ]]> </select>
前台页面：<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Test.aspx.cs" Inherits="NM_Test" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title></title> </head> <body> <div class="pageHeader"> <form id="pagerForm" onsubmit="return navTabSearch(this);" action="NM/Test.aspx" runat="server" method="post"> <div class="searchBar"> <input type="hidden" name="pageNum" value="1"/> <input type="hidden" id="page" name="numPerPage" value="<%=mNumPerPage%>" /> <table class="pageFormContent"> <tr> <td>发布时间从：</td> <td> <input type="text" id="FReleaseTimeS" name="FReleaseTimeS" field="FReleaseTimeS" class="date" runat="server"/> <a class="inputDateButton"href="javascript:;">选择</a> </td> <td>至：</td> <td> <input type="text" id="FReleaseTimeE" name="FReleaseTimeE" field="FReleaseTimeE" class="date" runat="server"/> <a class="inputDateButton"href="javascript:;">选择</a> </td> <td>主题：</td> <td> <input type="text" id="FTitle" name="FTitle" field="FTitle" runat="server"/> </td> </tr> </table> <div class="subBar"> <ul> <li id='liMsg'></li> <li> <div class="buttonActive"><div class="buttonContent"><button type="submit" id="btnTestQuery">查询</button></div></div> </li> </ul> </div> </div> </form> </div> <div class="pageContent"> <div class="panelBar"> <ul class="toolBar"> <li><a class="add" href="NM/TestEdit.aspx" target="dialog" rel="公告维护" mask="true" max="true" title="公告维护"><span>添加</span></a></li> <li><a class="edit" href="NM/TestEdit.aspx?FID={fid}" target="dialog" rel="公告维护" mask="true" id="Edit" max="true"><span>修改</span></a></li> <li class="line">line</li> <li><a class="delete" href="#" id="btnTestDelete"><span>删除</span></a></li> <%--<li style="display:block"><a class="icon" href="#" target="dwzExport" targetType="navTab" id="export" onclick="Save()"><span>导出EXCEL</span></a></li>--%> </ul> </div> <table class="table" width="100%" targetType="navTab" Layouth="150" id="tab"> <thead> <tr> <th width="40"><input type="checkbox" group="ids" class="checkboxCtrl"/></th> <th width="40">序号</th> <th>主题</th> <th width="200">发布单位</th> <th width="120">发布人</th> <th width="100">发布时间</th> </tr> </thead> <tbody id="table"> <asp:Repeater ID="rpGrid" runat="server"> <ItemTemplate> <%#DataBinder.Eval(Container.DataItem, "mFID", "<tr target=\"fid\" rel='{0}'>")%> <%#DataBinder.Eval(Container.DataItem, "mFID","<td align='center'><input name='ids' type='checkbox' value='{0}' ></td>")%> <td><%# DataBinder.Eval(Container.DataItem, "mRID")%> </td> <td><a href='NM/TestEdit.aspx?Action=edit&FID=<%#DataBinder.Eval(Container.DataItem, "mFID")%>' target="dialog" rel="公告编辑界面" mask="true" max="true" title="公告编辑界面"> <%# DataBinder.Eval(Container.DataItem, "mFTitle")%></a></td> <td><%# DataBinder.Eval(Container.DataItem, "mFReleaseUnitName")%> </td> <td><%# DataBinder.Eval(Container.DataItem, "mFReleaseByName")%> </td> <td><%# DataBinder.Eval(Container.DataItem, "mFReleaseTime", "{0:yyyy-MM-dd}")%> </td> </tr> </ItemTemplate> </asp:Repeater> </tbody> </table> <div class="panelBar"> <div class="pages"> <span>显示</span> <select id="numPerPage" class="combox" name="numPerPage" onchange="navTabPageBreak({numPerPage:this.value})"> <option value="20">20</option> <option value="50">50</option> <option value="100">100</option> <option value="200">200</option> </select> <span>条，共<%=mTotalCount%>条</span> </div> <div class="pagination" targetType="navTab" totalCount="<%= mTotalCount%>" numPerPage="<%=mNumPerPage%>" pageNumShown="<%=mPageNumShown%>" currentPage="<%=mPageNum %>"></div> </div> </div> </body> </html>
后天代码：using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using SCM.POS.NM.Domain; using SCM.POS.NM.Service; using SCM.POS.BD.Service; using System.Collections; public partial class NM_Test : ERDP.Web.UI.ListPage, IHttpHandler { ERDP.Common.LoginSession _login = new ERDP.Common.LoginSession(); protected void Page_Load(object sender, EventArgs e) { try { _login = GetLoginSession(); if(IsPostBack) { BindDate(); } } catch (Exception ex ) { Response.Write("<script>alertMsg.error("+ex.Message .Replace("'","").Replace("/","")+")</script>"); } } /// <summary> /// 数据绑定，同时需要设置数据总条数，当前页，每天条数 /// 当前页与每页条数由页面中的pagerForm表单回传得到 /// </summary> private void BindDate() { Annoucement annoucement = Annoucement.GetInstance(); IList<E_Annoucement> e_annoucements = null;//返回对象集合 Hashtable QueryPara = new Hashtable(); //开始时间 if (Server.UrlDecode(Request["FReleaseTimeS"]) != "" && Server.UrlDecode(Request["FReleaseTimeS"])!=null) { QueryPara.Add("mFReleaseTimeS", Convert.ToDateTime( Server.UrlDecode(Request["FReleaseTimeS"])).ToString("yyyy-MM-dd"));//加入条件查询参数 } //结束时间 if (Server.UrlDecode(Request["FReleaseTimeE"]) != "" && Server.UrlDecode(Request["FReleaseTimeE"]) != null) { QueryPara.Add("mFReleaseTimeE", Convert.ToDateTime(Server.UrlDecode(Request["mFReleaseTimeE"])).ToString("yyyy-MM-dd"));//加入条件查询参数 } if (Server.UrlDecode(Request["FReleaseTimeS"])!="" && Server.UrlDecode(Request["FReleaseTimeE"])!="") { if (Convert.ToDateTime( Server.UrlDecode(Request["FReleaseTimeS"])) >Convert.ToDateTime( Server.UrlDecode(Request["FReleaseTimeE"]))) { Response.Write("<script type='text/javascript'>alertMsg.info('发布时间(从)大于发布时间（止）');</script>"); return;//调成函数，直接跳出正在执行的函数不执行return后面的代码比如一个方法，一个函数，一次循环等等 } } if (Server.UrlDecode(Request["FTitle"]) != "" && Server.UrlDecode(Request["FTitle"]) != null) { QueryPara.Add("mFTitle", Server.UrlDecode(Request["FTitle"]).Trim()); } QueryPara.Add("mFType", "001"); QueryPara.Add("mLoginOrgID", _login.mOUID); QueryPara.Add("mUserID", _login.mUserID); QueryPara.Add("mPageNum", mPageNum);//页数 QueryPara.Add("mNumPerPage", mNumPerPage); e_annoucements = annoucement.QueryAnnoucement(QueryPara);//查询返回 mTotalCount = e_annoucements.Count;//总条数 if (mTotalCount == 0) { this.rpGrid.DataSource = null; this.rpGrid.DataBind(); Response.Write("<script type='text/javascript'>alertMsg.info('此条件下暂无记录！');</script>"); //绑定 数据源 } else { var list= e_annoucements.Skip((mPageNum-1)*mPageNum).Take(mPageNum);//返回剩余的，从剩余的开始 this.rpGrid.DataSource = list ; this.rpGrid.DataBind(); } } }
清空回声
