大米番茄

需求

  闲话不多说，先说要达到什么样的效果

   

  看着很简单吧，确实也挺简单

查询数据库

        /// <summary>
        /// 查询中断/完成任务（默认七天）
        /// </summary>
        /// <param name="Implement">中断/完成参数</param>
        /// <returns></returns>       
        public List<T_ImplementEntity> InquiryFinishAndInterrupt(T_ImplementEntity  enImplement)
        {
            DataTable dt = new DataTable();           
            SQLiteParameter[] paras = new SQLiteParameter[] { new SQLiteParameter("@is_finish",enImplement.Is_Finish),
                                                              new SQLiteParameter("@date",enImplement.Date.ToString())};
            string sql = "select * from t_Implement where is_finish=@is_finish and date=@date";
            dt = sqlitehelper.ExecuteQuery(sql,paras);
            List<T_ImplementEntity> list = new List<T_ImplementEntity>();
            if (dt.Rows.Count > 0)
            {
                ConvertToList Ctl = new ConvertToList();
                list = Ctl.TableToList<T_ImplementEntity>(dt);
            }
            return list;
        }

        /// <summary>
        /// 根据四象限查询任务
        /// </summary>
        /// <param name="PlanLevel">四象限名称</param>
        /// <returns></returns>
        public List<T_PlanlevelEntity> InquiryQuadrant(T_PlanlevelEntity  enPlanLevel)
        {
            DataTable dt = new DataTable();
            SQLiteParameter[] paras = new SQLiteParameter[] { new SQLiteParameter("@level_name",enPlanLevel.Level_name),
                                                                             new SQLiteParameter("@date",enPlanLevel.Level_Date)};
            string sql = "select * from t_Implement where plan_id in (select id from t_plan where plan_level_id = (select id from t_planlevel where level_name=@level_name)) and date=@date";
            dt = sqlitehelper.ExecuteQuery(sql,paras);
            List<T_PlanlevelEntity> list = new List<T_PlanlevelEntity>();
            if (dt.Rows.Count > 0)
            {
                ConvertToList Ctl = new ConvertToList();
                list = Ctl.TableToList<T_PlanlevelEntity>(dt);
            }
            return list;
        }

结果

  

小结：

   也算是根据不同的需求，产生不同的结果吧，实际上在根据需求的基础上也参考了时间和能力，工具会不断完善，在这个项目中学到的就是愿意尝试去理解，去思考去动手实践，不断总结不断学习。