private void Form2_Load(object sender, EventArgs e)
{
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
ConInfo.ConnectionInfo.UserID = DB_Base.Constr3;
ConInfo.ConnectionInfo.Password = DB_Base.Constr4;
ConInfo.ConnectionInfo.ServerName = DB_Base.Constr0;
ConInfo.ConnectionInfo.DatabaseName = DB_Base.Constr1;
for (int intCounter = 0; intCounter <= report_List_Hoghogh1.Database.Tables.Count - 1; intCounter++)
{
report_List_Hoghogh1.Database.Tables[intCounter].ApplyLogOnInfo(ConInfo);
}
ParameterFields paramFields = new ParameterFields();
paramFields.Clear();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
paramField1.Name = "@noe";
paramDiscreteValue1.Value = sarbarg;
paramField1.CurrentValues.Add(paramDiscreteValue1);
paramFields.Add(paramField1);
crystalReportViewer1.ReportSource = report_List_Hoghogh1;
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
protected override void OnSetParameterFields(ParameterFields myParams)
{
myParams.Clear();
switch (base.Key)
{
case "Phiếu nhập":
ut.SetParameterReport(myParams, "TrungTam", cboTrungTam.Text);
ut.SetParameterReport(myParams, "Ngay", txtNgayNhap.Text);
ut.SetParameterReport(myParams, "SoPhieuNhap", txtPhieuNhap.Text);
ut.SetParameterReport(myParams, "Kho", cboKho.Text);
ut.SetParameterReport(myParams, "GhiChu", txtGhiChu.Text);
ut.SetParameterReport(myParams, "SoTienChu", Common.ReadNumner_(txtTongTienHang.Text));
break;
case "Phiếu nhập chi tiết imei":
ut.SetParameterReport(myParams, "TrungTam", cboTrungTam.Text);
ut.SetParameterReport(myParams, "Ngay", txtNgayNhap.Text);
ut.SetParameterReport(myParams, "SoPhieuNhap", txtPhieuNhap.Text);
ut.SetParameterReport(myParams, "Kho", cboKho.Text);
ut.SetParameterReport(myParams, "GhiChu", txtGhiChu.Text);
break;
case "Các mã sản phẩm không hợp lệ":
ut.SetParameterReport(myParams, "TrungTam", cboTrungTam.Text);
ut.SetParameterReport(myParams, "Kho", cboKho.Text);
break;
}
}
private void خلاصهمالیاتToolStripMenuItem_Click(object sender, EventArgs e)
{
if (set_info_work() == true)
{
Pey4_CrystalReports.Form7 f = new Pey4_CrystalReports.Form7();
f.Text = " خلاصه مالیات - شرکت : " + comboBox3.Text + " - سال : " + id_year + " - ماه : " + comboBox1.Text;
ParameterFields paramFields = new ParameterFields();
paramFields.Clear();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
paramField1.Name = "@idgroup";
paramDiscreteValue1.Value = id_group;
paramField1.CurrentValues.Add(paramDiscreteValue1);
paramFields.Add(paramField1);
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue2 = new ParameterDiscreteValue();
paramField2.Name = "@idyear";
paramDiscreteValue2.Value = id_year;
paramField2.CurrentValues.Add(paramDiscreteValue2);
paramFields.Add(paramField2);
ParameterField paramField3 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue3 = new ParameterDiscreteValue();
paramField3.Name = "@idmoon";
paramDiscreteValue3.Value = id_moon;
paramField3.CurrentValues.Add(paramDiscreteValue3);
paramFields.Add(paramField3);
DataBase.Connection_Open();
DataBase.Fill("SELECT * FROM Tbl_maliat WHERE (tmpid=1)", objDataSet, "Tbl_maliat", true);
DataBase.Connection_Close();
ParameterField paramField4 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue4 = new ParameterDiscreteValue();
paramField4.Name = "@maliat_ta1";
paramDiscreteValue4.Value = objDataSet.Tables["Tbl_maliat"].Rows[0]["maliat_ta"].ToString();
paramField4.CurrentValues.Add(paramDiscreteValue4);
paramFields.Add(paramField4);
string file_name_date = @"DD.dll";
string[] installs_date = new string[1];
installs_date = System.IO.File.ReadAllLines(file_name_date, Encoding.Unicode);
ParameterField paramField5 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue5 = new ParameterDiscreteValue();
paramField5.Name = "@date2";
paramDiscreteValue5.Value = installs_date[0];
paramField5.CurrentValues.Add(paramDiscreteValue5);
paramFields.Add(paramField5);
f.paramFields = paramFields;
f.Show();
}
}
private void toolStripButtonPrint_Click(object sender, EventArgs e)
{
try
{
StaCatalina.Forms.Reports _Reporte = new Reports();
ReportDocument objReport = new ReportDocument();
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "EnvioArticulos.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
//crystalReportViewer.ShowGroupTreeButton = true;
// PARAMETROS DE CONEXION
TableLogOnInfo logoninfo = new TableLogOnInfo();
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false;
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
// FIN PARAMETROS DE CONEXION
ParameterFields Parametros = new ParameterFields();
ParameterField ParametroField = new ParameterField();
ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue();
Parametros.Clear();
//1er PARAMETRO
ParametroField.Name = "@fechaDesde";
ParametroValue.Value = this.dateTimeDesde.Value.ToString("yyyy-MM-dd 00:00:00");
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//2° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@fechaHasta";
ParametroValue.Value = this.dateTimeHasta.Value.ToString("yyyy-MM-dd 23:59:59");
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
_Reporte.Parameters = Parametros;
_Reporte.Reporte = objReport;
_Reporte.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void HistoricoPrecios()
{
try
{
StaCatalina.Forms.Reports _Reporte = new Reports();
ReportDocument objReport = new ReportDocument();
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "HistoricoDePrecios.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
// PARAMETROS DE CONEXION
TableLogOnInfo logoninfo = new TableLogOnInfo();
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false;
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
// FIN PARAMETROS DE CONEXION
ParameterFields Parametros = new ParameterFields();
ParameterField ParametroField = new ParameterField();
ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue();
Parametros.Clear();
//1er PARAMETRO
ParametroField.Name = "@codProducto";
ParametroValue.Value = this.comboBoxProductoxRubro.SelectedValue;
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
//2° PARAMETRO
ParametroField = new ParameterField();
ParametroValue = new ParameterDiscreteValue();
ParametroField.Name = "@codEmp";
ParametroValue.Value = Clases.Usuario.EmpresaLogeada.EmpresaIngresada.Trim();
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
_Reporte.Parameters = Parametros;
_Reporte.Reporte = objReport;
_Reporte.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ImprimeEpicrisis()
{
try
{
Reports _Reporte = new Reports();
ReportDocument objReport = new ReportDocument();
//String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt";
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "Epicrisis.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
// PARAMETROS DE CONEXION
TableLogOnInfo logoninfo = new TableLogOnInfo();
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSISTMED"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false;
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
// FIN PARAMETROS DE CONEXION
ParameterFields Parametros = new ParameterFields();
ParameterField ParametroField = new ParameterField();
ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue();
Parametros.Clear();
//1er PARAMETRO
ParametroField.Name = "@PACIENTE_ID";
ParametroValue.Value = Clases.Paciente.PacienteIngresado;
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
_Reporte.Parameters = Parametros;
_Reporte.Reporte = objReport;
_Reporte.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected override void OnSetParameterFields(ParameterFields myParams)
{
myParams.Clear();
switch (_transType)
{
case TransactionType.XUAT_BAN:
ut.SetParameterReport(myParams, "pTitle", "CHI TIẾT GIAO DỊCH BÁN HÀNG");
break;
case TransactionType.NHAP_TRA_LAI:
ut.SetParameterReport(myParams, "pTitle", "CHI TIẾT GIAO DỊCH NHẬP TRẢ LẠI");
break;
case TransactionType.XUAT_HUY_TIEU_HAO:
ut.SetParameterReport(myParams, "pTitle", "CHI TIẾT GIAO DỊCH XUẤT HỦY TIÊU HAO");
break;
}
ut.SetParameterReport(myParams, "pTrungTam", cboTrungTam.Text);
ut.SetParameterReport(myParams, "pTuNgay", dtTuNgay.Value.ToString("dd/MM/yyyy"));
ut.SetParameterReport(myParams, "pDenNgay", dtDenNgay.Value.ToString("dd/MM/yyyy"));
}
private void btnGenerar_Click(object sender, EventArgs e)
{
if(todos)
{
//C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteProveedor.rpt
FormProveedor formulario = new FormProveedor();
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(@"C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteProveedor.rpt");
formulario.crystalReportViewer1.ReportSource = crystalrpt;
formulario.crystalReportViewer1.Refresh();
formulario.Show();
}
else
{
DateTime fecha = dateDesde.Value;
string fechaDesde = fecha.ToString("d");
DateTime fecha2 = dateHasta.Value;
string fechaHasta = fecha2.ToString("d");
FormProveedoresParametros form = new FormProveedoresParametros();
ReportDocument oRep = new ReportDocument();
ParameterField pf = new ParameterField();
ParameterFields pfs = new ParameterFields();
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
pf.Name = "@fechaDesde";
pdv.Value = fechaDesde;
pf.CurrentValues.Add(pdv);
pfs.Add(pf);
pfs.Clear();
pf.Name = "@fechaHasta";
pdv.Value = fechaHasta;
pf.CurrentValues.Add(pdv);
pfs.Add(pf);
form.crystalReportViewer1.ParameterFieldInfo = pfs;
oRep.Load(@"C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteProveedoresParametros.rpt");
form.crystalReportViewer1.ReportSource = oRep;
form.Show();
}
}
private void btnGenerar_Click(object sender, EventArgs e)
{
FormFacturaC form = new FormFacturaC();
if(todos)
{
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(@"C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteTodosFacturasClientes.rpt");
form.crystalReportViewer1.ReportSource = crystalrpt;
form.crystalReportViewer1.Refresh();
form.Show();
}
else
if(fecha)
{
DateTime fecha1 = dateDesde.Value;
string fechaDesde = fecha1.ToString("d");
DateTime fecha2 = dateHasta.Value;
string fechaHasta = fecha2.ToString("d");
ReportDocument oRep = new ReportDocument();
ParameterField pf = new ParameterField();
ParameterFields pfs = new ParameterFields();
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
pf.Name = "@fechaDesde";
pdv.Value = fechaDesde;
pf.CurrentValues.Add(pdv);
pfs.Add(pf);
pfs.Clear();
pf.Name = "@fechaHasta";
pdv.Value = fechaHasta;
pf.CurrentValues.Add(pdv);
pfs.Add(pf);
form.crystalReportViewer1.ParameterFieldInfo = pfs;
oRep.Load(@"C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteFacturaClientePorFecha.rpt");
form.crystalReportViewer1.ReportSource = oRep;
form.Show();
}
else
{
if(txtNumFact.Text.Equals(""))
{
MessageBox.Show("Debe ingresar un Nro de Factura");
}
else
{
bool numFactura = MetodosBD.buscarNumFactCliente(txtNumFact.Text);
if(numFactura)
{
ReportDocument oRep = new ReportDocument();
ParameterField pf = new ParameterField();
ParameterFields pfs = new ParameterFields();
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
pf.Name = "@numFact";
pdv.Value = txtNumFact.Text;
pf.CurrentValues.Add(pdv);
pfs.Add(pf);
form.crystalReportViewer1.ParameterFieldInfo = pfs;
oRep.Load(@"C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteFacturaCliente2.rpt");
form.crystalReportViewer1.ReportSource = oRep;
form.Show();
}
else
{
MessageBox.Show("Número de Factura No existe");
}
}
}
}
