private void BuildParametersForQoH_ATS(ref RT2020.Controls.Reporting.OlapViewer olapViewer) { Hashtable parameterTable = new Hashtable(); parameterTable.Add("FromStockCode", this.txtFromStkCode.Text); parameterTable.Add("ToStockCode", this.txtToStkCode.Text); parameterTable.Add("FromDate", this.dtpFromDate.Value.ToString("yyyy-MM-dd")); parameterTable.Add("ToDate", this.dtpToDate.Value.ToString("yyyy-MM-dd")); parameterTable.Add("ShowPOQty", this.chkShowPOQty.Checked.ToString()); parameterTable.Add("ShowATSQty", this.chkShowATSQty.Checked.ToString()); parameterTable.Add("ShowOSTQty", this.chkShowOSTOnLoanQty.Checked.ToString()); parameterTable.Add("ShowRetailAmount", this.chkShowRetailAmount.Checked.ToString()); parameterTable.Add("ShowRemarks", this.chkShowRemarks.Checked.ToString()); parameterTable.Add("SkipZeroQty", this.chkSkipZeroQty.Checked.ToString()); System.Web.HttpContext.Current.Session["Qoh_Ats"] = parameterTable; if (this.ViewerType == RT2020.Controls.InvtUtility.InvtOlapViewerType.QoH_ATS_WithCutOffDate) { olapViewer.AspxPagePath = @"Inventory\Olap\QohAtsCutOff.aspx"; } else { olapViewer.AspxPagePath = @"Inventory\Olap\QohAtsNormal.aspx"; } }
private void BuildParametersForDiscrepancyAudit(ref RT2020.Controls.Reporting.OlapViewer olapViewer) { Hashtable parameterTable = new Hashtable(); parameterTable.Add("FromStockCode", this.txtFromStkCode_DiscrepancyAudit.Text); parameterTable.Add("ToStockCode", this.txtToStkCode_DiscrepancyAudit.Text); parameterTable.Add("Month", this.txtMonth_DiscrepancyAudit.Text); parameterTable.Add("FromDate", this.dtpFromDate_DiscrepancyAudit.Value.ToString("yyyy-MM-dd")); parameterTable.Add("ToDate", this.dtpToDate_DiscrepancyAudit.Value.ToString("yyyy-MM-dd")); parameterTable.Add("ShowDiff", this.chkShowDiff_DiscrepancyAudit.Checked.ToString()); System.Web.HttpContext.Current.Session["DiscrepancyAudit"] = parameterTable; olapViewer.AspxPagePath = @"Inventory\Olap\StockValueDiscrepancyAudit.aspx"; }
private void BuildParametersForStockReorder(ref RT2020.Controls.Reporting.OlapViewer olapViewer) { Hashtable parameterTable = new Hashtable(); parameterTable.Add("FromStockCode", this.txtFromStkCode_Reorder.Text); parameterTable.Add("ToStockCode", this.txtToStkCode_Reorder.Text); parameterTable.Add("FromDate", this.dtpFromDate_Reorder.Value.ToString("yyyy-MM-dd")); parameterTable.Add("ToDate", this.dtpToDate_Reorder.Value.ToString("yyyy-MM-dd")); parameterTable.Add("ShowBFQty", this.chkShowBFQty_Reorder.Checked.ToString()); parameterTable.Add("ShowCDQty", this.chkShowCDQty_Reorder.Checked.ToString()); parameterTable.Add("ShowATSQty", this.chkShowATSQty_Reorder.Checked.ToString()); parameterTable.Add("ShowPOQty", this.chkShowPOQty_Reorder.Checked.ToString()); System.Web.HttpContext.Current.Session["StockReorder"] = parameterTable; olapViewer.AspxPagePath = @"Inventory\Olap\StockReorder.aspx"; }
private void ShowOlapPage() { RT2020.Controls.Reporting.OlapViewer olapViewer = new RT2020.Controls.Reporting.OlapViewer(); olapViewer.Anchor = Gizmox.WebGUI.Forms.AnchorStyles.None; olapViewer.Dock = Gizmox.WebGUI.Forms.DockStyle.Fill; olapViewer.Location = new System.Drawing.Point(0, 0); olapViewer.Name = "olapViewer"; olapViewer.Size = new System.Drawing.Size(150, 445); olapViewer.TabIndex = 0; olapViewer.Text = "OlapViewer"; switch (this.ViewerType) { case RT2020.Controls.InvtUtility.InvtOlapViewerType.QoH_ATS: case RT2020.Controls.InvtUtility.InvtOlapViewerType.QoH_ATS_WithCutOffDate: this.BuildParametersForQoH_ATS(ref olapViewer); break; case RT2020.Controls.InvtUtility.InvtOlapViewerType.StockReorder: this.BuildParametersForStockReorder(ref olapViewer); break; case RT2020.Controls.InvtUtility.InvtOlapViewerType.StockIOHistory: this.BuildParametersForStockIOHistory(ref olapViewer); break; case RT2020.Controls.InvtUtility.InvtOlapViewerType.OCInventory: this.BuildParametersForOCInventory(ref olapViewer); break; case RT2020.Controls.InvtUtility.InvtOlapViewerType.DiscrepancyAudit: this.BuildParametersForDiscrepancyAudit(ref olapViewer); break; case RT2020.Controls.InvtUtility.InvtOlapViewerType.StockTransfer: this.BuildParametersForStockTransfer(ref olapViewer); break; case RT2020.Controls.InvtUtility.InvtOlapViewerType.CAP_Summary: this.BuildParametersForCapSummary(ref olapViewer); break; } this.splitContainer.Panel2.Controls.Add(olapViewer); }
private void BuildParametersForCapSummary(ref RT2020.Controls.Reporting.OlapViewer olapViewer) { Hashtable parameterTable = new Hashtable(); parameterTable.Add("FromTxNumber", this.txtFromTxNumber_CAPSummary.Text); parameterTable.Add("ToTxNumber", this.txtToTxNumber_CAPSummary.Text); parameterTable.Add("FromSupplierCode", this.txtFromSupplierNumber_CAPSummary.Text); parameterTable.Add("ToSupplierCode", this.txtToSupplierNumber_CAPSummary.Text); parameterTable.Add("FromWorkplaceCode", this.txtFromWorkplace_CAPSummary.Text); parameterTable.Add("ToWorkplaceCode", this.txtToWorkplace_CAPSummary.Text); parameterTable.Add("FromDate", this.dtpFromDate_CAPSummary.Value.ToString("yyyy-MM-dd")); parameterTable.Add("ToDate", this.dtpToDate_CAPSummary.Value.ToString("yyyy-MM-dd")); parameterTable.Add("PostedRecord", this.chkPostedRecord_CAPSummary.Checked.ToString()); parameterTable.Add("UnPostRecord", this.chkUnPostRecord_CAPSummary.Checked.ToString()); parameterTable.Add("ShowRemarks", this.chkShowRemarks_CAPSummary.Checked.ToString()); System.Web.HttpContext.Current.Session["CapSummary"] = parameterTable; olapViewer.AspxPagePath = @"Inventory\Olap\CapSummary.aspx"; }
private void BuildParametersForStockTransfer(ref RT2020.Controls.Reporting.OlapViewer olapViewer) { Hashtable parameterTable = new Hashtable(); parameterTable.Add("FromTxNumber", this.txtFromStkCode_DiscrepancyAudit.Text); parameterTable.Add("ToTxNumber", this.txtToStkCode_DiscrepancyAudit.Text); parameterTable.Add("FromStockCode", this.txtFromStkCode_DiscrepancyAudit.Text); parameterTable.Add("ToStockCode", this.txtToStkCode_DiscrepancyAudit.Text); parameterTable.Add("FromDate", this.dtpFromDate_DiscrepancyAudit.Value.ToString("yyyy-MM-dd")); parameterTable.Add("ToDate", this.dtpToDate_DiscrepancyAudit.Value.ToString("yyyy-MM-dd")); parameterTable.Add("CompletedStatus", this.chkCompleted_Transfer.Checked.ToString()); parameterTable.Add("InCompletedStatus", this.chkInCompleted_Transfer.Checked.ToString()); parameterTable.Add("UnprocessedStatus", this.chkUnprocessed_Transfer.Checked.ToString()); parameterTable.Add("PostedRecord", this.chkPostedRecords_Transfer.Checked.ToString()); parameterTable.Add("UnPostRecord", this.chkUnPostRecord_Transfer.Checked.ToString()); System.Web.HttpContext.Current.Session["StockTransfer"] = parameterTable; olapViewer.AspxPagePath = @"Inventory\Olap\StockTransfer.aspx"; }
private void BuildParametersForOCInventory(ref RT2020.Controls.Reporting.OlapViewer olapViewer) { if (!(string.Compare(txtFromMonth_OCInventory.Text, txtToMonth_OCInventory.Text) > 0)) { errorProvider.SetError(txtFromMonth_OCInventory, string.Empty); Hashtable parameterTable = new Hashtable(); parameterTable.Add("FromStockCode", this.txtFromStkCode_OCInventory.Text); parameterTable.Add("ToStockCode", this.txtToStkCode_OCInventory.Text); parameterTable.Add("FromMonth", this.txtFromMonth_OCInventory.Text); parameterTable.Add("ToMonth", this.txtToMonth_OCInventory.Text); System.Web.HttpContext.Current.Session["OCInventory"] = parameterTable; olapViewer.AspxPagePath = @"Inventory\Olap\InvtOpeningClosing.aspx"; } else { errorProvider.SetError(txtFromMonth_OCInventory, "*Shop range error!"); } }
private void BuildParametersForStockIOHistory(ref RT2020.Controls.Reporting.OlapViewer olapViewer) { if (!(string.Compare(txtFromWorkplace_IOHistory.Text, txtToWorkplace_IOHistory.Text) > 0)) { errorProvider.SetError(txtFromWorkplace_IOHistory, string.Empty); Hashtable parameterTable = new Hashtable(); parameterTable.Add("FromStockCode", this.txtFromStkCode_IOHistory.Text); parameterTable.Add("ToStockCode", this.txtToStkCode_IOHistory.Text); parameterTable.Add("FromWorkplace", this.txtFromWorkplace_IOHistory.Text); parameterTable.Add("ToWorkplace", this.txtToWorkplace_IOHistory.Text); parameterTable.Add("FromDate", this.dtpFromDate_IOHistory.Value.ToString("yyyy-MM-dd")); parameterTable.Add("ToDate", this.dtpToDate_IOHistory.Value.ToString("yyyy-MM-dd")); System.Web.HttpContext.Current.Session["StockIOHistory"] = parameterTable; olapViewer.AspxPagePath = @"Inventory\Olap\StockInOut.aspx"; } else { errorProvider.SetError(txtFromWorkplace_IOHistory, "*Shop range error!"); } }
private void ShowWorkspace(ref Panel wspPane, string Tag) { if (!string.IsNullOrEmpty(Tag)) { Control[] controls = this.Form.Controls.Find("wspPane", true); // OLAP Viewer RT2020.Inventory.Olap.OlapViewForm oOlapViewer = new RT2020.Inventory.Olap.OlapViewForm(); oOlapViewer.DockPadding.All = 6; oOlapViewer.Dock = DockStyle.Fill; switch (Tag.ToLower()) { case "invt_goodsreceive": RT2020.Inventory.GoodsReceive.DefaultCAPList oRecv = new RT2020.Inventory.GoodsReceive.DefaultCAPList(controls[0]); oRecv.DockPadding.All = 6; oRecv.Dock = DockStyle.Fill; wspPane.Controls.Add(oRecv); break; case "invt_goodsreturn": RT2020.Inventory.GoodsReturn.DefaultREJList oReturn = new RT2020.Inventory.GoodsReturn.DefaultREJList(controls[0]); oReturn.DockPadding.All = 6; oReturn.Dock = DockStyle.Fill; wspPane.Controls.Add(oReturn); break; case "invt_txfer": RT2020.Inventory.Transfer.DefaultTXFList oTxfer = new RT2020.Inventory.Transfer.DefaultTXFList(controls[0]); oTxfer.DockPadding.All = 6; oTxfer.Dock = DockStyle.Fill; wspPane.Controls.Add(oTxfer); break; case "invt_adjustment": RT2020.Inventory.Adjustment.DefaultADJList oAdjust = new RT2020.Inventory.Adjustment.DefaultADJList(controls[0]); oAdjust.DockPadding.All = 6; oAdjust.Dock = DockStyle.Fill; wspPane.Controls.Add(oAdjust); break; case "invt_replenishment": RT2020.Inventory.Replenishment.DefaultRPLList oReplenishment = new RT2020.Inventory.Replenishment.DefaultRPLList(controls[0]); oReplenishment.DockPadding.All = 6; oReplenishment.Dock = DockStyle.Fill; wspPane.Controls.Add(oReplenishment); break; case "invt_stocktake": RT2020.Inventory.StockTake.DefaultSTKTKList oStockTake = new RT2020.Inventory.StockTake.DefaultSTKTKList(controls[0]); oStockTake.DockPadding.All = 6; oStockTake.Dock = DockStyle.Fill; wspPane.Controls.Add(oStockTake); break; case "productcare_product": RT2020.Product.ProductList oProd = new RT2020.Product.ProductList(controls[0]); oProd.DockPadding.All = 6; oProd.Dock = DockStyle.Fill; wspPane.Controls.Add(oProd); break; case "productcare_appendix1": RT2020.Product.AppendixList oAppendix1List = new RT2020.Product.AppendixList(ProductHelper.Appendix.Appendix1, controls[0]); oAppendix1List.DockPadding.All = 6; oAppendix1List.Dock = DockStyle.Fill; wspPane.Controls.Add(oAppendix1List); break; case "productcare_appendix2": RT2020.Product.AppendixList oAppendix2List = new RT2020.Product.AppendixList(ProductHelper.Appendix.Appendix2, controls[0]); oAppendix2List.DockPadding.All = 6; oAppendix2List.Dock = DockStyle.Fill; wspPane.Controls.Add(oAppendix2List); break; case "productcare_appendix3": RT2020.Product.AppendixList oAppendix3List = new RT2020.Product.AppendixList(ProductHelper.Appendix.Appendix3, controls[0]); oAppendix3List.DockPadding.All = 6; oAppendix3List.Dock = DockStyle.Fill; wspPane.Controls.Add(oAppendix3List); break; case "productcare_class1": RT2020.Product.ClassList oClass1List = new RT2020.Product.ClassList("Class1", controls[0]); oClass1List.DockPadding.All = 6; oClass1List.Dock = DockStyle.Fill; wspPane.Controls.Add(oClass1List); break; case "productcare_class2": RT2020.Product.ClassList oClass2List = new RT2020.Product.ClassList("Class2", controls[0]); oClass2List.DockPadding.All = 6; oClass2List.Dock = DockStyle.Fill; wspPane.Controls.Add(oClass2List); break; case "productcare_class3": RT2020.Product.ClassList oClass3List = new RT2020.Product.ClassList("Class3", controls[0]); oClass3List.DockPadding.All = 6; oClass3List.Dock = DockStyle.Fill; wspPane.Controls.Add(oClass3List); break; case "productcare_class4": RT2020.Product.ClassList oClass4List = new RT2020.Product.ClassList("Class4", controls[0]); oClass4List.DockPadding.All = 6; oClass4List.Dock = DockStyle.Fill; wspPane.Controls.Add(oClass4List); break; case "productcare_class5": RT2020.Product.ClassList oClass5List = new RT2020.Product.ClassList("Class5", controls[0]); oClass5List.DockPadding.All = 6; oClass5List.Dock = DockStyle.Fill; wspPane.Controls.Add(oClass5List); break; case "productcare_class6": RT2020.Product.ClassList oClass6List = new RT2020.Product.ClassList("Class6", controls[0]); oClass6List.DockPadding.All = 6; oClass6List.Dock = DockStyle.Fill; wspPane.Controls.Add(oClass6List); break; case "productcare_combination": RT2020.Product.CombinationList oCombinList = new RT2020.Product.CombinationList(controls[0]); oCombinList.DockPadding.All = 6; oCombinList.Dock = DockStyle.Fill; wspPane.Controls.Add(oCombinList); break; case "productcare_analysiscode": RT2020.Product.AnalysisCodeList oAnalysisList = new RT2020.Product.AnalysisCodeList(controls[0]); oAnalysisList.DockPadding.All = 6; oAnalysisList.Dock = DockStyle.Fill; wspPane.Controls.Add(oAnalysisList); break; case "journal_goodsreceive": RT2020.Inventory.GoodsReceive.Reports.JournalWizard wizCAPJournal = new RT2020.Inventory.GoodsReceive.Reports.JournalWizard(); wizCAPJournal.ShowDialog(); break; case "journal_goodsreturn": RT2020.Inventory.GoodsReturn.Reports.JournalWizard wizRETJournal = new RT2020.Inventory.GoodsReturn.Reports.JournalWizard(); wizRETJournal.ShowDialog(); break; case "journal_transfer": RT2020.Inventory.Transfer.Reports.JournalWizard wizTransferJournal = new RT2020.Inventory.Transfer.Reports.JournalWizard(); wizTransferJournal.ShowDialog(); break; case "journal_adjustment": RT2020.Inventory.Adjustment.Reports.JournalWizard wizADJJournal = new RT2020.Inventory.Adjustment.Reports.JournalWizard(); wizADJJournal.ShowDialog(); break; case "journal_replenishment": RT2020.Inventory.Replenishment.Reports.JournalWizard wizRPLJournal = new RT2020.Inventory.Replenishment.Reports.JournalWizard(); wizRPLJournal.ShowDialog(); break; case "journal_stocktake": RT2020.Inventory.StockTake.Reports.JournalWizard wizSTKTKJournal = new RT2020.Inventory.StockTake.Reports.JournalWizard(); wizSTKTKJournal.ShowDialog(); break; case "olap_qohatsnormal": oOlapViewer.ViewerType = RT2020.Controls.InvtUtility.InvtOlapViewerType.QoH_ATS; wspPane.Controls.Add(oOlapViewer); break; case "olap_qohatsnormal_withas": RT2020.Controls.Reporting.OlapViewer oOlapViewerAS = new RT2020.Controls.Reporting.OlapViewer(); oOlapViewerAS.DockPadding.All = 6; oOlapViewerAS.Dock = DockStyle.Fill; oOlapViewerAS.AspxPagePath = @"Inventory\Olap\QohAtsNormalWithOlapConnection.aspx"; wspPane.Controls.Add(oOlapViewerAS); break; case "olap_qohatscutoff": oOlapViewer.ViewerType = RT2020.Controls.InvtUtility.InvtOlapViewerType.QoH_ATS_WithCutOffDate; wspPane.Controls.Add(oOlapViewer); break; case "olap_stockreorder": oOlapViewer.ViewerType = RT2020.Controls.InvtUtility.InvtOlapViewerType.StockReorder; wspPane.Controls.Add(oOlapViewer); break; case "olap_stockinout": oOlapViewer.ViewerType = RT2020.Controls.InvtUtility.InvtOlapViewerType.StockIOHistory; wspPane.Controls.Add(oOlapViewer); break; case "olap_invtopeningclosing": oOlapViewer.ViewerType = RT2020.Controls.InvtUtility.InvtOlapViewerType.OCInventory; wspPane.Controls.Add(oOlapViewer); break; case "olap_stockvaluediscrepancyaudit": oOlapViewer.ViewerType = RT2020.Controls.InvtUtility.InvtOlapViewerType.DiscrepancyAudit; wspPane.Controls.Add(oOlapViewer); break; case "olap_stocktransfer": oOlapViewer.ViewerType = RT2020.Controls.InvtUtility.InvtOlapViewerType.StockTransfer; wspPane.Controls.Add(oOlapViewer); break; case "olap_capsummary": oOlapViewer.ViewerType = RT2020.Controls.InvtUtility.InvtOlapViewerType.CAP_Summary; wspPane.Controls.Add(oOlapViewer); break; case "invthistory_monthlyinout": //RT2020.Inventory.Reports.History.InOutHistory_Monthly wizMonthlyHist = new RT2020.Inventory.Reports.History.InOutHistory_Monthly(); //wizMonthlyHist.ShowDialog(); var monthly = new RT2020.Inventory.Reports.Journal.Monthly(); monthly.DockPadding.All = 6; monthly.Dock = DockStyle.Fill; wspPane.Controls.Add(monthly); break; case "invthistory_inoutlist": //RT2020.Inventory.Reports.History.InOutHistory_List wizInOutList = new RT2020.Inventory.Reports.History.InOutHistory_List(); //wizInOutList.ShowDialog(); var list = new RT2020.Inventory.Reports.Journal.List(); list.DockPadding.All = 6; list.Dock = DockStyle.Fill; wspPane.Controls.Add(list); break; case "invthistory_inoutsummary": //RT2020.Inventory.Reports.History.InOutHistory_Summary wizInOutSummary = new RT2020.Inventory.Reports.History.InOutHistory_Summary(); //wizInOutSummary.ShowDialog(); var summary = new RT2020.Inventory.Reports.Journal.Summary(); summary.DockPadding.All = 6; summary.Dock = DockStyle.Fill; wspPane.Controls.Add(summary); break; case "price_change": RT2020.PriceMgmt.PriceMgmtList wizPriceChangeList = new RT2020.PriceMgmt.PriceMgmtList(controls[0], EnumHelper.PriceMgmtPMType.Price); wizPriceChangeList.DockPadding.All = 6; wizPriceChangeList.Dock = DockStyle.Fill; wspPane.Controls.Add(wizPriceChangeList); break; case "discount_change": RT2020.PriceMgmt.PriceMgmtList wizDiscChangeList = new RT2020.PriceMgmt.PriceMgmtList(controls[0], EnumHelper.PriceMgmtPMType.Discount); wizDiscChangeList.DockPadding.All = 6; wizDiscChangeList.Dock = DockStyle.Fill; wspPane.Controls.Add(wizDiscChangeList); break; case "reason_code": RT2020.PriceMgmt.DiscountReasonList oReasonList = new RT2020.PriceMgmt.DiscountReasonList(controls[0]); oReasonList.DockPadding.All = 6; oReasonList.Dock = DockStyle.Fill; wspPane.Controls.Add(oReasonList); break; case "sales_input": RT2020.EmulatedPoS.DefaultList oSalesInputList = new RT2020.EmulatedPoS.DefaultList(controls[0], EnumHelper.TxType.CAS); oSalesInputList.DockPadding.All = 6; oSalesInputList.Dock = DockStyle.Fill; wspPane.Controls.Add(oSalesInputList); break; case "sales_return": RT2020.EmulatedPoS.DefaultList oSalesReturnList = new RT2020.EmulatedPoS.DefaultList(controls[0], EnumHelper.TxType.CRT); oSalesReturnList.DockPadding.All = 6; oSalesReturnList.Dock = DockStyle.Fill; wspPane.Controls.Add(oSalesReturnList); break; } } }