Пример #1
0
        /// <summary>
        ///查询事件
        /// </summary>
        /// <param name="s"></param>
        /// <param name="e"></param>
        protected void btnSearch_Click(object s, EventArgs e)
        {
            string statr       = StartDate.Value;
            string end         = EndDate.Value;
            string sort        = "ga_zffs_id";
            string order       = "DESC";
            int    currentPage = Pager.CurrentPageIndex;

            string where = "where 1=1 ";

            if (statr != "")
            {
                where += " and ga_Type=110 and  datediff (second,ga_date,'" + statr + "')<0 ";
            }
            if (end != "")
            {
                where += " and datediff(second,ga_date,'" + end + "')>0 ";
            }
            if (OrderNo.Value != "")
            {
                where += " and ga_number like '%" + OrderNo.Value + "%'";
            }
            this.rep1.DataSource = gaBll.GetMethPayMoneyPage1(sort, order, currentPage, pageSize, where);
            this.rep1.DataBind();
        }