Пример #1
0
        private void PrintDoc(int headeroption, int middleoption, int bottomoption)
        {
            string          reporttitle = formHeadertext.ToUpper();
            frm_reportViwer rpt         = new frm_reportViwer();

            rpt.MdiParent      = MDI_SMartAnything.ActiveForm;
            rpt.FormHeadertext = reporttitle;
            ParameterField         paramField         = new ParameterField();
            ParameterFields        paramFields        = new ParameterFields();
            ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();

            paramFields = commonFunctions.AddCrystalParamsWithLoca(reporttitle, commonFunctions.Loginuser.ToUpper(), commonFunctions.GlobalLocation, findExisting.FindExisitingLoca(commonFunctions.GlobalLocation));

            paramField.Name          = "status";
            paramDiscreteValue.Value = "Original".ToUpper();
            paramField.CurrentValues.Add(paramDiscreteValue);
            paramFields.Add(paramField);

            rpt_StockCard rptBank = new rpt_StockCard();

            if (rdo_productwise.Checked)
            {
                rptBank.SetDataSource(commonFunctions.GetDatatable(ReportStrings.GetStockBalance("", "", "", headeroption, middleoption, bottomoption)));
            }
            else if (rdo_lotwise.Checked)
            {
            }

            rpt.RepViewer.ParameterFieldInfo = paramFields;
            rpt.RepViewer.ReportSource       = rptBank;
            rpt.RepViewer.Refresh();
            rpt.Show();
        }
Пример #2
0
        private void btn_print_Click(object sender, EventArgs e)
        {
            int headeroption = 1;
            int middleoption = 1;
            int bottomoption = 1;

            string          reporttitle = formHeadertext.ToUpper();
            frm_reportViwer rpt         = new frm_reportViwer();

            rpt.MdiParent      = MDI_SMartAnything.ActiveForm;
            rpt.FormHeadertext = reporttitle;
            ParameterField         paramField         = new ParameterField();
            ParameterFields        paramFields        = new ParameterFields();
            ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();

            paramFields = commonFunctions.AddCrystalParamsWithLoca(reporttitle, commonFunctions.Loginuser.ToUpper(), commonFunctions.GlobalLocation, findExisting.FindExisitingLoca(commonFunctions.GlobalLocation));

            paramField.Name          = "status";
            paramDiscreteValue.Value = "Original".ToUpper();
            paramField.CurrentValues.Add(paramDiscreteValue);
            paramFields.Add(paramField);



            if (rdo_productwise.Checked)
            {
                rpt_stockbalance_product rptBank = new rpt_stockbalance_product();
                if (rdo_all.Checked)
                {
                    rptBank.SetDataSource(commonFunctions.GetDatatable(ReportStrings.GetStockBalance(txt_loca1.Text, txt_loca2.Text, "", 1, 1, 1)));
                }
                else
                {
                    if (Chk_allLoca.Checked)
                    {
                        rptBank.SetDataSource(commonFunctions.GetDatatable(ReportStrings.GetStockBalance(txt_loca1.Text, txt_loca2.Text, "", 1, 2, 1)));
                    }
                    else if (rdo_product.Checked)
                    {
                        rptBank.SetDataSource(commonFunctions.GetDatatable(ReportStrings.GetStockBalance(txt_product1.Text, txt_product2.Text, "", 1, 3, 1)));
                    }
                    else if (rdo_category.Checked)
                    {
                        rptBank.SetDataSource(commonFunctions.GetDatatable(ReportStrings.GetStockBalance(txt_Category.Text, txt_Category1.Text, "", 1, 4, 1)));
                    }
                }
                rpt.RepViewer.ParameterFieldInfo = paramFields;
                rpt.RepViewer.ReportSource       = rptBank;
                rpt.RepViewer.Refresh();
                rpt.Show();
            }
            else if (rdo_lotwise.Checked)
            {
                rpt_stockbalance_Stock rptBank = new rpt_stockbalance_Stock();
                if (rdo_all.Checked)
                {
                    rptBank.SetDataSource(commonFunctions.GetDatatable(ReportStrings.GetStockBalance(txt_loca1.Text, txt_loca2.Text, "", 2, 1, 1)));
                }
                else
                {
                    if (rdo_location.Checked)
                    {
                        rptBank.SetDataSource(commonFunctions.GetDatatable(ReportStrings.GetStockBalance(txt_loca1.Text, txt_loca2.Text, "", 2, 1, 1)));
                    }
                    else if (rdo_product.Checked)
                    {
                        rptBank.SetDataSource(commonFunctions.GetDatatable(ReportStrings.GetStockBalance(txt_loca1.Text, txt_loca2.Text, "", 2, 1, 1)));
                    }
                    else if (rdo_category.Checked)
                    {
                        rptBank.SetDataSource(commonFunctions.GetDatatable(ReportStrings.GetStockBalance(txt_loca1.Text, txt_loca2.Text, "", 2, 1, 1)));
                    }
                }
                rpt.RepViewer.ParameterFieldInfo = paramFields;
                rpt.RepViewer.ReportSource       = rptBank;
                rpt.RepViewer.Refresh();
                rpt.Show();
            }
        }