2010年9月17日
选择access中的所有的表
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name;

 

以上SQL语句就是选择access所有的表的SQL语句的，本来想直接写SQL语句把每个表的记录数给统计出来的，不过还没有找到办法，只能是先取出所有的表了，然后在外面用程序来计算记录数了 

 

posted @ 2010-09-17 11:54 牛腩 阅读(29) 评论(0) 编辑
获取本周的周一和周日
代码
        // 获取本周的周一
        public string GetThisWeekMonday()
        {
            DateTime date = DateTime.Now;
            DateTime first = System.DateTime.Now;
            switch (date.DayOfWeek)
            {
                case System.DayOfWeek.Monday:
                    first = date;
                    break;
                case System.DayOfWeek.Tuesday:
                    first = date.AddDays(-1);
                    break;
                case System.DayOfWeek.Wednesday:
                    first = date.AddDays(-2);
                    break;
                case System.DayOfWeek.Thursday:
                    first = date.AddDays(-3);
                    break;
                case System.DayOfWeek.Friday:
                    first = date.AddDays(-4);
                    break;
                case System.DayOfWeek.Saturday:
                    first = date.AddDays(-5);
                    break;
                case System.DayOfWeek.Sunday:
                    first = date.AddDays(-6);
                    break;
            }
            return first.ToString("yyyy-MM-dd");
        }


        // 获取本周的周日
        public string GetThisWeekSunday()
        {
            DateTime date = DateTime.Now;
            DateTime last = System.DateTime.Now;
            switch (date.DayOfWeek)
            {
                case System.DayOfWeek.Monday:
                    last = date.AddDays(6);
                    break;
                case System.DayOfWeek.Tuesday:
                    last = date.AddDays(5);
                    break;
                case System.DayOfWeek.Wednesday:
                    last = date.AddDays(4);
                    break;
                case System.DayOfWeek.Thursday:
                    last = date.AddDays(3);
                    break;
                case System.DayOfWeek.Friday:
                    last = date.AddDays(2);
                    break;
                case System.DayOfWeek.Saturday:
                    last = date.AddDays(1);
                    break;
                case System.DayOfWeek.Sunday:
                    last = date;
                    break;
            }
            return last.ToString("yyyy-MM-dd");
        }

 

posted @ 2010-09-17 11:51 牛腩 阅读(52) 评论(0) 编辑