/// <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 GetManNoPassByDeptList(string BeginDate, string EndDate, string ProductID, string DeptID, string OrderBy, int PageIndex, int PageCount, ref int TotalCount)
{
SqlCommand comm = PurchaseApplyNoPassDBHelper.GetManNoPassByDeptDetail(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 GetManNoPassByDeptOut(string BeginDate, string EndDate, string ProductID, string DeptID)
{
SqlCommand comm = PurchaseApplyNoPassDBHelper.GetManNoPassByDeptDetail(BeginDate, EndDate, ProductID, DeptID);
return(SqlHelper.ExecuteSearch(comm));
}