private void btnPriview_Click(object sender, EventArgs e)
        {
            if (IsSelValid())
            {
                string[,] param =
                {
                    { "FromTxDate",  this.dtpTrnFromTime.Value.ToString(DateTimeHelper.GetDateFormat()) },
                    { "ToTxDate",    this.dtpTrnToTime.Value.ToString(DateTimeHelper.GetDateFormat())   },
                    { "TOPNumber",   this.txtTopVipSpendingNumber.Text.Trim()                           },
                    { "SalesAmount", this.txtSalesAmountOver.Text.Trim()                                },
                    { "BRAND",       SelectedList(this.lvVendorList, 2)                                 },
                    { "PrintedOn",   DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())          },
                    { "CompanyName", SystemInfoEx.CurrentInfo.Default.CompanyName                       }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwVIP_TopSpending";
                view.ReportName           = "RT2020.Member.Reports.VipVendorSpendingFormRdl.rdlc";
                view.Parameters           = param;

                if (SelectedList(this.lvVendorList, 2).Length > 0)
                {
                    view.Show();
                }
                else
                {
                    MessageBox.Show(String.Format("Must select at least one {0}!", SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS1")), "Please Select");
                    view.Close();
                }
            }
        }
Beispiel #2
0
        private void btnPriview_Click(object sender, EventArgs e)
        {
            if (cmbFrom.Text.CompareTo(cmbTo.Text) <= 0)
            {
                string[,] param =
                {
                    { "FromAppendix",           this.cmbFrom.Text.Trim()                                                          },
                    { "ToAppendix",             this.cmbTo.Text.Trim()                                                            },
                    { "PrintedOn",              DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())                         },
                    { this.AppendixType.Trim(), SystemInfoHelper.Settings.GetSystemLabelByKey(this.AppendixType.Trim().ToUpper()) },
                    { "CompanyName",            SystemInfoEx.CurrentInfo.Default.CompanyName                                      }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_ap" + this.AppendixType.Trim() + "List";
                view.ReportName           = "RT2020.Product.Reports." + this.AppendixType.Trim() + "ListRdl.rdlc";
                view.Parameters           = param;

                view.Show();
            }
            else
            {
                MessageBox.Show("Out of range!", "ATTENTION");
            }
        }
Beispiel #3
0
        private void cmdPreview_Click(object sender, EventArgs e)
        {
            if (IsSelValid())
            {
                string[,] param =
                {
                    { "FromTxNumber", this._TxNumberFrom                                                },
                    { "ToTxNumber",   this._TxNumberTo                                                  },
                    { "FromTxDate",   this.dtpTxDateFrom.Value.ToString(DateTimeHelper.GetDateFormat()) },
                    { "ToTxDate",     this.dtpTxDateTo.Value.ToString(DateTimeHelper.GetDateFormat())   },
                    { "PrintedOn",    DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())         },
                    { "PrintedBy",    StaffEx.GetStaffNameById(ConfigHelper.CurrentUserId)              },
                    { "DateFormat",   DateTimeHelper.GetDateFormat()                                    },
                    { "CompanyName",  SystemInfoEx.CurrentInfo.Default.CompanyName                      },
                    { "StockCode",    SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")          },
                    { "Appendix1",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1")        },
                    { "Appendix2",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2")        },
                    { "Appendix3",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3")        }
                };

                RT2020.Controls.Reporting.Viewer oViewer = new RT2020.Controls.Reporting.Viewer();

                oViewer.Datasource           = BindData();
                oViewer.ReportName           = "RT2020.Inventory.Adjustment.Reports.HistoryRdl.rdlc";
                oViewer.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptSubLedgerADJ";
                oViewer.Parameters           = param;

                oViewer.Show();
            }
        }
Beispiel #4
0
        /// <summary>
        /// Handles the Click event of the cmdPreview control.
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
        private void CmdPreview_Click(object sender, EventArgs e)
        {
            if (this.IsSelValid("Order Number"))
            {
                string[,] param =
                {
                    { "Appendix1",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1") },
                    { "Appendix2",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2") },
                    { "Appendix3",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3") },
                    { "PrintedOn",   DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())  },
                    { "STKCODE",     SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")   },
                    { "CompanyName", SystemInfoHelper.Settings.GetSystemLabelByKey("Company")   }, ////test data
                    { "DateFormat",  DateTimeHelper.GetDateFormat()                             }
                };

                RT2020.Controls.Reporting.Viewer rptViewer = new RT2020.Controls.Reporting.Viewer();

                rptViewer.Datasource = this.BindData();

                if (rdoActive.Checked)
                {
                    rptViewer.ReportName = "RT2020.Purchasing.Reports.OfficialDocument.Reports.OfficialPurchaseOrderActiveMatrixRdl.rdlc";
                }
                else
                {
                    rptViewer.ReportName = "RT2020.Purchasing.Reports.OfficialDocument.Reports.OfficialPurchaseOrderBatchMatrixRdl.rdlc";
                }

                rptViewer.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptPurchaseOrderDocument";
                rptViewer.Parameters           = param;

                rptViewer.Show();
            }
        }
Beispiel #5
0
        private void cmdPreview_Click()
        {
            string[,] param =
            {
                { "FromTxNumber", this.txtTxNumber.Text.Trim()                                    },
                { "ToTxNumber",   this.txtTxNumber.Text.Trim()                                    },
                { "FromTxDate",   this.dtpRecvDate.Value.ToString(DateTimeHelper.GetDateFormat()) },
                { "ToTxDate",     this.dtpRecvDate.Value.ToString(DateTimeHelper.GetDateFormat()) },
                { "PrintedOn",    DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())       },
                { "PrintedBy",    StaffEx.GetStaffNameById(ConfigHelper.CurrentUserId)            },
                { "StockCode",    SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")        },
                { "Appendix1",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1")      },
                { "Appendix2",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2")      },
                { "Appendix3",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3")      },
                { "DateFormat",   DateTimeHelper.GetDateFormat()                                  },
                { "CompanyName",  SystemInfoEx.CurrentInfo.Default.CompanyName                    }
            };

            RT2020.Controls.Reporting.Viewer oViewer = new RT2020.Controls.Reporting.Viewer();

            oViewer.Datasource           = BindData();
            oViewer.ReportName           = "RT2020.Inventory.GoodsReturn.Reports.WorksheetRdl.rdlc";
            oViewer.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptBatchCAP";
            oViewer.Parameters           = param;

            oViewer.Show();
        }
Beispiel #6
0
        private void btnPreview_Click(object sender, EventArgs e)
        {
            if (IsSelValid() && reportName.Trim().Length > 0)
            {
                string[,] param =
                {
                    { "FromTxNumber",   this.cboFromTxNumber.Text.Trim()                                },
                    { "ToTxNumber",     this.cboToTxNumber.Text.Trim()                                  },
                    { "FromTxDate",     this.dtpFromDate.Value.ToString(DateTimeHelper.GetDateFormat()) },
                    { "ToTxDate",       this.dtpToDate.Value.ToString(DateTimeHelper.GetDateFormat())   },
                    { "PrintedOn",      DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())       },
                    { "IgnoreZeroDiff", chkIgnoreDiffZeroRecord.Checked.ToString()                      },
                    { "DateFormat",     DateTimeHelper.GetDateFormat()                                  },
                    { "CompanyName",    SystemInfoEx.CurrentInfo.Default.CompanyName                    },
                    { "StockCode",      SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")        },
                    { "Appendix1",      SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1")      },
                    { "Appendix2",      SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2")      },
                    { "Appendix3",      SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3")      }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptStkTkList";
                view.ReportName           = reportName;
                view.Parameters           = param;

                view.Show();
            }
        }
Beispiel #7
0
        private void btnPriview_Click(object sender, EventArgs e)
        {
            if (cmbFrom.Text.CompareTo(cmbTo.Text) <= 0)
            {
                string[,] param =
                {
                    { "FromWorkplaceList", this.cmbFrom.Text.Trim()                                  },
                    { "ToWorkplaceList",   this.cmbTo.Text.Trim()                                    },
                    { "PrintedOn",         DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat()) },
                    { "CompanyName",       SystemInfoEx.CurrentInfo.Default.CompanyName              }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_apWorkplaceList";
                view.ReportName           = "RT2020.Workplace.Reports.WorkplaceListRdl.rdlc";
                view.Parameters           = param;

                view.Show();
            }
            else
            {
                MessageBox.Show("Wrong range! ", "ATTENTION");
            }
        }
Beispiel #8
0
        private void btnPriview_Click(object sender, EventArgs e)
        {
            string[,] param =
            {
                { "PrintedOn", DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat()) }
            };

            RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

            #region ReportName
            if (this.rbtnLayout_1.Checked)
            {
                view.ReportName = "RT2020.Member.Reports.VipMLblBirthdayYtdForm_001ADCRdl.rdlc";
            }
            else
            {
                view.ReportName = "RT2020.Member.Reports.VipMLblBirthdayYtdForm_001CDARdl.rdlc";
            }
            #endregion

            view.Datasource           = BindData();
            view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwVIP_MemberList";
            view.Parameters           = param;

            view.Show();
        }
Beispiel #9
0
        private void cmdPreview_Click(object sender, EventArgs e)
        {
            if (IsSelValid())
            {
                //RT2020.DAL.Staff curUser = RT2020.DAL.Staff.Load(ConfigHelper.CurrentUserId);
                string[,] param =
                {
                    { "FromTxNumber", this.cboFrom.Text.Trim()                                          },
                    { "ToTxNumber",   this.cboTo.Text.Trim()                                            },
                    { "FromTxDate",   this.dtpTxDateFrom.Value.ToString(DateTimeHelper.GetDateFormat()) },
                    { "ToTxDate",     this.dtpTxDateTo.Value.ToString(DateTimeHelper.GetDateFormat())   },
                    { "PrintedOn",    DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())         },
                    //{"PrintedBy",curUser.FullName},
                    { "DateFormat",   DateTimeHelper.GetDateFormat()                                    },
                    { "CompanyName",  SystemInfoEx.CurrentInfo.Default.CompanyName                      },
                    { "StockCode",    SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")          },
                    { "Appendix1",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1")        },
                    { "Appendix2",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2")        },
                    { "Appendix3",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3")        }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptStkTkList";
                view.ReportName           = "RT2020.Inventory.StockTake.Reports.WorksheetRdl.rdlc";
                view.Parameters           = param;

                view.Show();
            }
        }
Beispiel #10
0
        private void btnPreview_Click(object sender, EventArgs e)
        {
            if (cboTxNumber.SelectedValue != null)
            {
                string txNumber = this.cboTxNumber.Text.Trim().Length > 12 ? this.cboTxNumber.Text.Trim().Substring(0, 12) : string.Empty;
                string[,] param =
                {
                    { "FromTxNumber",       txNumber                                                   },
                    { "ToTxNumber",         txNumber                                                   },
                    { "PrintedOn",          DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())  },
                    { "DateFormat",         DateTimeHelper.GetDateFormat()                             },
                    { "DateFormatWithTime", DateTimeHelper.GetDateTimeFormat()                         },
                    { "CompanyName",        SystemInfoEx.CurrentInfo.Default.CompanyName               },
                    { "DataType",           rbtnAllData.Checked.ToString()                             },
                    { "StockCode",          SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")   },
                    { "Appendix1",          SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1") },
                    { "Appendix2",          SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2") },
                    { "Appendix3",          SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3") }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptStkTkHHTList";
                view.ReportName           = "RT2020.Inventory.StockTake.Reports.HHTHistoryRdl.rdlc";
                view.Parameters           = param;

                view.Show();
            }
            else
            {
                MessageBox.Show("No record found!", "ATTENTION");
            }
        }
Beispiel #11
0
        private void btnPreview_Click(object sender, EventArgs e)
        {
            if (IsSelValid())
            {
                string[,] param =
                {
                    { "STKFrom",     this.cboFrom.Text.Trim()                                          },
                    { "STKTo",       this.cboTo.Text.Trim()                                            },
                    { "FromDate",    this.dtpTxDateFrom.Value.ToString(DateTimeHelper.GetDateFormat()) },
                    { "ToDate",      this.dtpTxDateTo.Value.ToString(DateTimeHelper.GetDateFormat())   },
                    { "PrintedOn",   DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())         },
                    { "DateFormat",  DateTimeHelper.GetDateFormat()                                    },
                    { "STKLabel",    SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")          },
                    { "APPENDIX1",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1")        },
                    { "APPENDIX2",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2")        },
                    { "APPENDIX3",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3")        },
                    { "CLASS1",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS1")           },
                    { "CLASS2",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS2")           },
                    { "CLASS3",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS3")           },
                    { "CLASS4",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS4")           },
                    { "CLASS5",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS5")           },
                    { "CLASS6",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS6")           },
                    { "CompanyName", SystemInfoEx.CurrentInfo.Default.CompanyName                      }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwInOutHistory";
                view.ReportName           = "RT2020.Inventory.Reports.History.InOutHistory_ListRdl.rdlc";
                view.Parameters           = param;

                view.Show();
            }
        }
        private void btnPriview_Click(object sender, EventArgs e)
        {
            if (txtFromSTKCode.Text.CompareTo(txtToSTKCode.Text) <= 0)
            {
                string[,] param =
                {
                    { "FromSTKCODE", this.txtFromSTKCode.Text.Trim()                           },
                    { "ToSTKCODE",   this.txtToSTKCode.Text.Trim()                             },
                    { "PrintedOn",   DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat()) },
                    { "CompanyName", SystemInfoEx.CurrentInfo.Default.CompanyName              }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_apProductList";
                view.ReportName           = "RT2020.Product.Reports.ProductMasterListRdl.rdlc";
                view.Parameters           = param;

                view.Show();
            }
            else
            {
                MessageBox.Show("Out of range!", "ATTENTION");
            }
        }
Beispiel #13
0
        /// <summary>
        /// Handles the Click event of the cmdSuppPreview control.
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
        private void CmdSuppPreview_Click(object sender, EventArgs e)
        {
            if (this.IsSelValid("Supplier Number"))
            {
                string[,] param =
                {
                    { "FromSupplier", this.cboSuppFrom.Text.Trim()                                        },
                    { "ToSupplier",   this.cboSuppTo.Text.Trim()                                          },
                    { "FromDate",     this.dtpSuppDateFrom.Value.ToString(DateTimeHelper.GetDateFormat()) },
                    { "ToDate",       this.dtpSuppDateTo.Value.ToString(DateTimeHelper.GetDateFormat())   },
                    { "PrintedOn",    DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())           },
                    { "STKCODE",      SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")            },
                    { "Appendix1",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1")          },
                    { "Appendix2",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2")          },
                    { "Appendix3",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3")          },
                    { "Company",      SystemInfoEx.CurrentInfo.Default.CompanyName                        },
                    { "DateFormat",   DateTimeHelper.GetDateFormat()                                      }
                };

                RT2020.Controls.Reporting.Viewer rptViewer = new RT2020.Controls.Reporting.Viewer();

                rptViewer.Datasource           = this.BindDataSupp();
                rptViewer.ReportName           = "RT2020.Purchasing.Reports.PurchaseOrder.Reports.WorksheetSuppStatusRdl.rdlc";
                rptViewer.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptPurchaseOrder";
                rptViewer.Parameters           = param;

                rptViewer.Show();
            }
        }
Beispiel #14
0
        /// <summary>
        /// Handles the Click event of the cmdPreview control.
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
        private void CmdPreview_Click(object sender, EventArgs e)
        {
            if (this.IsSelValid("Order Number"))
            {
                string[,] param =
                {
                    { "PrintedOn",  DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())  },
                    { "STKCODE",    SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")   },
                    { "Appendix1",  SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1") },
                    { "Appendix2",  SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2") },
                    { "Appendix3",  SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3") },
                    { "Company",    SystemInfoEx.CurrentInfo.Default.CompanyName               },
                    { "DateFormat", DateTimeHelper.GetDateFormat()                             }
                };

                RT2020.Controls.Reporting.Viewer rptViewer = new RT2020.Controls.Reporting.Viewer();

                rptViewer.Datasource           = this.BindData();
                rptViewer.ReportName           = "RT2020.Purchasing.Reports.ReceivingSchedule.Reports.WorksheetPOBlankReceivingRdl.rdlc";
                rptViewer.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptPurchaseOrderReceivingSchedule";
                rptViewer.Parameters           = param;

                rptViewer.Show();
            }
        }
        private void btnPriview_Click(object sender, EventArgs e)
        {
            if (IsSelValid())
            {
                string DateRange = string.Empty;
                if (rbtnAllToDate.Checked)
                {
                    DateRange = "ALL TO DATE";
                }
                else if (rbtnSpecifiedRange.Checked)
                {
                    DateRange = this.dtpSpecifiedRangeFrom.Value.ToString(DateTimeHelper.GetDateFormat()) + "-" +
                                this.dtpSpecifiedRangeTo.Value.ToString(DateTimeHelper.GetDateFormat());
                }

                string[,] param =
                {
                    { "FromVipNumber", this.cmbFrom.Text.Trim()                                   },
                    { "ToVipNumber",   this.cmbTo.Text.Trim()                                     },
                    { "DateRange",     DateRange                                                  },
                    { "Appendix1",     Appendix1                                                  },
                    { "Appendix2",     Appendix2                                                  },
                    { "Appendix3",     Appendix3                                                  },
                    { "Appendix1Name", SystemInfoHelper.Settings.GetSystemLabelByKey("Appendix1") },
                    { "Appendix2Name", SystemInfoHelper.Settings.GetSystemLabelByKey("Appendix2") },
                    { "Appendix3Name", SystemInfoHelper.Settings.GetSystemLabelByKey("Appendix3") },
                    { "PrintedOn",     DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())  },
                    { "SubTotal",      SubTotal                                                   },
                    { "CompanyName",   SystemInfoEx.CurrentInfo.Default.CompanyName               }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();
                view.Datasource = BindData();

                #region ReportName
                if (rbtPDF.Checked)
                {
                    view.ReportName = "RT2020.Member.Reports.VipSummaryListFormRdl.rdlc";
                }
                else if (rbtXLS.Checked)
                {
                    view.ReportName = "RT2020.Member.Reports.VipSummaryListFormAppendix1..3Rdl.rdlc";
                }
                #endregion

                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwVIP_SalesSummary";
                view.Parameters           = param;

                view.Show();
            }
        }
        private void DoPreview()
        {
            string DatasourceName = string.Empty;
            string reportName     = string.Empty;
            string StartOn        = string.Empty;

            if (rbSunday.Checked)
            {
                //StartOn = "SU";
                DatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptPurchaseWeeklyExpectedReceivingSummaryStartOnSunday";
                reportName     = "RT2020.Purchasing.Reports.Receiving.Reports.WeeklyExpectedReceivingSummary_SundayRdl.rdlc";
            }
            else if (rbMonday.Checked)
            {
                //StartOn = "MO";
                DatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptPurchaseWeeklyExpectedReceivingSummaryStartOnMonday";
                reportName     = "RT2020.Purchasing.Reports.Receiving.Reports.WeeklyExpectedReceivingSummary_MondayRdl.rdlc";
            }
            string[,] param =
            {
                { "DateBegin",             this.dtDateFrom.Value.ToString(DateTimeHelper.GetDateFormat()) },
                { "DateEnd",               this.dtDateTo.Value.ToString(DateTimeHelper.GetDateFormat())   },
                { "SupplierCodeFrom",      this.cboSupplierFrom.Text.Trim()                               },
                { "SupplierCodeTo",        this.cboSupplierTo.Text.Trim()                                 },
                { "STKCODEFrom",           this.cboStockCodeFrom.Text.Trim()                              },
                { "STKCODETo",             this.cboStockCodeTo.Text.Trim()                                },
                { "StartOn",               StartOn.ToString()                                             },
                { "SelectedWorkplaceCode", this.SelectedWorkplaceList().ToString().Trim(',')              },
                { "CompanyName",           SystemInfoEx.CurrentInfo.Default.CompanyName                   }
            };

            RT2020.Controls.Reporting.Viewer viewer = new RT2020.Controls.Reporting.Viewer();

            //viewer.Datasource = SqlHelper.ExecuteDataSet("apRptPurchaseWeeklyExpectedReceivingSummary",obj).Tables[0];
            viewer.Datasource           = BindData();
            viewer.ReportDatasourceName = DatasourceName;
            viewer.ReportName           = reportName;
            viewer.Parameters           = param;

            if ((SelectedWorkplaceList().Length != 0) && (rbMonday.Checked || rbSunday.Checked))
            {
                viewer.Show();
            }
            else
            {
                MessageBox.Show("Location和WeekdayStart中任何一项不能为空!", "请选值!");
                viewer.Close();
            }
        }
Beispiel #17
0
        private void btnPreview_Click(object sender, EventArgs e)
        {
            if (IsSelValid())
            {
                DateTime FromDate = new DateTime(FromYear, FromMonth, 1);
                DateTime ToDate   = new DateTime(FromYear, FromMonth, DateTime.DaysInMonth(FromYear, FromMonth));

                string[,] param =
                {
                    { "STKFrom",     this.cboFrom.Text.Trim()                                   },
                    { "STKTo",       this.cboTo.Text.Trim()                                     },
                    { "FromDate",    FromDate.ToString("dd/MM/yyyy")                            },
                    { "ToDate",      ToDate.ToString("dd/MM/yyyy")                              },
                    { "PrintedOn",   DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())  },
                    { "DateFormat",  DateTimeHelper.GetDateFormat()                             },
                    { "STKLabel",    SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")   },
                    { "APPENDIX1",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1") },
                    { "APPENDIX2",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2") },
                    { "APPENDIX3",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3") },
                    { "CLASS1",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS1")    },
                    { "CLASS2",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS2")    },
                    { "CLASS3",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS3")    },
                    { "CLASS4",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS4")    },
                    { "CLASS5",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS5")    },
                    { "CLASS6",      SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS6")    },
                    { "CompanyName", SystemInfoEx.CurrentInfo.Default.CompanyName               }
                };

                #region ProcParameter
                //SqlParameter[] obj = {
                //                         new SqlParameter("@STKFrom",this.cboFrom.Text.Trim()),
                //                         new SqlParameter("@STKTo",this.cboTo.Text.Trim()),
                //                         new SqlParameter("@Year",this.FromYear),
                //                         new SqlParameter("@Month",this.FromMonth)
                //                     };
                #endregion

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                //view.Datasource = SqlHelper.ExecuteDataSet("spInOutMonthlyHistory", obj).Tables[0];
                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwInOutHistory";
                view.ReportName           = "RT2020.Inventory.Reports.History.InOutHistory_MonthlyRdl.rdlc";
                view.Parameters           = param;

                view.Show();
            }
        }
Beispiel #18
0
        private void btnPriview_Click(object sender, EventArgs e)
        {
            if (IsSelValid())
            {
                string[,] param =
                {
                    { "FromTxNumber", this.cboFrom.Text.Trim()                                          },
                    { "ToTxNumber",   this.cboTo.Text.Trim()                                            },
                    { "FromTxDate",   this.dtpTxDateFrom.Value.ToString(DateTimeHelper.GetDateFormat()) },
                    { "ToTxDate",     this.dtpTxDateTo.Value.ToString(DateTimeHelper.GetDateFormat())   },
                    { "PrintedOn",    DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())         },
                    { "DateFormat",   DateTimeHelper.GetDateFormat()                                    },
                    { "STKCODE",      SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")          },
                    { "APPENDIX1",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1")        },
                    { "APPENDIX2",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2")        },
                    { "APPENDIX3",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3")        },
                    { "CLASS1",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS1")           },
                    { "CLASS2",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS2")           },
                    { "CLASS3",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS3")           },
                    { "CLASS4",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS4")           },
                    { "CLASS5",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS5")           },
                    { "CLASS6",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS6")           },
                    { "CompanyName",  SystemInfoEx.CurrentInfo.Default.CompanyName                      }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource4PriceMgmt_vwRptBatchPriceMgmt";

                if (this.ReportType.ToString().Substring(0, 1) == "P")
                {
                    view.ReportName = "RT2020.PriceMgmt.Reports.PriceWorksheetRdl.rdlc";
                }
                else if (this.ReportType.ToString().Substring(0, 1) == "D")
                {
                    view.ReportName = "RT2020.PriceMgmt.Reports.DiscountWorksheetRdl.rdlc";
                }

                view.Parameters = param;

                view.Show();
            }
        }
Beispiel #19
0
        private void btnPriview_Click(object sender, EventArgs e)
        {
            string[,] param =
            {
                { "FromCurrencyCode", this.cmbFrmCurrencyCode.Text.Trim()                       },
                { "ToCurrencyCode",   this.cmbToCurrencyCode.Text.Trim()                        },
                { "PrintedOn",        DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat()) },
                { "CompanyName",      SystemInfoEx.CurrentInfo.Default.CompanyName              }
            };

            RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

            view.Datasource           = BindData();
            view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_apCurrencyList";
            view.ReportName           = "RT2020.Settings.Reports.CurrencyListRdl.rdlc";
            view.Parameters           = param;

            view.Show();
        }
        private void btnPriviewClick(object sender, EventArgs e)
        {
            string[,] param =
            {
                { "FromCombin",  this.cmbFrom.Text.Trim()                                   },
                { "ToCombin",    this.cmbTo.Text.Trim()                                     },
                { "PrintedOn",   DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())  },
                { "Appendix3",   SystemInfoHelper.Settings.GetSystemLabelByKey("Appendix3") },
                { "CompanyName", SystemInfoEx.CurrentInfo.Default.CompanyName               }
            };

            RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

            view.Datasource           = BindData();
            view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_apProductDimAPP3List";
            view.ReportName           = "RT2020.Product.Reports.Appendix3CombinRdl.rdlc";
            view.Parameters           = param;

            view.Show();
        }
        private void btnPriview_Click(object sender, EventArgs e)
        {
            string[,] param =
            {
                { "FromVipMature", this.cmbFrom.Text.Trim()                                  },
                { "ToVipMature",   this.cmbTo.Text.Trim()                                    },
                { "PrintedOn",     DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat()) },
                { "TotalNetSales", this.txtNetSalesAmtOver.Text.Trim()                       },
                { "CompanyName",   SystemInfoEx.CurrentInfo.Default.CompanyName              }
            };

            RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

            view.Datasource           = BindData();
            view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwVIP_MemberList";
            view.ReportName           = "RT2020.Member.Reports.VipMatureListRdl.rdlc";
            view.Parameters           = param;

            view.Show();
        }
Beispiel #22
0
        private void btnPreview_Click(object sender, EventArgs e)
        {
            if (IsSelValid())
            {
                string[,] param =
                {
                    { "FromTxNumber",         this.txtFromStockCode.Text.Trim()                                                 },
                    { "ToTxNumber",           this.txtToStockCode.Text.Trim()                                                   },
                    { "FromTxDate",           this.dtpTxDateFrom.Value.ToString(DateTimeHelper.GetDateFormat())                 },
                    { "ToTxDate",             this.dtpTxDateTo.Value.ToString(DateTimeHelper.GetDateFormat())                   },
                    { "PrintedOn",            DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())                         },
                    { "DateFormat",           DateTimeHelper.GetDateFormat()                                                    },
                    { "LocationFrom",         txtFromStockCode.Text                                                             },
                    { "LocationTo",           txtToStockCode.Text                                                               },
                    { "STKLabel",             SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")                          },
                    { "APPENDIX1",            SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1")                        },
                    { "APPENDIX2",            SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2")                        },
                    { "APPENDIX3",            SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3")                        },
                    { "CLASS1",               SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS1")                           },
                    { "CLASS2",               SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS2")                           },
                    { "CLASS3",               SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS3")                           },
                    { "CLASS4",               SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS4")                           },
                    { "CLASS5",               SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS5")                           },
                    { "CLASS6",               SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS6")                           },
                    { "Locations",            this.cboLocation.Text.Substring(0, cboLocation.Text.IndexOf(' '))                 },
                    { "CompanyName",          SystemInfoEx.CurrentInfo.Default.CompanyName                                      },
                    { "IsCurrentSystemMonth", (SystemInfoEx.CurrentInfo.Default.CurrentSystemMonth == txtMonth.Text).ToString() }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = Bindata();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwJournalADJList";
                view.ReportName           = "RT2020.Inventory.Adjustment.Reports.JournalRdl.rdlc";
                view.Parameters           = param;

                view.Show();
            }
        }
Beispiel #23
0
        /// <summary>
        /// Handles the Click event of the cmdPreview control.
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
        private void CmdPreview_Click(object sender, EventArgs e)
        {
            if (this.IsSelValid("Remark Code"))
            {
                string[,] param =
                {
                    { "FromCode",  this.cboFrom.Text.Trim()                                  },
                    { "ToCode",    this.cboTo.Text.Trim()                                    },
                    { "PrintedOn", DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat()) },
                    { "Company",   SystemInfoEx.CurrentInfo.Default.CompanyName              }
                };

                RT2020.Controls.Reporting.Viewer rptViewer = new RT2020.Controls.Reporting.Viewer();

                rptViewer.Datasource           = this.BindData();
                rptViewer.ReportName           = "RT2020.Purchasing.Reports.Others.Reports.PORemarkRdl.rdlc";
                rptViewer.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_Remarks";
                rptViewer.Parameters           = param;

                rptViewer.Show();
            }
        }
Beispiel #24
0
        /// <summary>
        /// Handles the Click event of the btnPrint control.
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
        private void btnPrint_Click(object sender, EventArgs e)
        {
            if (CheckValid())
            {
                string title = "";
                if (this.SalesType == EnumHelper.TxType.CAS)
                {
                    title = "Sales Input Worksheet";
                }
                else
                {
                    title = "Sales Return Worksheet";
                }
                string[,] param =
                {
                    { "CompanyName",    SystemInfoEx.CurrentInfo.Default.CompanyName               },
                    { "WorksheetTitle", title                                                      },
                    { "PrintedOn",      DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())  },
                    { "FromTRN",        cboFromTrn.Text.Trim()                                     },
                    { "ToTRN",          cboToTrn.Text.Trim()                                       },
                    { "FromDate",       dtpFromDate.Value.ToString(DateTimeHelper.GetDateFormat()) },
                    { "ToDate",         dtpToDate.Value.ToString(DateTimeHelper.GetDateFormat())   },
                    { "CLASS1",         SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS1")    },
                    { "CLASS2",         SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS2")    },
                    { "CLASS3",         SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS3")    },
                    { "CLASS4",         SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS4")    },
                    { "CLASS5",         SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS5")    },
                    { "CLASS6",         SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS6")    },
                };
                RT2020.Controls.Reporting.Viewer oViewer = new RT2020.Controls.Reporting.Viewer();

                oViewer.Datasource           = BindData();
                oViewer.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptEPOSWorksheet";
                oViewer.ReportName           = "RT2020.EmulatedPoS.Reports.WorksheetRdl.rdlc";
                oViewer.Parameters           = param;
                oViewer.Show();
            }
        }
Beispiel #25
0
        private void btnPreview_Click(object sender, EventArgs e)
        {
            #region Procedure Parameters
            SqlParameter[] obj =
            {
                new SqlParameter("@fromSTKCODE",           cboSTKCodeFrom.Text.Trim()),
                new SqlParameter("@toSTKCODE",             cboSTKCodeTo.Text.Trim()),
                new SqlParameter("@fromDate",              dtDateFrom.Value),
                new SqlParameter("@toDate",                dtDateTo.Value),
                new SqlParameter("@SelectedWorkplaceCode", SelectedWorkplaceCodeList().Replace("'","")),
                new SqlParameter("@SelectedTYPE",          SelectedDataType()),
                new SqlParameter("@ShowSkipZeroQty",       chkSkipZeroQty.Checked),
                new SqlParameter("@ShowReCalculatedCD",    chkReCalulated.Checked)
            };
            #endregion

            RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

            if (String.Compare(txtForMonth.Text, currentDate) >= 0)
            {
                view.Datasource           = SqlHelper.Default.ExecuteDataSet("apStockInOutSummary_CurrentMonth", obj).Tables[0];
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_apStockInOutSummary_CurrentMonth";


                if (rbStkAndLoc.Checked)
                {
                    view.ReportName = "RT2020.Inventory.Reports.History.InOutHistory_SummaryStkAndLocRdl.rdlc";
                }
                else if (rbStk.Checked)
                {
                    view.ReportName = "RT2020.Inventory.Reports.History.InOutHistory_SummaryStkRdl.rdlc";
                }
                else if (rbLoction.Checked)
                {
                    view.ReportName = "RT2020.Inventory.Reports.History.InOutHistory_SummaryLocRdl.rdlc";
                }
            }
            else
            {
                view.Datasource           = SqlHelper.Default.ExecuteDataSet("apStockInOutSummary_HistoryMonth", obj).Tables[0];
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_apStockInOutSummary_HistoryMonth";

                if (rbStkAndLoc.Checked)
                {
                    view.ReportName = "RT2020.Inventory.Reports.History.InOutHistory_HisSummaryStkAndLocRdl.rdlc";
                }
                else if (rbStk.Checked)
                {
                    view.ReportName = "RT2020.Inventory.Reports.History.InOutHistory_HisSummaryStkRdl.rdlc";
                }
                else if (rbLoction.Checked)
                {
                    view.ReportName = "RT2020.Inventory.Reports.History.InOutHistory_HisSummaryLocRdl.rdlc";
                }
            }

            string[,] param =
            {
                { "STKCODEFrom",  this.cboSTKCodeFrom.Text.Trim()                           },
                { "STKCODETo",    this.cboSTKCodeTo.Text.Trim()                             },
                { "FromDate",     dtDateFrom.Value.ToString(DateTimeHelper.GetDateFormat()) },
                { "ToDate",       dtDateTo.Value.ToString(DateTimeHelper.GetDateFormat())   },
                { "PrintedOn",    DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat()) },
                { "CalculatedCD", chkReCalulated.Checked.ToString()                         },
                { "Locations",    this.SelectedWorkplaceCodeList()                          },
                { "CompanyName",  SystemInfoEx.CurrentInfo.Default.CompanyName              }
            };

            view.Parameters = param;

            view.Show();
        }
Beispiel #26
0
        /// <summary>
        /// Handles the Click event of the cmdPreview control.
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
        private void CmdPreview_Click(object sender, EventArgs e)
        {
            if (this.IsSelValid("Supplier Code"))
            {
                DataTable     dt = this.BindData();
                List <string> st = new List <string>();
                StringBuilder sb = new StringBuilder();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    DataRow row = dt.Rows[i];
                    if (!st.Contains(row["OrderNumber"].ToString()))
                    {
                        st.Add(row["OrderNumber"].ToString());
                    }
                }
                for (int i = 0; i < st.Count; i++)
                {
                    sb.Append(st[i].ToString()).Append(",");
                }

                string[,] param =
                {
                    { "PrintedOn",   DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())                                         },
                    { "Appendix1",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1")                                        },
                    { "Appendix2",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2")                                        },
                    { "Appendix3",   SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3")                                        },
                    { "CompanyName", SystemInfoEx.CurrentInfo.Default.CompanyName                                                      },
                    { "DateFormat",  DateTimeHelper.GetDateFormat()                                                                    },
                    { "STKCODE",     SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")                                          },
                    { "DeliverOn",   this.dtpDateFrom.Value.ToString("dd/MM/yyyy") + "-" + this.dtpDateTo.Value.ToString("dd/MM/yyyy") },
                    { "OrderNumber", sb.ToString().Trim(',')                                                                           }
                };

                RT2020.Controls.Reporting.Viewer rptViewer = new RT2020.Controls.Reporting.Viewer();


                rptViewer.Datasource = this.BindData();

                #region ReportName
                if (cboSortedBy.SelectedIndex == 0)
                {
                    // SortedBy = Stock Code

                    if (cboType.SelectedIndex == 0)
                    {
                        ////Type = Active
                        if (chkPrintPhoto.Checked && (chkHideAPPENDIX3.Checked || !chkHideAPPENDIX3.Checked))
                        {
                            ////Print out Item Photo AND Hide APPENDIX3
                            rptViewer.ReportName = "RT2020.Purchasing.Reports.OfficialDocument.Reports.OfficialPurchaseOrderActivePhotoMatrixByStockCodeRdl.rdlc";
                        }
                        else if (!chkPrintPhoto.Checked && chkHideAPPENDIX3.Checked)
                        {
                            ////Hide APPENDIX3
                            rptViewer.ReportName = "RT2020.Purchasing.Reports.OfficialDocument.Reports.OfficialPurchaseOrderActiveMatrixByStockCodeRdl.rdlc";
                        }
                        else
                        {
                        }
                    }
                    else
                    {
                        ////Type = Batch
                        if (chkPrintPhoto.Checked && (chkHideAPPENDIX3.Checked || !chkHideAPPENDIX3.Checked))
                        {
                            ////Print out Item Photo AND Hide APPENDIX3
                            rptViewer.ReportName = "RT2020.Purchasing.Reports.OfficialDocument.Reports.OfficialPurchaseOrderBatchPhotoMatrixByStockCodeRdl.rdlc";
                        }

                        else if (!chkPrintPhoto.Checked && chkHideAPPENDIX3.Checked)
                        {
                            ////Hide APPENDIX3
                            rptViewer.ReportName = "RT2020.Purchasing.Reports.OfficialDocument.Reports.OfficialPurchaseOrderBatchMatrixByStockCodeRdl.rdlc";
                        }
                        else
                        {
                        }
                    }
                }
                else
                {
                    // SortedBy = Supplier Number


                    if (cboType.SelectedIndex == 0)
                    {
                        ////Type = Active
                        if (chkPrintPhoto.Checked)
                        {
                            ////Print out Item Photo
                            rptViewer.ReportName = "RT2020.Purchasing.Reports.OfficialDocument.Reports.OfficialPOSummaryActivePhotoRdl.rdlc";
                        }
                        else
                        {
                            ////Hide Photo
                            rptViewer.ReportName = "RT2020.Purchasing.Reports.OfficialDocument.Reports.OfficialPOSummaryActiveRdl.rdlc";
                        }
                    }
                    else
                    {
                        ////Type = Batch
                        if (chkPrintPhoto.Checked)
                        {
                            ////Print out Item Photo
                            rptViewer.ReportName = "RT2020.Purchasing.Reports.OfficialDocument.Reports.OfficialPOSummaryBatchPhotoRdl.rdlc";
                        }
                        else
                        {
                            ////Hide Photo
                            rptViewer.ReportName = "RT2020.Purchasing.Reports.OfficialDocument.Reports.OfficialPOSummaryBatchRdl.rdlc";
                        }
                    }
                }
                #endregion

                rptViewer.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwRptPurchaseOrderDocument";
                rptViewer.Parameters           = param;

                rptViewer.Show();
            }
        }
Beispiel #27
0
        private void btnPriview_Click(object sender, EventArgs e)
        {
            if (IsSelValid())
            {
                string[,] param =
                {
                    { "PrintedOn", DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat()) }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_vwVIP_TopSpending";

                #region ReportName
                if (rbtnLayout_1.Checked)
                {
                    //print Address District Country
                    if (rbtnVIP_L001.Checked)
                    {
                        view.ReportName = "RT2020.Member.Reports.VipMLblBySpendingForm_L001ADCRdl.rdlc";
                    }
                    else if (rbtnVIP_L002.Checked)
                    {
                        view.ReportName = "RT2020.Member.Reports.VipMLblBySpendingForm_L002ADCRdl.rdlc";
                    }
                    else if (rbtnVIP_L003.Checked)
                    {
                        view.ReportName = "RT2020.Member.Reports.VipMLblBySpendingForm_L003ADCRdl.rdlc";
                    }
                    else if (rbtnVIP_L004.Checked)
                    {
                        view.ReportName = "RT2020.Member.Reports.VipMLblBySpendingForm_L004ADCRdl.rdlc";
                    }
                }
                else if (rbtnLayout_2.Checked)
                {
                    //print Country District Address
                    if (rbtnVIP_L001.Checked)
                    {
                        view.ReportName = "RT2020.Member.Reports.VipMLblBySpendingForm_L001CDARdl.rdlc";
                    }
                    else if (rbtnVIP_L002.Checked)
                    {
                        view.ReportName = "RT2020.Member.Reports.VipMLblBySpendingForm_L002CDARdl.rdlc";
                    }
                    else if (rbtnVIP_L003.Checked)
                    {
                        view.ReportName = "RT2020.Member.Reports.VipMLblBySpendingForm_L003CDARdl.rdlc";
                    }
                    else if (rbtnVIP_L004.Checked)
                    {
                        view.ReportName = "RT2020.Member.Reports.VipMLblBySpendingForm_L004CDARdl.rdlc";
                    }
                }
                #endregion

                view.Parameters = param;

                if (SelectedList(this.lvVendorList, 2).Length > 0)
                {
                    view.Show();
                }
                else
                {
                    MessageBox.Show("Must Select At least One of BRAND!", "Please Select");
                    view.Close();
                }
            }
        }
        private void btnPriview_Click(object sender, EventArgs e)
        {
            if (IsSelValid())
            {
                string[,] param =
                {
                    { "STKFrom",      this.cboFrom.Text.Trim()                                   },
                    { "STKTo",        this.cboTo.Text.Trim()                                     },
                    { "CurrentYear",  currentYeaar                                               },
                    { "CurrentMonth", currentMonth                                               },
                    { "FromYear",     this.txtYear.Text.Trim().ToString()                        },
                    { "FromMonth",    this.txtMonth.Text.Trim().ToString()                       },
                    { "PrintedOn",    DateTime.Now.ToString(DateTimeHelper.GetDateTimeFormat())  },
                    { "DateFormat",   DateTimeHelper.GetDateFormat()                             },
                    { "STKLabel",     SystemInfoHelper.Settings.GetSystemLabelByKey("STKCODE")   },
                    { "APPENDIX1",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX1") },
                    { "APPENDIX2",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX2") },
                    { "APPENDIX3",    SystemInfoHelper.Settings.GetSystemLabelByKey("APPENDIX3") },
                    { "CLASS1",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS1")    },
                    { "CLASS2",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS2")    },
                    { "CLASS3",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS3")    },
                    { "CLASS4",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS4")    },
                    { "CLASS5",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS5")    },
                    { "CLASS6",       SystemInfoHelper.Settings.GetSystemLabelByKey("CLASS6")    },
                    { "FromLocation", this.cboLocationFrom.Text.Trim().ToString()                },
                    { "ToLocation",   this.cboLocationTo.Text.Trim().ToString()                  },
                    { "CompanyName",  SystemInfoEx.CurrentInfo.Default.CompanyName               }
                };

                RT2020.Controls.Reporting.Viewer view = new RT2020.Controls.Reporting.Viewer();

                view.Datasource           = BindData();
                view.ReportDatasourceName = "RT2020_Controls_Reporting_DataSource_" + ReportDataSourceName() + "";

                #region ReportName
                if (ReportDataSourceName() == "vwRptStockStatus_Monthly")
                {
                    if (this.cboStkRemark.Text.Trim() == "Class 1 - 6")
                    {
                        view.ReportName = "RT2020.Inventory.Reports.StockStatus.StockStatus_MonthlyWithClassRdl.rdlc";
                    }
                    else if (this.cboStkRemark.Text.Trim() == "Description")
                    {
                        view.ReportName = "RT2020.Inventory.Reports.StockStatus.StockStatus_MonthlyWithDescRdl.rdlc";
                    }
                }
                else
                {
                    if (this.cboStkRemark.Text.Trim() == "Class 1 - 6")
                    {
                        view.ReportName = "RT2020.Inventory.Reports.StockStatus.StockStatus_MonthlyPeriodWithClassRdl.rdlc";
                    }
                    else if (this.cboStkRemark.Text.Trim() == "Description")
                    {
                        view.ReportName = "RT2020.Inventory.Reports.StockStatus.StockStatus_MonthlyPeriodWithDescRdl.rdlc";
                    }
                }
                #endregion

                view.Parameters = param;

                view.Show();
            }
        }