DBUtility/ProjectVDB.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DBUtility
{
    public class ProjectVDB
    {
        /// <summary>
        /// 返回结果集
        /// </summary>
        /// <returns></returns>
        public DataSet GetList()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" select [nianfen],[value],[value2] from [dbo].[Table]");
            return DbHelperSQL.Query(strSql.ToString());
        }

        #region 顶部
        /// <summary>
        /// 全部项目数/已完成数
        /// </summary>
        /// <returns></returns>
        public DataSet GetListAll()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" SELECT count(distinct field0003) as '全部项目数',(SELECT count(distinct field0003) FROM formson_0765 where field0026 = 1 ) as '已完成项目数'  ");
            strSql.Append(" from formson_0765  ");
            return DbHelperSQL.Query(strSql.ToString());
        }
        /// <summary>
        /// 项目总进度本周各节点完成情况
        /// </summary>
        /// <returns></returns>
        public DataSet GetListAllweek()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" SELECT count(CASE WHEN field0024=0 THEN 0 END) as '本周一级节点',count(CASE WHEN field0024=1 THEN 0 END) as '本周三级节点'  ");
            strSql.Append(" from formson_0765  ");
            strSql.Append(" where (DATEDIFF(week,field0008,GETDATE())=0) and field0026 =1  ");
            return DbHelperSQL.Query(strSql.ToString());
        }
        /// <summary>
        /// 各个项目各个节点本周完成数/应完成数
        /// </summary>
        /// <param name="type">field0020(0工程1科研)</param>
        /// <param name="jiedian">field0024(0一级1三级)</param>
        /// <returns></returns>
        public DataSet GetListWeek(int type, int jiedian)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" SELECT count(*) as '本周应完成数',count(CASE WHEN field0026=1 THEN 0 END) as '本周完成数' ");
            strSql.Append(" from formson_0765  ");
            strSql.Append(" where (DATEDIFF(week,field0008,GETDATE())=0) and field0020 = " + type + " and field0024 = " + jiedian + "  ");
            return DbHelperSQL.Query(strSql.ToString());
        }