public static ReportDocument LoadInventoryAdjustmentList(DateTime date1, DateTime date2) { ReportDocument rpt = new Inventory.rprInventoryAdjustmentList(); dsReports ds = new dsReports(); ds.EnforceConstraints = false; DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillInventoryAdjustments(ds.DenormalizedOrders, date1, date2); if (ds.DenormalizedOrders.Rows.Count <= 0) { FillNoData(ds.DenormalizedOrders); } RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1); rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2); return(rpt); }
public static ReportDocument LoadDeliveryOrderForm(string code) { ReportDocument rpt = new Forms.rptDeliveryOrderForm(); dsReports ds = new dsReports(); DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillByOrderNo(ds.DenormalizedOrders, code, TransactionTypes.TX_DELIVERY_ORDER); if (ds.DenormalizedOrders.Rows.Count <= 0) FillNoData(ds.DenormalizedOrders); RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); return rpt; }
public static ReportDocument LoadDeliveryOrderForm(int id) { ReportDocument rpt = new Forms.rptDeliveryOrderForm(); dsReports ds = new dsReports(); DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillByID(ds.DenormalizedOrders, id); if (ds.DenormalizedOrders.Rows.Count <= 0) FillNoData(ds.DenormalizedOrders); RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); return rpt; }
public static ReportDocument LoadDeliveryOrderForm(string code) { ReportDocument rpt = new Forms.rptDeliveryOrderForm(); dsReports ds = new dsReports(); DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillByOrderNo(ds.DenormalizedOrders, code, TransactionTypes.TX_DELIVERY_ORDER); if (ds.DenormalizedOrders.Rows.Count <= 0) { FillNoData(ds.DenormalizedOrders); } RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); return(rpt); }
public static ReportDocument LoadDeliveryOrderForm(int id) { ReportDocument rpt = new Forms.rptDeliveryOrderForm(); dsReports ds = new dsReports(); DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillByID(ds.DenormalizedOrders, id); if (ds.DenormalizedOrders.Rows.Count <= 0) { FillNoData(ds.DenormalizedOrders); } RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); return(rpt); }
public static ReportDocument LoadInventoryMutation(int id) { ReportDocument rpt = new Inventory.rprInventoryMutation(); dsReports ds = new dsReports(); ds.EnforceConstraints = false; DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillByItemID(ds.DenormalizedOrders, id); if (ds.DenormalizedOrders.Rows.Count <= 0) { FillNoData(ds.DenormalizedOrders); } RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); return(rpt); }
public static ReportDocument LoadSalesOutstanding(DateTime date1, DateTime date2) { ReportDocument rpt = new Sales.rprBackOrders(); dsReports ds = new dsReports(); DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillNotCompleted(ds.DenormalizedOrders, TransactionTypes.TX_SALES_ORDER, date1, date2); if (ds.DenormalizedOrders.Rows.Count <= 0) { FillNoData(ds.DenormalizedOrders); } RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1); rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2); return(rpt); }
public static ReportDocument LoadPurchaseByVendor(DateTime date1, DateTime date2) { ReportDocument rpt = new Purchasing.rprPurchaseByVendor(); dsReports ds = new dsReports(); DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillByDate(ds.DenormalizedOrders, TransactionTypes.TX_PURCHASE_ORDER, date1, date2); if (ds.DenormalizedOrders.Rows.Count <= 0) { FillNoData(ds.DenormalizedOrders); } RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1); rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2); return(rpt); }
public static ReportDocument LoadInventoryAdjustmentList(DateTime date1, DateTime date2) { ReportDocument rpt = new Inventory.rprInventoryAdjustmentList(); dsReports ds = new dsReports(); ds.EnforceConstraints = false; DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillInventoryAdjustments(ds.DenormalizedOrders, date1, date2); if (ds.DenormalizedOrders.Rows.Count <= 0) FillNoData(ds.DenormalizedOrders); RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1); rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2); return rpt; }
public static ReportDocument LoadInventoryMutation(int id) { ReportDocument rpt = new Inventory.rprInventoryMutation(); dsReports ds = new dsReports(); ds.EnforceConstraints = false; DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillByItemID(ds.DenormalizedOrders, id); if (ds.DenormalizedOrders.Rows.Count <= 0) FillNoData(ds.DenormalizedOrders); RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); return rpt; }
public static ReportDocument LoadSalesOutstanding(DateTime date1, DateTime date2) { ReportDocument rpt = new Sales.rprBackOrders(); dsReports ds = new dsReports(); DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillNotCompleted(ds.DenormalizedOrders, TransactionTypes.TX_SALES_ORDER, date1, date2); if (ds.DenormalizedOrders.Rows.Count <= 0) FillNoData(ds.DenormalizedOrders); RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1); rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2); return rpt; }
public static ReportDocument LoadPurchaseByVendor(DateTime date1, DateTime date2) { ReportDocument rpt = new Purchasing.rprPurchaseByVendor(); dsReports ds = new dsReports(); DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter(); ta.ClearBeforeFill = true; ta.Connection = AppHelper.GetDbConnection(); ta.FillByDate(ds.DenormalizedOrders, TransactionTypes.TX_PURCHASE_ORDER, date1, date2); if (ds.DenormalizedOrders.Rows.Count <= 0) FillNoData(ds.DenormalizedOrders); RetrieveDeveloper(ds.Developer); RetrieveOwner(ds.Owner); rpt.SetDataSource(ds); rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1); rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2); return rpt; }