C#个人重构之按照日期查询

【人参果】

技术点：

1、在dateTimePicker1控件上获取时间。

2、比较两个时间是否合适，一个小方法

3、定义时间实体

4、D层的SQL语句

【披荆斩棘】

代码：

U层：

        DateTime dtStart;
        DateTime dtEnd;
  

        private void btnLookUp_Click(object sender, EventArgs e)
        {
            dtStart = Convert.ToDateTime(dateTimePicker1.Value.Date.ToString("yyyy-MM-dd"));
            dtEnd = Convert.ToDateTime(dateTimePicker2.Value.Date.ToString("yyyy-MM-dd"));

            Entity.TimeHelper TimeInfo = new Entity.TimeHelper();
            TimeInfo.DtStart = dtStart.ToString("yyyy-MM-dd");
            TimeInfo.DtEnd = dtEnd.ToString("yyyy-MM-dd");

            if (DateTime.Compare(dtStart,dtEnd)>=0)
            {
                MessageBox.Show("选择时间不合适！");
            }
            else
            {          
                Facade.QueryFacade facadeQueryOperatorRechargeRecordInfo = new Facade.QueryFacade();
                List<Entity.RechargeRecordInfo> List = new List<Entity.RechargeRecordInfo>();
                List = facadeQueryOperatorRechargeRecordInfo.queryOperatorRechargeRecordInfo(TimeInfo);
                dataGridView1.DataSource = List;
            }
        }

D层：

        #region 收取金额查询
        public List<Entity.RechargeRecordInfo> queryOperatorRechargeRecordInfo(Entity.TimeHelper TimeInfo)
        {
            SqlHelper.SqlHelperAll sqlHelperQueryOperatorRechargeRecordInfo = new SqlHelper.SqlHelperAll();
            string sql = "select * from RechargeRecord_Info where RechargeDate between @RechargeDateStart and @RechargeDateEnd ";          
            SqlParameter[] sqlparams = { new SqlParameter("@RechargeDateStart", TimeInfo.DtStart), new SqlParameter("@RechargeDateEnd", TimeInfo.DtEnd) };
            DataTable result = sqlHelperQueryOperatorRechargeRecordInfo.ExecuteNomQuery(sql, CommandType.Text, sqlparams);
            ConvertHelper ct = new ConvertHelper();
            List<Entity.RechargeRecordInfo> List =  new List<Entity.RechargeRecordInfo>();
            List = ct.convertToList <Entity.RechargeRecordInfo>(result);
            return List;   
        }
        #endregion

【仙人指路】

太上老君：苏西月——细节的注意

原始天尊：皮皮虾——解决实际问题的思路

通天教主：世代庄少主——坚持到底，最后自己解决了

【筋斗云】