Example #1
0
        void PrintSFD(int i_CFID)
        {
            DataSet tmpDs = BLL.ChargeBLL.GetSFDs(i_CFID);

            //
            FastReport.Report report1 = new FastReport.Report();
            report1.Load("Reports\\SFPrint.frx");

            DataSet   FDataSet = new DataSet();
            DataTable table    = new DataTable();

            table           = tmpDs.Tables[0].Copy();
            table.TableName = "ChargeF";
            FDataSet.Tables.Add(table);

            tmpDs           = BLL.ChargeBLL.GetSFChargeDetail(i_CFID);
            table           = tmpDs.Tables[0].Copy();
            table.TableName = "ChargeDetail";
            FDataSet.Tables.Add(table);
            DataRelation dr = new DataRelation("FK_1", FDataSet.Tables["ChargeF"].Columns["CFID"], FDataSet.Tables["ChargeDetail"].Columns["CFID"]);

            FDataSet.Relations.Add(dr);

            report1.RegisterData(FDataSet);
            report1.Show();
            report1.Dispose();
        }
Example #2
0
        void ButtonPrint1Click(object sender, EventArgs e)
        {
            //打印非零库存
            FastReport.Report report1 = new FastReport.Report();
            report1.Load("Reports\\Stock.frx");

            DataSet   FDataSet = new DataSet();
            DataTable table    = new DataTable();

            table = ds1.Tables[0].Clone();
            DataRow[] drArr = ds1.Tables[0].Select("EndQty <> 0");            //查询
            table.TableName = "Stock";
            for (int i = 0; i < drArr.Length; i++)
            {
                 
                {
                     
                        table.ImportRow(drArr[i]);
                }
            }
            FDataSet.Tables.Add(table);
            report1.SetParameterValue("PeriodNo", sPeriodNo);
            report1.RegisterData(FDataSet);
            report1.Show();
            report1.Dispose();
        }
Example #3
0
        void 入库统计ToolStripMenuItemClick(object sender, EventArgs e)
        {
            //打印非零库存
            FastReport.Report report1 = new FastReport.Report();
            report1.Load("Reports\\IncomeSum.frx");

            DataSet   FDataSet = new DataSet();
            DataTable table    = new DataTable();

            table           = BLL.GoodsTypeBLL.GetAllGoodsType().Tables[0].Copy();
            table.TableName = "GoodsType";
            FDataSet.Tables.Add(table);

            table           = BLL.ReceiptBLL.GetAllReceiptItems().Tables[0].Copy();
            table.TableName = "ReceiptItems";
            FDataSet.Tables.Add(table);
            //report1.SetParameterValue("PeriodNo",sPeriodNo);
            DataRelation dsdr  =  new DataRelation("R1",  FDataSet.Tables["GoodsType"].Columns["GoodsTypeID"],  FDataSet.Tables["ReceiptItems"].Columns["GoodsTypeID"]);   
            FDataSet.Relations.Add(dsdr);   
            CalculateTotal(ref FDataSet);

            report1.RegisterData(FDataSet);
            report1.Show();
            report1.Dispose();
        }
Example #4
0
        private void button1_Click(object sender, EventArgs e)
        {
            report1 = new FastReport.Report();
            report1.Load(Path.Combine(@"AltAltaVeriYazma.frx"));


            var kisi     = new Kisi();
            var kisiList = kisi.getKisiList();

            foreach (var data in kisiList)
            {
                var rowadaparsel = dataSet1.Tables["Kisi"].NewRow();

                rowadaparsel["No"]    = data.No;
                rowadaparsel["Ad"]    = data.Ad;
                rowadaparsel["Soyad"] = data.Soyad;
                rowadaparsel["TC"]    = data.TC;
                dataSet1.Tables["Kisi"].Rows.Add(rowadaparsel);
            }

            report1.RegisterData(dataSet1.Tables["Kisi"], "Kisi");
            report1.GetDataSource("Kisi").Enabled = true;
            (report1.Report.FindObject("Data1") as FastReport.DataBand).DataSource = report1.GetDataSource("Kisi");

            report1.Show();
        }
Example #5
0
        private void ExceReportAnzeigenDruck(object sender, ExecutedRoutedEventArgs e)
        {
            _Report.Clear();
            var dsRep = _Auswertungen.Current;

            if (dsRep.Report != null)
            {
                MemoryStream mem;
                mem = new MemoryStream(dsRep.Report);
                _Report.Load(mem);
            }

            _Report.SetParameterValue("SqlVerbindung", Properties.Settings.Default.DatenbankVerbindungsString);

            if (e.Command == MyCommands.ReportAnzeigen)
            {
                _Report.Show();
            }
            else if (e.Command == Commands.MyCommands.ReportDrucken)
            {
                _Report.Print();
            }
            else if (e.Command == Commands.MyCommands.ReportBearbeiten)
            {
                _Report.Design();
            }
        }
Example #6
0
        void Button1Click(object sender, EventArgs e)
        {
            //打印当前显示的库存内容
            FastReport.Report report1 = new FastReport.Report();
            report1.Load("Reports\\Stock.frx");

            DataSet   FDataSet = new DataSet();
            DataTable table    = new DataTable();

            table = ds1.Tables[0].Clone();

            table.TableName = "Stock";
            //dataGridView1.SelectAll();
            foreach (DataGridViewRow dr in dataGridView1.SelectedRows)
            {
                 
                string    tsGoodsID = dr.Cells["GoodsID"].Value.ToString();
                DataRow[] dr1       = ds1.Tables[0].Select("GoodsID = " + tsGoodsID);          //查询
                table.ImportRow(dr1[0]);
            }
            FDataSet.Tables.Add(table);
            report1.SetParameterValue("PeriodNo", sPeriodNo);
            report1.RegisterData(FDataSet);
            report1.Show();
            report1.Dispose();
        }
        private void DisplayReporteTraspaso()
        {
            try
            {
                var movimiento = Datos.GetListOf <MovimientoInventarioView>(m => m.MovimientoInventarioID.Equals(oID));
                var detalle    = Datos.GetListOf <MovimientoInventarioDetalleView>(d => d.MovimientoInventarioID.Equals(oID));

                IEnumerable <MovimientoInventarioView>        movimientoE = movimiento;
                IEnumerable <MovimientoInventarioDetalleView> detalleE    = detalle;

                using (FastReport.Report report = new FastReport.Report())
                {
                    if (detalle.Count < 10)
                    {
                        report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteTraspaso.frx"));
                    }
                    else
                    {
                        report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteTraspasosMasDeDiez.frx"));
                    }

                    report.RegisterData(movimientoE, "movimiento", 3);
                    report.RegisterData(detalleE, "detalle", 3);
                    report.GetDataSource("movimiento").Enabled = true;
                    report.GetDataSource("detalle").Enabled    = true;
                    report.Show(true);
                }
            }
            catch (Exception ex)
            {
                Util.MensajeError(ex.Message, GlobalClass.NombreApp);
            }
        }
