private void btnExecute_Click(object sender, EventArgs e)
{
ReportDocument report = new ReportDocument();
report.Load(this.filePath);
report.SetDatabaseLogon(userName, password, server, db);
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
//order no
crParameterDiscreteValue.Value = txtFilter.Text;
crParameterFieldDefinitions = report.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["orderNo"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
//start date
crParameterDiscreteValue.Value = dtpStartDate.Value;
crParameterFieldDefinitions = report.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["startDate"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
//end date
crParameterDiscreteValue.Value = dtpEndDate.Value;
crParameterFieldDefinitions = report.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["endDate"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
ConnectionInfo crConnectionInfo = new ConnectionInfo();
crConnectionInfo.ServerName = server;
crConnectionInfo.DatabaseName = db;
crConnectionInfo.UserID = userName;
crConnectionInfo.Password = password;
TableLogOnInfo logOnInfo = new TableLogOnInfo();
logOnInfo.ConnectionInfo = crConnectionInfo;
TableLogOnInfos logOnInfos = new TableLogOnInfos();
logOnInfos.Add(logOnInfo);
crystalReportViewer.LogOnInfo = logOnInfos;
crystalReportViewer.ReportSource = report;
crystalReportViewer.Refresh();
}
public void GenerarVentasTodo()
{
//Llamas el reporte
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(@"C:\Users\Frank Crow-Belloso\Source\CapaDatos4\CapaPresentacion2\Modulo_Empleados\INTERFAZ_PRINCIPAL\VentasTodo.rpt");
//declaras los metodos
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValue = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
//parametro Fecha Inicial
crParameterDiscreteValue.Value = dtp_inicial.Value;
crParameterFieldDefinitions = crystalrpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["FechaInicial"];
crParameterValue = crParameterFieldDefinition.CurrentValues;
crParameterValue.Clear();
crParameterValue.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValue);
//parametro Fecha Final
crParameterDiscreteValue.Value = dtp_final.Value;
crParameterFieldDefinitions = crystalrpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["FechaFinal"];
crParameterValue = crParameterFieldDefinition.CurrentValues;
crParameterValue.Clear();
crParameterValue.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValue);
//Parametro Nombre Producto
crParameterDiscreteValue.Value = cb_producto.Text;
crParameterFieldDefinitions = crystalrpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["NombreProducto"];
crParameterValue = crParameterFieldDefinition.CurrentValues;
crParameterValue.Clear();
crParameterValue.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValue);
//Parametro Id Empleado
crParameterDiscreteValue.Value = Convert.ToInt32(cb_empleado.Text.Substring(0, cb_empleado.Text.IndexOf(" -")));//Envio el IdVenta
crParameterFieldDefinitions = crystalrpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["IdEmpleado"];
crParameterValue = crParameterFieldDefinition.CurrentValues;
crParameterValue.Clear();
crParameterValue.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValue);
//Ejecuta el reporte
crystalReportViewer1.ReportSource = crystalrpt;
crystalReportViewer1.Refresh();
}
public void GetInventoryMonthly(string file)
{
int year = Convert.ToInt32(comboBox2.Text.Trim());
string month = comboBox3.Text.Trim();
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(file);
ConnectionInfo crConnectionInfo = new ConnectionInfo();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = year;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["yearparam"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = month;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["monthparam"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crConnectionInfo.ServerName = "localhost";
crConnectionInfo.DatabaseName = "slimmersdb";
crConnectionInfo.UserID = "root";
crConnectionInfo.Password = "******";
inventoryView.ReportSource = cryRpt;
inventoryView.RefreshReport();
inventfilter = "";
inventfilter2 = "";
panel7.Hide();
btnSales.Enabled = true;
btnInventory.Enabled = true;
btnPatients.Enabled = true;
btnReceipts.Enabled = true;
btnAppointments.Enabled = true;
btnInventoryList.Enabled = true;
btnPullOut.Enabled = true;
btnRestock.Enabled = true;
Pulloutfilter.Enabled = true;
Restockfilter.Enabled = true;
inventoryFilter.Enabled = true;
bunifuFlatButton19.Enabled = true;
bunifuFlatButton18.Enabled = true;
}
private void Bank_Account_Printcs_Load(object sender, EventArgs e)
{
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(Application.StartupPath + @"\Bank Account Report.rpt");
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = Day;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Day"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = Day2;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Day2"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = BankID;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@BankID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = BankName;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["name"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}
private void Product_Account_Print_Load(object sender, EventArgs e)
{
string path = Application.StartupPath;
string directory = Path.GetDirectoryName(path); //without file name
string oneUp = Path.GetDirectoryName(directory); // Temp folder
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(Application.StartupPath + @"\Product Account Report.rpt");
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = Day;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Day"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = Day2;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Day2"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = product_ID;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@product_ID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}
public void GetWeeklyAppoint(string file)
{
int year = Convert.ToInt32(comboBox7.Text.Trim());
string month = comboBox8.Text.Trim();
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(file);
ConnectionInfo crConnectionInfo = new ConnectionInfo();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = year;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["yearparam"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = month;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["monthparam"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crConnectionInfo.ServerName = "localhost";
crConnectionInfo.DatabaseName = "slimmersdb";
crConnectionInfo.UserID = "root";
crConnectionInfo.Password = "******";
appointmentViewer.ReportSource = cryRpt;
appointmentViewer.RefreshReport();
appointfilter = "";
btnAppointments.Enabled = true;
btnInventory.Enabled = true;
btnPatients.Enabled = true;
btnReceipts.Enabled = true;
btnSales.Enabled = true;
appointmentFilter.Enabled = true;
panel14.Visible = false;
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(@"C:\Users\Lahkrome\Desktop\Beta Sinergia\alfa2_Sinergia\CrystalReport.rpt");
//crystalReportViewer1.ReportSource = crystalrpt;
//crystalReportViewer1.Refresh();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = textBox1.Text;
crParameterFieldDefinitions = crystalrpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["ProductName"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = crystalrpt;
crystalReportViewer1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(@"C:\Users\Lahkrome\Desktop\Beta Sinergia\alfa2_Sinergia\CrystalReport.rpt");
//crystalReportViewer1.ReportSource = crystalrpt;
//crystalReportViewer1.Refresh();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = textBox1.Text;
crParameterFieldDefinitions = crystalrpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["ProductName"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = crystalrpt;
crystalReportViewer1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show("Error"+ex);
}
}
// ================================================================================================= ||
// Esta linea de codigo representa el metodo imprimir() para imprimir la factura en la cual estemos
// trabajando
// ================================================================================================= ||
private void imprimir()
{
try
{
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load("C:\\Users\\JOSE\\Documents\\Visual Studio 2013\\Projects\\Proyectos\\Lavanderia0.1\\Lavanderia0.1\\reporte1.rpt");
ParameterFieldDefinition definicion_parametro;
ParameterFieldDefinitions definiciones_parametros;
ParameterValues valor = new ParameterValues();
ParameterDiscreteValue discretevalor = new ParameterDiscreteValue();
discretevalor.Value = f.dameid1();
definiciones_parametros = crystalrpt.DataDefinition.ParameterFields;
definicion_parametro = definiciones_parametros["param1"];
valor = definicion_parametro.CurrentValues;
valor.Clear();
valor.Add(discretevalor);
definicion_parametro.ApplyCurrentValues(valor);
crystalrpt.PrintToPrinter(1, true, 0, 0);
}
catch (CrystalReportsException cr)
{
MessageBox.Show(cr.Message);
}
catch (Exception e) { MessageBox.Show(e.Message); }
}
protected void Page_Load(object sender, EventArgs e)
{
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("~/Reports/crptDepartment.rpt"));
ParameterFieldDefinition pdf;
ParameterFieldDefinitions pdfs;
ParameterValues pvs = new ParameterValues();
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
if (Session["User_Id"].ToString() != (100).ToString())
{
pdv.Value = Convert.ToInt16(Session["User_Id"]);
pdfs = rd.DataDefinition.ParameterFields;
pdf = pdfs["FacultyID"];
pvs = pdf.CurrentValues;
pvs.Clear();
pvs.Add(pdv);
pdf.ApplyCurrentValues(pvs);
}
CrystalReportViewer1.ReportSource = rd;
}
private void printBatchToolStripButton_Click(object sender, EventArgs e)
{
long batchId = (long)this.aCHFileDataGridView.SelectedRows[0].Cells[0].Value;
ReportDocument report = new ReportDocument();
report.Load(@"\\cfs-fileserv01\ACHReports\Abra Reports\Misc\ACH Batch Details.rpt");
ParameterFieldDefinitions parameters = report.DataDefinition.ParameterFields;
ParameterFieldDefinition parameter = parameters["BatchId"];
ParameterDiscreteValue parameterValue = new ParameterDiscreteValue();
parameterValue.Value = batchId;
ParameterValues values = new ParameterValues();
values = parameter.CurrentValues;
values.Clear();
values.Add(parameterValue);
parameter.ApplyCurrentValues(values);
if (this.printDialog.ShowDialog() == DialogResult.OK)
{
report.PrintOptions.PrinterName = this.printDialog.PrinterSettings.PrinterName;
report.PrintToPrinter(1, false, 0, 0);
}
}
public void reportes(string fecha1, string fecha2)
{
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(metodos.ruta + "CrystalReportNominaDpto.rpt");
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = cbNominas.Text;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions[fecha1];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = cbDpto.Text;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions[fecha2];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Update();
crystalReportViewer1.Refresh();
}
void Ticket(string parametro)
{
CapaPresentacion.Venta_Ticket VT = new CapaPresentacion.Venta_Ticket();
//Llamas el reporte
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(@"C:\Users\Frank Crow-Belloso\Source\CapaDatos4\CapaPresentacion\Ticket.rpt");
//declaras los metodos
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValue = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
//parametro 1
crParameterDiscreteValue.Value = parametro;//Envio el IdVenta
crParameterFieldDefinitions = crystalrpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["IdVenta"];
crParameterValue = crParameterFieldDefinition.CurrentValues;
crParameterValue.Clear();
crParameterValue.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValue);
//Ejecuta el reporte
VT.crystalReportViewer1.ReportSource = crystalrpt;
VT.crystalReportViewer1.Refresh();
VT.ShowDialog();
}
private void InHoaDon_Load(object sender, EventArgs e)
{
ReportDocument crypt = new ReportDocument();
crypt.Load("F:/Documents/GitHub/QuanLyCafe/QuanLyCafe/CrystalReport1.rpt");
ParameterFieldDefinitions pfds;
ParameterFieldDefinition pfd;
ParameterValues pv = new ParameterValues();
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
pdv.Value = mabill;
pfds = crypt.DataDefinition.ParameterFields;
pfd = pfds["MaBill"];
pv = pfd.CurrentValues;
pv.Clear();
pv.Add(pdv);
pfd.ApplyCurrentValues(pv);
ParameterValues pv1 = new ParameterValues();
ParameterDiscreteValue pdv1 = new ParameterDiscreteValue();
pdv1.Value = Giamgia;
pfds = crypt.DataDefinition.ParameterFields;
pfd = pfds["GiamGia"];
pv1 = pfd.CurrentValues;
pv1.Clear();
pv1.Add(pdv1);
pfd.ApplyCurrentValues(pv1);
crystalReportViewer1.ReportSource = crypt;
crystalReportViewer1.Refresh();
}
private void previewBatchToolStripButton1_Click(object sender, EventArgs e)
{
ReportDocument report = new ReportDocument();
report.Load(@"\\cfs-fileserv01\ACHReports\ACH Batch Details.rpt");
ParameterFieldDefinitions parameters = report.DataDefinition.ParameterFields;
ParameterFieldDefinition parameter = parameters["BatchId"];
ParameterDiscreteValue parameterValue = new ParameterDiscreteValue();
parameterValue.Value = this._batchId;
ParameterValues values = new ParameterValues();
values = parameter.CurrentValues;
values.Clear();
values.Add(parameterValue);
parameter.ApplyCurrentValues(values);
Reports.PreviewReport preview = new Cfs.Custom.Software.Reports.PreviewReport();
preview.Report = report;
preview.MdiParent = this.ParentForm;
preview.Show();
}
private void printReportToolStripButton_Click(object sender, EventArgs e)
{
ReportDocument report = new ReportDocument();
report.Load(@"\\cfs-intranet\Abra Reports\Misc\ACH Batch Details.rpt");
ParameterFieldDefinitions parameters = report.DataDefinition.ParameterFields;
ParameterFieldDefinition parameter = parameters["BatchId"];
ParameterDiscreteValue parameterValue = new ParameterDiscreteValue();
parameterValue.Value = this._batchId;
ParameterValues values = new ParameterValues();
values = parameter.CurrentValues;
values.Clear();
values.Add(parameterValue);
parameter.ApplyCurrentValues(values);
if (this.printDialog.ShowDialog() == DialogResult.OK)
{
report.PrintOptions.PrinterName = this.printDialog.PrinterSettings.PrinterName;
report.PrintToPrinter(1, false, 0, 0);
}
}
private void CRviewer_Load(object sender, EventArgs e)
{
try
{
String PsngrId = PID;
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load("C:\\Users\\HOME\\Desktop\\Running\\Railway_Reservation_System\\RailForms\\CRticket.rpt");
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = PsngrId;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["PassengerId"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
public void ShowReport(string reportFileName, string reportTitle, string MaPN)
{
CRPPhieunhap rpt = new CRPPhieunhap();
#region
rpt.Load(string.Format("{0}\\Reports\\{1}", Application.StartupPath, reportFileName));
TableLogOnInfo tli = new TableLogOnInfo();
tli.ConnectionInfo.ServerName = "WINDOWS-S8RLUFM\\SQLEXPRESS";
tli.ConnectionInfo.DatabaseName = "BibyShop";
tli.ConnectionInfo.IntegratedSecurity = true;
foreach (Table t in rpt.Database.Tables)
{
t.ApplyLogOnInfo(tli);
}
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = MaPN;
crParameterFieldDefinitions = rpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@MaPN"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
#endregion
if (!string.IsNullOrEmpty(reportTitle))
{
rpt.SummaryInfo.ReportTitle = reportTitle;
}
CRVPhieunhap.ReportSource = rpt;
}
private void comboUsername_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load("C:\\Users\\HOME\\Desktop\\Running\\Railway_Reservation_System\\RailForms\\ByUserReservation.rpt");
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = comboUsername.Text;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["UserName"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void FrmVisualizadorContrato_Load(object sender, EventArgs e)
{
//ReportDocument report = new ReportDocument();
//report.Load("C:\\Users\\João\\Documents\\Video Aulas\\Canal Professor Drausion\\1° Temporada\\KISNER_EVENTOS\\Apresentacao\\Relatorios\\Contrato\\RelContrato.rpt");
//string path = System.Reflection.Assembly.GetExecutingAssembly().Location;
//report.Load("\\Relatorios\\Contrato\\RelContrato.rpt");
Relatorios.Contrato.RelContrato report = new Relatorios.Contrato.RelContrato();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = codEvento;
crParameterFieldDefinitions = report.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["ParCodEvento"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
//trabalhando com os brinquedos escolhidos pelo usuário! Usando DataSet
/*Relatorios.Contrato.DsEventoBrinquedo eb = new Relatorios.Contrato.DsEventoBrinquedo();
DataTable brinquedos = eb.Tables.Add("DtBrinquedo");
brinquedos.Columns.Add("codBrinquedo", Type.GetType("System.Int32"));
brinquedos.Columns.Add("nome", Type.GetType("System.String"));
BrinquedoColecao bc = new BrinquedoColecao();
*/
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = report;
crystalReportViewer1.Refresh();
}
private void button_Click(object sender, RoutedEventArgs e)
{
CapaPresentacion.Venta_Ticket VT = new CapaPresentacion.Venta_Ticket();
//Llamas el reporte
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(@"C:\Users\pclr\Desktop\CapaPresentacion\CapaPresentacion\Ticket.rpt");
//declaras los metodos
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValue = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
//parametro 1
crParameterDiscreteValue.Value = "111";//Envio el IdVenta
crParameterFieldDefinitions = crystalrpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["IdVenta"];
crParameterValue = crParameterFieldDefinition.CurrentValues;
crParameterValue.Clear();
crParameterValue.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValue);
//Ejecuta el reporte
VT.crystalReportViewer1.ReportSource = crystalrpt;
VT.crystalReportViewer1.Refresh();
VT.ShowDialog();
}
public static bool export_pdf(string pdf_path, string db_name, string crystal_path, string docentry)
{
try
{
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(crystal_path);
new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo;
var crConnectionInfo = new ConnectionInfo();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = Convert.ToString(docentry);
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@DOCENTRY"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crConnectionInfo.ServerName = "SYSPEXSAP04";
crConnectionInfo.DatabaseName = db_name;
crConnectionInfo.UserID = "sa";
crConnectionInfo.Password = "******";
var crTables = cryRpt.Database.Tables;
foreach (Table crTable in crTables)
{
crtableLogoninfo = crTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crtableLogoninfo);
}
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = pdf_path;
CrExportOptions = cryRpt.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
cryRpt.Export();
return(true);
}
catch (CrystalReportsException ex)
{
throw ex;
}
}
private void Parametros(string parametro1, string parametro2)
{
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(@"B:\Desarrollo\C#\GIT\INVAZD\Inventario_Avanzado\CrystalReport1.rpt");
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
// ----------Parametro Detalles----------
crParameterDiscreteValue.Value = parametro1;
crParameterFieldDefinitions = crystalrpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["detalles"];
crParameterValues.Add(crParameterDiscreteValue);
//crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
// ----------Parametro cantidad----------
crParameterDiscreteValue.Value = parametro2;
crParameterFieldDefinitions = crystalrpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["cantidad"];
crParameterValues.Add(crParameterDiscreteValue);
//crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterValues.Clear();
crystalReportViewer1.ReportSource = crystalrpt;
crystalReportViewer1.Refresh();
}
private void rpt_customers_details_Load(object sender, EventArgs e)
{
try
{
String RES_NO = REPORT.RESERVATION_NO;
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(Application.StartupPath + "\\reports\\RECEIPT.rpt");
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterDiscreteValue.Value = RES_NO;
crParameterFieldDefinition = crParameterFieldDefinitions["RESERVATION_NO"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}
catch (Exception EX)
{
MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error());
mdg.ShowDialog();
}
}
private void previewBatchToolStripButton_Click(object sender, EventArgs e)
{
long batchId = (long)this.aCHFileDataGridView.SelectedRows[0].Cells[0].Value;
ReportDocument report = new ReportDocument();
report.Load(@"\\cfs-intranet\Abra Reports\Misc\ACH Batch Details.rpt");
ParameterFieldDefinitions parameters = report.DataDefinition.ParameterFields;
ParameterFieldDefinition parameter = parameters["BatchId"];
ParameterDiscreteValue parameterValue = new ParameterDiscreteValue();
parameterValue.Value = batchId;
ParameterValues values = new ParameterValues();
values = parameter.CurrentValues;
values.Clear();
values.Add(parameterValue);
parameter.ApplyCurrentValues(values);
Reports.PreviewReport preview = new Cfs.Custom.Software.Reports.PreviewReport();
preview.Report = report;
preview.MdiParent = this.ParentForm;
preview.Show();
}
public void receipt()
{
try
{
cryRpt.Load(System.IO.Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, System.AppDomain.CurrentDomain.RelativeSearchPath ?? "rptReciept.rpt"));
// cryRpt.Load("C:\\Users\\YouJezzy\\Documents\\Visual Studio 2015\\Projects\\LuckInventorySystem_v2\\LuckInventorySystem_v2\\rptReciept.rpt");
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = tranx_no;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["tranx_no"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void GetToday(string date, string file)
{
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(file);
ConnectionInfo crConnectionInfo = new ConnectionInfo();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = date;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["dateparam"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crConnectionInfo.ServerName = "localhost";
crConnectionInfo.DatabaseName = "slimmersdb";
crConnectionInfo.UserID = "root";
crConnectionInfo.Password = "******";
productViewer.ReportSource = cryRpt;
productViewer.RefreshReport();
}
public void reportes(string fecha1, string fecha2)
{
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(conexiones.ruta + "CrystalReportRegalia.rpt");
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = dtpInicio.Value.ToShortDateString();
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions[fecha1];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = dtpFinal.Value.ToShortDateString();
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions[fecha2];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Update();
crystalReportViewer1.Refresh();
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.Text != "")
{
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load("C:\\Users\\Udara Indrajith\\Documents\\2nd year\\2nd semester\\ITP\\Project\\backup\\7\\WindowsFormsApplication2\\WindowsFormsApplication2\\2.Invoice.rpt");
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = comboBox1.Text;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["OrderID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}
else
{
MessageBox.Show("Please Enter value");
}
label1.Visible = false;
comboBox1.Visible = false;
button1.Visible = false;
}
private void button1_Click(object sender, EventArgs e)
{
valor.Clear();
dis.Value = Convert.ToInt32(comboBox1.SelectedValue);
valor.Add(dis);
info.DataDefinition.ParameterFields["idcentro"].ApplyCurrentValues(valor);
crystalReportViewer1.ReportSource = info;
}
public void GetMonthly(string file)
{
int year = Convert.ToInt32(cboYear.Text.Trim());
string month = cboMonth.Text.Trim();
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(file);
ConnectionInfo crConnectionInfo = new ConnectionInfo();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = year;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["yearparam"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue.Value = month;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["monthparam"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crConnectionInfo.ServerName = "localhost";
crConnectionInfo.DatabaseName = "slimmersdb";
crConnectionInfo.UserID = "root";
crConnectionInfo.Password = "******";
productViewer.ReportSource = cryRpt;
productViewer.RefreshReport();
filter = "";
filter2 = "";
panel2.Hide();
productFilter.Enabled = true;
serviceFilter.Enabled = true;
bunifuThinButton21.Enabled = true;
bunifuThinButton22.Enabled = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User_Id"] == null)
{
Response.Redirect("LoginPage.aspx");
}
if (Request.QueryString.Count <= 0)
{
Response.Redirect("PopupPTD.aspx");
}
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("~/Reports/crptPTD.rpt"));
ParameterFieldDefinition pdf;
ParameterFieldDefinitions pdfs;
ParameterValues pvs = new ParameterValues();
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
if (Session["User_Id"].ToString() != (100).ToString())
{
pdv.Value = Convert.ToInt16(Session["User_Id"]);
pdfs = rd.DataDefinition.ParameterFields;
pdf = pdfs["FacultyID"];
pvs = pdf.CurrentValues;
pvs.Clear();
pvs.Add(pdv);
pdf.ApplyCurrentValues(pvs);
}
//
pvs = new ParameterValues();
pdv = new ParameterDiscreteValue();
pdv.Value = Request.QueryString["EMPNO"];
pdfs = rd.DataDefinition.ParameterFields;
pdf = pdfs["EmployeeID"];
pvs = pdf.CurrentValues;
pvs.Add(pdv);
pdf.ApplyCurrentValues(pvs);
//
//
pvs = new ParameterValues();
pdv = new ParameterDiscreteValue();
pdv.Value = Request.QueryString["YEAR"];
pdfs = rd.DataDefinition.ParameterFields;
pdf = pdfs["Year"];
pvs = pdf.CurrentValues;
pvs.Add(pdv);
pdf.ApplyCurrentValues(pvs);
//
CrystalReportViewer1.ReportSource = rd;
}
private void button51_Click(object sender, EventArgs e)
{
getGui.DeleteInvoiceItemized(StaticClass.storeId, this.invoiceNum);
if (myCash1.listInvoiceItem.Rows.Count == 0)
{
myCash1.invoiceTotal.Rows[0][15] = "V";
getGui.CloseTable(StaticClass.storeId, invoiceNum);
}
else
{
myCash1.invoiceTotal.Rows[0][57] = Convert.ToInt32(myCash1.invoiceTotal.Rows[0][57]) + 1;
foreach (DataRow c in myCash1.listInvoiceItem.Rows)
{
getGui.UpdateInvoiceItemized(StaticClass.storeId, invoiceNum, c[2].ToString(), c[3].ToString(), c[12].ToString(), c[1].ToString(), c[6].ToString(), c[7].ToString(), c[8].ToString());
}
}
UpdateInvoiceTotals();
if (myCash1.listInvoiceItem.Rows.Count != 0)
{
CrystalReport5 xxx = new CrystalReport5();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterFieldDefinitions crParameterFieldDefinitions1;
ParameterFieldDefinition crParameterFieldDefinition1;
ParameterValues crParameterValues1 = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = StaticClass.storeId;
crParameterFieldDefinitions = xxx.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Store_ID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue1.Value = invoiceNum;
crParameterFieldDefinitions1 = xxx.DataDefinition.ParameterFields;
crParameterFieldDefinition1 = crParameterFieldDefinitions1["@Invoice_Number"];
crParameterValues1 = crParameterFieldDefinition1.CurrentValues;
crParameterValues1.Clear();
crParameterValues1.Add(crParameterDiscreteValue1);
crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1);
xxx.PrintToPrinter(1, true, 1, 1);
}
this.Dispose();
formLayout.FrmLayout_Load(null, null);
}
private void load_pass(CrystalReportPass crystal, string val)
{
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = val;
crParameterFieldDefinitions = crystal.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["idresep"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
}
private void load_pass(transaksiugd crystal, string val)
{
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = val;
crParameterFieldDefinitions = crystal.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["pasien"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
}
private void fmProjectCosting_Load(object sender, EventArgs e)
{
crystalReportViewer1.Top = 0;
try
{
ReportDocument cryRpt = new ReportDocument();
string dir = System.IO.Directory.GetCurrentDirectory();
dir = "Default_ProjectCost.rpt";
cryRpt.Load(dir);
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = orderid;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["orderid"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = cryRpt;
//crystalReportViewer1.RefreshReport();
}
catch (LogOnException)
{
MessageBox.Show("Incorrect Logon Parameters. Check your user name and password.");
}
catch (DataSourceException)
{
MessageBox.Show("An error has occurred while connecting to the database.");
}
catch (EngineException ex)
{
MessageBox.Show (ex.Message);
}
}
private void setReport(string[] discretes, string[] values, ReportDocument reportSource)
{
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
for (int i = 0; i < discretes.Length; i++)
{
crParameterDiscreteValue.Value = values[i];
crParameterFieldDefinitions = reportSource.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions[discretes[i]];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
}
crystalReportViewer1.ReportSource = reportSource;
crystalReportViewer1.Refresh();
}
private void button1_Click(object sender, EventArgs e)
{
CrystalReport5 xxx = new CrystalReport5();
xxx.DataSourceConnections[0].SetConnection("THANH\\SQLEXPRESS","Po",true);
MessageBox.Show(xxx.DataSourceConnections[0].DatabaseName);
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterFieldDefinitions crParameterFieldDefinitions1;
ParameterFieldDefinition crParameterFieldDefinition1;
ParameterValues crParameterValues1 = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = "1001";
crParameterFieldDefinitions = xxx.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Store_ID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue1.Value = textBox1.Text;
crParameterFieldDefinitions1 = xxx.DataDefinition.ParameterFields;
crParameterFieldDefinition1 = crParameterFieldDefinitions1["@Invoice_Number"];
crParameterValues1 = crParameterFieldDefinition1.CurrentValues;
crParameterValues1.Clear();
crParameterValues1.Add(crParameterDiscreteValue1);
crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1);
xxx.PrintToPrinter(1, true, 1, 1);
crystalReportViewer1.ReportSource = xxx;
}
private void setReport(string[] discretes, string[] values, ReportDocument reportSource)
{
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
reportSource.SetDatabaseLogon(dbo.getDatabaseInformationLogon()[2], dbo.getDatabaseInformationLogon()[3], dbo.getDatabaseInformationLogon()[0], dbo.getDatabaseInformationLogon()[1]);
for (int i = 0; i < discretes.Length; i++)
{
crParameterDiscreteValue.Value = values[i];
crParameterFieldDefinitions = reportSource.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions[discretes[i]];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
}
crv.ReportSource = reportSource;
crv.Refresh();
}
private void btSendQuote_Click(object sender, EventArgs e)
{
try
{
MySqlDataReader rdr = null;
string email = "";
string contact = "";
string qry = "select c.email, c.contact from customer c where c.ID = '" + cbCustomer.Text + "';";
rdr = MysqlInterface.DoQuery(qry);
while (rdr.Read())
{
email = rdr.GetString(0);
contact = rdr.GetString(1);
}
string orderid = tbOrderId.Text;
ReportDocument cryRpt = new ReportDocument();
string dir = System.IO.Directory.GetCurrentDirectory();
dir = "Quote.rpt";
cryRpt.Load(dir);
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = orderid;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["orderid"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, "quotations//quote-" + orderid + ".pdf");
Outlook.Application outlookApp = new Outlook.Application();
Outlook.MailItem mailItem = (Outlook.MailItem)outlookApp.CreateItem(Outlook.OlItemType.olMailItem);
string directory = Directory.GetCurrentDirectory();
orderid = tbOrderId.Text;
directory = directory + "\\quotations\\quote-" + orderid + ".pdf";
mailItem.Attachments.Add(directory);
mailItem.Subject = "Pinnacle Glass Doors - Quote# " + orderid;
mailItem.To = email;
string name = contact;
if (contact != "")
{
int pos = name.IndexOf(' ');
if (pos != -1)
name = name.Substring(0, pos);
}
mailItem.Body = "Hi " + name + ",\n\n" + "Here is the quote you requested. Please let me know if you would like to proceed with the order" +
"\n\nThank You,\n\n" + Globals.USER_NAME;
mailItem.Importance = Outlook.OlImportance.olImportanceNormal;
mailItem.Display(true);
//crystalReportViewer1.ReportSource = cryRpt;
//crystalReportViewer1.RefreshReport();
}
catch (LogOnException)
{
MessageBox.Show("Incorrect Logon Parameters. Check your user name and password.");
}
catch (DataSourceException)
{
MessageBox.Show("An error has occurred while connecting to the database.");
}
catch (EngineException ex)
{
MessageBox.Show(ex.Message);
}
}
private void btSendConfirm_Click(object sender, EventArgs e)
{
try
{
MySqlDataReader rdr = null;
string email = "";
string contact = "";
string qry = "select co.contact_email, co.contact_name from customer c inner join contact co on co.owner_id = c.id where c.id = '" +
cbCustomer.Text + "' and co.contact_name = '" + cbContact.Text + "';";
rdr = MysqlInterface.DoQuery(qry);
while (rdr.Read())
{
if (!rdr.IsDBNull(0)) email = rdr.GetString(0);
if (!rdr.IsDBNull(1)) contact = rdr.GetString(1);
}
string orderid = tbOrderId.Text;
ReportDocument cryRpt = new ReportDocument();
string dir = System.IO.Directory.GetCurrentDirectory();
dir = "Confirmation.rpt";
cryRpt.Load(dir);
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = orderid;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["orderid"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, "confirmations//confirmation-" + orderid + ".pdf");
Outlook.Application outlookApp = new Outlook.Application();
Outlook.MailItem mailItem = (Outlook.MailItem)outlookApp.CreateItem(Outlook.OlItemType.olMailItem);
string directory = Directory.GetCurrentDirectory();
orderid = tbOrderId.Text;
string po = tbCustPO.Text;
directory = directory + "\\confirmations\\confirmation-" + orderid + ".pdf";
mailItem.Attachments.Add(directory);
mailItem.Subject = "Pinnacle Glass Doors - Confirmation# " + orderid + " - PO# " + po;
mailItem.To = email;
string name = contact;
if (contact != "")
{
int pos = name.IndexOf(' ');
if (pos != -1)
name = name.Substring(0, pos);
}
mailItem.Body = "Hi " + name + ",\n\n" + "Attached is a confirmation of your purchase order " + po + "." +
"\n\nThank You,\n\n" + Globals.USER_NAME;
mailItem.Importance = Outlook.OlImportance.olImportanceNormal;
try
{ mailItem.Display(true); }
catch
(Exception) { }
//crystalReportViewer1.ReportSource = cryRpt;
//crystalReportViewer1.RefreshReport();
}
catch (LogOnException)
{
MessageBox.Show("Incorrect Logon Parameters. Check your user name and password.");
}
catch (DataSourceException)
{
MessageBox.Show("An error has occurred while connecting to the database.");
}
catch (EngineException ex)
{
MessageBox.Show(ex.Message);
}
}
private void button51_Click(object sender, EventArgs e)
{
getGui.DeleteInvoiceItemized(StaticClass.storeId, this.invoiceNum);
if (myCash1.listInvoiceItem.Rows.Count == 0)
{
myCash1.invoiceTotal.Rows[0][15] = "V";
getGui.CloseTable(StaticClass.storeId, invoiceNum);
}
else
{
myCash1.invoiceTotal.Rows[0][57] = Convert.ToInt32(myCash1.invoiceTotal.Rows[0][57]) + 1;
foreach (DataRow c in myCash1.listInvoiceItem.Rows)
{
getGui.UpdateInvoiceItemized(StaticClass.storeId, invoiceNum, c[2].ToString(), c[3].ToString(), c[12].ToString(), c[1].ToString(), c[6].ToString(), c[7].ToString(), c[8].ToString());
}
}
UpdateInvoiceTotals();
if (myCash1.listInvoiceItem.Rows.Count != 0)
{
CrystalReport5 xxx = new CrystalReport5();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterFieldDefinitions crParameterFieldDefinitions1;
ParameterFieldDefinition crParameterFieldDefinition1;
ParameterValues crParameterValues1 = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = StaticClass.storeId;
crParameterFieldDefinitions = xxx.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Store_ID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue1.Value = invoiceNum;
crParameterFieldDefinitions1 = xxx.DataDefinition.ParameterFields;
crParameterFieldDefinition1 = crParameterFieldDefinitions1["@Invoice_Number"];
crParameterValues1 = crParameterFieldDefinition1.CurrentValues;
crParameterValues1.Clear();
crParameterValues1.Add(crParameterDiscreteValue1);
crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1);
xxx.PrintToPrinter(1, true, 1, 1);
}
this.Dispose();
formLayout.FrmLayout_Load(null, null);
}
public void ImprimirRelPed()
{
try
{
//Instancio o FormConsulta
FrmConPDV x = (FrmConPDV)_pdv;
if (x.rdbped.Checked)
{
//Instancio o Relatorio
RptConPDV objRptConPDV = new RptConPDV();
//Instancio o Dataset
COMERCIALDataSet oDataset = new COMERCIALDataSet();
Microsoft.Practices.EnterpriseLibrary.Data.Database db = DatabaseFactory.CreateDatabase();
//Crio a Conexão
SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["Comercial.Properties.Settings.COMERCIALConnectionString"].ConnectionString);
//Abro a conexão
sqlcon.Open();
//Recebo a String SQL feita na tela de consulta
string StringConnection = x.pesquisar();
SqlDataAdapter dtAdapter = new SqlDataAdapter(StringConnection, sqlcon);
//Localizo o datatable criado no dataset
dtAdapter.Fill(oDataset, "RelPedido");
objRptConPDV.SetDataSource(oDataset);
//Passo parametro para relatorio no caso somente o de pedido tem parametro
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = "PDV";
crParameterFieldDefinitions = objRptConPDV.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["Tipo"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
//atribiu o resultado ao CristalReportView
crstlRprtVwrRel.DisplayGroupTree = false;
crstlRprtVwrRel.ReportSource = objRptConPDV;
}
else
{
//Instancio o Relatorio
RptConPDV objRptConPDV = new RptConPDV();
//Instancio o Dataset
COMERCIALDataSet oDataset = new COMERCIALDataSet();
Microsoft.Practices.EnterpriseLibrary.Data.Database db = DatabaseFactory.CreateDatabase();
//Crio a Conexão
SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["Comercial.Properties.Settings.COMERCIALConnectionString"].ConnectionString);
//Abro a conexão
sqlcon.Open();
//Recebo a String SQL feita na tela de consulta
string StringConnection = x.pesquisar();
SqlDataAdapter dtAdapter = new SqlDataAdapter(StringConnection, sqlcon);
//Localiso o datateble criado no dataset
dtAdapter.Fill(oDataset, "RelPedido");
objRptConPDV.SetDataSource(oDataset);
//Passo parametro para relatorio no caso somente o de pedido tem parametro
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = "prd";
crParameterFieldDefinitions = objRptConPDV.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["Tipo"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
//atribiu o resultado ao CristalReportView
crstlRprtVwrRel.DisplayGroupTree = false;
crstlRprtVwrRel.ReportSource = objRptConPDV;
}
}
catch (Exception ex)
{
throw ex;
}
}
private void SendPO()
{
try
{
MySqlDataReader rdr = null;
string email = "";
string contact = "";
string qry = "select c.email, c.contact from vendor c where c.ID = '" + cbVendor.Text + "';";
rdr = MysqlInterface.DoQuery(qry);
while (rdr.Read())
{
email = rdr.GetString(0);
contact = rdr.GetString(1);
}
string orderid = tbOrderId.Text;
ReportDocument cryRpt = new ReportDocument();
string dir = System.IO.Directory.GetCurrentDirectory();
dir = "PurchaseOrder.rpt";
cryRpt.Load(dir);
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = orderid;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["order_id"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, "pos//po-" + orderid + ".pdf");
Outlook.Application outlookApp = new Outlook.Application();
Outlook.MailItem mailItem = (Outlook.MailItem)outlookApp.CreateItem(Outlook.OlItemType.olMailItem);
string directory = System.IO.Directory.GetCurrentDirectory();
orderid = tbOrderId.Text;
directory = directory + "\\pos\\po-" + orderid + ".pdf";
mailItem.Attachments.Add(directory);
mailItem.Subject = "Pinnacle Glass Doors - Purchase Order# " + orderid;
mailItem.To = email;
string name = contact;
if (contact != "")
{
int pos = name.IndexOf(' ');
if (pos != -1)
name = name.Substring(0, pos);
}
mailItem.Body = "Hi " + name + ",\n\n" + "Please see the attached purchase order. Please confirm pricing and ship date." +
"\n\nThank You,\n\n" + Globals.USER_NAME;
mailItem.Importance = Outlook.OlImportance.olImportanceNormal;
mailItem.Display(true);
}
catch (LogOnException)
{
MessageBox.Show("Incorrect Logon Parameters. Check your user name and password.");
}
catch (DataSourceException)
{
MessageBox.Show("An error has occurred while connecting to the database.");
}
catch (EngineException ex)
{
MessageBox.Show(ex.Message);
}
}
private void Form2_Load(object sender, EventArgs e)
{
crystalReportViewer1.Top = 0;
try
{
ReportDocument cryRpt = new ReportDocument();
string dir = System.IO.Directory.GetCurrentDirectory(); dir = "Default_WorkOrder.rpt";
cryRpt.Load(dir);
/*ConnectionInfo crConnectionInfo = new ConnectionInfo();
crConnectionInfo.ServerName = MysqlInterface.host;
crConnectionInfo.DatabaseName = MysqlInterface.dbase;
crConnectionInfo.UserID = MysqlInterface.user;
crConnectionInfo.Password = MysqlInterface.password;
crConnectionInfo.AllowCustomConnection = true;
Tables crTables;
crTables = cryRpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
TableLogOnInfo myTableLogonInfo = crTable.LogOnInfo;
myTableLogonInfo.ConnectionInfo.DatabaseName = MysqlInterface.dbase;
myTableLogonInfo.ConnectionInfo.UserID = MysqlInterface.user;
myTableLogonInfo.ConnectionInfo.Password = MysqlInterface.password;
myTableLogonInfo.ConnectionInfo.ServerName = MysqlInterface.host;
crTable.ApplyLogOnInfo(myTableLogonInfo);
}
*/
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = orderid;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["orderid"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}
catch (LogOnException)
{
MessageBox.Show("Incorrect Logon Parameters. Check your user name and password.");
}
catch (DataSourceException)
{
MessageBox.Show("An error has occurred while connecting to the database.");
}
catch (EngineException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
private void button54_Click(object sender, EventArgs e)
{
if(myCash1.listInvoiceItem.Rows.Count != 0)
{
FrmPay frmPay = new FrmPay();
frmPay.textBox1.Text = frmPay.textBox2.Text = String.Format("{0:0,0}", Convert.ToDecimal(myCash1.label_Total.Text));
if(frmPay.ShowDialog() == DialogResult.OK)
{
myCash1.invoiceTotal.Rows[0]["Amt_Tendered"] = frmPay.tienTra;
myCash1.invoiceTotal.Rows[0]["Amt_Change"] = frmPay.tienThoi;
myCash1.invoiceTotal.Rows[0]["Status"] = "C";
myCash1.invoiceTotal.Rows[0]["Payment_Method"] = frmPay.hinhThucTra;
if(frmPay.hinhThucTra == "CA")
{
myCash1.invoiceTotal.Rows[0]["CA_Amount"] = Convert.ToDecimal(myCash1.label_Total.Text);
}
else if (frmPay.hinhThucTra == "CC")
{
myCash1.invoiceTotal.Rows[0]["CC_Amount"] = Convert.ToDecimal(myCash1.label_Total.Text);
}
else if (frmPay.hinhThucTra == "DC")
{
myCash1.invoiceTotal.Rows[0]["DC_Amount"] = Convert.ToDecimal(myCash1.label_Total.Text);
}
myCash1.invoiceTotal.Rows[0]["Cashier_ID"] = StaticClass.cashierId;
getGui.DeleteInvoiceItemized(StaticClass.storeId, this.invoiceNum);
if (myCash1.listInvoiceItem.Rows.Count == 0)
{
myCash1.invoiceTotal.Rows[0][15] = "V";
getGui.CloseTable(StaticClass.storeId, invoiceNum);
}
else
{
foreach (DataRow c in myCash1.listInvoiceItem.Rows)
{
getGui.UpdateInvoiceItemized(StaticClass.storeId, invoiceNum, c[2].ToString(), c[3].ToString(), c[12].ToString(), c[1].ToString(), c[6].ToString(), c[7].ToString(), c[8].ToString(), c[5].ToString(), c[19].ToString());
}
}
UpdateInvoiceTotals();
getGui.DeleteInvoiceOnhold(StaticClass.storeId,invoiceNum);
SendToKitchen();
this.Dispose();
formLayout.FrmLayout_Load(null, null);
formLogin.RequestMess("UpdateForm");
Printer printer = serviceGet.GetPrinterByName(StaticClass.storeId, StaticClass.stationId, "Hóa đơn");
if (!(printer == null || printer.Details == "NONE" || printer.Disable == true))
{
Re_ThanhToan xxx = new Re_ThanhToan();
xxx.DataSourceConnections[0].SetConnection(StaticClass.serverName, StaticClass.databaseName, true);
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterFieldDefinitions crParameterFieldDefinitions1;
ParameterFieldDefinition crParameterFieldDefinition1;
ParameterValues crParameterValues1 = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = StaticClass.storeId;
crParameterFieldDefinitions = xxx.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Store_ID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue1.Value = invoiceNum;
crParameterFieldDefinitions1 = xxx.DataDefinition.ParameterFields;
crParameterFieldDefinition1 = crParameterFieldDefinitions1["@Invoice_Number"];
crParameterValues1 = crParameterFieldDefinition1.CurrentValues;
crParameterValues1.Clear();
crParameterValues1.Add(crParameterDiscreteValue1);
xxx.PrintOptions.PrinterName = printer.Details;
crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1);
xxx.PrintOptions.ApplyPageMargins(new PageMargins(1, 2, 1, 0));
xxx.PrintToPrinter(1, false, 0, 0);
}
}
}
else
{
Alert.Show("Hóa đơn chưa có hàng",Color.Red);
}
}
private void button51_Click(object sender, EventArgs e)
{
getGui.DeleteInvoiceItemized(StaticClass.storeId, this.invoiceNum);
if (myCash1.listInvoiceItem.Rows.Count == 0)
{
myCash1.invoiceTotal.Rows[0][15] = "V";
getGui.CloseTable(StaticClass.storeId, invoiceNum);
}
else
{
myCash1.invoiceTotal.Rows[0][57] = Convert.ToInt32(myCash1.invoiceTotal.Rows[0][57]) + 1;
foreach (DataRow c in myCash1.listInvoiceItem.Rows)
{
getGui.UpdateInvoiceItemized(StaticClass.storeId, invoiceNum, c[2].ToString(), c[3].ToString(), c[12].ToString(), c[1].ToString(), c[6].ToString(), c[7].ToString(), c[8].ToString(), c[5].ToString(), c[19].ToString());
}
}
UpdateInvoiceTotals();
SendToKitchen();
if (myCash1.listInvoiceItem.Rows.Count != 0)
{
Printer printer = serviceGet.GetPrinterByName(StaticClass.storeId, StaticClass.stationId, "Hóa đơn");
if(!(printer == null || printer.Details == "NONE" || printer.Disable == true))
{
CrystalReport5 xxx = new CrystalReport5();
xxx.DataSourceConnections[0].SetConnection(StaticClass.serverName, StaticClass.databaseName, true);
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterValues crParameterValues = new ParameterValues();
ParameterFieldDefinitions crParameterFieldDefinitions1;
ParameterValues crParameterValues1 = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = StaticClass.storeId;
crParameterFieldDefinitions = xxx.DataDefinition.ParameterFields;
ParameterFieldDefinition crParameterFieldDefinition = crParameterFieldDefinitions["@Store_ID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue1.Value = invoiceNum;
crParameterFieldDefinitions1 = xxx.DataDefinition.ParameterFields;
ParameterFieldDefinition crParameterFieldDefinition1 = crParameterFieldDefinitions1["@Invoice_Number"];
crParameterValues1 = crParameterFieldDefinition1.CurrentValues;
crParameterValues1.Clear();
crParameterValues1.Add(crParameterDiscreteValue1);
crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1);
xxx.DataSourceConnections[0].SetConnection(StaticClass.serverName, StaticClass.databaseName, true);
xxx.PrintOptions.PrinterName = printer.Details;
xxx.PrintOptions.ApplyPageMargins(new PageMargins(1, 2, 1, 0));
xxx.PrintToPrinter(1, false, 0, 0);
}
}
this.Dispose();
formLayout.FrmLayout_Load(null, null);
}