/// <summary>
        /// 根据类型获取部门的汇总金额
        /// </summary>
        /// <param name="valueType"></param>
        /// <returns></returns>
        public decimal GetDeptMoney(StatisticValueType valueType, string deptName)
        {
            decimal result = 0M;
            string  sql    = string.Format("Select Sum(Amount) from WM_PurchaseDetail d inner join WM_PurchaseHeader h on d.PurchaseHead_ID = h.ID Where d.Dept='{0}' ", deptName);
            //if (valueType == StatisticValueType.CurrentMoney)
            //{
            //    sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} ", DateTimeHelper.GetServerDateTime2().Year, DateTimeHelper.GetServerDateTime2().Month);
            //}
            //else if (valueType == StatisticValueType.CurrentInMoney)
            //{
            //    sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} and h.OperationType='入库' ", DateTimeHelper.GetServerDateTime2().Year, DateTimeHelper.GetServerDateTime2().Month);
            //}
            //else if (valueType == StatisticValueType.CurrentOutMoney)
            //{
            //    sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} and h.OperationType='出库' ", DateTimeHelper.GetServerDateTime2().Year, DateTimeHelper.GetServerDateTime2().Month);
            //}
            //else if (valueType == StatisticValueType.LastMoney)
            //{
            //    DateTime lastMonth = DateTimeHelper.GetServerDateTime2().AddMonths(-1);
            //    sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} ", lastMonth.Year, lastMonth.Month);
            //}

            string value = baseDal.SqlValueList(sql);

            if (!string.IsNullOrEmpty(value))
            {
                result = Convert.ToDecimal(value);
            }

            return(result);
        }
        /// <summary>
        /// 根据类型获取部门的汇总数量
        /// </summary>
        /// <param name="valueType"></param>
        /// <returns></returns>
        public int GetDeptCount(StatisticValueType valueType, string deptName)
        {
            int    result = 0;
            string sql    = string.Format("Select Sum(Quantity) from WM_PurchaseDetail d inner join WM_PurchaseHeader h on d.PurchaseHead_ID = h.ID Where d.Dept='{0}' ", deptName);

            if (valueType == StatisticValueType.CurrentCount)
            {
                sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} ", DateTime.Now.Year, DateTime.Now.Month);
            }
            else if (valueType == StatisticValueType.CurrentInCount)
            {
                sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} and h.OperationType='入库' ", DateTime.Now.Year, DateTime.Now.Month);
            }
            else if (valueType == StatisticValueType.CurrentOutCount)
            {
                sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} and h.OperationType='出库' ", DateTime.Now.Year, DateTime.Now.Month);
            }
            else if (valueType == StatisticValueType.LastCount)
            {
                DateTime lastMonth = DateTime.Now.AddMonths(-1);
                sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} ", lastMonth.Year, lastMonth.Month);
            }

            string value = baseDal.SqlValueList(sql);

            if (!string.IsNullOrEmpty(value))
            {
                result = Convert.ToInt32(value);
            }

            return(result);
        }
        /// <summary>
        /// 根据类型获取所有库房的备件属类的汇总数量
        /// </summary>
        /// <param name="valueType"></param>
        /// <returns></returns>
        public int GetWareItemBigTypeCount(StatisticValueType valueType, string itemBigType)
        {
            int    result = 0;
            string sql    = string.Format("Select Sum(Quantity) from WM_PurchaseDetail d inner join WM_PurchaseHeader h on d.PurchaseHead_ID = h.ID Where ItemBigType='{0}' ", itemBigType);
            //if (valueType == StatisticValueType.CurrentCount)
            //{
            //    sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} ", DateTimeHelper.GetServerDateTime2().Year, DateTimeHelper.GetServerDateTime2().Month);
            //}
            //else if (valueType == StatisticValueType.CurrentInCount)
            //{
            //    sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} and h.OperationType='入库' ", DateTimeHelper.GetServerDateTime2().Year, DateTimeHelper.GetServerDateTime2().Month);
            //}
            //else if (valueType == StatisticValueType.CurrentOutCount)
            //{
            //    sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} and h.OperationType='出库' ", DateTimeHelper.GetServerDateTime2().Year, DateTimeHelper.GetServerDateTime2().Month);
            //}
            //else if (valueType == StatisticValueType.LastCount)
            //{
            //    DateTime lastMonth = DateTimeHelper.GetServerDateTime2().AddMonths(-1);
            //    sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} ", lastMonth.Year, lastMonth.Month);
            //}

            string value = baseDal.SqlValueList(sql);

            if (!string.IsNullOrEmpty(value))
            {
                result = Convert.ToInt32(value);
            }

            return(result);
        }
        /// <summary>
        /// 根据类型获取所有库房的备件属类的汇总金额
        /// </summary>
        /// <param name="valueType"></param>
        /// <returns></returns>
        public decimal GetWareItemBigTypeMoney(StatisticValueType valueType, string itemBigType)
        {
            decimal result = 0M;
            string  sql    = string.Format("Select Sum(Amount) from WM_PurchaseDetail d inner join WM_PurchaseHeader h on d.PurchaseHead_ID = h.ID Where ItemBigType='{0}' ", itemBigType);

            if (valueType == StatisticValueType.CurrentMoney)
            {
                sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} ", DateTime.Now.Year, DateTime.Now.Month);
            }
            else if (valueType == StatisticValueType.CurrentInMoney)
            {
                sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} and h.OperationType='入库' ", DateTime.Now.Year, DateTime.Now.Month);
            }
            else if (valueType == StatisticValueType.CurrentOutMoney)
            {
                sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} and h.OperationType='出库' ", DateTime.Now.Year, DateTime.Now.Month);
            }
            else if (valueType == StatisticValueType.LastMoney)
            {
                DateTime lastMonth = DateTime.Now.AddMonths(-1);
                sql += string.Format(" AND h.CreateYear={0} and h.CreateMonth={1} ", lastMonth.Year, lastMonth.Month);
            }

            string value = baseDal.SqlValueList(sql);

            if (!string.IsNullOrEmpty(value))
            {
                result = Convert.ToDecimal(value);
            }

            return(result);
        }