MKCQ

備忘:

 

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

//SELECT DISTINCT [字段名] ,[其他字段名] FROM [表名] WHERE [检索条件字句]
//SELECT * FROM TEST WHERE id in (SELECT MIN(id) FROM TEST GROUP BY B)


namespace Csharp_MKCQ
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            txtDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
        }

        private void btnExport_Click(object sender, EventArgs e)
        {
            StringBuilder sb = new StringBuilder();
            DateTime morningFrom = DateTime.Parse(txtDate.Text+" 06:00");
            DateTime morningTo = DateTime.Parse(txtDate.Text + " 09:00");

            DateTime nooningFrom = DateTime.Parse(txtDate.Text + " 11:30");
            DateTime nooningTo = DateTime.Parse(txtDate.Text + " 13:30");

            DateTime afternoonFrom = DateTime.Parse(txtDate.Text + " 17:00");
            DateTime afternoonTo = DateTime.Parse(txtDate.Text + " 19:00");

            DateTime nightFrom = DateTime.Parse(txtDate.Text + " 23:00");
            DateTime nightTo = DateTime.Parse(txtDate.Text + " 00:30").AddDays(1);

            DateTime date = DateTime.Parse(txtDate.Text.Trim());

            //sb.Append("SELECT '早餐' AS [TYPE], MIN(CHECKTIME) AS MIN_TIME, USERID FROM CHECKINOUT WHERE CHECKTIME>=@MORNING_FROM AND CHECKTIME<=@MORNING_TO  GROUP BY USERID");
            //sb.Append(" UNION ALL ");
            //sb.Append("SELECT '中餐' AS [TYPE], MIN(CHECKTIME) AS MIN_TIME, USERID FROM CHECKINOUT  WHERE CHECKTIME>=@NOONING_FROM AND CHECKTIME<=@NOONING_TO  GROUP BY USERID");
            //sb.Append(" UNION ALL ");
            //sb.Append("SELECT '晚餐' AS [TYPE], MIN(CHECKTIME) AS MIN_TIME, USERID FROM CHECKINOUT  WHERE CHECKTIME>=@AFTERNOON_FROM AND CHECKTIME<=@AFTERNOON_TO  GROUP BY USERID");
            //sb.Append(" UNION ALL ");
            //sb.Append("SELECT '夜宵' AS [TYPE], MIN(CHECKTIME) AS MIN_TIME, USERID FROM CHECKINOUT  WHERE CHECKTIME>=@NIGHT_FROM AND CHECKTIME<=@NIGHT_TO  GROUP BY USERID");


            //OleDbParameter[] paras ={ new OleDbParameter("@MORNING_FROM",morningFrom),
            //                            new OleDbParameter("@MORNING_FROM",morningTo),
            //                            new OleDbParameter("@NOONING_FROM",nooningFrom),
            //                            new OleDbParameter("@NOONING_TO",nooningTo),
            //                            new OleDbParameter("@AFTERNOON_FROM",afternoonFrom),
            //                            new OleDbParameter("@AFTERNOON_TO",afternoonTo),
            //                            new OleDbParameter("@NIGHT_FROM",nightFrom),
            //                            new OleDbParameter("@NIGHT_TO",nightTo)
            //                        };

            sb.Append("SELECT SWITCH(CHECKTIME>=@MORNING_FROM AND CHECKTIME<=@MORNING_TO,'早餐',CHECKTIME>=@NOONING_FROM AND CHECKTIME<=@NOONING_TO,'午餐') AS [TYPE], CHECKTIME AS MIN_TIME, USERID FROM CHECKINOUT ");
            //sb.Append(" UNION ALL ");
            //sb.Append("SELECT '中餐' AS [TYPE], MIN(CHECKTIME) AS MIN_TIME, USERID FROM CHECKINOUT  WHERE CHECKTIME>=@NOONING_FROM AND CHECKTIME<=@NOONING_TO  GROUP BY USERID");
            //sb.Append(" UNION ALL ");
            //sb.Append("SELECT '晚餐' AS [TYPE], MIN(CHECKTIME) AS MIN_TIME, USERID FROM CHECKINOUT  WHERE CHECKTIME>=@AFTERNOON_FROM AND CHECKTIME<=@AFTERNOON_TO  GROUP BY USERID");
            //sb.Append(" UNION ALL ");
            //sb.Append("SELECT '夜宵' AS [TYPE], MIN(CHECKTIME) AS MIN_TIME, USERID FROM CHECKINOUT  WHERE CHECKTIME>=@NIGHT_FROM AND CHECKTIME<=@NIGHT_TO  GROUP BY USERID");


            OleDbParameter[] paras ={ new OleDbParameter("@MORNING_FROM",morningFrom),
                                        new OleDbParameter("@MORNING_FROM",morningTo),
                                        new OleDbParameter("@NOONING_FROM",nooningFrom),
                                        new OleDbParameter("@NOONING_TO",nooningTo)
                                        //new OleDbParameter("@AFTERNOON_FROM",afternoonFrom),
                                        //new OleDbParameter("@AFTERNOON_TO",afternoonTo),
                                        //new OleDbParameter("@NIGHT_FROM",nightFrom),
                                        //new OleDbParameter("@NIGHT_TO",nightTo)
                                    };
            DataTable dt = clAccess.ExecuteDataSet(sb.ToString(),paras).Tables[0];
            gvDetails.DataSource=dt;
           
        }
    }
}

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
项目:使用AngularJs编写的简单 益智游戏(附源代码)  这是一个简单的 javascript 项目。这是一个拼图游戏,也包含一个填字游戏。这个游戏玩起来很棒。有两个不同的版本可以玩这个游戏。你也可以玩填字游戏。 关于游戏 这款游戏的玩法很简单。如上所述,它包含拼图和填字游戏。您可以通过移动图像来玩滑动拼图。您还可以选择要在滑动面板中拥有的列数和网格数。 另一个是填字游戏。在这里你只需要找到浏览器左侧提到的那些单词。 要运行此游戏,您需要在系统上安装浏览器。下载并在代码编辑器中打开此项目。然后有一个 index.html 文件可供您修改。在命令提示符中运行该文件,或者您可以直接运行索引文件。使用 Google Chrome 或 FireFox 可获得更好的用户体验。此外,这是一款多人游戏,双方玩家都是人类。 这个游戏包含很多 JavaScript 验证。这个游戏很有趣,如果你能用一点 CSS 修改它,那就更好了。 总的来说,这个项目使用了很多 javascript 和 javascript 库。如果你可以添加一些具有不同颜色选项的级别,那么你一定可以利用其库来提高你的 javascript 技能。 演示: 该项目为国外大神项目,可以作为毕业设计的项目,也可以作为大作业项目,不用担心代码重复,设计重复等,如果需要对项目进行修改,需要具备一定基础知识。 注意:如果装有360等杀毒软件,可能会出现误报的情况,源码本身并无病毒,使用源码时可以关闭360,或者添加信任。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值