Example #8
0
        void ButtonSCClick(object sender, EventArgs e)
        {
            FastReport.Report report1 = new FastReport.Report();
            report1.Load("Reports\\PriceLimit.frx");

            DataSet   FDataSet = new DataSet();
            DataTable table    = new DataTable();

            table           = BLL.GoodsTypeBLL.GetAllGoodsType().Tables[0].Copy();
            table.TableName = "GoodsType";
            FDataSet.Tables.Add(table);

            table           = BLL.RKBLL.GetInStockItems(Convert.ToInt32(comboBoxProject.SelectedValue)).Tables[0].Copy();
            table.TableName = "ReceiptItems";
            FDataSet.Tables.Add(table);

            sProjectName = comboBoxProject.Text;
            report1.SetParameterValue("ProjectName", sProjectName);

            DataRelation dsdr  =  new DataRelation("R1",  FDataSet.Tables["GoodsType"].Columns["GoodsTypeID"],  FDataSet.Tables["ReceiptItems"].Columns["GoodsTypeID"]);   
            FDataSet.Relations.Add(dsdr);   


            report1.RegisterData(FDataSet);

            report1.Show();
            report1.Dispose();
        }
Example #9
0
        private void toolPrint_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(taskid))
            {
                DataSet ds = new DataSet();

                DataTable dtPrint = new SqlServerHelper().GetDataTable("View_GroupInfo", "taskid='" + taskid + "'", "");

                dtPrint.TableName = "用户报装申请表";
                ds.Tables.Add(dtPrint.Copy());
                FastReport.Report report1 = new FastReport.Report();
                try
                {
                    // load the existing report
                    report1.Load(Application.StartupPath + @"\PRINTModel\业扩模板\多用户报装申请表.frx");
                    // register the dataset
                    report1.RegisterData(ds);
                    report1.GetDataSource("用户报装申请表").Enabled = true;
                    // run the report
                    report1.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                finally
                {
                    // free resources used by report
                    report1.Dispose();
                }
            }
        }
Example #10
0
        private void btnImprimir_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.dgvDatos.DataSource == null)
                {
                    return;
                }

                BindingSource bs = (BindingSource)this.dgvDatos.DataSource;
                DataTable     dt = (DataTable)bs.DataSource;

                using (FastReport.Report report = new FastReport.Report())
                {
                    report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReportePartesClasificacionAbc.frx"));
                    report.RegisterData(dt, "PartesClasificacionAbc");
                    report.GetDataSource("PartesClasificacionAbc").Enabled = true;
                    report.Show(true);
                }
            }
            catch (Exception ex)
            {
                Util.MensajeError(ex.Message, GlobalClass.NombreApp);
            }
        }
