/// <summary>
        /// 生产不合格按产品分析-明细
        /// </summary>
        /// <param name="BeginDate"></param>
        /// <param name="EndDate"></param>
        /// <param name="ProductID"></param>
        /// <param name="DeptID"></param>
        /// <param name="OrderBy"></param>
        /// <param name="PageIndex"></param>
        /// <param name="PageCount"></param>
        /// <param name="TotalCount"></param>
        /// <returns></returns>
        public static DataTable GetManNoPassByProductList(string BeginDate, string EndDate, string ProductID, string DeptID, string OrderBy, int PageIndex, int PageCount, ref int TotalCount)
        {
            SqlCommand comm = PurchaseApplyNoPassDBHelper.GetManNoPassByProductDetail(BeginDate, EndDate, ProductID, DeptID);

            return(SqlHelper.PagerWithCommand(comm, PageIndex, PageCount, OrderBy, ref TotalCount));
        }
        /// <summary>
        /// 生产不合格按产品分析-导出
        /// </summary>
        /// <param name="BeginDate"></param>
        /// <param name="EndDate"></param>
        /// <param name="ProductID"></param>
        /// <param name="DeptID"></param>
        /// <returns></returns>
        public static DataTable GetManNoPassByProductOut(string BeginDate, string EndDate, string ProductID, string DeptID)
        {
            SqlCommand comm = PurchaseApplyNoPassDBHelper.GetManNoPassByProductDetail(BeginDate, EndDate, ProductID, DeptID);

            return(SqlHelper.ExecuteSearch(comm));
        }