/// <summary> /// 采购不合格按供应商分析-导出 /// </summary> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="ProductID"></param> /// <returns></returns> public static DataTable GetNoPassByProviderOut(string BeginDate, string EndDate, string ProductID, string ProviderID) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; SqlCommand comm = PurchaseApplyNoPassDBHelper.SearchPurApplyNoPass(companyCD, BeginDate, EndDate, ProductID, ""); return(SqlHelper.ExecuteSearch(comm)); }
/// <summary> /// 采购不合格按供应商分析-详细信息列表 /// </summary> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="ProductID"></param> /// <param name="OrderBy"></param> /// <param name="PageIndex"></param> /// <param name="PageCount"></param> /// <param name="TotalCount"></param> /// <returns></returns> public static DataTable GetNoPassByProviderList(string BeginDate, string EndDate, string ProductID, string ProviderID, string OrderBy, int PageIndex, int PageCount, ref int TotalCount) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; SqlCommand comm = PurchaseApplyNoPassDBHelper.SearchPurApplyNoPass(companyCD, BeginDate, EndDate, ProductID, ProviderID); 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="ProcessWay"></param> /// <param name="OrderBy"></param> /// <returns></returns> public static DataTable GetNoPassDetailOut(string BeginDate, string EndDate, string ProductID, string ProcessWay, string OrderBy) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; return(PurchaseApplyNoPassDBHelper.GetNoPassDetailOut(companyCD, BeginDate, EndDate, ProductID, ProcessWay, OrderBy)); }
/// <summary> /// 采购不合格按供应商分析 /// </summary> /// <param name="CompanyCD"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="CustID"></param> /// <returns></returns> public static DataTable GetNoPassByProvider(string BeginDate, string EndDate, string ProductID) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; return(PurchaseApplyNoPassDBHelper.GetNoPassByProvider(companyCD, BeginDate, EndDate, ProductID)); }
public static DataTable SearchNoPass(string Method, string BeginDate, string EndDate, string ReasonID, string myOrder, int PageIndex, int PageCount, ref string TotalNotPassNum, ref int TotalCount) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; return(PurchaseApplyNoPassDBHelper.GetNoPass(Method, companyCD, BeginDate, EndDate, ReasonID, myOrder, PageIndex, PageCount, ref TotalNotPassNum, ref TotalCount)); }
/// <summary> /// 不合格产品处置分布-链接到详细信息 /// </summary> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="ProductID"></param> /// <param name="ProcessWay"></param> /// <param name="PageIndex"></param> /// <param name="PageCount"></param> /// <param name="OrderBy"></param> /// <param name="TotalCount"></param> /// <returns></returns> public static DataTable GetNoPassDetail(string BeginDate, string EndDate, string ProductID, string ProcessWay, int PageIndex, int PageCount, string OrderBy, ref int TotalCount) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; return(PurchaseApplyNoPassDBHelper.GetNoPassDetail(companyCD, BeginDate, EndDate, ProductID, ProcessWay, PageIndex, PageCount, OrderBy, ref TotalCount)); }
/// <summary> /// 生产不合格走势-列表 /// </summary> /// <param name="TimeType"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="ProductID"></param> /// <param name="DeptID"></param> /// <param name="XValue"></param> /// <param name="OrderBy"></param> /// <param name="PageIndex"></param> /// <param name="PageCount"></param> /// <param name="TotalCount"></param> /// <returns></returns> public static DataTable GetManNoPassTendencyList(string TimeType, string BeginDate, string EndDate, string ProductID, string DeptID, string XValue, string OrderBy, int PageIndex, int PageCount, ref int TotalCount) { SqlCommand comm = PurchaseApplyNoPassDBHelper.GetManNoPassTendencyDetail(TimeType, BeginDate, EndDate, ProductID, DeptID, XValue); return(SqlHelper.PagerWithCommand(comm, PageIndex, PageCount, OrderBy, ref TotalCount)); }
/// <summary> /// 生产不合格走势-导出 /// </summary> /// <param name="TimeType"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="ProductID"></param> /// <param name="DeptID"></param> /// <param name="XValue"></param> /// <returns></returns> public static DataTable GetManNoPassTendencyOut(string TimeType, string BeginDate, string EndDate, string ProductID, string DeptID, string XValue) { SqlCommand comm = PurchaseApplyNoPassDBHelper.GetManNoPassTendencyDetail(TimeType, BeginDate, EndDate, ProductID, DeptID, XValue); return(SqlHelper.ExecuteSearch(comm)); }
/// <summary> /// 生产不合格走势 /// </summary> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="ProductID"></param> /// <param name="DeptID"></param> /// <param name="Type"></param> /// <returns></returns> public static DataTable GetManNoPassTendency(string BeginDate, string EndDate, string ProductID, string DeptID, string Type) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; return(PurchaseApplyNoPassDBHelper.GetManNoPassTendency(companyCD, BeginDate, EndDate, ProductID, DeptID, Type)); }
/// <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)); }
/// <summary> /// 采购不合格走势-导出 /// </summary> /// <param name="Method"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="ProductID"></param> /// <param name="CustID"></param> /// <param name="XValue"></param> /// <returns></returns> public static DataTable GetNoPassTendencyListOut(string Method, string BeginDate, string EndDate, string ProductID, string CustID, string XValue) { SqlCommand comm = PurchaseApplyNoPassDBHelper.GetNoPassTendencyDetail(Method, BeginDate, EndDate, ProductID, CustID, XValue); return(SqlHelper.ExecuteSearch(comm)); }