ECS/frm/formLogQuery.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace ECS.frm
{
    public partial class formLogQuery : Form
    {
        public formLogQuery()
        {
            InitializeComponent();
            dataGridView1.AutoGenerateColumns = false;
            PagingUC.PagingUC.Get_Paging += new PagingUC.PagingUC.GetPaging(Paging);
        }

        private void formAlarmQuery_Load(object sender, EventArgs e)
        {
            dtp_ddatestart.Value = DateTime.Now.AddDays(-1);
        }

        private void btQuery_Click(object sender, EventArgs e)
        {
            QueryData();
        }

        /// <summary>
        /// 初始化查询
        /// </summary>
        private void QueryData()
        {
            //记录总数
            pagingUC1.Count = Convert.ToInt32(SQLHelper.ExecuteDt(String.Format("select count(1) from tpb_useroptlog where {0}", ReturnQueryWhere())).Rows[0][0]);
            if (pagingUC1.Count > 0)
                //翻页查询
                Paging();
            else
                dataGridView1.DataSource = null;
        }

        /// <summary>
        /// 返回查询条件
        /// </summary>
        /// <returns></returns>
        private string ReturnQueryWhere()
        {
            string str = string.Format("ddate>='{0}' and ddate<'{1}'", dtp_ddatestart.Value.Date, dtp_ddateend.Value.Date.AddDays(1));
            if (!string.IsNullOrEmpty(tBType.Text.Trim()))
                str += string.Format(" and COPTTYPE like '%{0}%'", tBType.Text.Trim());
            if (!string.IsNullOrEmpty(tBcremark.Text.Trim()))
                str += string.Format(" and cremark like '%{0}%'", tBcremark.Text.Trim());
            return str;
        }

        /// <summary>
        /// 翻页
        /// </summary>