Example #11
0
        //Print
        private void button1_Click(object sender, EventArgs e)
        {
            errorProvider1.Clear( );
            int  number = 0;
            bool isOk   = true;

            if (int.TryParse(textBox1.Text, out number) == false)
            {
                errorProvider1.SetError(textBox1, "请输入正确的打印数量");
                isOk = false;
            }
            if (texProduct.Tag == null)
            {
                errorProvider1.SetError(texProduct, "品号不可为空");
                isOk = false;
            }
            if (string.IsNullOrEmpty(texProduct.Text))
            {
                errorProvider1.SetError(texProduct, "品名不可为空");
                isOk = false;
            }
            if (string.IsNullOrEmpty(texSpec.Text))
            {
                errorProvider1.SetError(texSpec, "规格不可为空");
                isOk = false;
            }
            if (string.IsNullOrEmpty(textBox3.Text))
            {
                errorProvider1.SetError(textBox3, "型号不可为空");
                isOk = false;
            }
            if (string.IsNullOrEmpty(comboBox1.Text))
            {
                errorProvider1.SetError(comboBox1, "轴号不可为空");
                isOk = false;
            }
            if (isOk == false)
            {
                return;
            }
            numOf( );
            if (Save( ) == false)
            {
                return;
            }
            RDataSet = new DataSet( );

            getDataTable( );
            FastReport.Report report = new FastReport.Report( );
            string            path   = "";

            path = Application.StartupPath;
            //if ( string . IsNullOrEmpty ( texPack . Text ) )
            report.Load(path + "\\PrintBarCode.frx");
            //else
            //report . Load ( path + "\\PrintBarCodeA.frx" );
            report.RegisterData(RDataSet);
            report.Show( );
        }
 private void btn_storage_Click(object sender, EventArgs e)
 {
     try
     {
         FastReport.Report report1 = new FastReport.Report();
         report1.Load("2.frx");
         DataTable dt = new DataTable();
         DataSet   ds = new DataSet();
         dt.Columns.Add("物品名");
         dt.Columns.Add("物品数量");
         dt.Columns.Add("物品代码");
         dt.Columns.Add("物品备注");
         dt.Columns.Add("物品价格");
         dt.Columns.Add("物品类型");
         dt.Columns.Add("物品体积");
         dt.Columns.Add("物品重量");
         dt.Columns.Add("仓库名称");
         dt.Columns.Add("客户名称");
         dt.Columns.Add("物品规格");
         dt.Columns.Add("入库方式");
         dt.Columns.Add("生产日期");
         dt.Columns.Add("到期日期");
         dt.Columns.Add("批号");
         dt.Columns.Add("清单备注");
         dt.Columns.Add("操作人员");
         dt.Rows.Add();
         dt.Rows[0][0]  = gm.Goods_name;
         dt.Rows[0][1]  = bm.Goods_amount;
         dt.Rows[0][2]  = gm.Goods_code;
         dt.Rows[0][3]  = gm.Goods_note;
         dt.Rows[0][4]  = bm.Goods_price;
         dt.Rows[0][5]  = gtm.Goods_type;
         dt.Rows[0][6]  = gm.Goods_volume;
         dt.Rows[0][7]  = gm.Goods_wight;
         dt.Rows[0][8]  = wnm.Warehouse_name;
         dt.Rows[0][9]  = cm.Client_name;
         dt.Rows[0][10] = gm.Specifications;
         dt.Rows[0][11] = otm.Operation_type;
         dt.Rows[0][12] = bm.Expiration_date;
         dt.Rows[0][13] = bm.Manufacture_date;
         dt.Rows[0][14] = bm.Lot_number;
         dt.Rows[0][15] = bm.Bill_note;
         dt.Rows[0][16] = mm.Manager_name;
         ds.Tables.Add(dt);
         dt.TableName = "putreport";
         report1.RegisterData(ds);
         report1.GetDataSource("putreport").Enabled = true;
         report1.Show();
         //report1.Design();
         //report1.Prepare();
         //report1.ShowPrepared();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
Example #13
0
 private void Form2_Load(object sender, EventArgs e)
 {
     #region 快速报表
     FastReport.Report fr = new FastReport.Report();
     fr.Load(@"Reports\fastReport1.frx");
     fr.Preview = previewControl1;
     fr.SetParameterValue("Title", "快速报表~~~");
     fr.Show();
     #endregion
 }
Example #14
0
 private void hotSpot1_Click(object sender, EventArgs e)
 {
     if (File.Exists(txtREPORTFILE.Text) && (txtREPORTFILE.Text.Length > 0))
     {
         FastReport.Report rpt = new FastReport.Report();
         rpt.Load(txtREPORTFILE.Text);
         rpt.AutoFillDataSet = false;
         rpt.Dictionary.Connections[0].ConnectionString = string.Format(@"XSDFile={1};XmlFile={0}", txtXMLDataFile.Text, txtXSDSchemaFile.Text);
         rpt.AutoFillDataSet = true;
         rpt.Show();
     }
 }
Example #15
0
        void ButtonPrintClick(object sender, EventArgs e)
        {
            string s_CFIDs = "";

            foreach (DataGridViewRow drs in dataGridView1.SelectedRows)
            {
                s_CFIDs += drs.Cells["CFID"].Value.ToString();
                s_CFIDs += ",";
            }

            if (s_CFIDs != "")
            {
                s_CFIDs = s_CFIDs.Substring(0, s_CFIDs.Length - 1);
                s_CFIDs = "(" + s_CFIDs + ")";
            }
            else
            {
                s_CFIDs = "(0)";
            }

            DataSet tmpDs = BLL.ChargeBLL.GetSFDs(s_CFIDs);

            //
            FastReport.Report report1 = new FastReport.Report();
            report1.Load("Reports\\SFPrint.frx");

            DataSet   FDataSet = new DataSet();
            DataTable table    = new DataTable();

            table           = tmpDs.Tables[0].Copy();
            table.TableName = "ChargeF";
            FDataSet.Tables.Add(table);

            tmpDs = BLL.ChargeBLL.GetSFChargeDetail(s_CFIDs);
            if (ds2.Tables.Count == 0)
            {
                return;
            }
            table           = tmpDs.Tables[0].Copy();
            table.TableName = "ChargeDetail";
            FDataSet.Tables.Add(table);
            DataRelation dr = new DataRelation("FK_1", FDataSet.Tables["ChargeF"].Columns["CFID"], FDataSet.Tables["ChargeDetail"].Columns["CFID"]);

            FDataSet.Relations.Add(dr);

            report1.RegisterData(FDataSet);
            report1.Show();
            report1.Dispose();
        }
Example #16
0
        private void DisplayReporteEtiquetas()
        {
            try
            {
                var movimientoEtiquetas = Datos.GetListOf <MovimientoInventarioEtiquetasView>(l => l.MovimientoInventarioID.Equals(oID));
                var listaEtiquetas      = new List <Etiquetas>();

                var cont = 0;
                foreach (var etiqueta in movimientoEtiquetas)
                {
                    for (var x = 0; x < etiqueta.NumeroEtiquetas; x++)
                    {
                        cont += 1;

                        var e = new Etiquetas()
                        {
                            MovimientoInventarioEtiquetaID = cont,
                            MovimientoInventarioID         = oID,
                            ParteID         = etiqueta.ParteID,
                            sParteID        = etiqueta.ParteID.ToString("D8"),
                            NumeroParte     = etiqueta.NumeroParte,
                            CodigoBarra     = etiqueta.CodigoBarra,
                            NumeroEtiquetas = 1,
                            NombreParte     = etiqueta.NombreParte
                                              //NombreParte = etiqueta.ParteID.ToString("D8")
                        };
                        listaEtiquetas.Add(e);
                    }
                }

                // Se obtiene el folio de la factura, para mandarlo al reporte
                var oMov = Datos.GetEntity <MovimientoInventario>(c => c.MovimientoInventarioID == oID);

                IEnumerable <Etiquetas> detalleE = listaEtiquetas;
                using (FastReport.Report report = new FastReport.Report())
                {
                    report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteEtiquetas.frx"));
                    report.RegisterData(detalleE, "etiquetas", 3);
                    report.SetParameterValue("FolioFactura", oMov.FolioFactura);
                    report.GetDataSource("etiquetas").Enabled = true;
                    report.Show(true);
                    //report.Design(true);
                }
            }
            catch (Exception ex)
            {
                Util.MensajeError(ex.Message, GlobalClass.NombreApp);
            }
        }
Example #17
0
        //导出到Excel
        void OutPutExcel(DataGridView dgv, string name)
        {
            FastReport.Report report1 = new FastReport.Report();
            report1.Load("Reports\\GoodsList1.frx");

            DataSet   FDataSet = new DataSet();
            DataTable table    = new DataTable();

            table           = ds1.Tables[0].Copy();
            table.TableName = "Goods";
            FDataSet.Tables.Add(table);
            report1.RegisterData(FDataSet);
            report1.Show();
            report1.Dispose();
        }
Example #18
0
        void ButtonPrintClick(object sender, EventArgs e)
        {
            if (dataGridView1.CurrentRow == null)
            {
                return;
            }



            DataSet   tmpDs    = new DataSet();
            DataSet   FDataSet = new DataSet();
            DataTable table    = new DataTable();


            int     i_CompanyID      = Convert.ToInt32(comboBoxProjectCompany.SelectedValue);
            int     i_ProjectID      = Convert.ToInt32(comboBoxProject.SelectedValue);
            string  s_StatementCycle = dataGridView1.CurrentRow.Cells["StatementCycle"].Value.ToString();;
            LeaseHT tLeaseHT         = BLL.LeaseBLL.GetLeaseHT(i_ProjectID, i_CompanyID);

            tmpDs           = BLL.LeaseBLL.GetLeaseAccountDs(i_ProjectID, i_CompanyID, s_StatementCycle);
            table           = tmpDs.Tables[0].Copy();
            table.TableName = "LeaseAccount";
            FDataSet.Tables.Add(table);

            int i_BillID = 0;

            foreach (DataRow drtmp in table.Rows)
            {
                i_BillID = Convert.ToInt32(drtmp["BillID"]);
            }

            tmpDs           = BLL.LeaseBLL.GetLeaseAccountList(i_BillID);
            table           = tmpDs.Tables[0].Copy();
            table.TableName = "LeaseAccountList";
            FDataSet.Tables.Add(table);

            tmpDs           = BLL.LeaseBLL.GetLeaseAccountList(0, i_BillID);
            table           = tmpDs.Tables[0].Copy();
            table.TableName = "LeaseAccountLeft";
            FDataSet.Tables.Add(table);
            //将需要结算的数据填写到报表中的表中

            FastReport.Report report1 = new FastReport.Report();
            report1.Load("Reports\\LeaseHisJS.frx");
            report1.RegisterData(FDataSet);
            report1.Show();
            report1.Dispose();
        }
Example #19
0
 /// <summary>
 /// 打印预览
 /// </summary>
 /// <param name="dic">打印数据</param>
 public void DetailPreview(Dictionary <string, DataTable> dic)
 {
     if (dic == null)
     {
         return;
     }
     FastReport.Report report = GetDetailReport(dic);
     if (report == null)
     {
         return;
     }
     report.Prepare();
     report.Show();
     report.Dispose();
     dic = null;
 }
Example #20
0
        void ButtonPrintClick(object sender, EventArgs e)
        {
            FastReport.Report report1 = new FastReport.Report();
            report1.Load("Reports\\Stock.frx");

            DataSet   FDataSet = new DataSet();
            DataTable table    = new DataTable();

            table           = ds1.Tables[0].Copy();
            table.TableName = "Stock";
            FDataSet.Tables.Add(table);
            report1.SetParameterValue("PeriodNo", sPeriodNo);
            report1.RegisterData(FDataSet);
            report1.Show();
            report1.Dispose();
        }
Example #21
0
        void ButtonPrintClick(object sender, EventArgs e)
        {
            //打印
            using (FastReport.Report report1 = new FastReport.Report())
            {
                report1.Load("Reports\\AccountList.frx");

                DataSet   FDataSet = BLL.AccountBillBLL.GetAllAccountBillFK();
                DataTable table    = new DataTable();
                table           = FDataSet.Tables[0];
                table.TableName = "AccountBill";
                report1.SetParameterValue("ListType", 1);
                report1.RegisterData(FDataSet);
                report1.Show();
                report1.Dispose();
            }
        }
Example #22
0
        private void toolPrintPreview_Click(object sender, EventArgs e)
        {
            #region
            FastReport.Report report1 = new FastReport.Report();
            try
            {
                // load the existing report
                report1.Load(Application.StartupPath + @"\PRINTModel\收据模板\日结明细单模板.frx");

                (report1.FindObject("txtYSCOUNT") as FastReport.TextObject).Text        = "发票数量:" + intYSCount + "张,收据数量:" + intYSRECEIPRNOCOUNT.ToString() + "张";
                (report1.FindObject("txtYSSF") as FastReport.TextObject).Text           = "应收水费:" + decBCYS.ToString("F2") + "元";
                (report1.FindObject("txtSSSF") as FastReport.TextObject).Text           = "实收金额:" + decYSBCSS.ToString("F2") + "元";
                (report1.FindObject("txtSSSFXJ") as FastReport.TextObject).Text         = "现金:" + decYSBCSSXJ.ToString("F2") + "元";
                (report1.FindObject("txtSSSFPOS") as FastReport.TextObject).Text        = "POS机:" + decYSBCSSPOS.ToString("F2") + "元";
                (report1.FindObject("txtSSSFZHUANZHANG") as FastReport.TextObject).Text = "转账汇款:" + decYSBCSSZHUANZHANG.ToString("F2") + "元";
                (report1.FindObject("txtYEZJ") as FastReport.TextObject).Text           = "余额增减:" + decYSBCSZ.ToString("F2") + "元";

                (report1.FindObject("txtYCCount") as FastReport.TextObject).Text        = "收据数量:" + intYCCount + "张";
                (report1.FindObject("txtQQYE") as FastReport.TextObject).Text           = "前期余额:" + decYCQQYE.ToString("F2") + "元";
                (report1.FindObject("txtYCSF") as FastReport.TextObject).Text           = "预存收费:" + decYCBCSZ.ToString("F2") + "元";
                (report1.FindObject("txtYCSFXJ") as FastReport.TextObject).Text         = "现金:" + decYCBCSZXJ.ToString("F2") + "元";
                (report1.FindObject("txtYCSFPOS") as FastReport.TextObject).Text        = "POS机:" + decYCBCSZPOS.ToString("F2") + "元";
                (report1.FindObject("txtYCSFZHUANZHANG") as FastReport.TextObject).Text = "转账汇款:" + decYCBCSZZHUANZHANG.ToString("F2") + "元";
                (report1.FindObject("txtJSYE") as FastReport.TextObject).Text           = "结算余额::" + decYCJSYE.ToString("F2") + "元";

                (report1.FindObject("txtJEZJ") as FastReport.TextObject).Text     = "金额总计: " + labBCSS.Text;
                (report1.FindObject("txtDateTime") as FastReport.TextObject).Text = "统计时间:" + dtpStartSearch.Value.ToString("yyyy-MM-dd HH:mm:ss") + " 至 " + dtpEndSearch.Value.ToString("yyyy-MM-dd HH:mm:ss");

                (report1.FindObject("txtWorkerName") as FastReport.TextObject).Text = "收 费 员:" + txtWorkerNameSearch.Text;
                report1.Show();
            }
            catch (Exception exx)
            {
                MessageBox.Show(exx.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                // free resources used by report
                report1.Dispose();
            }
            #endregion
        }
Example #23
0
        public static void PrintCredit(CreditViewModel model, ServiceClient repository)
        {
            ReportDataSet dsRep = new ReportDataSet();

            ReportDataSet.CreditDTRow dsCreditDtRowRow = dsRep.CreditDT.NewCreditDTRow();
            dsCreditDtRowRow.Fio       = model.UserName;
            dsCreditDtRowRow.Data      = model.DataStart;
            dsCreditDtRowRow.SummaFull = model.SummaFull.ToString();
            dsCreditDtRowRow.Stavka    = model.Stavka.ToString();
            dsCreditDtRowRow.TermMonth = model.TermMonth.ToString();
            dsCreditDtRowRow.IdCredit  = model.Id.ToString();

            dsRep.CreditDT.Rows.Add(dsCreditDtRowRow);

            List <Payment> payments = repository.GetPaymentsByIdCredit(model.Id).ToList();

            foreach (var item in payments)
            {
                ReportDataSet.PaymentDTRow dsPaymentDtRow = dsRep.PaymentDT.NewPaymentDTRow();
                dsPaymentDtRow.IdCredit    = model.Id.ToString();
                dsPaymentDtRow.NumberMonth = item.NumberMonth.ToString();
                dsPaymentDtRow.Data        = item.Data;
                dsPaymentDtRow.LostSumma   = item.LostSumma.ToString();
                dsPaymentDtRow.MainPay     = item.MainPay.ToString();
                dsPaymentDtRow.Percent     = item.Percent.ToString();
                dsPaymentDtRow.SummaMonth  = item.SummaMonth.ToString();
                dsRep.PaymentDT.Rows.Add(dsPaymentDtRow);
            }

            using (FastReport.Report report = new FastReport.Report())
            {
                report.StoreInResources = true;
                report.Load("Report\\CreditReport.frx");

                report.RegisterData((DataTable)dsRep.CreditDT, "CreditInfoList");
                report.GetDataSource("CreditInfoList").Enabled = true;
                report.RegisterData((DataTable)dsRep.PaymentDT, "PaymentList");
                report.GetDataSource("PaymentList").Enabled = true;
                //report.Design();
                report.Show();
            }
        }
Example #24
0
        void ButtonJSPreviewClick(object sender, EventArgs e)
        {
            if (CheckFillOK())
            {
                DataSet   tmpDs    = new DataSet();
                DataSet   FDataSet = new DataSet();
                DataTable table    = new DataTable();


                int i_ProjectID;
                int i_CompanyID;
                i_ProjectID = Convert.ToInt32(comboBoxProject.SelectedValue.ToString());
                i_CompanyID = Convert.ToInt32(comboBoxCompany.SelectedValue.ToString());
                LeaseHT tLeaseHT = BLL.LeaseBLL.GetLeaseHT(i_ProjectID, i_CompanyID);

                tmpDs           = BLL.LeaseBLL.GetLeaseAccountDs(0);            //随便取数据,用空结构填充
                table           = tmpDs.Tables[0].Clone();
                table.TableName = "LeaseAccount";
                FDataSet.Tables.Add(table);

                tmpDs           = BLL.LeaseBLL.GetLeaseAccountList(0);
                table           = tmpDs.Tables[0].Clone();
                table.TableName = "LeaseAccountList";
                FDataSet.Tables.Add(table);

                tmpDs           = BLL.LeaseBLL.GetLeaseAccountLeft(0);
                table           = tmpDs.Tables[0].Clone();
                table.TableName = "LeaseAccountLeft";
                FDataSet.Tables.Add(table);

                //将需要结算的数据填写到报表中的表中
                FillReportData(FDataSet);

                FastReport.Report report1 = new FastReport.Report();
                report1.Load("Reports\\LeaseJS.frx");
                report1.RegisterData(FDataSet);
                report1.Show();
                report1.Dispose();
            }
        }
Example #25
0
        private void button1_Click(object sender, EventArgs e)
        {
            string  sql      = "select * from fastReportForPrint where frxName='frxa.frx'";
            DataSet dsa      = getDataSet(sql);
            DataSet FDataSet = new DataSet();

            if (dsa.Tables[0].Rows.Count > 0)
            {
                sql      = dsa.Tables[0].Rows[0]["sqlStr"].ToString() + " where id=1";
                FDataSet = getDataSet(sql);
                FastReport.Report report1 = new FastReport.Report();
                try
                {
                    // load the existing report
                    report1.Load(dsa.Tables[0].Rows[0]["frxName"].ToString());
                    // register the dataset
                    report1.RegisterData(FDataSet);
                    report1.GetDataSource(dsa.Tables[0].Rows[0]["fromTable"].ToString()).Enabled = true;
                    // run the report
                    report1.Show();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                finally
                {
                    // free resources used by report
                    report1.Dispose();
                }
            }

            //DataTable table = new DataTable();
            //table.TableName = "S_User";
            //FDataSet.Tables.Add(table);
            //table.Columns.Add("Name", typeof(string));
            //table.Columns.Add("Pwd", typeof(string));
            //table.Rows.Add("管理员", "19A2854144B63A8F7617A6F225019B12");
            //table.Rows.Add("超级管理员", "EBEC10142B9FC9E4E67B0CFD347E23E6");
        }
Example #26
0
        void ButtonPrintJFClick(object sender, EventArgs e)
        {
            DataSet tmpDs = BLL.ChargeBLL.GetJFDs();

            //
            FastReport.Report report1 = new FastReport.Report();
            report1.Load("Reports\\JFPrint.frx");

            DataSet   FDataSet = new DataSet();
            DataTable table    = new DataTable();

            table           = tmpDs.Tables[0].Copy();
            table.TableName = "Charge";
            FDataSet.Tables.Add(table);

            tmpDs           = BLL.ChargeBLL.GetCanSFAll(textBoxPeriodNo.Text);
            table           = tmpDs.Tables[0].Copy();
            table.TableName = "ChargeDetail";
            FDataSet.Tables.Add(table);
            DataRelation dr = new DataRelation("FK_1", FDataSet.Tables["Charge"].Columns["CID"], FDataSet.Tables["ChargeDetail"].Columns["CID"]);

            FDataSet.Relations.Add(dr);

            tmpDs           = BLL.CustomersBLL.GetAllCustomers();
            table           = tmpDs.Tables[0].Copy();
            table.TableName = "Customers";
            FDataSet.Tables.Add(table);

            tmpDs           = BLL.WyInfosBLL.GetAllWyInfos();
            table           = tmpDs.Tables[0].Copy();
            table.TableName = "WyInfos";
            FDataSet.Tables.Add(table);
            dr = new DataRelation("FK_2", FDataSet.Tables["Customers"].Columns["CustomerID"], FDataSet.Tables["Wyinfos"].Columns["CustomerID"]);
            FDataSet.Relations.Add(dr);

            report1.RegisterData(FDataSet);
            report1.Show();
            report1.Dispose();
        }
Example #27
0
 /// <summary>
 /// 入库单生成报表
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btn_print_Click(object sender, EventArgs e)
 {
     try
     {
         FastReport.Report report1 = new FastReport.Report();
         report1.Load("1.frx");
         DataTable tb = new DataTable();
         tb           = ds.Tables[0];
         tb.TableName = "putreport";
         ds.Tables.Clear();
         ds.Tables.Add(tb);
         report1.RegisterData(ds);
         report1.GetDataSource("putreport").Enabled = true;
         report1.Show();
         //report1.Design();
         //report1.Prepare();
         //report1.ShowPrepared();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
Example #28
0
        private void button2_Click(object sender, EventArgs e)
        {
            Cargando.Mostrar();
            var etiquetas = new List <Etiquetas>();

            foreach (DataGridViewRow item in this.dgvExistencias.Rows)
            {
                int     pID    = Util.Entero(item.Cells["ParteID"].Value);
                var     oParte = Datos.GetEntity <Parte>(c => c.ParteID == pID);
                decimal test   = (decimal)item.Cells["Existencia"].Value;
                for (var x = 0; x < (decimal)item.Cells["Existencia"].Value; x++)
                {
                    var etiqueta = new Etiquetas()
                    {
                        ParteID         = pID,
                        NumeroParte     = oParte.NumeroParte,
                        sParteID        = oParte.ParteID.ToString("D8"),
                        NombreParte     = oParte.NombreParte,
                        CodigoBarra     = oParte.CodigoBarra,
                        NumeroEtiquetas = Convert.ToInt32(Math.Round(test, 0))
                    };
                    etiquetas.Add(etiqueta);
                }
            }
            Cargando.Cerrar();
            IEnumerable <Etiquetas> detalleE = etiquetas;

            using (FastReport.Report report = new FastReport.Report())
            {
                report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteEtiquetas.frx"));
                report.RegisterData(detalleE, "etiquetas", 3);
                report.SetParameterValue("FolioFactura", 0);
                report.GetDataSource("etiquetas").Enabled = true;
                report.Show(true);
                //report.Design(true);
            }
        }
        void ButtonPrtRKDClick(object sender, EventArgs e)
        {
            //打印入库单
            FastReport.Report report1 = new FastReport.Report();
            report1.Load("Reports\\RKD.frx");
            int i_ReceiptID = Convert.ToInt32(dataGridView1.CurrentRow.Cells["ReceiptID"].Value.ToString());

            DataSet   FDataSet = new DataSet();
            DataTable table    = new DataTable();
            DataSet   ds1      = BLL.RKBLL.GetReceipt1(i_ReceiptID);

            table           = ds1.Tables[0].Copy();
            table.TableName = "Receipt";
            FDataSet.Tables.Add(table);

            ds1             = BLL.RKBLL.GetReceiptItems(i_ReceiptID);
            table           = ds1.Tables[0].Copy();
            table.TableName = "ReceiptItems";
            FDataSet.Tables.Add(table);

            report1.RegisterData(FDataSet);
            report1.Show();
            report1.Dispose();
        }
Example #30
0
        private void toolPrintPreview_Click(object sender, EventArgs e)
        {
            if (dtList.Rows.Count == 0)
            {
                toolPrint.Enabled        = false;
                toolPrintPreview.Enabled = false;
                return;
            }

            DataSet   ds           = new DataSet();
            DataTable dtRecordTemp = dtList.Clone();

            dtRecordTemp.Columns["收费月份"].DataType = typeof(string);
            foreach (DataRow dr in dtList.Rows)
            {
                dtRecordTemp.ImportRow(dr);
            }
            for (int i = 0; i < dtRecordTemp.Rows.Count; i++)
            {
                object obj = dtRecordTemp.Rows[i]["收费月份"];
                if (Information.IsDate(obj))
                {
                    dtRecordTemp.Rows[i]["收费月份"] = Convert.ToDateTime(obj).ToString("yyyy-MM");
                }
                //object objWaterMeterNO = dtRecord.Rows[i]["waterMeterNo"];
                //if (objWaterMeterNO != null && objWaterMeterNO != DBNull.Value)
                //    if (objWaterMeterNO.ToString().Length > 7)
                //        dtRecord.Rows[i]["waterMeterNo"] = objWaterMeterNO.ToString().Substring(6, 2);
            }

            dtRecordTemp.ImportRow(dtSum.Rows[0]);
            DataTable dtPrint = dtRecordTemp.Copy();

            dtPrint.TableName = "一户式查询模板";

            string strWaterUserID = "", strWaterUserName = "", strAddress = "";
            object objWaterUser = dtList.Rows[0]["用户编号"];

            if (objWaterUser != null && objWaterUser != DBNull.Value)
            {
                strWaterUserID = objWaterUser.ToString();
            }
            objWaterUser = dtList.Rows[0]["用户名称"];
            if (objWaterUser != null && objWaterUser != DBNull.Value)
            {
                strWaterUserName = objWaterUser.ToString();
            }
            objWaterUser = dtList.Rows[0]["地址"];
            if (objWaterUser != null && objWaterUser != DBNull.Value)
            {
                strAddress = objWaterUser.ToString();
            }

            ds.Tables.Add(dtPrint);
            FastReport.Report report1 = new FastReport.Report();
            try
            {
                // load the existing report
                report1.Load(Application.StartupPath + @"\PRINTModel\收据模板\一户式查询模板.frx");
                (report1.FindObject("txtWaterUser") as FastReport.TextObject).Text        = "用户编号:" + strWaterUserID + "       用户名称:" + strWaterUserName;
                (report1.FindObject("txtWaterUserAddress") as FastReport.TextObject).Text = "地    址:" + strAddress;
                // register the dataset
                report1.RegisterData(ds);
                report1.GetDataSource("一户式查询模板").Enabled = true;
                // run the report
                report1.Show();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                // free resources used by report
                report1.Dispose();
            }
        }
Example #31
0
        private void btnProcesar_Click(object sender, EventArgs e)
        {
            try
            {
                this.tabPedidos.SelectedIndex = 0; ;
                if (this.dgvProveedores.CurrentRow == null)
                {
                    Util.MensajeError("Debe seleccionar a un Proveedor.", GlobalClass.NombreApp);
                    return;
                }

                // Se valida que haya al menos una parte seleccionada
                bool bError = true;
                foreach (DataGridViewRow oFila in this.dgvSugeridos.Rows)
                {
                    if (Util.Logico(oFila.Cells["sug_Sel"].Value))
                    {
                        bError = false;
                        break;
                    }
                }
                // if (this.dgvSugeridos.DataSource == null)
                if (bError)
                {
                    Util.MensajeError("Debe seleccionar al menos un número de parte.", GlobalClass.NombreApp);
                    return;
                }

                var proveedorId = Util.Entero(this.dgvProveedores.CurrentRow.Cells["pro_ProveedorID"].Value);
                var proveedor = Datos.GetEntity<Proveedor>(p => p.ProveedorID == proveedorId);
                if (proveedor != null)
                {
                    var msj = string.Format("{0} {1} {2}", "¿Está seguro de que la información del Pedido es correcta?", "Para el Proveedor:", proveedor.NombreProveedor);
                    var res = Util.MensajePregunta(msj, GlobalClass.NombreApp);
                    if (res == DialogResult.No)
                        return;
                }
                else
                {
                    Util.MensajeError("Proveedor Inválido.", GlobalClass.NombreApp);
                    return;
                }

                this.Cursor = Cursors.WaitCursor;
                SplashScreen.Show(new Splash());
                this.btnProcesar.Enabled = false;

                var pedido = new Pedido()
                {
                    ProveedorID = proveedorId,
                    ImporteTotal = Util.Decimal(this.txtImporteTotal.Text.SoloNumeric()),
                    PedidoEstatusID = 2
                };

                Datos.Guardar<Pedido>(pedido);

                if (pedido.PedidoID <= 0)
                {
                    this.Cursor = Cursors.Default;
                    SplashScreen.Close();
                    Util.MensajeError("Ocurrio un error al guardar el Pedido.", GlobalClass.NombreApp);
                    this.btnProcesar.Enabled = true;
                    return;
                }

                // DataTable dt = new DataTable();
                // BindingSource bs = (BindingSource)this.dgvSugeridos.DataSource;

                //Validación, debe estar seleccionado y el pedido debe ser mayor a 0
                /* if (!string.IsNullOrEmpty(bs.Filter))
                {
                    DataView dv = (DataView)bs.List;
                    dt = dv.ToTable().AsEnumerable().Where(x => x.Field<Boolean>("Sel") && x.Field<decimal>("Pedido") > 0).CopyToDataTable();
                } */

                foreach (DataGridViewRow oFila in this.dgvSugeridos.Rows)
                {
                    if (!oFila.Visible) continue;

                    int iParteID = Util.Entero(oFila.Cells["sug_ParteID"].Value);

                    // Se verifica si no se debe pedir por existencia en equivalentes
                    var oNoPedir = Datos.GetEntity<ParteCaracteristicaTemporal>(c => c.ParteID == iParteID
                        && c.Caracteristica == Cat.CaracTempPartes.NoPedidosPorEquivalentes);
                    if (Util.Cadena(oFila.Cells["sug_Caracteristica"].Value) == "NP")
                    {
                        if (oNoPedir == null)
                        {
                            oNoPedir = new ParteCaracteristicaTemporal()
                            {
                                ParteID = iParteID,
                                Caracteristica = Cat.CaracTempPartes.NoPedidosPorEquivalentes
                            };
                            Datos.Guardar<ParteCaracteristicaTemporal>(oNoPedir);
                        }
                    }
                    else
                    {
                        if (oNoPedir != null)
                            Datos.Eliminar<ParteCaracteristicaTemporal>(oNoPedir);
                    }

                    // Se verifica si está marcado o tiene pedidos para procesar, si no, se salta
                    if (!Util.Logico(oFila.Cells["sug_Sel"].Value) || Util.Decimal(oFila.Cells["sug_Pedido"].Value) <= 0)
                        continue;

                    if (Util.Entero(oFila.Cells["sug_ProveedorID"].Value) != proveedorId)
                    {
                        this.Cursor = Cursors.Default;
                        SplashScreen.Close();
                        var msj = string.Format("{0} {1} {2} {3}", "El número de Parte:", Util.Cadena(oFila.Cells["sug_NumeroDeParte"].Value)
                            , "No está asignado al Proveedor:", proveedor.NombreProveedor);
                        Util.MensajeError(msj, GlobalClass.NombreApp);
                        this.btnProcesar.Enabled = true;
                        return;
                    }

                    //
                    var detallePedido = new PedidoDetalle()
                    {
                        PedidoID = pedido.PedidoID,
                        ParteID = iParteID,
                        CantidadPedido = Util.Decimal(oFila.Cells["sug_Pedido"].Value),
                        CostosUnitario = Util.Decimal(oFila.Cells["sug_CostoConDescuento"].Value),
                        PedidoEstatusID = 2
                    };
                    Datos.Guardar<PedidoDetalle>(detallePedido);

                    // Se marca como pedido si es 9500
                    if (Util.Cadena(oFila.Cells["sug_Caracteristica"].Value) == "9500")
                    {
                        var o9500 = Datos.GetListOf<Cotizacion9500Detalle>(c => c.ParteID == iParteID && !c.Pedido && c.Estatus);
                        foreach (var oReg in o9500)
                        {
                            oReg.Pedido = true;
                            Datos.Guardar<Cotizacion9500Detalle>(oReg);
                        }
                    }

                    // Se marca como pedido en reporte de faltante, si aplica
                    if (Util.Cadena(oFila.Cells["sug_Caracteristica"].Value) == "RF")
                    {
                        var oFaltantes = Datos.GetListOf<ReporteDeFaltante>(c => c.ParteID == iParteID && !c.Pedido && c.Estatus);
                        foreach (var oReg in oFaltantes)
                        {
                            oReg.Pedido = true;
                            Datos.Guardar<ReporteDeFaltante>(oReg);
                        }
                    }
                }

                var ped = Datos.GetListOf<PedidosView>(p => p.PedidoID.Equals(pedido.PedidoID));
                var detalle = Datos.GetListOf<PedidosDetalleView>(p => p.PedidoID.Equals(pedido.PedidoID));

                IEnumerable<PedidosView> pedidoE = ped;
                IEnumerable<PedidosDetalleView> detalleE = detalle;

                using (FastReport.Report report = new FastReport.Report())
                {
                    report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReportePedidos.frx"));
                    report.RegisterData(pedidoE, "Pedido");
                    report.GetDataSource("Pedido").Enabled = true;
                    report.RegisterData(detalleE, "DetallePedido");
                    report.GetDataSource("DetallePedido").Enabled = true;
                    report.Show(true);
                }

                this.Cursor = Cursors.Default;
                this.LimpiarFormularioDos();
                SplashScreen.Close();
                this.btnProcesar.Enabled = true;
                new Notificacion("Pedido Guardado exitosamente", 2 * 1000).Mostrar(Principal.Instance);
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                SplashScreen.Close();
                this.btnProcesar.Enabled = true;
                Util.MensajeError(ex.Message, GlobalClass.NombreApp);
            }
        }
Example #32
0
        public static void getReport(string SQL, string AliasName, string FolderName, string FileName)
        {
            FastReport.Report report = new FastReport.Report();
            try
            {
                if (Function.FTPDownload(@"C:\Report/" + FolderName, FolderName, FileName))
                {
                    DataTable dt = Services.Database.ExecuteQuery(SQL).Tables[0];

                    report.RegisterData(dt, AliasName);
                    report.GetDataSource(AliasName).Enabled = true;
                    report.Load(@"C:\Report/" + FolderName + "/" + FileName);
                    report.Show();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Дараахи алдаа гарлаа. " + ex.Message.ToString(), "Алдаа", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                report.Dispose();
            }
        }
Example #33
0
        private void btnImprimir_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.dgvDatos.DataSource == null)
                    return;

                BindingSource bs = (BindingSource)this.dgvDatos.DataSource;
                DataTable dt = (DataTable)bs.DataSource;

                using (FastReport.Report report = new FastReport.Report())
                {
                    report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReportePartesClasificacionAbc.frx"));
                    report.RegisterData(dt, "PartesClasificacionAbc");
                    report.GetDataSource("PartesClasificacionAbc").Enabled = true;
                    report.Show(true);
                }
            }
            catch (Exception ex)
            {
                Util.MensajeError(ex.Message, GlobalClass.NombreApp);
            }
        }
Example #34
0
        private void DisplayReporteEntradaCompra()
        {
            try
            {
                var movimiento = Datos.GetListOf<MovimientoInventarioView>(m => m.MovimientoInventarioID.Equals(oID));
                var detalle = Datos.GetListOf<MovimientoInventarioDetalleView>(d => d.MovimientoInventarioID.Equals(oID));

                var detalleDescuentosGen = new List<MovimientoInventarioDescuentoView>();
                var detalleDescuentosGenerales = Datos.GetListOf<MovimientoInventarioDescuentoView>(m => m.MovimientoInventarioID.Equals(oID)
                    && (m.TipoDescuentoID.Equals(1) || m.TipoDescuentoID.Equals(4) || m.TipoDescuentoID.Equals(2) || m.TipoDescuentoID.Equals(5)));

                bool uno = false;
                bool cuatro = false;
                bool dos = false;
                bool cinco = false;
                foreach (var descuentoGen in detalleDescuentosGenerales)
                {
                    if (descuentoGen.TipoDescuentoID.Equals(1) && uno.Equals(false))
                    {
                        uno = true;
                        detalleDescuentosGen.Add(descuentoGen);
                    }
                    if (descuentoGen.TipoDescuentoID.Equals(4) && cuatro.Equals(false))
                    {
                        cuatro = true;
                        detalleDescuentosGen.Add(descuentoGen);
                    }
                    if (descuentoGen.TipoDescuentoID.Equals(2) && dos.Equals(false))
                    {
                        dos = true;
                        detalleDescuentosGen.Add(descuentoGen);
                    }
                    if (descuentoGen.TipoDescuentoID.Equals(5) && cinco.Equals(false))
                    {
                        cinco = true;
                        detalleDescuentosGen.Add(descuentoGen);
                    }
                }

                var detalleDescuentosInd = Datos.GetListOf<MovimientoInventarioDescuentoView>(m => m.MovimientoInventarioID.Equals(oID)
                    && m.TipoDescuentoID.Equals(3));

                foreach (var descuentoGen in detalleDescuentosInd)
                {
                    detalleDescuentosGen.Add(descuentoGen);
                }

                IEnumerable<MovimientoInventarioView> movimientoE = movimiento;
                IEnumerable<MovimientoInventarioDetalleView> detalleE = detalle;
                IEnumerable<MovimientoInventarioDescuentoView> descuentosGen = detalleDescuentosGen;
                //IEnumerable<MovimientoInventarioDescuentoView> descuentosInd = detalleDescuentosInd;

                using (FastReport.Report report = new FastReport.Report())
                {
                    report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteEntradaCompra.frx"));
                    report.RegisterData(movimientoE, "movimiento", 3);
                    report.RegisterData(detalleE, "detalle", 3);
                    report.RegisterData(descuentosGen, "descuentosGenerales", 3);
                    //report.RegisterData(descuentosInd, "descuentosIndividuales", 3);
                    report.GetDataSource("movimiento").Enabled = true;
                    report.GetDataSource("detalle").Enabled = true;
                    report.GetDataSource("descuentosGenerales").Enabled = true;
                    //report.GetDataSource("descuentosIndividuales").Enabled = true;
                    report.Show(true);
                }

            }
            catch (Exception ex)
            {
                Util.MensajeError(ex.Message, GlobalClass.NombreApp);
            }
        }
Example #35
0
        private void DisplayReporteEtiquetas()
        {
            try
            {
                var movimientoEtiquetas = Datos.GetListOf<MovimientoInventarioEtiquetasView>(l => l.MovimientoInventarioID.Equals(oID));
                var listaEtiquetas = new List<Etiquetas>();

                var cont = 0;
                foreach (var etiqueta in movimientoEtiquetas)
                {
                    for (var x = 0; x < etiqueta.NumeroEtiquetas; x++)
                    {
                        cont += 1;
                        var e = new Etiquetas()
                        {
                            MovimientoInventarioEtiquetaID = cont,
                            MovimientoInventarioID = oID,
                            ParteID = etiqueta.ParteID,
                            NumeroParte = etiqueta.NumeroParte,
                            CodigoBarra = etiqueta.CodigoBarra,
                            NumeroEtiquetas = 1,
                            NombreParte = etiqueta.NombreParte
                        };
                        listaEtiquetas.Add(e);
                    }
                }

                // Se obtiene el folio de la factura, para mandarlo al reporte
                var oMov = Datos.GetEntity<MovimientoInventario>(c => c.MovimientoInventarioID == oID);

                IEnumerable<Etiquetas> detalleE = listaEtiquetas;
                using (FastReport.Report report = new FastReport.Report())
                {
                    report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteEtiquetas.frx"));
                    report.RegisterData(detalleE, "etiquetas", 3);
                    report.SetParameterValue("FolioFactura", oMov.FolioFactura);
                    report.GetDataSource("etiquetas").Enabled = true;
                    report.Show(true);
                    //report.Design(true);
                }

            }
            catch (Exception ex)
            {
                Util.MensajeError(ex.Message, GlobalClass.NombreApp);
            }
        }
Example #36
0
        private void DisplayReporteTraspaso()
        {
            try
            {
                var movimiento = Datos.GetListOf<MovimientoInventarioView>(m => m.MovimientoInventarioID.Equals(oID));
                var detalle = Datos.GetListOf<MovimientoInventarioDetalleView>(d => d.MovimientoInventarioID.Equals(oID));

                IEnumerable<MovimientoInventarioView> movimientoE = movimiento;
                IEnumerable<MovimientoInventarioDetalleView> detalleE = detalle;

                using (FastReport.Report report = new FastReport.Report())
                {
                    if (detalle.Count < 10)
                        report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteTraspaso.frx"));
                    else
                        report.Load(string.Format("{0}{1}", GlobalClass.ConfiguracionGlobal.pathReportes, "ReporteTraspasosMasDeDiez.frx"));

                    report.RegisterData(movimientoE, "movimiento", 3);
                    report.RegisterData(detalleE, "detalle", 3);
                    report.GetDataSource("movimiento").Enabled = true;
                    report.GetDataSource("detalle").Enabled = true;
                    report.Show(true);
                }
            }
            catch (Exception ex)
            {
                Util.MensajeError(ex.Message, GlobalClass.NombreApp);
            }
        }