public Boolean printReport(CrystalDecisions.CrystalReports.Engine.ReportClass crReport, CrystalReportViewer CrystalReportViewer1, String param1, String ParamName1, String param2, String ParamName2) { if (PrinterName=="none") return false; paramField.ParameterFieldName = ParamName1; discreteVal.Value = param1; paramField.CurrentValues.Add (discreteVal); paramFields.Add (paramField); crReport.DataDefinition.ParameterFields[0].CurrentValues.Add (discreteVal); paramField2.ParameterFieldName = ParamName2; discreteVal2.Value = param2; paramField2.CurrentValues.Add (discreteVal2); paramFields.Add (paramField2); crReport.DataDefinition.ParameterFields[1].CurrentValues.Add (discreteVal2); CrystalReportViewer1.ReportSource = crReport; CrystalReportViewer1.ParameterFieldInfo = paramFields; CrystalReportViewer1.RefreshReport(); ParameterValues tmpParam = new ParameterValues(); ParameterValues tmpParam2 = new ParameterValues(); tmpParam.Add(discreteVal); tmpParam2.Add(discreteVal2); crReport.DataDefinition.ParameterFields[0].ApplyCurrentValues(tmpParam); crReport.DataDefinition.ParameterFields[1].ApplyCurrentValues(tmpParam2); crReport.PrintOptions.PrinterName = PrinterName; // crReport.PrintToPrinter(1,false,1,1); crReport.PrintToPrinter(1,false,1,99); //Response.write (PrinterName); return true; }
private void GroupReport_Load(object sender, EventArgs e) { repDoc = new ReportDocument(); ParameterFields rptParams; ParameterValues paramValues; ParameterDiscreteValue paramDiscreteValue; ParameterField paramField; try { repDoc.Load("../../Reports/Group.rpt"); //repDoc.Load("C:\\Users\\keith.sullivan\\Documents\\CIS\\CISApp\\CISApp\\Reports\\Group.rpt"); rptParams = repDoc.ParameterFields; paramValues = new ParameterValues(); paramDiscreteValue = new ParameterDiscreteValue(); paramDiscreteValue.Value = groupId; paramValues.Add(paramDiscreteValue); paramField = rptParams["studentgroup"]; paramField.CurrentValues = paramValues; crystalReportViewer1.ReportSource = repDoc; crystalReportViewer1.Refresh(); } catch (Exception ex) { Console.WriteLine(ex); Console.WriteLine("Could not connect to report"); } }
private void button1_Click(object sender, EventArgs e) { var report = new rptTestimonial(); ParameterValues pvValues = new ParameterValues(); ParameterDiscreteValue pdvDiscreteValue = new ParameterDiscreteValue(); pdvDiscreteValue.Value = textBox1.Text; pvValues.Add(pdvDiscreteValue); ParameterFieldDefinitions pfdDefinitions = report.DataDefinition.ParameterFields; ParameterFieldDefinition prdDefinition = pfdDefinitions["textThing"]; prdDefinition.ApplyCurrentValues(pvValues); /*var data = Database.Row("learner_details a, enrollments b, enrollmentscourses c, courses d", "a.Division = '" + clsGlobal.loggedOnUserDivison + "' AND a.LearnerNumber = '" + number.Selection + "' AND b.LearnerKey = a.LearnerKey AND c.idEnrollments = b.idEnrollments AND" + " d.idCourses = c.idCourses");*/ report.DataDefinition.FormulaFields["mainText"].Text = "\"" + textBox1.Text + "\""; report.DataDefinition.FormulaFields["principle"].Text = "\"" + GlobalProperties.DivisionPrinciple + "\""; report.DataDefinition.FormulaFields["name"].Text = "\"" + learner["Surname"] + ", " + learner["name"]+ "\""; report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number + "\""; //report.DataDefinition.FormulaFields["respParty"].Text = "\"" + clsGlobal.loggedOnUser + "\""; //report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\""; //logs.WriteXml(@"C:\tmpXml.xml"); var frmReport = new frmReport(report) { Text = "Testimonial" }; frmReport.ShowDialog(); }
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 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 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 override AsimovTask GetDeployTask(AsimovVersion version, ParameterValues parameterValues, AsimovUser user, string correlationId) { var task = new DeployTask(this, version, parameterValues, user, correlationId); task.AddDeployStep<UpdateWebSite>(); foreach (var action in Actions.OfType<VerifyCommandUnitAction>()) { task.AddDeployStep(new ExecuteUnitAction(action, user)); } return task; }
private void SetCurrentValuesForParameterField(ParameterFields parameterFields, ArrayList arrayList) { ParameterValues currentParameterValues = new ParameterValues(); foreach (object submittedValue in arrayList) { ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); parameterDiscreteValue.Value = submittedValue.ToString(); currentParameterValues.Add(parameterDiscreteValue); } ParameterField parameterField = parameterFields[PARAMETER_FIELD_NAME]; parameterField.CurrentValues = currentParameterValues; }
public void Read(string srr) { this.reportQuary = dateTimePicker1.Text + " to " + dateTimePicker2.Text; string query = ""; query = "Select * From TbDailyIncome Where IncomeDate BETWEEN '" + dateTimePicker1.Value.Date + "' AND '" + dateTimePicker2.Value.Date + "' AND Debit = @Debit Order By IncomeDate"; if (query != "") { SqlConnection conn = new SqlConnection(this.connectionString); SqlCommand comm = new SqlCommand(query, conn); comm.Parameters.Add("@Debit", SqlDbType.VarChar, 50); comm.Parameters["@Debit"].Value = comboBox1.Text; SqlDataAdapter adap = new SqlDataAdapter(); DataSets.DebitVoucherDataSet dataset = new DataSets.DebitVoucherDataSet(); DebitVoucherByDebitACCrystalReport crp = new DebitVoucherByDebitACCrystalReport(); try { conn.Open(); adap.SelectCommand = comm; adap.Fill(dataset, "DataTable1"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { conn.Close(); } crp.SetDataSource(dataset); ParameterValues v = new ParameterValues(); ParameterDiscreteValue dv = new ParameterDiscreteValue(); dv = new ParameterDiscreteValue(); dv.Value = this.reportQuary; v.Add(dv); crp.DataDefinition.ParameterFields["report_query"].ApplyCurrentValues(v); crystalReportViewer2.ReportSource = crp; } }
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 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); }
protected void Page_Load(object sender, EventArgs e) { if (!SessionBox.CheckUserSession()) { Response.Redirect("~/Admin/Login.aspx"); } else { //load crystal report ReportDocument Report = new ReportDocument(); Report.Load(Server.MapPath("Sales_Return.rpt ")); //this.CrystalReportSource1.Report.FileName = Server.MapPath("Sales_order.rpt"); TableLogOnInfo logOnInfo = new TableLogOnInfo(); logOnInfo.ConnectionInfo.ServerName = "USER-3924AC2E56"; logOnInfo.ConnectionInfo.DatabaseName = "MyData"; logOnInfo.ConnectionInfo.UserID = "sa"; logOnInfo.ConnectionInfo.Password = "******"; //对报表中的每个表进行循环 for (int i = 0; i < Report.Database.Tables.Count; i++) { Report.Database.Tables[i].ApplyLogOnInfo(logOnInfo); } //load param //CrystalDecisions.Web.Parameter param = new CrystalDecisions.Web.Parameter(); //param.Name = "OrderID"; //param.DefaultValue = Request.QueryString["TextBoxId"].ToString().Trim(); //add param //this.CrystalReportSource1.Report.Parameters.Add(param); ParameterValues ParamValues = new ParameterValues(); ParameterDiscreteValue ParamValue = new ParameterDiscreteValue(); ParamValue.Value = Request.QueryString["TextBoxId"].ToString().Trim(); ParamValues.Add(ParamValue); Report.DataDefinition.ParameterFields[0].ApplyCurrentValues(ParamValues); //bind this.CrystalReportViewer1.ReportSource = Report; //this.CrystalReportViewer1.ReportSourceID = this.CrystalReportSource1.ID; //關閉左邊 this.CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None; //強制安裝ActiveX CrystalReportViewer1.PrintMode = CrystalDecisions.Web.PrintMode.ActiveX; this.CrystalReportViewer1.DataBind(); } }
public void AddParameter(string i_paramName, string i_paramValue, ParameterFields o_paramFields) { ParameterField paramField = new ParameterField(); ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue(); ParameterValues paramValues = new ParameterValues(); // Set the name of the parameter to modify. paramField.ParameterFieldName = i_paramName; // Set a value to the parameter. paramDiscreteValue.Value = i_paramValue; paramValues.Add(paramDiscreteValue); paramField.CurrentValues = paramValues; // Add the parameter to the ParameterFields collection. o_paramFields.Add(paramField); // Return paramFields }
public ModelOutput Run(ParameterValues parameters) { ModelOutput mf = new ModelOutput(); LoadDimensions(parameters, mf); InitVariables(mf); ConnectBindings(mf); ConnectLeftoversToParameters(mf, parameters); RunComponents(mf); mf.SwitchOffChecks(); return mf; }
private void button1_Click(object sender, EventArgs e) { this.reportQuary = dateTimePicker1.Text + " to " + dateTimePicker2.Text; string query = ""; query = "Select * From tblBankStatement Where TransDate BETWEEN '" + dateTimePicker1.Value.Date + "' AND '" + dateTimePicker2.Value.Date + "' Order By AutoId"; if (query != "") { SqlConnection conn = new SqlConnection(this.connectionString); SqlCommand comm = new SqlCommand(query, conn); SqlDataAdapter adap = new SqlDataAdapter(); DataSets.BankDataSet dataset = new DataSets.BankDataSet(); BankStatementCrystalReport crp = new BankStatementCrystalReport(); try { conn.Open(); adap.SelectCommand = comm; adap.Fill(dataset, "DataTable1"); crp.SetDataSource(dataset); ParameterValues v = new ParameterValues(); ParameterDiscreteValue dv = new ParameterDiscreteValue(); dv = new ParameterDiscreteValue(); dv.Value = this.reportQuary; v.Add(dv); crp.DataDefinition.ParameterFields["report_query"].ApplyCurrentValues(v); crystalReportViewer2.ReportSource = crp; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { conn.Close(); } } }
private ParameterFields AddParameter(string paramName, string paramValue, ParameterFields paramFields) { ParameterField paramField = new ParameterField(); ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue(); ParameterValues paramValues = new ParameterValues(); // 设置要修改的参数的名称。 paramField.ParameterFieldName = paramName; // 为该参数设置一个值。 paramDiscreteValue.Value = paramValue; paramValues.Add(paramDiscreteValue); paramField.CurrentValues = paramValues; // 将该参数添加到 ParameterFields 集合中。 paramFields.Add(paramField); return paramFields; }
public void Read() { this.reportQuary = fromdateTimePicker.Text + " to " + todateTimePicker2.Text; string query = ""; query = "Select * From TbAccountStatement Where CreateDate BETWEEN '" + fromdateTimePicker.Value.Date + "' AND '" + todateTimePicker2.Value.Date + "' Order By AutoId"; if (query != "") { SqlConnection conn = new SqlConnection(this.connectionString); SqlCommand comm = new SqlCommand(query, conn); SqlDataAdapter adap = new SqlDataAdapter(); AccountStatementDataSet dataset = new AccountStatementDataSet(); AccountStatementCrystalReport crp = new AccountStatementCrystalReport(); try { conn.Open(); adap.SelectCommand = comm; adap.Fill(dataset, "DataTable1"); crp.SetDataSource(dataset); ParameterValues v = new ParameterValues(); ParameterDiscreteValue dv = new ParameterDiscreteValue(); dv = new ParameterDiscreteValue(); dv.Value = this.reportQuary; v.Add(dv); crp.DataDefinition.ParameterFields["report_query"].ApplyCurrentValues(v); crystalReportViewer1.ReportSource = crp; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { conn.Close(); } } }
public void StartingDeploy(AsimovVersion newVersion, string logFileName, AsimovUser user, string correlationId, ParameterValues parameters) { DeployStatus = DeployStatus.Deploying; Version = new DeployedVersion { DeployTimestamp = DateTime.Now, VersionId = newVersion.Id, VersionNumber = newVersion.Number, VersionBranch = newVersion.Branch, VersionTimestamp = newVersion.Timestamp, VersionCommit = newVersion.Commit, LogFileName = logFileName, UserId = user.UserId, UserName = user.UserName, DeployFailed = false, CorrelationId = correlationId, Parameters = parameters.GetInternalDictionary() }; NotificationPublisher.PublishNotifications(new DeployStartedEvent(Name, Version)); }
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 btnImprimir_Click(object sender, EventArgs e) { //clsConexion a la base de datos MySqlConnection myclsConexion = new MySqlConnection(clsConexion.ConectionString); // Creando el command que ejecutare MySqlCommand myCommand = new MySqlCommand(); // Creando el Data Adapter MySqlDataAdapter myAdapter = new MySqlDataAdapter(); // Creando el String Builder StringBuilder sbQuery = new StringBuilder(); // Otras variables del entorno string cWhere = " WHERE 1 = 1"; string cUsuario = frmLogin.cUsuarioActual; string cTitulo = ""; try { // Abro clsConexion myclsConexion.Open(); // Creo comando myCommand = myclsConexion.CreateCommand(); // Adhiero el comando a la clsConexion myCommand.Connection = myclsConexion; // Filtros de la busqueda // CREANDO EL QUERY DE CONSULTA //string fechadesde = fechaDesde.Value.ToString("yyyy-MM-dd"); //string fechahasta = fechaHasta.Value.ToString("yyyy-MM-dd"); //cWhere = cWhere + " AND fechacita >= "+"'"+ fechadesde +"'" +" AND fechacita <= "+"'"+ fechahasta +"'"+""; //cWhere = cWhere + " AND year = '" + txtYear.Text + "'"; sbQuery.Clear(); sbQuery.Append("SELECT estaciones.id, estaciones.estacion as estaciones "); //sbQuery.Append(" tipo_deptogas.tipo as tipodescripcion, tipo_deptogas.id, deptobeneficiariogas.tarjeta"); sbQuery.Append(" FROM estaciones "); //sbQuery.Append(" INNER JOIN tipo_deptogas ON tipo_deptogas.id = deptobeneficiariogas.tipo"); sbQuery.Append(cWhere); sbQuery.Append(" ORDER BY estaciones.estacion ASC"); // Paso los valores de sbQuery al CommandText myCommand.CommandText = sbQuery.ToString(); // Creo el objeto Data Adapter y ejecuto el command en el myAdapter = new MySqlDataAdapter(myCommand); // Creo el objeto Data Table DataTable dtEstaciones = new DataTable(); // Lleno el data adapter myAdapter.Fill(dtEstaciones); // Cierro el objeto clsConexion myclsConexion.Close(); // Verifico cantidad de datos encontrados int nRegistro = dtEstaciones.Rows.Count; if (nRegistro == 0) { MessageBox.Show("No Hay Datos Para Mostrar, Favor Verificar", "Sistema de Gestion de Combustibles", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { //1ero.HACEMOS LA COLECCION DE PARAMETROS //los campos de parametros contiene un objeto para cada campo de parametro en el informe ParameterFields oParametrosCR = new ParameterFields(); //Proporciona propiedades para la recuperacion y configuracion del tipo de los parametros ParameterValues oParametrosValuesCR = new ParameterValues(); //2do.CREAMOS LOS PARAMETROS ParameterField oUsuario = new ParameterField(); //parametervaluetype especifica el TIPO de valor de parametro //ParameterValueKind especifica el tipo de valor de parametro en la PARAMETERVALUETYPE de la Clase PARAMETERFIELD oUsuario.ParameterValueType = ParameterValueKind.StringParameter; //3ero.VALORES PARA LOS PARAMETROS //ParameterDiscreteValue proporciona propiedades para la recuperacion y configuracion de //parametros de valores discretos ParameterDiscreteValue oUsuarioDValue = new ParameterDiscreteValue(); oUsuarioDValue.Value = cUsuario; //4to. AGREGAMOS LOS VALORES A LOS PARAMETROS oUsuario.CurrentValues.Add(oUsuarioDValue); //5to. AGREGAMOS LOS PARAMETROS A LA COLECCION oParametrosCR.Add(oUsuario); //nombre del parametro en CR (Crystal Reports) oParametrosCR[0].Name = "cUsuario"; //nombre del TITULO DEL INFORME cTitulo = "LISTADO DE ESTACIONES DE COMBUSTIBLE"; //6to Instanciamos nuestro REPORTE //Reportes.ListadoDoctores oListado = new Reportes.ListadoDoctores(); //REPORTES.rptClientes orptClientes = new REPORTES.rptClientes(); rptEstaciones orptEstaciones = new rptEstaciones(); //pasamos el nombre del TITULO del Listado //SumaryInfo es un objeto que se utiliza para leer,crear y actualizar las propiedades del reporte // oListado.SummaryInfo.ReportTitle = cTitulo; orptEstaciones.SummaryInfo.ReportTitle = cTitulo; //7mo. instanciamos nuestro el FORMULARIO donde esta nuestro ReportViewer frmPrinter ofrmPrinter = new frmPrinter(dtEstaciones, orptEstaciones, cTitulo); //ParameterFieldInfo Obtiene o establece la colección de campos de parámetros. ofrmPrinter.CrystalReportViewer1.ParameterFieldInfo = oParametrosCR; ofrmPrinter.ShowDialog(); } } catch (Exception myEx) { MessageBox.Show("Error : " + myEx.Message, "Mostrando Reporte", MessageBoxButtons.OK, MessageBoxIcon.Information); // clsExceptionLog.LogError(myEx, false); return; } }
protected override IEnumerable <ISearchResultModel> GetResultIsLatestBySqlQuery(string sqlString) { return(DbManager.SqlQuery <SearchResultIsLatest>(sqlString, ParameterValues.ToArray()).ToList()); }
private void btnImprimir_Click(object sender, EventArgs e) { //clsConexion a la base de datos MySqlConnection myclsConexion = new MySqlConnection(Conexion.ConectionString); // Creando el command que ejecutare MySqlCommand myCommand = new MySqlCommand(); // Creando el Data Adapter MySqlDataAdapter myAdapter = new MySqlDataAdapter(); // Creando el String Builder StringBuilder sbQuery = new StringBuilder(); // Otras variables del entorno string cWhere = " WHERE 1 = 1"; string cUsuario = ""; //frmLogin.cUsuarioActual; string cTitulo = ""; try { // Abro clsConexion myclsConexion.Open(); // Creo comando myCommand = myclsConexion.CreateCommand(); // Adhiero el comando a la clsConexion myCommand.Connection = myclsConexion; // Filtros de la busqueda //if (txtYear.Text != "") //{ //// Habilitando los campos necesarios //txtYear.Enabled = true; //txtYear.Focus(); // CREANDO EL QUERY DE CONSULTA //string fechadesde = fechaDesde.Value.ToString("yyyy-MM-dd"); //string fechahasta = fechaHasta.Value.ToString("yyyy-MM-dd"); //cWhere = cWhere + " AND fechacita >= "+"'"+ fechadesde +"'" +" AND fechacita <= "+"'"+ fechahasta +"'"+""; //cWhere = cWhere + " AND year = '" + txtYear.Text + "'"; sbQuery.Clear(); sbQuery.Append("SELECT subcategorias.id as Id, subcategorias.descripcion as Descripcion, categorias.descripcion as Categoria"); //sbQuery.Append(" doctores.doctores_cedula,upper(CONCAT(doctores.doctores_nombre,' ',doctores.doctores_apellido)) as doctor,departamentos.departamento_descripcion"); sbQuery.Append(" FROM subcategorias"); sbQuery.Append(" INNER JOIN categorias ON subcategorias.categoria = categorias.id"); sbQuery.Append(cWhere); sbQuery.Append(" ORDER BY categorias.descripcion, subcategorias.descripcion ASC"); // Paso los valores de sbQuery al CommandText myCommand.CommandText = sbQuery.ToString(); // Creo el objeto Data Adapter y ejecuto el command en el myAdapter = new MySqlDataAdapter(myCommand); // Creo el objeto Data Table DataTable dtSubcategoriasProductos = new DataTable(); // Lleno el data adapter myAdapter.Fill(dtSubcategoriasProductos); // Cierro el objeto clsConexion myclsConexion.Close(); // Verifico cantidad de datos encontrados int nRegistro = dtSubcategoriasProductos.Rows.Count; if (nRegistro == 0) { MessageBox.Show("No Hay Datos Para Mostrar, Favor Verificar", "Sistema de Gestion Bananera", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { //1ero.HACEMOS LA COLECCION DE PARAMETROS //los campos de parametros contiene un objeto para cada campo de parametro en el informe ParameterFields oParametrosCR = new ParameterFields(); //Proporciona propiedades para la recuperacion y configuracion del tipo de los parametros ParameterValues oParametrosValuesCR = new ParameterValues(); //2do.CREAMOS LOS PARAMETROS ParameterField oUsuario = new ParameterField(); //parametervaluetype especifica el TIPO de valor de parametro //ParameterValueKind especifica el tipo de valor de parametro en la PARAMETERVALUETYPE de la Clase PARAMETERFIELD oUsuario.ParameterValueType = ParameterValueKind.StringParameter; //3ero.VALORES PARA LOS PARAMETROS //ParameterDiscreteValue proporciona propiedades para la recuperacion y configuracion de //parametros de valores discretos ParameterDiscreteValue oUsuarioDValue = new ParameterDiscreteValue(); oUsuarioDValue.Value = cUsuario; //4to. AGREGAMOS LOS VALORES A LOS PARAMETROS oUsuario.CurrentValues.Add(oUsuarioDValue); //5to. AGREGAMOS LOS PARAMETROS A LA COLECCION oParametrosCR.Add(oUsuario); //nombre del parametro en CR (Crystal Reports) oParametrosCR[0].Name = "cUsuario"; //nombre del TITULO DEL INFORME cTitulo = "LISTADO DE SUB-CATEGORIAS DE PRODUCTOS"; //6to Instanciamos nuestro REPORTE //Reportes.ListadoDoctores oListado = new Reportes.ListadoDoctores(); REPORTES.rptSubCategorias orptSubCategoriasProductos = new REPORTES.rptSubCategorias(); //pasamos el nombre del TITULO del Listado //SumaryInfo es un objeto que se utiliza para leer,crear y actualizar las propiedades del reporte // oListado.SummaryInfo.ReportTitle = cTitulo; orptSubCategoriasProductos.SummaryInfo.ReportTitle = cTitulo; //7mo. instanciamos nuestro el FORMULARIO donde esta nuestro ReportViewer frmPrinter ofrmPrinter = new frmPrinter(dtSubcategoriasProductos, orptSubCategoriasProductos, cTitulo); //ParameterFieldInfo Obtiene o establece la colección de campos de parámetros. ofrmPrinter.CrystalReportViewer1.ParameterFieldInfo = oParametrosCR; ofrmPrinter.ShowDialog(); } //} //else //{ // MessageBox.Show("No se puede realizar busqueda con campos vacios..."); // txtYear.Focus(); //} } catch (Exception myEx) { MessageBox.Show("Error : " + myEx.Message, "Mostrando Reporte", MessageBoxButtons.OK, MessageBoxIcon.Information); // clsExceptionLog.LogError(myEx, false); return; } }
private void frmRVentaProductoCaja_Load(object sender, EventArgs e) { try { string bandera = frmReporteVentaCliente.f1.lblBandera.Text; string fechaInicio = ""; string fechaFin = ""; DateTime fecIn; if (bandera == "1") { fechaInicio = frmReporteVentaCliente.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd" + " 00:00:00"); fechaFin = frmReporteVentaCliente.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd" + " 23:59:59"); } else { fecIn = Convert.ToDateTime(frmPrincipal.f1.lblFechaApertura.Text); fechaInicio = fecIn.ToString("yyyy-MM-dd HH:mm:ss"); fechaFin = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } int idProducto = Convert.ToInt32(frmReporteVentasProducto.f1.cbProducto.SelectedValue); int nroCaja = Convert.ToInt32(frmReporteVentasProducto.f1.lblCaja.Text); ReportDocument repdoc = new ReportDocument(); repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SISTEMAUCHPA_Barra1\CapaPresentacion\Reportes/RVentaProductoCaja.rpt"); //repdoc.Load(@"E:\Reportes\RVentaProducto.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToDateTime(fechaInicio + " 00:00:00"); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaInicio"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = Convert.ToDateTime(fechaFin + " 23:59:59"); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaFin"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = idProducto; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@idProducto"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = nroCaja; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@nroCaja"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"UCHPABAR\SQLUCHPA"; crConnectionInfo.DatabaseName = "db_SISTEMAUCHPA"; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
private void SetParameters(ReportDocument Report) { DateTime dteRetValue = Constants.C_DATE_MIN_VALUE; ParameterFieldDefinition paramField; ParameterValues currentValues; ParameterDiscreteValue discreteParam; paramField = Report.DataDefinition.ParameterFields["CompanyName"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = CompanyDetails.CompanyName; currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); paramField = Report.DataDefinition.ParameterFields["PrintedBy"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = Session["Name"].ToString(); currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); switch (cboReportType.SelectedItem.Value) { case ReportTypes.CREDITS_Purchases: #region purchases paramField = Report.DataDefinition.ParameterFields["CreditCardTypeName"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = cboCreditType.SelectedItem.Text; currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); paramField = Report.DataDefinition.ParameterFields["PurchaseStartDate"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = DateTime.TryParse(txtTrxStartDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd"); currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); paramField = Report.DataDefinition.ParameterFields["PurchaseEndDate"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = DateTime.TryParse(txtTrxEndDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd"); currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); #endregion break; case ReportTypes.CREDITS_Payments: #region payments paramField = Report.DataDefinition.ParameterFields["CreditCardTypeName"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = cboCreditType.SelectedItem.Text; currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); paramField = Report.DataDefinition.ParameterFields["PaymentStartDate"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = DateTime.TryParse(txtTrxStartDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd"); currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); paramField = Report.DataDefinition.ParameterFields["PaymentEndDate"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = DateTime.TryParse(txtTrxEndDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd"); currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); #endregion break; case ReportTypes.CREDITS_CreditorsLedgerSummary: #region ledger summary paramField = Report.DataDefinition.ParameterFields["CreditCardTypeName"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = cboCreditType.SelectedItem.Text; currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); Data.CreditBills clsCreditBills = new Data.CreditBills(); Data.CreditBillDetails clsCreditBillDetails = clsCreditBills.Details(CreditType.Individual, DateTime.Parse(cboBillingDate.SelectedItem.Value), Int16.Parse(cboCreditType.SelectedItem.Value)); clsCreditBills.CommitAndDispose(); paramField = Report.DataDefinition.ParameterFields["CreditPurcStartDateToProcess"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = clsCreditBillDetails.CreditPurcStartDateToProcess; currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); paramField = Report.DataDefinition.ParameterFields["CreditPurcEndDateToProcess"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = clsCreditBillDetails.CreditPurcEndDateToProcess; currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); paramField = Report.DataDefinition.ParameterFields["PaymentDueDate"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = clsCreditBillDetails.CreditPaymentDueDate; currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); paramField = Report.DataDefinition.ParameterFields["BillingDate"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = DateTime.Parse(cboBillingDate.SelectedItem.Value); currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); paramField = Report.DataDefinition.ParameterFields["ShowDetails"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = true; currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); #endregion break; default: break; } }
public static ReportDocument SetReportDoc(double top, double bottom, double left, double right, int printCount, params string[] nums) { ReportDocument doc = new ReportDocument(); try { string ReportPath = nums[0].ToString(); doc.Load(ReportPath); for (int i = 3; i < nums.Length; i++) { string paramValue = nums[i].ToString(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = paramValue; ParameterValues pv = new ParameterValues(); pv.Add(pdv); doc.DataDefinition.ParameterFields[i - 3].ApplyCurrentValues(pv); } if (doc.Database.Tables.Count > 0) { //for (int i = 0; i < doc.Database.Tables.Count; i++) //{ // doc.Database.Tables[i].ApplyLogOnInfo(LoginInfo()); //} doc.Database.Tables[0].ApplyLogOnInfo(LoginInfo()); } string msgStr = "【" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss fff") + "】 加载报表 \r\n"; PrinterLOG.WriterLog(msgStr, nums[2], false); //Sections sections = doc.ReportDefinition.Sections; //foreach (Section section in sections) //{ // ReportObjects reportObjects = section.ReportObjects; // foreach (ReportObject reportObject in reportObjects) // { // if (reportObject.Kind == ReportObjectKind.SubreportObject) // { // SubreportObject subreportObject = (SubreportObject)reportObject; // ReportDocument subReportDocument = subreportObject.OpenSubreport(subreportObject.SubreportName); // if (subReportDocument.Database.Tables.Count > 0) // { // for (int i = 0; i < subReportDocument.Database.Tables.Count; i++) // { // subReportDocument.Database.Tables[i].ApplyLogOnInfo(LoginInfo()); // } // //subReportDocument.Database.Tables[0].ApplyLogOnInfo(LoginInfo()); // } // } // } //} //打印机名字 doc.PrintOptions.PrinterName = nums[2].ToString(); //设置打印边距 PageMargins margins; margins = doc.PrintOptions.PageMargins; margins.topMargin = Convert.ToInt32(top * 567); //567 margins.leftMargin = Convert.ToInt32(left * 567); margins.rightMargin = Convert.ToInt32(right * 567); margins.bottomMargin = Convert.ToInt32(bottom * 567); doc.PrintOptions.ApplyPageMargins(margins); if (nums[1].ToString().StartsWith("Y")) { //if (nums[1].ToString() == "Y1") //{ // doc.PrintOptions.PaperSize = PaperSize.PaperA4; //} //else //{ // doc.PrintOptions.PaperOrientation = PaperOrientation.DefaultPaperOrientation; // doc.PrintOptions.PaperSize = PaperSize.DefaultPaperSize; //} //打印份数,是否逐份打印,打印第一页,最后一页 if (printCount > 20) { printCount = 1; } doc.PrintToPrinter(printCount, false, 0, 0); } } catch (Exception exp) { PrinterLOG.WriterLog(exp.Message, nums[2].ToString(), true); doc = null; } return(doc); }
private void addDefaultPercentileFor(ParameterValues parameterValues) { var allPercentiles = new double[parameterValues.Values.Count].InitializeWith(CoreConstants.DEFAULT_PERCENTILE); addPercentileValues(parameterValues, allPercentiles); }
private void TransactionsReportFrom_Load(object sender, EventArgs e) { string str; ReportDocument reportDocument; ReportDataTable reportDataTable; ParameterValues parameterValue; ParameterDiscreteValue parameterDiscreteValue; ParameterValues parameterValue2; ParameterDiscreteValue parameterDiscreteValue2; ParameterValues parameterValue3; ParameterDiscreteValue parameterDiscreteValue3; ParameterValues parameterValue4; ParameterDiscreteValue parameterDiscreteValue4; ReportDocument reportDocument2; ParameterValues parameterValue5; ParameterDiscreteValue parameterDiscreteValue5; ParameterValues parameterValue6; ParameterDiscreteValue parameterDiscreteValue6; ReportDocument reportDocument3; ParameterValues parameterValue7; ParameterDiscreteValue parameterDiscreteValue7; ParameterValues parameterValue8; ParameterDiscreteValue parameterDiscreteValue8; ReportDocument reportDocument4; ParameterValues parameterValue9; ParameterDiscreteValue parameterDiscreteValue9; ParameterValues parameterValue10; ParameterDiscreteValue parameterDiscreteValue10; ReportDocument reportDocument5; AccountsViewDataTable accountsViewDataTable; ReportDocument reportDocument6; ReportDocument reportDocument7; ReportDocument reportDocument8; ParameterValues parameterValue11; ParameterDiscreteValue parameterDiscreteValue11; ParameterValues parameterValue12; ParameterDiscreteValue parameterDiscreteValue12; AccountsBLL accountsBLL = new AccountsBLL(); Cursor.Current = Cursors.WaitCursor; base.WindowState = FormWindowState.Maximized; switch (this.reportType) { case ReportType.TrialBalance: { this.set_Text("ميزان المراجعة"); reportDocument3 = new ReportDocument(); reportDocument3.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\TrialBalanceCR.rpt")); reportDocument3.SetDataSource(this._reportBll.getTrialBalance(this.From, this.To)); parameterValue7 = new ParameterValues(); parameterDiscreteValue7 = new ParameterDiscreteValue(); parameterDiscreteValue7.set_Value(this.From); parameterValue7.Add(parameterDiscreteValue7); reportDocument3.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue7); parameterValue8 = new ParameterValues(); parameterDiscreteValue8 = new ParameterDiscreteValue(); parameterDiscreteValue8.set_Value(this.To); parameterValue8.Add(parameterDiscreteValue8); reportDocument3.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue8); this.crViewer.set_ReportSource(reportDocument3); } case ReportType.BalanceSheet: { this.set_Text("الميزانية العمومية"); reportDocument4 = new ReportDocument(); reportDocument4.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\BalanceSheetCR.rpt")); reportDocument4.SetDataSource(this._reportBll.getBalanceSheet(this.From, this.To)); parameterValue9 = new ParameterValues(); parameterDiscreteValue9 = new ParameterDiscreteValue(); parameterDiscreteValue9.set_Value(this.From); parameterValue9.Add(parameterDiscreteValue9); reportDocument4.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue9); parameterValue10 = new ParameterValues(); parameterDiscreteValue10 = new ParameterDiscreteValue(); parameterDiscreteValue10.set_Value(this.To); parameterValue10.Add(parameterDiscreteValue10); reportDocument4.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue10); this.crViewer.set_ReportSource(reportDocument4); } case ReportType.Transactions: { this.set_Text("كشف حركة حساب"); str = accountsBLL.GetAccountByID(this.account)[0].GL_Name_VC; reportDocument = new ReportDocument(); reportDocument.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\reportTest.rpt")); reportDataTable = this._reportBll.getByCodeDate(this.From, this.To, this.account); reportDocument.SetDataSource(reportDataTable); parameterValue = new ParameterValues(); parameterDiscreteValue = new ParameterDiscreteValue(); parameterDiscreteValue.set_Value(str); parameterValue.Add(parameterDiscreteValue); reportDocument.DataDefinition.ParameterFields["account"].ApplyCurrentValues(parameterValue); parameterValue2 = new ParameterValues(); parameterDiscreteValue2 = new ParameterDiscreteValue(); parameterDiscreteValue2.set_Value(this.From); parameterValue2.Add(parameterDiscreteValue2); reportDocument.DataDefinition.ParameterFields["dtFrom"].ApplyCurrentValues(parameterValue2); parameterValue3 = new ParameterValues(); parameterDiscreteValue3 = new ParameterDiscreteValue(); parameterDiscreteValue3.set_Value(this.To); parameterValue3.Add(parameterDiscreteValue3); reportDocument.DataDefinition.ParameterFields["dtTo"].ApplyCurrentValues(parameterValue3); parameterValue4 = new ParameterValues(); parameterDiscreteValue4 = new ParameterDiscreteValue(); parameterDiscreteValue4.set_Value(reportDataTable[reportDataTable.Count - 1].Balance); parameterValue4.Add(parameterDiscreteValue4); reportDocument.DataDefinition.ParameterFields["tBalance"].ApplyCurrentValues(parameterValue4); this.crViewer.set_ReportSource(reportDocument); } case ReportType.ProfitAndLoss: { this.set_Text("بيان الأرباح والخسائر"); reportDocument2 = new ReportDocument(); reportDocument2.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\ProfitLossCR.rpt")); reportDocument2.SetDataSource(this._reportBll.getProfitAndLoss(this.From, this.To)); parameterValue5 = new ParameterValues(); parameterDiscreteValue5 = new ParameterDiscreteValue(); parameterDiscreteValue5.set_Value(this.From); parameterValue5.Add(parameterDiscreteValue5); reportDocument2.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue5); parameterValue6 = new ParameterValues(); parameterDiscreteValue6 = new ParameterDiscreteValue(); parameterDiscreteValue6.set_Value(this.To); parameterValue6.Add(parameterDiscreteValue6); reportDocument2.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue6); this.crViewer.set_ReportSource(reportDocument2); } case ReportType.Accounts: { this.set_Text("كشف أرصدة مجموعة حسابات"); reportDocument5 = new ReportDocument(); reportDocument5.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\AccountsCR.rpt")); accountsViewDataTable = new AccountsBLL().GetAccountsView(); reportDocument5.SetDataSource(accountsViewDataTable); this.crViewer.set_ReportSource(reportDocument5); this.set_Text("الموظفون"); reportDocument6 = new ReportDocument(); reportDocument6.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\EmployeeCR.rpt")); reportDocument6.SetDataSource(new EmployeeBll().getEmployee()); this.crViewer.set_ReportSource(reportDocument6); this.set_Text("الموردون"); reportDocument7 = new ReportDocument(); reportDocument7.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\SupplierCR.rpt")); reportDocument7.SetDataSource(new SupplierBll().getSuppliers()); this.crViewer.set_ReportSource(reportDocument7); this.set_Text("مجمع الإهلاك"); reportDocument8 = new ReportDocument(); reportDocument8.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\fixedCR.rpt")); reportDocument8.SetDataSource(this._reportBll.FixedAssetsReport(this.From, this.To)); parameterValue11 = new ParameterValues(); parameterDiscreteValue11 = new ParameterDiscreteValue(); parameterDiscreteValue11.set_Value(this.From); parameterValue11.Add(parameterDiscreteValue11); reportDocument8.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue11); parameterValue12 = new ParameterValues(); parameterDiscreteValue12 = new ParameterDiscreteValue(); parameterDiscreteValue12.set_Value(this.To); parameterValue12.Add(parameterDiscreteValue12); reportDocument8.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue12); this.crViewer.set_ReportSource(reportDocument8); goto; } case ReportType.None: { this.set_Cursor(Cursors.Default); return; } } }
private void btnImprimir_Click(object sender, EventArgs e) { //Conexion a la base de datos MySqlConnection myConexion = new MySqlConnection(clsConexion.ConectionString); // Creando el command que ejecutare MySqlCommand myCommand = new MySqlCommand(); // Creando el Data Adapter MySqlDataAdapter myAdapter = new MySqlDataAdapter(); // Creando el String Builder StringBuilder sbQuery = new StringBuilder(); // Otras variables del entorno string cWhere = " WHERE 1 = 1"; string cUsuario = ""; string cTitulo = ""; if (rbDespachada.Checked == true) { cWhere = cWhere + " AND facturacion.despachada = 0 AND facturacion.anulada = 0"; } else if (rbCobradas.Checked == true) { cWhere = cWhere + " AND facturacion.despachada = 1 AND facturacion.status = 0 AND facturacion.anulada = 0"; } else { cWhere = cWhere + " AND facturacion.anulada = 1"; } try { // Abro conexion myConexion.Open(); // Creo comando myCommand = myConexion.CreateCommand(); // Adhiero el comando a la conexion myCommand.Connection = myConexion; // Filtros de la busqueda //string fechadesde = fechaDesde.Value.ToString("yyyy-MM-dd"); //string fechahasta = fechaHasta.Value.ToString("yyyy-MM-dd"); //cWhere = cWhere + " AND fechacita >= " + "'" + fechadesde + "'" + " AND fechacita <= " + "'" + fechahasta + "'" + ""; sbQuery.Clear(); sbQuery.Append("SELECT "); sbQuery.Append(" facturacion.idfacturacion, facturacion.fecha, facturacion.monto_b,"); sbQuery.Append(" facturacion.monto_n, "); sbQuery.Append(" clientes.nombre as cliente"); sbQuery.Append(" FROM facturacion "); sbQuery.Append(" INNER JOIN clientes ON facturacion.idcliente = clientes.idcliente"); sbQuery.Append(cWhere); // Paso los valores de sbQuery al CommandText myCommand.CommandText = sbQuery.ToString(); // Creo el objeto Data Adapter y ejecuto el command en el myAdapter = new MySqlDataAdapter(myCommand); // Creo el objeto Data Table DataTable dtFacturacion = new DataTable(); // Lleno el data adapter myAdapter.Fill(dtFacturacion); // Cierro el objeto conexion myConexion.Close(); // Verifico cantidad de datos encontrados int nRegistro = dtFacturacion.Rows.Count; if (nRegistro == 0) { MessageBox.Show("No Hay Datos Para Mostrar, Favor Verificar", "Sistema de Gestion de Facturacion e Inventario", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { //1ero.HACEMOS LA COLECCION DE PARAMETROS //los campos de parametros contiene un objeto para cada campo de parametro en el informe ParameterFields oParametrosCR = new ParameterFields(); //Proporciona propiedades para la recuperacion y configuracion del tipo de los parametros ParameterValues oParametrosValuesCR = new ParameterValues(); //2do.CREAMOS LOS PARAMETROS ParameterField oUsuario = new ParameterField(); //parametervaluetype especifica el TIPO de valor de parametro //ParameterValueKind especifica el tipo de valor de parametro en la PARAMETERVALUETYPE de la Clase PARAMETERFIELD oUsuario.ParameterValueType = ParameterValueKind.StringParameter; //3ero.VALORES PARA LOS PARAMETROS //ParameterDiscreteValue proporciona propiedades para la recuperacion y configuracion de //parametros de valores discretos ParameterDiscreteValue oUsuarioDValue = new ParameterDiscreteValue(); oUsuarioDValue.Value = cUsuario; //4to. AGREGAMOS LOS VALORES A LOS PARAMETROS oUsuario.CurrentValues.Add(oUsuarioDValue); //5to. AGREGAMOS LOS PARAMETROS A LA COLECCION oParametrosCR.Add(oUsuario); //nombre del parametro en CR (Crystal Reports) oParametrosCR[0].Name = "cUsuario"; //nombre del TITULO DEL INFORME if (rbDespachada.Checked == true) { cTitulo = "LISTADO DE FACTURACIONES PENDIENTES POR DESPACHAR"; } else if (rbCobradas.Checked == true) { cTitulo = "LISTADO DE FACTURACIONES PENDIENTES POR COBRAR"; } else { cTitulo = "LISTADO DE FACTURACIONES ANULADAS"; } //6to Instanciamos nuestro REPORTE //Reportes.ListadoDoctores oListado = new Reportes.ListadoDoctores(); rptFacturacion orptFacturacion = new rptFacturacion(); //pasamos el nombre del TITULO del Listado //SumaryInfo es un objeto que se utiliza para leer,crear y actualizar las propiedades del reporte // oListado.SummaryInfo.ReportTitle = cTitulo; orptFacturacion.SummaryInfo.ReportTitle = cTitulo; //7mo. instanciamos nuestro el FORMULARIO donde esta nuestro ReportViewer frmPrinter ofrmPrinter = new frmPrinter(dtFacturacion, orptFacturacion, cTitulo); //ParameterFieldInfo Obtiene o establece la colección de campos de parámetros. ofrmPrinter.CrystalReportViewer1.ParameterFieldInfo = oParametrosCR; ofrmPrinter.ShowDialog(); } } catch (Exception myEx) { MessageBox.Show("Error : " + myEx.Message, "Mostrando Reporte", MessageBoxButtons.OK, MessageBoxIcon.Information); //ExceptionLog.LogError(myEx, false); return; } }
public string Execute(ParameterValues parameterValues) { return(_Execute?.Invoke(parameterValues) ?? "No Action defined"); }
protected void GenerateReport() { string paramName = string.Empty; try { ReportDocument theReport = new ReportDocument(); string reportFile = Converter.GetString(SessionStore.GetValue(Params.REPORT_FILE_NAME_KEY)); if ((reportFile != string.Empty) & (reportFile != null)) { TableLogOnInfo myLog; CrystalDecisions.CrystalReports.Engine.Table myTable; reportFile = reportFile + ".rpt"; string reportPath = this.MapPath(".") + @"\Reports\" + reportFile; theReport.Load(reportPath); ConnectionInfo conn = new ConnectionInfo(); //conn.ServerName = ConfigurationManager.AppSettings["DBServer"].Trim(); conn.DatabaseName = Converter.GetString(SessionStore.GetValue(Params.REPORT_DATABASE_NAME_KEY));//ConfigurationManager.AppSettings["InitialDB"].Trim(); //conn.UserID = ConfigurationManager.AppSettings["DBUserName"].Trim(); //conn.Password = ConfigurationManager.AppSettings["DBPassword"].Trim(); conn.IntegratedSecurity = true; int tableCount = theReport.Database.Tables.Count - 1; for (int i = 0; i <= tableCount; i++) { myTable = theReport.Database.Tables[i]; myLog = myTable.LogOnInfo; myLog.ConnectionInfo = conn; myTable.ApplyLogOnInfo(myLog); myTable.Location = myLog.TableName; } int reportobjectsCount = theReport.ReportDefinition.ReportObjects.Count - 2; for (int i = 0; i <= reportobjectsCount; i++) { CrystalDecisions.CrystalReports.Engine.ReportObject rpt = theReport.ReportDefinition.ReportObjects[i]; if (rpt.Kind == ReportObjectKind.SubreportObject) { SubreportObject subrpt = (SubreportObject)rpt; ReportDocument r = theReport.OpenSubreport(subrpt.SubreportName); int subreportTableCount = r.Database.Tables.Count - 2; for (int j = 0; j <= subreportTableCount; j++) { myTable = r.Database.Tables[j]; myLog = myTable.LogOnInfo; myTable.ApplyLogOnInfo(myLog); myTable.Location = myLog.TableName; } } } ParameterValues pList = new ParameterValues(); ParameterDiscreteValue pV = new ParameterDiscreteValue(); int parameterFieldsCount = theReport.DataDefinition.ParameterFields.Count - 1; for (int i = 0; i <= parameterFieldsCount; i++) { paramName = theReport.DataDefinition.ParameterFields[i].Name; //Report Parameters Fields 1 if (paramName == "@BRNO") { pV.Value = SessionStore.GetValue(Params.BRNO_ID); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 2 else if (paramName == "@CONO") { pV.Value = SessionStore.GetValue(Params.CONO_ID); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 3 else if (paramName == "@CompanyName") { pV.Value = SessionStore.GetValue(Params.COMPANY_NAME); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CompanyNameB") { pV.Value = SessionStore.GetValue(Params.COMPANY_NAME_B); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 4 else if (paramName == "@BranchName") { pV.Value = SessionStore.GetValue(Params.BRANCH_NAME); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 5 else if (paramName == "@BranchAddress") { pV.Value = SessionStore.GetValue(Params.BRANCH_ADDRESS); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@BranchAddressB") { pV.Value = SessionStore.GetValue(Params.BRANCH_ADDRESS_B); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 6 else if (paramName == "@CommonName") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 6 else if (paramName == "@CommonName1") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME1); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 7 else if (paramName == "@CommonName2") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME2); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 8 else if (paramName == "@CommonName3") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME3); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 9 else if (paramName == "@CommonName4") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME4); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 10 else if (paramName == "@CommonName5") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME5); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 11 else if (paramName == "@CommonName6") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME6); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 12 else if (paramName == "@CommonName7") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME7); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 13 else if (paramName == "@CommonName8") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME8); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 14 else if (paramName == "@CommonName9") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME9); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 15 else if (paramName == "@CommonName10") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME10); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 15 else if (paramName == "@CommonName11") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME11); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 15 else if (paramName == "@CommonName12") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME12); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 15 else if (paramName == "@CommonName13") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME13); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 15 else if (paramName == "@CommonName14") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME14); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CommonName15") { pV.Value = SessionStore.GetValue(Params.COMMON_NAME15); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 16 else if (paramName == "@CommonNo1") { pV.Value = SessionStore.GetValue(Params.COMMON_NO1); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 17 else if (paramName == "@CommonNo2") { pV.Value = SessionStore.GetValue(Params.COMMON_NO2); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 18 else if (paramName == "@CommonNo3") { pV.Value = SessionStore.GetValue(Params.COMMON_NO3); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 19 else if (paramName == "@CommonNo4") { pV.Value = SessionStore.GetValue(Params.COMMON_NO4); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 20 else if (paramName == "@CommonNo5") { pV.Value = SessionStore.GetValue(Params.COMMON_NO5); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 21 else if (paramName == "@CommonNo6") { pV.Value = SessionStore.GetValue(Params.COMMON_NO6); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 22 else if (paramName == "@CommonNo7") { pV.Value = SessionStore.GetValue(Params.COMMON_NO7); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 23 else if (paramName == "@CommonNo8") { pV.Value = SessionStore.GetValue(Params.COMMON_NO8); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 24 else if (paramName == "@CommonNo9") { pV.Value = SessionStore.GetValue(Params.COMMON_NO9); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 25 else if (paramName == "@CommonNo10") { pV.Value = SessionStore.GetValue(Params.COMMON_NO10); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CommonNo11") { pV.Value = SessionStore.GetValue(Params.COMMON_NO11); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 32 else if (paramName == "@CommonNo12") { pV.Value = SessionStore.GetValue(Params.COMMON_NO12); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 33 else if (paramName == "@CommonNo13") { pV.Value = SessionStore.GetValue(Params.COMMON_NO13); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 34 else if (paramName == "@CommonNo14") { pV.Value = SessionStore.GetValue(Params.COMMON_NO14); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 35 else if (paramName == "@CommonNo15") { pV.Value = SessionStore.GetValue(Params.COMMON_NO15); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CommonNo16") { pV.Value = SessionStore.GetValue(Params.COMMON_NO16); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CommonNo17") { pV.Value = SessionStore.GetValue(Params.COMMON_NO17); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CommonNo18") { pV.Value = SessionStore.GetValue(Params.COMMON_NO18); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CommonNo19") { pV.Value = SessionStore.GetValue(Params.COMMON_NO19); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CommonNo20") { pV.Value = SessionStore.GetValue(Params.COMMON_NO20); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 26 else if (paramName == "@UserID") { pV.Value = SessionStore.GetValue(Params.USERNO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@UserName") { pV.Value = SessionStore.GetValue(Params.USERNAME); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@BranchNo") { pV.Value = SessionStore.GetValue(Params.BRNO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CuNo") { pV.Value = SessionStore.GetValue(Params.CUNO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 27 else if (paramName == "@CuType") { pV.Value = SessionStore.GetValue(Params.CUPTYE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 28 else if (paramName == "@AccType") { pV.Value = SessionStore.GetValue(Params.ACCTYPE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 29 else if (paramName == "@AccNo") { pV.Value = SessionStore.GetValue(Params.ACCNO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 30 else if (paramName == "@MemType") { pV.Value = SessionStore.GetValue(Params.MEMTYPE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@MemNo") { pV.Value = SessionStore.GetValue(Params.MEMNO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@ColCode") { pV.Value = SessionStore.GetValue(Params.COLCODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@RegNo") { pV.Value = SessionStore.GetValue(Params.REGNO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 31 //Report Parameters Fields 36 else if (paramName == "@fDate") { pV.Value = SessionStore.GetValue(Params.COMMON_FDATE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } // Report Parameters Fields 37 else if (paramName == "@tDate") { pV.Value = SessionStore.GetValue(Params.COMMON_TDATE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } // Report Parameters Fields 38 else if (paramName == "@ProdCode") { pV.Value = SessionStore.GetValue(Params.PROD_CODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } // Report Parameters Fields 39 else if (paramName == "@BatchNo") { pV.Value = SessionStore.GetValue(Params.BATCH_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } // Report Parameters Fields 40 else if (paramName == "@VchNo") { pV.Value = SessionStore.GetValue(Params.VOUCHER_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } // Report Parameters Fields 41 else if (paramName == "@fBatchNo") { pV.Value = SessionStore.GetValue(Params.FIRST_BATCH_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } // Report Parameters Fields 42 else if (paramName == "@tBatchNo") { pV.Value = SessionStore.GetValue(Params.TO_BATCH_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } // Report Parameters Fields 43 else if (paramName == "@TrnasferType") { pV.Value = SessionStore.GetValue(Params.TRANSFER_TYPE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } // Report Parameters Fields 45 else if (paramName == "@TrnSlNo") { pV.Value = SessionStore.GetValue(Params.TRNSL_CODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 46 else if (paramName == "@LedgerType") { pV.Value = SessionStore.GetValue(Params.LEDGER_TYPE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 47 else if (paramName == "@LedgerNo") { pV.Value = SessionStore.GetValue(Params.LEDGER_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 48 else if (paramName == "@ReqNo") { pV.Value = SessionStore.GetValue(Params.REQ_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 49 else if (paramName == "@ProdCode") { pV.Value = SessionStore.GetValue(Params.PROD_CODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 50 else if (paramName == "@BatchNo") { pV.Value = SessionStore.GetValue(Params.BATCH_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 51 else if (paramName == "@GRNNo") { pV.Value = SessionStore.GetValue(Params.GRN_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 52 else if (paramName == "@nItemType") { pV.Value = SessionStore.GetValue(Params.ITEM_TYPE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 53 else if (paramName == "@nItemSource") { pV.Value = SessionStore.GetValue(Params.ITEM_SOURCE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //......................................nimara................................................. //Report Parameters Fields 54 else if (paramName == "@SuppCode") { pV.Value = SessionStore.GetValue(Params.SUPP_CODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //....................................................................................... //Report Parameters Fields 55 else if (paramName == "@ManuCode") { pV.Value = SessionStore.GetValue(Params.MANU_CODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //............................................................................................ //Report Parameters Fields 56 else if (paramName == "@OrdNo") { pV.Value = SessionStore.GetValue(Params.ORDER_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 57 else if (paramName == "@ItemCode") { pV.Value = SessionStore.GetValue(Params.ITEM_CODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 58 else if (paramName == "@fItemCode") { pV.Value = SessionStore.GetValue(Params.F_ITEM_CODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 59 else if (paramName == "@tItemCode") { pV.Value = SessionStore.GetValue(Params.T_ITEM_CODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 60 else if (paramName == "@ChalanNo") { pV.Value = SessionStore.GetValue(Params.CHALLAN_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 61 else if (paramName == "@EmpNo") { pV.Value = SessionStore.GetValue(Params.EMP_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //Report Parameters Fields 62 else if (paramName == "@PPICNo") { pV.Value = SessionStore.GetValue(Params.PPIC_NO); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@AccountCode") { pV.Value = SessionStore.GetValue(Params.ACCOUNTCODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@nFlag") { pV.Value = SessionStore.GetValue(Params.NFLAG); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@LPurpose") { pV.Value = SessionStore.GetValue(Params.LPURPOSE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@KeyCode") { pV.Value = SessionStore.GetValue(Params.KEYCODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@Currency") { pV.Value = SessionStore.GetValue(Params.CURRENCY); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //......................................Multiuser Store Procedure........................... else if (paramName == "@AccClass") { pV.Value = SessionStore.GetValue(Params.MU_ACC_CLASS); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@Func99") { pV.Value = SessionStore.GetValue(Params.MU_FUNC_99); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@FcashCode") { pV.Value = SessionStore.GetValue(Params.MU_F_CASH_CODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@TrnType") { pV.Value = SessionStore.GetValue(Params.MU_TRN_TYPE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@teller") { pV.Value = SessionStore.GetValue(Params.MU_TELLER); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@TrnMode") { pV.Value = SessionStore.GetValue(Params.MU_TRN_MODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@TrnNature") { pV.Value = SessionStore.GetValue(Params.MU_TRN_NATURE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@TrnModule") { pV.Value = SessionStore.GetValue(Params.MU_TRN_MODULE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@TranSw") { pV.Value = SessionStore.GetValue(Params.MU_TRAN_SW); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@UserId") { pV.Value = SessionStore.GetValue(Params.MU_USER_ID); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CashCode") { pV.Value = SessionStore.GetValue(Params.MU_CASH_CODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CSGLTransaction") { pV.Value = SessionStore.GetValue(Params.MU_CS_GL_TRN); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@AutoTransaction") { pV.Value = SessionStore.GetValue(Params.MU_AUTO_TRN); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@TransactionAmount") { pV.Value = SessionStore.GetValue(Params.MU_TRAN_AMT); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@AccStatFlag") { pV.Value = SessionStore.GetValue(Params.MU_ACC_STAT_FLAG); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@BalanceFlag") { pV.Value = SessionStore.GetValue(Params.MU_BALANCE_FLAG); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@fBalance") { pV.Value = SessionStore.GetValue(Params.MU_F_BALANCE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@tBalance") { pV.Value = SessionStore.GetValue(Params.MU_T_BALANCE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@CodeType") { pV.Value = SessionStore.GetValue(Params.MU_CODE_TYPE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@TrnCode") { pV.Value = SessionStore.GetValue(Params.MU_TRN_CODE); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } else if (paramName == "@ContractInt") { pV.Value = SessionStore.GetValue(Params.MU_CONTRACT_INT); pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } //......................................End of Multiuser Store Procedure.................... //............................................................................................ else { //This else for SP parameters 63 paramName = theReport.DataDefinition.ParameterFields[i].Name; string paramValue = Converter.GetString(SessionStore.GetValue(Params.WHERE_CLAUSE)); pV.Value = paramValue; pList.Add((ParameterValue)pV); theReport.DataDefinition.ParameterFields[paramName].ApplyCurrentValues(pList); } } this.CrystalReportViewer1.ReportSource = theReport; this.CrystalReportViewer1.RefreshReport(); Session["ReportDocument"] = theReport; } else { //TODO } } catch (Exception ex) { //string notifyMsg = "?msg=" + ex.ToString() + System.Environment.NewLine + "Please Check Value = " + paramName + System.Environment.NewLine + Request.UrlReferrer + "&PreviousMenu=A2ZERPModule.aspx"; //Server.Transfer("MessageDisplay.aspx" + notifyMsg); throw ex; //Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.GenerateReport Problem');</script>"); } }
private void button1ok_Click(object sender, EventArgs e) { try { Cursor.Current = Cursors.WaitCursor; SqlCommand cmd = new SqlCommand(); SqlConnection myConnection = default(SqlConnection); SqlDataAdapter myDA = new SqlDataAdapter(); DataSet myDS = new DataSet(); myConnection = new SqlConnection(cs.DBConn); cmd.Connection = myConnection; myConnection.Open(); string cmdStrinzz = "SELECT TFinancials.FDate, TFinancials.Particular, TFinancials.FCredit," + " TFinancials.FDebit, TFinancials.Names, Accounts.Account_type, Cash_Bank.Cash_type," + " CASE WHEN TFinancials.FDebit > 0 THEN 'Expense' ELSE 'Income' END AS Transaction_type " +//take note of the if else statement in there use for the p/l statement " FROM TFinancials INNER JOIN " + " Cash_Bank ON TFinancials.Id = Cash_Bank.Id INNER JOIN " + " Accounts ON TFinancials.Account_id = Accounts.Account_id" + " where (TFinancials.FDate >= @a2) AND (TFinancials.FDate <= @a3) "; cmd = new SqlCommand(cmdStrinzz, myConnection); cmd.Parameters.AddWithValue("@a2", SqlDbType.Date).Value = (dateTimePicker1.Value.Date); cmd.Parameters.AddWithValue("@a3", SqlDbType.Date).Value = (dateTimePicker2.Value.Date); myDA.SelectCommand = cmd; myDA.Fill(myDS, "S_And_C_statment"); rptpandlst rpt3 = new rptpandlst(); rpt3.SetDataSource(myDS); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = "BIG LTD Profit And Loss Statement " + Environment.NewLine + " For the period of " + dateTimePicker1.Value.ToShortDateString() + " To " + dateTimePicker2.Value.ToShortDateString(); crParameterFieldDefinitions = rpt3.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["My Parameter"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); //frmcashsummary frm2 = new frmcashsummary(); crystalReportViewer1.ReportSource = rpt3; //frm2.ShowDialog(); myConnection.Close(); Cursor = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show("Error " + ex); } }
private static void WriteData(Session session, Parameter parameter, ParameterDataAccessBase pdaNewParameter, ParameterValues samples) { // add data to new created parameter for (var j = samples.SampleCount - 1; j >= 0; j--) { var newTimestamp = samples.Timestamp[j]; var newValue = samples.Data[j] + 10; session.AddChannelData( parameter.ChannelIds.FirstOrDefault(), newTimestamp, 1, //value of 1 param BitConverter.GetBytes(newValue)); Console.WriteLine($"Written sample. Timestamp: {newTimestamp.ToTimeString()} Value:{newValue}"); } // read data back to verify the data added pdaNewParameter.GoTo(session.EndTime); var samplesNewParameter = pdaNewParameter.GetNextSamples(10, StepDirection.Reverse); for (var j = 0; j < samplesNewParameter.SampleCount; j++) { Console.WriteLine($"{parameter.Identifier} {samplesNewParameter.Timestamp[j].ToTimeString()} {samplesNewParameter.Data[j]}"); } }
public Boolean printReport(CrystalDecisions.CrystalReports.Engine.ReportClass crReport, CrystalReportViewer CrystalReportViewer1, String param, String ParamName) { bool success=false; if (PrinterName!="none") { try { paramField.ParameterFieldName = ParamName; discreteVal.Value = param; paramField.CurrentValues.Add (discreteVal); paramFields.Add (paramField); crReport.DataDefinition.ParameterFields[0].CurrentValues.Add (discreteVal); CrystalReportViewer1.ReportSource = crReport; CrystalReportViewer1.ParameterFieldInfo = paramFields; CrystalReportViewer1.RefreshReport(); ParameterValues tmpParam = new ParameterValues(); tmpParam.Add(discreteVal); crReport.DataDefinition.ParameterFields[0].ApplyCurrentValues(tmpParam); crReport.PrintOptions.PrinterName = PrinterName; //crReport.PrintToPrinter(1,false,1,1); crReport.PrintToPrinter(1,false,1,99); success=true; } catch{} } return success; }
/// <summary> /// IMPR: Reduce complexity by creating a 'result' structure and split method in several parts. /// </summary> /// <param name="writer"></param> /// <param name="combi"></param> /// <param name="index"></param> private void PrintTimbre(TextWriter writer, ICombi combi, int index) { var timbre = combi.Timbres.TimbresCollection[index]; var status = timbre.GetParam(ParameterNames.TimbreParameterName.Status).Value; var muteParam = timbre.GetParam(ParameterNames.TimbreParameterName.Mute); var mute = muteParam != null && (bool)muteParam.Value; var muteString = mute.ToYesNo(); if (!ShowTimbre(timbre)) { return; } var usedProgram = timbre.UsedProgram; var timbreId = (usedProgram == null) ? "???" : timbre.ColumnProgramId; var isGmProgram = (usedProgram != null) && ((ProgramBank)(timbre.UsedProgram.Parent)).Type == BankType.EType.Gm; var byteOffset = (usedProgram == null) ? 0 : timbre.UsedProgram.ByteOffset; var name = isGmProgram ? "-" : (byteOffset == 0) ? "???" : timbre.ColumnProgramName; var category = isGmProgram ? "-" : (byteOffset == 0) ? "???" : timbre.UsedProgram.CategoryAsName; var subCategory = isGmProgram ? "-" : ((byteOffset == 0) ? "???" : timbre.UsedProgram.SubCategoryAsName); var volume = (string)(timbre.GetParam(ParameterNames.TimbreParameterName.Volume).Value.ToString()); var priority = timbre.GetParam(ParameterNames.TimbreParameterName.Priority); var priorityString = (isGmProgram || (priority == null)) ? "No" : ((byteOffset == 0) ? "???" : ((bool)priority.Value).ToYesNo()); var midiChannelString = ParameterValues.GetStringValue(ParameterNames.TimbreParameterName.MidiChannel, (int)timbre.GetParam(ParameterNames.TimbreParameterName.MidiChannel).Value); var bottomKey = (string)ParameterValues.GetStringValue(ParameterNames.TimbreParameterName.BottomKey, timbre.GetParam(ParameterNames.TimbreParameterName.BottomKey).Value); var topKey = (string)ParameterValues.GetStringValue(ParameterNames.TimbreParameterName.TopKey, timbre.GetParam(ParameterNames.TimbreParameterName.TopKey).Value); var bottomVelocity = (string)timbre.GetParam(ParameterNames.TimbreParameterName.BottomVelocity).Value.ToString(); var topVelocity = (string)timbre.GetParam(ParameterNames.TimbreParameterName.TopVelocity).Value.ToString(); var paramOscMode = timbre.GetParam(ParameterNames.TimbreParameterName.OscMode); var oscMode = (paramOscMode == null) ? "-" : (string)paramOscMode.Value; var paramOscSelect = timbre.GetParam(ParameterNames.TimbreParameterName.OscSelect); var oscSelect = (paramOscSelect == null) ? "-" : (string)paramOscSelect.Value; var transpose = (string)ParameterValues.GetStringValue(ParameterNames.TimbreParameterName.Transpose, timbre.GetParam(ParameterNames.TimbreParameterName.Transpose).Value); var paramDetune = timbre.GetParam(ParameterNames.TimbreParameterName.Detune); var detune = (paramDetune == null) ? "-" : (string)ParameterValues.GetStringValue(ParameterNames.TimbreParameterName.Detune, paramDetune.Value); var paramPortamento = timbre.GetParam(ParameterNames.TimbreParameterName.Portamento); var portamento = (paramPortamento == null) ? "-" : (string)ParameterValues.GetStringValue(ParameterNames.TimbreParameterName.Portamento, paramPortamento.Value); var bendRange = (string)ParameterValues.GetStringValue(ParameterNames.TimbreParameterName.BendRange, timbre.GetParam(ParameterNames.TimbreParameterName.BendRange).Value); writer.Write( $"|{index + 1,2} |{timbreId,-10}|{name,-24}|{category,-24}|{subCategory,-24}|{volume,3}|{status,-3}|{muteString,-4}|{priorityString,-4}|{midiChannelString,-4}|"); // ReSharper disable RedundantStringFormatCall writer.WriteLine( $"{bottomKey,-4}~{topKey,-4}|{bottomVelocity,3}~{topVelocity,3}|{oscMode,-4}|{oscSelect,-4}|{transpose,3}|{detune,5}|{portamento,3}|{bendRange,-3} |"); }
private void frmRDctoTrabajador_Load(object sender, EventArgs e) { try { ExcelFormatOptions objExcel = new ExcelFormatOptions(); string fechaInicio = ""; string fechaFin = ""; int idTrabajador = 0; string estado = frmReporteDctoTrabajador.f1.cbEstado.Text; if (frmReporteDctoTrabajador.f1.cbTrabajador.Checked == true) { idTrabajador = Convert.ToInt32(frmReporteDctoTrabajador.f1.cbEmpleado.SelectedValue); } else if (frmReporteDctoTrabajador.f1.cbTrabajador.Checked == false) { idTrabajador = 0; } fechaInicio = frmReporteDctoTrabajador.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd" + " 00:00:00"); fechaFin = frmReporteDctoTrabajador.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd" + " 23:59:59"); //int idProducto = Convert.ToInt32(frmReporteVentasProducto.f1.cbProducto.SelectedValue); ReportDocument repdoc = new ReportDocument(); // repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RVentaProducto.rpt"); repdoc.Load(@"D:\Reportes\RDescuentoTrabajador.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToDateTime(fechaInicio); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaInicio"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = Convert.ToDateTime(fechaFin); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaFin"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = idTrabajador; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@idTrabajador"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = estado; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@estado"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "BD_RESTAURANTE"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); objExcel.ExcelUseConstantColumnWidth = false; } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
//Generar pdf private void GenerarReporte(int agencia, DateTime fecha, string responsable) { ExportOptions exportOpts = new ExportOptions(); DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions PDFFormatOpts = new PdfRtfWordFormatOptions(); ExcelFormatOptions EXCFormatOpts = new ExcelFormatOptions(); TableLogOnInfo InfoConexBd; Ver.Visible = false; //FormulaFieldDefinitions crFormulas; try { string nomuser = ConfigurationManager.AppSettings["UID"]; string password = ConfigurationManager.AppSettings["PWD"]; AMS.CriptoServiceProvider.Crypto miCripto = new Crypto(AMS.CriptoServiceProvider.Crypto.CryptoProvider.TripleDES); miCripto.IV = ConfigurationManager.AppSettings["VectorInicialEncriptacion"]; miCripto.Key = ConfigurationManager.AppSettings["ValorConcatClavePrivada"]; string passw = miCripto.DescifrarCadena(password); ReportDocument oRpt = new ReportDocument(); string NombreReporte = ConfigurationManager.AppSettings["PathToReportsSource"] + "AMS.Comercial.ReporteAgenciaTaquillero.rpt"; oRpt.Load(NombreReporte); /*for(int i=0;i<oRpt.DataDefinition.ParameterFields.Count;i++) * { * string nombreReportePadre=oRpt.DataDefinition.ParameterFields[i].ReportName; * if(nombreReportePadre=="") * lblError.Text+=oRpt.DataDefinition.ParameterFields[i].Name+"<BR>"; * }*/ string tem = ""; foreach (CrystalDecisions.CrystalReports.Engine.Table tabla1 in oRpt.Database.Tables) { tem = tabla1.Name.ToString(); InfoConexBd = tabla1.LogOnInfo; InfoConexBd.ConnectionInfo.UserID = nomuser; InfoConexBd.ConnectionInfo.Password = passw; InfoConexBd.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["DataBase"]; tabla1.ApplyLogOnInfo(InfoConexBd); } try { ParameterDiscreteValue paramAgencia = new ParameterDiscreteValue(); ParameterDiscreteValue paramFecha = new ParameterDiscreteValue(); ParameterDiscreteValue paramResponsable = new ParameterDiscreteValue(); ParameterValues currentAgencia = new ParameterValues(); ParameterValues currentFecha = new ParameterValues(); ParameterValues currentResponsable = new ParameterValues(); paramAgencia.Value = agencia; paramFecha.Value = fecha; paramResponsable.Value = responsable; currentAgencia.Add(paramAgencia); currentFecha.Add(paramFecha); currentResponsable.Add(paramResponsable); oRpt.DataDefinition.ParameterFields["CODIGO_AGENCIA"].ApplyCurrentValues(currentAgencia); oRpt.DataDefinition.ParameterFields["FECHA"].ApplyCurrentValues(currentFecha); oRpt.DataDefinition.ParameterFields["NIT"].ApplyCurrentValues(currentResponsable); } catch (Exception e) { lblError.Text += e.Message; } exportOpts = oRpt.ExportOptions; exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat; //exportOpts.ExportFormatType = ExportFormatType.ExcelRecord; exportOpts.FormatOptions = PDFFormatOpts; //exportOpts.FormatOptions = EXCFormatOpts; exportOpts.ExportDestinationType = ExportDestinationType.DiskFile; diskOpts.DiskFileName = ConfigurationManager.AppSettings["PathToReports"] + "ReporteDiarioAgencia" + agencia + "_" + fecha.ToString("yyyy-MM-dd") + ".pdf"; //diskOpts.DiskFileName = ConfigurationManager.AppSettings["PathToReports"] + "ReporteDiarioAgencia"+agencia+"_"+fecha.ToString("yyyy-MM-dd")+ ".xls"; exportOpts.DestinationOptions = diskOpts; oRpt.Export(); Ver.NavigateUrl = ConfigurationManager.AppSettings["PathToPreviews"] + "ReporteDiarioAgencia" + agencia + "_" + fecha.ToString("yyyy-MM-dd") + ".pdf"; //Ver.NavigateUrl=ConfigurationManager.AppSettings["PathToPreviews"]+"ReporteDiarioAgencia"+agencia+"_"+fecha.ToString("yyyy-MM-dd")+ ".xls"; Ver.Visible = true; } catch (Exception ex) { lblError.Text += ex.Message; } }
public override Expression VisitSqlFunction(SqlFunctionExpression sqlFunctionExpression) { switch (sqlFunctionExpression.FunctionName) { case "EXTRACT": { Sql.Append(sqlFunctionExpression.FunctionName); Sql.Append("("); Visit(sqlFunctionExpression.Arguments[0]); Sql.Append(" FROM "); Visit(sqlFunctionExpression.Arguments[1]); Sql.Append(")"); return(sqlFunctionExpression); } case "CAST": { Sql.Append(sqlFunctionExpression.FunctionName); Sql.Append("("); Visit(sqlFunctionExpression.Arguments[0]); Sql.Append(" AS "); Visit(sqlFunctionExpression.Arguments[1]); Sql.Append(")"); return(sqlFunctionExpression); } case "AVG" when sqlFunctionExpression.Type == typeof(decimal): case "SUM" when sqlFunctionExpression.Type == typeof(decimal): { Sql.Append("CAST("); base.VisitSqlFunction(sqlFunctionExpression); Sql.Append(" AS DECIMAL(29,4))"); return(sqlFunctionExpression); } case "INSTR": { if (sqlFunctionExpression.Arguments[1] is ParameterExpression parameterExpression && ParameterValues.TryGetValue(parameterExpression.Name, out var value) && (string)value == string.Empty) { return(Visit(Expression.Constant(1))); } break; } case "ADD_MONTHS": { Sql.Append("CAST("); base.VisitSqlFunction(sqlFunctionExpression); Sql.Append(" AS TIMESTAMP)"); return(sqlFunctionExpression); } } return(base.VisitSqlFunction(sqlFunctionExpression)); }
public override string ToString() => Function.Name.ToString() + (ParameterValues.Length == 0 ? "" : "(" + string.Join(", ", ParameterValues.Select(v => v.ToString())) + ")");
public void GenerateReport(string parameter) { string _Report = string.Empty; if (_reportType == "Normal") { _Report = _reportName_Outside; } else if (_reportType == "Replacement") { _Report = _reportName_Outside_Replacement; } else { _Report = _reportName_Outside_Sample; } ReportDocument objReport1 = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo ConInfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); if (File.Exists(_path + _Report)) { objReport1.Load(_path + _Report); } else { objReport1.Load(ClsConfig.LotCardCantierReportPath_Trial + _Report); } crParameterDiscreteValue.Value = parameter; crParameterFieldDefinitions = objReport1.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@LotCardGroupNo"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); string sUserID = ClsConfig.ReportUser; string sPassword = ClsConfig.ReportPassword; string sServerName = ClsConfig.ReportServer; string sDatabaseName = ClsConfig.ReportDatabase_LotCard; crConnectionInfo.ServerName = sServerName; crConnectionInfo.DatabaseName = sDatabaseName; crConnectionInfo.UserID = sUserID; crConnectionInfo.Password = sPassword; CrTables = objReport1.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { ConInfo = CrTable.LogOnInfo; ConInfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(ConInfo); } docA = objReport1; reportViewer.ViewerCore.ReportSource = docA; }
private ReportDocument SetReport_JP() { //ReportDocument rptDoc = new ReportDocument(); ReportDocument rptDoc = null; ParameterValues pvFromDate = new ParameterValues(); ParameterValues pvToDate = new ParameterValues(); ParameterValues pvMonth = new ParameterValues(); ParameterValues pvYear = new ParameterValues(); ParameterValues pvUserName = new ParameterValues(); ParameterValues pvPicURL = new ParameterValues(); ParameterDiscreteValue pdvFromDate = new ParameterDiscreteValue(); ParameterDiscreteValue pdvToDate = new ParameterDiscreteValue(); ParameterDiscreteValue pdvMonth = new ParameterDiscreteValue(); ParameterDiscreteValue pdvYear = new ParameterDiscreteValue(); ParameterDiscreteValue pdvUserName = new ParameterDiscreteValue(); ParameterDiscreteValue pdvPicURL = new ParameterDiscreteValue(); ParameterValues pvDepartmentID = new ParameterValues(); ParameterDiscreteValue pdvDepartmentID = new ParameterDiscreteValue(); if (optGlobal.Checked) { pdvDepartmentID.Value = 1;//mac dinh ban dau chon ca cong ty } else { pdvDepartmentID.Value = cboDepartment.SelectedValue; } pdvUserName.Value = WorkingContext.Username; pvUserName.Add(pdvUserName); switch (lstGroupReport.SelectedIndex) { #region báo cáo nhân sự case 0: switch (lstDetailReport.SelectedIndex) { case 0:// Báo cáo danh sách nhân viên //rptDoc = new Reports_JP.EmployeeDepartment(); //rptDoc.Load(@"Reports_JP\EmployeeDepartment.rpt"); rptDoc = new Reports_JP.EmployeeDepartment(); reportName = "EmployeeDepartment"; break; case 1:// Thông tin chi tiết nhân viên dtpFromDate.Enabled = false; dtpToDate.Enabled = false; //rptDoc.Load(@"Reports_JP\AllEmployeeInfo.rpt"); rptDoc = new Reports_JP.AllEmployeeInfo(); // pdvUserName.Value = WorkingContext.Username; // pvUserName.Add(pdvUserName); pdvPicURL.Value = WorkingContext.Setting.PicturePath; pvPicURL.Add(pdvPicURL); //MessageBox.Show(pdvPicURL.Value.ToString()); pvDepartmentID.Add(pdvDepartmentID); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["PicURL"].ApplyCurrentValues(pvPicURL); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "AllEmployeeInfo"; break; case 2:// Danh sách nhân viên nghỉ try { // Load the report //rptDoc.Load(@"Reports_JP\RestEmployee.rpt"); rptDoc = new Reports_JP.RestEmployee(); // Set the connection information for all the tables used in the report // Set the discreet value to the customers name. pdvFromDate.Value = dtpFromDate.Value.ToShortDateString(); pdvToDate.Value = dtpToDate.Value.ToShortDateString(); // pdvDepartmentID.Value = cboDepartment.SelectedValue; // Add it to the parameter collection. pvFromDate.Add(pdvFromDate); pvToDate.Add(pdvToDate); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@dtpFrom"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@dtpTo"].ApplyCurrentValues(pvToDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); reportName = "RestEmployee"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // MessageBox.Show("OK"); break; case 3:// Bảng theo dõi cơm trưa try { rptDoc = new Reports_JP.LunchSheet(); pdvMonth.Value = dtpFromDate.Value.Month; pdvYear.Value = dtpFromDate.Value.Year; pvMonth.Add(pdvMonth); pvYear.Add(pdvYear); pvDepartmentID.Add(pdvDepartmentID); rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvMonth); rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); reportName = "LunchSheet"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 4:// Danh sách làm thêm giờ try { rptDoc = new Reports_JP.RegOverTime(); pdvFromDate.Value = dtpFromDate.Value.ToShortDateString(); pvFromDate.Add(pdvFromDate); pvDepartmentID.Add(pdvDepartmentID); rptDoc.DataDefinition.ParameterFields["@WorkingDay"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "RegOverTime"; reportDate = dtpFromDate.Value; } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // break; case 5://Danh sách nhân viên đi công tác try { rptDoc = new Reports_JP.LeaveSchedule(); // Set the connection information for all the tables used in the report // Set the discreet value to the customers name. pdvFromDate.Value = dtpFromDate.Value.ToShortDateString(); pdvToDate.Value = dtpToDate.Value.ToShortDateString(); // Add it to the parameter collection. pvFromDate.Add(pdvFromDate); pvToDate.Add(pdvToDate); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@dtpFrom"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@dtpEnd"].ApplyCurrentValues(pvToDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); reportName = "LeaveSchedule"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 6:// Theo dõi thay đổi phòng ban //rptDoc.Load(@"Reports_JP\DepartmentHistory.rpt"); rptDoc = new Reports_JP.DepartmentHistory(); pvDepartmentID.Add(pdvDepartmentID); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "DepartmentHistory"; break; case 7:// Theo dõi thay đổi chức vụ rptDoc = new Reports_JP.PositionHistory(); pvDepartmentID.Add(pdvDepartmentID); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "PositionHistory"; break; case 8:// Theo dõi diễn biến lương nhân viên; rptDoc = new Reports_JP.SalaryHistory(); pvDepartmentID.Add(pdvDepartmentID); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); // pvUserName.Add(pdvUserName); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "SalaryHistory"; break; case 9://Thanh toán tiền phép theo phòng ban try { rptDoc = new Reports_JP.RestSheet(); pvDepartmentID.Add(pdvDepartmentID); pdvYear.Value = dtpFromDate.Value.Year; pvYear.Add(pdvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "RestSheet"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 10:// Danh sách suất ăn làm thêm try { //rptDoc.Load(@"Reports_JP\LunchOverTime.rpt"); rptDoc = new Reports_JP.LunchOverTime(); pdvFromDate.Value = dtpFromDate.Value.ToShortDateString(); pvFromDate.Add(pdvFromDate); pvDepartmentID.Add(pdvDepartmentID); // pdvUserName.Value = WorkingContext.Username; // pvUserName.Add(pdvUserName); rptDoc.DataDefinition.ParameterFields["@WorkingDay"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "LunchOverTime"; reportDate = dtpFromDate.Value; } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // break; case 11:// Danh sách suất ăn làm thêm theo thang try { // Load the report //rptDoc.Load(@"Reports_JP/LunchOverTimeInMonth.rpt"); rptDoc = new Reports_JP.LunchOverTimeInMonth(); // Set the discreet value to the customers name. pdvMonth.Value = dtpFromDate.Value.Month; pdvYear.Value = dtpFromDate.Value.Year; // Add it to the parameter collection. pvMonth.Add(pdvMonth); pvYear.Add(pdvYear); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvMonth); rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); reportName = "LunchOverTimeInMonth"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 12:// Danh sách nhân viên được thưởng try { // Load the report //rptDoc.Load(@"Reports\PunishEmployee.rpt"); rptDoc = new Reports.AverageEmployee(); // Set the connection information for all the tables used in the report // Set the discreet value to the customers name. pdvFromDate.Value = dtpFromDate.Value.ToShortDateString(); //pdvToDate.Value = dtpToDate.Value.ToShortDateString(); // pdvDepartmentID.Value = cboDepartment.SelectedValue; // Add it to the parameter collection. pvFromDate.Add(pdvFromDate); //pvToDate.Add(pdvToDate); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@dtpFromDate"].ApplyCurrentValues(pvFromDate); //rptDoc.DataDefinition.ParameterFields["@dtpToDate"].ApplyCurrentValues(pvToDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); reportName = "AverageEmployee"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // MessageBox.Show("OK"); break; } break; #endregion #region báo cáo chấm công case 1: switch (lstDetailReport.SelectedIndex) { case 0:// Báo cáo chấm công chi tiết ngày try { // Load the report //rptDoc.Load(@"Reports_JP\DetailAttendance.rpt"); rptDoc = new Reports_JP.DetailAttendance(); // Set the connection information for all the tables used in the report // Set the discreet value to the customers name. pdvFromDate.Value = dtpFromDate.Value.ToShortDateString(); pdvToDate.Value = dtpToDate.Value.ToShortDateString(); // Add it to the parameter collection. pvFromDate.Add(pdvFromDate); pvToDate.Add(pdvToDate); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@FromDate"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@ToDate"].ApplyCurrentValues(pvToDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "DetailAttendance"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 1:// báo cáo chấm công tháng try { // Load the report //rptDoc.Load(@"Reports_JP\TimeSheet.rpt"); rptDoc = new Reports_JP.TimeSheet(); // Set the discreet value to the customers name. pdvMonth.Value = dtpFromDate.Value.Month; pdvYear.Value = dtpFromDate.Value.Year; // pdvUserName.Value = WorkingContext.Username; // pvUserName.Add(pdvUserName); // Add it to the parameter collection. pvMonth.Add(pdvMonth); pvYear.Add(pdvYear); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvMonth); rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "TimeSheet"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 2:// Danh sách nhân viên không quẹt thẻ try { //rptDoc.Load(@"Reports_JP\InvalidStrike.rpt"); rptDoc = new Reports_JP.InvalidStrike(); pdvFromDate.Value = dtpFromDate.Value.ToShortDateString(); pvFromDate.Add(pdvFromDate); pvDepartmentID.Add(pdvDepartmentID); rptDoc.DataDefinition.ParameterFields["@WorkingDay"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "InvalidStrike"; reportDate = dtpFromDate.Value; } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // break; case 3:// Tổng hợp nhân viên trong ngày try { //rptDoc.Load(@"Reports_JP\EmployeeSummary.rpt"); rptDoc = new Reports_JP.EmployeeSummary(); pdvFromDate.Value = dtpFromDate.Value.ToShortDateString(); pvFromDate.Add(pdvFromDate); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); rptDoc.DataDefinition.ParameterFields["@Date"].ApplyCurrentValues(pvFromDate); reportName = "EmployeeSummary"; reportDate = dtpFromDate.Value; } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // break; case 4:// báo cáo tổng hợp dữ liệu của một nhân viên trong tháng try { // Load the report //rptDoc.Load(@"Reports_JP\EmployeeSummaryInMonth.rpt"); rptDoc = new Reports_JP.EmployeeSummaryInMonth(); // Set the discreet value to the customers name. pdvMonth.Value = dtpFromDate.Value.Month; pdvYear.Value = dtpFromDate.Value.Year; // pdvUserName.Value = WorkingContext.Username; // pvUserName.Add(pdvUserName); // Add it to the parameter collection. pvMonth.Add(pdvMonth); pvYear.Add(pdvYear); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvMonth); rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "EmployeeSummaryInMonth"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 5:// báo cáo tổng hợp dữ liệu của nhân viên trong một năm try { // Load the report //rptDoc.Load(@"Reports_JP\EmployeeSummaryInYear.rpt"); rptDoc = new Reports_JP.EmployeeSummaryInYear(); // Set the discreet value to the customers name. pdvYear.Value = dtpFromDate.Value.Year; pvMonth.Add(pdvMonth); pvYear.Add(pdvYear); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "EmployeeSummaryInYear"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 6:// báo cáo chi tiết của từng nhân viên trong tháng try { // Load the report //rptDoc.Load(@"Reports_JP\AttendanceRecord.rpt"); rptDoc = new Reports_JP.AttendanceRecord(); // Set the discreet value to the customers name. pdvFromDate.Value = dtpFromDate.Value; pvFromDate.Add(pdvFromDate); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "AttendanceRecord"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 7:// Danh sách nhân viên không quẹt thẻ try { //rptDoc.Load(@"Reports\InvalidStrike.rpt"); rptDoc = new Reports.InvalidStrikeYesterday(); //rptDoc = new Reports.InvalidStrikeYesterday(); pdvFromDate.Value = dtpFromDate.Value.ToShortDateString(); pvFromDate.Add(pdvFromDate); pvDepartmentID.Add(pdvDepartmentID); rptDoc.DataDefinition.ParameterFields["@WorkingDay"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "InvalidStrikeYesterday"; reportDate = dtpFromDate.Value; } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // break; case 8://Bảng thanh toán lương tổng hợp theo phòng ban try { // Load the report //rptDoc.Load(@"Reports\SalarySummary.rpt"); rptDoc = new Reports.TimeSheetSummary(); // Set the discreet value to the customers name. pdvMonth.Value = dtpFromDate.Value.Month; pdvYear.Value = dtpFromDate.Value.Year; // Add it to the parameter collection. pvMonth.Add(pdvMonth); pvYear.Add(pdvYear); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvMonth); rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "Bao cao cham cong theo phong ban"; reportDate = dtpFromDate.Value; } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // break; } break; #endregion #region báo cáo lương case 2: switch (lstDetailReport.SelectedIndex) { case 0://Bảng thanh toán lương tổng hợp try { // Load the report //rptDoc.Load(@"Reports_JP\SalarySheet.rpt"); rptDoc = new Reports_JP.SalarySheet(); // Set the discreet value to the customers name. pdvMonth.Value = dtpFromDate.Value.Month; pdvYear.Value = dtpFromDate.Value.Year; pvMonth.Add(pdvMonth); pvYear.Add(pdvYear); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvMonth); rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "SalarySheet"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 1://Bảng thanh toán lương chi tiết nhân viên try { // Load the report //rptDoc.Load(@"Reports_JP\DetailSalary.rpt"); rptDoc = new Reports_JP.DetailSalary(); // Set the discreet value to the customers name. pdvMonth.Value = dtpFromDate.Value.Month; pdvYear.Value = dtpFromDate.Value.Year; // pdvUserName.Value = WorkingContext.Username; // pvUserName.Add(pdvUserName); // Add it to the parameter collection. pvMonth.Add(pdvMonth); pvYear.Add(pdvYear); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvMonth); rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "DetailSalary"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 2://Bảng tóm tắt lương nhân viên=> in lên phong bì try { // Load the report //rptDoc.Load(@"Reports_JP\BriefSalary.rpt"); rptDoc = new Reports_JP.BriefSalary(); // Set the discreet value to the customers name. pdvMonth.Value = dtpFromDate.Value.Month; pdvYear.Value = dtpFromDate.Value.Year; // Add it to the parameter collection. pvMonth.Add(pdvMonth); pvYear.Add(pdvYear); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvMonth); rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); reportName = "BriefSalary"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 3://Bảng thanh toán lương tổng hợp theo phòng ban try { // Load the report //rptDoc.Load(@"Reports_JP\SalarySummary.rpt"); rptDoc = new Reports_JP.SalarySummary(); // Set the discreet value to the customers name. pdvMonth.Value = dtpFromDate.Value.Month; pdvYear.Value = dtpFromDate.Value.Year; // Add it to the parameter collection. pvMonth.Add(pdvMonth); pvYear.Add(pdvYear); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvMonth); rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "SalarySummary"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; case 4://Bảng lương chi tiết từng nhân viên try { // Load the report //rptDoc.Load(@"Reports_JP\SalaryPerEmployee.rpt"); rptDoc = new Reports_JP.SalaryPerEmployee(); // Set the discreet value to the customers name. pdvMonth.Value = dtpFromDate.Value.Month; pdvYear.Value = dtpFromDate.Value.Year; // pdvUserName.Value = WorkingContext.Username; // pvUserName.Add(pdvUserName); // Add it to the parameter collection. pvMonth.Add(pdvMonth); pvYear.Add(pdvYear); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvMonth); rptDoc.DataDefinition.ParameterFields["@Year"].ApplyCurrentValues(pvYear); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "SalaryPerEmployee"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } break; } break; #endregion #region báo cáo thưởng phạt case 3: switch (lstDetailReport.SelectedIndex) { case 0:// Danh sách nhân viên được thưởng try { // Load the report //rptDoc.Load(@"Reports_JP\PunishEmployee.rpt"); rptDoc = new Reports_JP.PunishEmployee(); // Set the connection information for all the tables used in the report // Set the discreet value to the customers name. pdvFromDate.Value = dtpFromDate.Value.ToShortDateString(); pdvToDate.Value = dtpToDate.Value.ToShortDateString(); // pdvDepartmentID.Value = cboDepartment.SelectedValue; // Add it to the parameter collection. pvFromDate.Add(pdvFromDate); pvToDate.Add(pdvToDate); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@dtpFromDate"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@dtpToDate"].ApplyCurrentValues(pvToDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); reportName = "PunishEmployee"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // MessageBox.Show("OK"); break; } break; #endregion #region Bảo hiểm Xã hội case 4: switch (lstDetailReport.SelectedIndex) { case 0:// Danh sách nhân viên đóng BHXH theo tháng try { // Load the report //rptDoc.Load(@"Reports_JP\SocialInsurance.rpt"); rptDoc = new Reports_JP.SocialInsurance(); // Set the connection information for all the tables used in the report // Set the discreet value to the customers name. // pdvFromDate.Value = dtpFromDate.Value.ToShortDateString(); // pdvDepartmentID.Value = cboDepartment.SelectedValue; // // Add it to the parameter collection. // pvFromDate.Add(pdvFromDate); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. // rptDoc.DataDefinition.ParameterFields["@dtpFromDate"].ApplyCurrentValues(pvFromDate); // rptDoc.DataDefinition.ParameterFields["@dtpToDate"].ApplyCurrentValues(pvToDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); reportName = "SocialInsurance"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // MessageBox.Show("OK"); break; case 1:// Danh sách nhân viên điều chỉnh BHXH try { // Load the report //rptDoc.Load(@"Reports_JP\SocialInsuranceAdjust.rpt"); rptDoc = new Reports_JP.SocialInsuranceAdjust(); // Set the connection information for all the tables used in the report // Set the discreet value to the customers name. pdvFromDate.Value = dtpFromDate.Value; // pdvToDate.Value = dtpToDate.Value.ToShortDateString(); // pdvDepartmentID.Value = cboDepartment.SelectedValue; // Add it to the parameter collection. pvFromDate.Add(pdvFromDate); // pvToDate.Add(pdvToDate); // pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); // rptDoc.DataDefinition.ParameterFields["@dtpToDate"].ApplyCurrentValues(pvToDate); // rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); optLocal.Enabled = false; reportName = "SocialInsuranceAdjust"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // MessageBox.Show("OK"); break; case 2:// Danh sách lao động và quỹ tiền lương trích nộp BHXH try { optLocal.Enabled = false; // Load the report //rptDoc.Load(@"Reports\BHXH\InsuranceC45.rpt"); rptDoc = new Reports.BHXH.InsuranceC45(); // Set the connection information for all the tables used in the report // Set the discreet value to the customers name. pdvFromDate.Value = dtpFromDate.Value; // pdvToDate.Value = dtpToDate.Value.ToShortDateString(); // pdvDepartmentID.Value = cboDepartment.SelectedValue; // Add it to the parameter collection. pvFromDate.Add(pdvFromDate); // pvToDate.Add(pdvToDate); // pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Date"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); // rptDoc.DataDefinition.ParameterFields["@dtpToDate"].ApplyCurrentValues(pvToDate); // rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); reportName = "InsuranceC45"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // MessageBox.Show("OK"); break; case 3:// Xác nhận người lao động nghỉ việc trông con ốm try { optLocal.Enabled = true; // Load the report //rptDoc.Load(@"Reports\BHXH\RestLookChildEmployee.rpt"); rptDoc = new Reports.BHXH.RestLookChildEmployee(); // Set the connection information for all the tables used in the report // Set the discreet value to the customers name. pdvFromDate.Value = dtpFromDate.Value; // pdvToDate.Value = dtpToDate.Value.ToShortDateString(); //pdvDepartmentID.Value = cboDepartment.SelectedValue; // Add it to the parameter collection. pvFromDate.Add(pdvFromDate); // pvToDate.Add(pdvToDate); pvDepartmentID.Add(pdvDepartmentID); // Apply the current parameter values. rptDoc.DataDefinition.ParameterFields["@Date"].ApplyCurrentValues(pvFromDate); rptDoc.DataDefinition.ParameterFields["@UserName"].ApplyCurrentValues(pvUserName); // rptDoc.DataDefinition.ParameterFields["@dtpToDate"].ApplyCurrentValues(pvToDate); rptDoc.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvDepartmentID); reportName = "RestLookChildEmployee"; reportDate = dtpFromDate.Value; } catch (LoadSaveReportException Exp) { //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); string str = WorkingContext.LangManager.GetString("frmListReport_Error_Messa1"); string str1 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa2"); //MessageBox.Show("Không tìm thấy đường dẫn của file báo cáo..", "Lỗi đọc file báo cáo."); MessageBox.Show(str, str1); } catch (Exception Exp) { //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); string str2 = WorkingContext.LangManager.GetString("frmListReport_Error_Messa3"); //MessageBox.Show(Exp.Message, "Có lỗi xảy ra"); MessageBox.Show(Exp.Message, str2); } // MessageBox.Show("OK"); break; } break; #endregion } if (rptDoc != null) { SetDBLogonForReport(rptDoc); } return rptDoc; }
protected void ConnectLeftoversToParameters(ModelOutput mf, ParameterValues parameters) { var parametersToFindValueFor = from component in Components from parameter in component.Parameters where parameter.Binding is ParameterValueFile select new { ComponentName = component.Name, ParameterName = parameter.Name, DimensionTypes = parameter.DimensionTypes, DataType = parameter.DataType, DefaultValue = parameter.Binding.DefaultValue, paer = parameter }; var parametersWithManualValues = from component in Components from parameter in component.Parameters where parameter.Binding is ParameterValueManualConstant select new { ComponentName = component.Name, ParameterName = parameter.Name, DimensionTypes = parameter.DimensionTypes, DataType = parameter.DataType, Value = ((ParameterValueManualConstant)parameter.Binding).Value, paer = parameter }; var parametersWithLambdas = from component in Components from parameter in component.Parameters where parameter.Binding is ParameterValueManuelLambda select new { ComponentName = component.Name, ParameterName = parameter.Name, DimensionTypes = parameter.DimensionTypes, DataType = parameter.DataType, Value = ((ParameterValueManuelLambda)parameter.Binding).Lambda, paer = parameter }; var parametersInFileThatAreNotBound = from p in parameters let pName = p.Name.ToLowerInvariant() where !parametersToFindValueFor.Any(i => pName == i.ParameterName.ToLowerInvariant()) && pName != "region" select p.Name; foreach (var p in parametersWithManualValues) { mf.AddNonDimensionalVariable(p.ComponentName, p.ParameterName, p.Value); } foreach (var p in parametersWithLambdas) { if (p.Value.GetType().GetGenericTypeDefinition() == typeof(Func <, ,>)) { var types = p.Value.GetType().GetGenericArguments(); var method = mf.GetType().GetMethod("Add2DimensionalParameterLambda").MakeGenericMethod(types); method.Invoke(mf, new object[] { p.ComponentName, p.ParameterName, p.Value }); } else { throw new NotImplementedException(); } } foreach (var p in parametersToFindValueFor) { if (parameters.Contains(p.ParameterName)) { mf.LoadVariableFromParameter(p.ComponentName, p.ParameterName, parameters, p.DataType, p.DimensionTypes.ToArray()); } else if (p.DefaultValue != null) { mf.AddNonDimensionalVariable(p.ComponentName, p.ParameterName, p.DefaultValue); } else { throw new InvalidOperationException(); } } }
private void btnInPhieu_Click_1(object sender, EventArgs e) { expandableSplitter1.Expanded = true; btnInPhieu.Visible = false; btnTroLai.Visible = true; PhieuThu rp = new PhieuThu(); ParameterValues a = new ParameterValues(); ParameterDiscreteValue b = new ParameterDiscreteValue(); b.Value = txtHoBenhNhan.Text; a.Add(b); rp.DataDefinition.ParameterFields["HoBenhNhan"].ApplyCurrentValues(a); b.Value = txtTenBenhNhan.Text; a.Add(b); rp.DataDefinition.ParameterFields["TenBenhNhan"].ApplyCurrentValues(a); b.Value = dtPicker_NgaySinh.Text; a.Add(b); rp.DataDefinition.ParameterFields["NgaySinh"].ApplyCurrentValues(a); b.Value = txtNgheNghiep.Text; a.Add(b); rp.DataDefinition.ParameterFields["NgheNghiep"].ApplyCurrentValues(a); b.Value = txtDiaChi.Text; a.Add(b); rp.DataDefinition.ParameterFields["DiaChi"].ApplyCurrentValues(a); b.Value = txtTenDichVu.Text; a.Add(b); rp.DataDefinition.ParameterFields["TenDichVu"].ApplyCurrentValues(a); b.Value = txtDonGia.Text; a.Add(b); rp.DataDefinition.ParameterFields["DonGia"].ApplyCurrentValues(a); b.Value = txtMaPhieuThu.Text; a.Add(b); rp.DataDefinition.ParameterFields["MaPhieuThu"].ApplyCurrentValues(a); b.Value = txtHoNhanVien.Text; a.Add(b); rp.DataDefinition.ParameterFields["HoNhanVien"].ApplyCurrentValues(a); b.Value = txtTenNhanVien.Text; a.Add(b); rp.DataDefinition.ParameterFields["TenNhanVien"].ApplyCurrentValues(a); string tongtien = txtDonGia.Text.ToString(); long tien = long.Parse(tongtien); So_chu(tien); b.Value = So_chu(tien).ToString(); a.Add(b); rp.DataDefinition.ParameterFields["TongTien"].ApplyCurrentValues(a); crystalReportViewer1.ReportSource = rp; }
private void addPercentileValues(ParameterValues parameterValues, double[] allPercentiles) { parameterValues.Percentiles = new List <double>(allPercentiles); }
protected void Page_Load(object sender, EventArgs e) { try { isNavigated = false; string UserId = EventFunctions.Functions.GetSessionUserId(); if (UserId == "") { return; } HideWindow(); string sCmd = ("" + Request.QueryString["cmd"]).ToString(); if ((Request.QueryString["ReportName"] != null) && (Request.QueryString["DataSource"] != null) && sCmd != "finished") { //BL.Report repObj = new BL.Report(); string _reportname = null; DataTable _datasource = null; string _reportselectionformula = null; bool _grouptree = false; string _reporttitle = null; string _printType = null; DataTable[] _dt = new DataTable[10]; _reportname = Request.QueryString["ReportName"]; if (Request.QueryString["ReportSelectionFormula"] != null) { _reportselectionformula = Request.QueryString["ReportSelectionFormula"]; _reportselectionformula = _reportselectionformula.Replace("~", "'"); } _grouptree = Convert.ToBoolean(Request.QueryString["GroupTree"]); _reporttitle = Request.QueryString["ReportTitle"]; _printType = Request.QueryString["PrintType"]; /*repObj.DateParameter1 = Request.QueryString["DateParameter1"]; * repObj.DateParameter2 = Request.QueryString["DateParameter2"]; * repObj.DateParameter3 = Request.QueryString["DateParameter3"]; * repObj.DateParameter4 = Request.QueryString["DateParameter4"]; * repObj.DecimalParameter1 = Request.QueryString["DecimalParameter1"]; * repObj.DecimalParameter2 = Request.QueryString["DecimalParameter2"]; * repObj.StringParameter1 = "" + Request.QueryString["sP1"]; * repObj.StringParameter2 = "" + Request.QueryString["sP2"]; * repObj.StringParameter3 = "" + Request.QueryString["sP3"]; * repObj.StringParameter4 = "" + Request.QueryString["sP4"]; * repObj.StringParameter5 = "" + Request.QueryString["sP5"]; * repObj.StringParameter6 = "" + Request.QueryString["sP6"]; * repObj.BoolParameter1 = Request.QueryString["BoolParameter1"]; * repObj.BoolParameter2 = Request.QueryString["BoolParameter2"]; * if (("" + Request.QueryString["StringArray"]).ToString().Trim() != "") * repObj.StringArray = Request.QueryString["StringArray"].Trim().Split(','); * int iSubRptCnt = System.Common.Functions.ToInt(Request.QueryString["SubReports"]); * if (iSubRptCnt > 0) * _dt = repObj.LoadReportDatasourceArray(Request.QueryString["DataSource"]); * else * _datasource = repObj.LoadReportDatasource(Request.QueryString["DataSource"]);*/ int SalesId = Functions.ToInt(Request.QueryString["SalesId"]); int iSubRptCnt = 0; ParameterValues myparameterValues = new ParameterValues(); ParameterDiscreteValue myparamDiscreteValue = new ParameterDiscreteValue(); DBConnection DBConn = new DBConnection(); switch (_reportname) { case "Receipt": string sql = "select count(*) as cnt from ProductDetail P, SalesDetails S where P.SalesDetailId = S.SalesDetailId and status = 3 and S.SalesMasterId = " + SalesId; string returnCnt = DBConn.RetData(sql, CommandType.Text); _datasource = DBConn.ExecuteDataSet("SELECT SalesMaster.SalesMasterId SalesId,DATE_FORMAT(SalesDate,'%m/%d/%Y') SalesDate,CustomerName,DATE_FORMAT(SalesDate,'%h:%i %p') as `SalesTime`,concat(IFNULL((SELECT Name FROM ProductMaster WHERE ProductMaster.ProductId = SalesDetails.ProductId),''), IFNULL(SalesDetails.ProductName,''), IFNULL(concat(' (SD Order #: ',SDOrderNo,')'),'')) as Description,Count as Quantity,SalesAmount as Price,'' as PayType,0 as PayAmount, " + returnCnt + " as ReturnCount FROM SalesMaster,SalesDetails where SalesMaster.SalesMasterId = SalesDetails.SalesMasterId and SalesMaster.SalesMasterId= " + SalesId, CommandType.Text).Tables[0]; _reportname = "Receipt.rpt"; break; case "Sales": string sFrom = "" + Request.QueryString["fromd"]; string sTo = "" + Request.QueryString["tod"]; DateTime dt1; sql = "SELECT '0' as type, 0 as SRID, SalesMasterId ID, DATE_FORMAT(SalesDate,'%m/%d/%Y %h:%i %p') SalesDate, SalesDate sdt, PurchaseAmount as Amount, GrandTotal GT, (SELECT Name FROM LocationMaster WHERE LocationMaster.LocationId = SalesMaster.LocationId) as Location, (SELECT UserName FROM UserMaster WHERE UserMaster.UserId = SalesMaster.ClerkId) as Clerk, CustomerName, (SELECT SUM(COUNT) FROM SalesDetails WHERE SalesMasterId = SalesMaster.SalesMasterId) ticket, "; if (sFrom.Trim() != "" && sTo.Trim() != "") { sql += "'" + sFrom + "' sFrom,'" + sTo + "' sTo FROM SalesMaster where 1=1"; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and (SalesDate between '" + sFrom + " 00:00:01' and '" + sTo + " 23:59:59')"; } else if (sFrom.Trim() != "") { sql += "'" + sFrom + "' sFrom,'' sTo FROM SalesMaster where 1=1"; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); sql += " and SalesDate >= '" + sFrom + " 00:00:01'"; } else if (sTo.Trim() != "") { sql += "'' sFrom,'" + sTo + "' sTo FROM SalesMaster where 1=1"; dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and SalesDate <= '" + sTo + " 23:59:59'"; } else { sql += "'' sFrom,'' sTo FROM SalesMaster where 1=1"; } //sql += " order by sdt"; sql += " union SELECT '1' as type, SalesReturnMasterId SRID, (SELECT SalesMasterId from SalesDetails, SalesReturnDetails WHERE SalesDetails.SalesDetailId = SalesReturnDetails.SalesDetailId and SalesReturnDetails.SalesReturnMasterId = SalesReturnMaster.SalesReturnMasterId limit 1) as ID, DATE_FORMAT(SalesReturnDate,'%m/%d/%Y %h:%i %p') SalesDate, SalesReturnDate sdt, 0 as Amount, Amount GT, (SELECT Name FROM LocationMaster WHERE LocationMaster.LocationId = SalesReturnMaster.LocationId) as Location, (SELECT UserName FROM UserMaster WHERE UserMaster.UserId = SalesReturnMaster.ClerkId) as Clerk, '' as CustomerName, (SELECT SUM(Qty) FROM SalesReturnDetails WHERE SalesReturnMasterId = SalesReturnMaster.SalesReturnMasterId) ticket, "; if (sFrom.Trim() != "" && sTo.Trim() != "") { sql += "'" + sFrom + "' sFrom,'" + sTo + "' sTo FROM SalesReturnMaster where 1=1"; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and (SalesReturnDate between '" + sFrom + " 00:00:01' and '" + sTo + " 23:59:59')"; } else if (sFrom.Trim() != "") { sql += "'" + sFrom + "' sFrom,'' sTo FROM SalesReturnMaster where 1=1"; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); sql += " and SalesReturnDate >= '" + sFrom + " 00:00:01'"; } else if (sTo.Trim() != "") { sql += "'' sFrom,'" + sTo + "' sTo FROM SalesReturnMaster where 1=1"; dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and SalesReturnDate <= '" + sTo + " 23:59:59'"; } else { sql += "'' sFrom,'' sTo FROM SalesReturnMaster where 1=1"; } sql += " order by type, sdt"; _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; _reportname = "Sales.rpt"; break; case "SalesDetails": sFrom = "" + Request.QueryString["fromd"]; sTo = "" + Request.QueryString["tod"]; sql = @"SELECT '0' as type, 0 as SalesMasterId, SalesMaster.SalesMasterId SalesId,DATE_FORMAT(SalesDate,'%m/%d/%Y %h:%i %p') SalesDate,PurchaseAmount AS Amount, DATE_FORMAT(SalesDate,'%m/%d/%Y') SD,SalesDetails.SerialNo, (SELECT NAME FROM LocationMaster WHERE LocationMaster.LocationId = SalesMaster.LocationId) AS Location, (SELECT UserName FROM UserMaster WHERE UserMaster.UserId = SalesMaster.ClerkId) AS Clerk,CustomerName, concat(IFNULL((SELECT Name FROM ProductMaster WHERE ProductMaster.ProductId = SalesDetails.ProductId),''), IFNULL(SalesDetails.ProductName,'')) AS Description, COUNT AS Quantity,SalesAmount AS Price, (SELECT CASE WHEN PaymentType=1 THEN 'Cash' WHEN PaymentType=2 THEN 'Card' Else 'Vouher' END FROM PaymentDetails WHERE SalesMasterId = SalesMaster.SalesMasterId) paytype, (SELECT CardAuthorizationId FROM PaymentDetails WHERE SalesMasterId = SalesMaster.SalesMasterId) authcode,"; if (sFrom.Trim() != "" && sTo.Trim() != "") { sql += "'" + sFrom + "' sFrom,'" + sTo + "' sTo FROM SalesMaster,SalesDetails WHERE SalesMaster.SalesMasterId = SalesDetails.SalesMasterId "; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and (SalesMaster.SalesDate between '" + sFrom + " 00:00:01' and '" + sTo + " 23:59:59')"; } else if (sFrom.Trim() != "") { sql += "'" + sFrom + "' sFrom,'' sTo FROM SalesMaster,SalesDetails WHERE SalesMaster.SalesMasterId = SalesDetails.SalesMasterId"; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); sql += " and SalesMaster.SalesDate >= '" + sFrom + " 00:00:01'"; } else if (sTo.Trim() != "") { sql += "'' sFrom,'" + sTo + "' sTo FROM SalesMaster,SalesDetails WHERE SalesMaster.SalesMasterId = SalesDetails.SalesMasterId"; dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and SalesMaster.SalesDate <= '" + sTo + " 23:59:59'"; } else { sql += "'' sFrom,'' sTo FROM SalesMaster,SalesDetails WHERE SalesMaster.SalesMasterId = SalesDetails.SalesMasterId"; } //sql += " order by SalesMaster.SalesDate"; sql += @" union SELECT '1' as type, SalesReturnMaster.SalesReturnMasterId SalesMasterId, (select SalesMasterId from SalesDetails where SalesDetailId = SalesReturnDetails.SalesDetailId limit 1) as SalesId, DATE_FORMAT(SalesReturnDate,'%m/%d/%Y %h:%i %p') SalesDate, SalesReturnMaster.Amount AS Amount, DATE_FORMAT(SalesReturnDate,'%m/%d/%Y') SD, SalesReturnDetails.SerialNo, (SELECT NAME FROM LocationMaster WHERE LocationMaster.LocationId = SalesReturnMaster.LocationId) AS Location, (SELECT UserName FROM UserMaster WHERE UserMaster.UserId = SalesReturnMaster.ClerkId) AS Clerk, '' as CustomerName, (SELECT NAME FROM ProductMaster WHERE ProductMaster.ProductId = SalesReturnDetails.ProductId) AS Description, Qty AS Quantity, SalesReturnDetails.Amount AS Price, (SELECT CASE WHEN PaymentType=1 THEN 'Cash' WHEN PaymentType=2 THEN 'Card' Else 'Vouher' END FROM PaymentDetails WHERE SalesMasterId = SalesReturnMaster.SalesReturnMasterId) paytype, '' as authcode,"; if (sFrom.Trim() != "" && sTo.Trim() != "") { sql += "'" + sFrom + "' sFrom,'" + sTo + "' sTo FROM SalesReturnMaster, SalesReturnDetails WHERE SalesReturnMaster.SalesReturnMasterId = SalesReturnDetails.SalesReturnMasterId "; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and (SalesReturnMaster.SalesReturnDate between '" + sFrom + " 00:00:01' and '" + sTo + " 23:59:59')"; } else if (sFrom.Trim() != "") { sql += "'" + sFrom + "' sFrom,'' sTo FROM SalesReturnMaster,SalesReturnDetails WHERE SalesReturnMaster.SalesReturnMasterId = SalesReturnDetails.SalesReturnMasterId"; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); sql += " and SalesReturnMaster.SalesReturnDate >= '" + sFrom + " 00:00:01'"; } else if (sTo.Trim() != "") { sql += "'' sFrom,'" + sTo + "' sTo FROM SalesReturnMaster,SalesReturnDetails WHERE SalesReturnMaster.SalesReturnMasterId = SalesReturnDetails.SalesReturnMasterId"; dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and SalesReturnMaster.SalesReturnDate <= '" + sTo + " 23:59:59'"; } else { sql += "'' sFrom,'' sTo FROM SalesReturnMaster,SalesReturnDetails WHERE SalesReturnMaster.SalesReturnMasterId = SalesReturnDetails.SalesReturnMasterId"; } sql += " order by SalesDate"; _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; _reportname = "SalesDetails.rpt"; break; case "EventSoldCount": sFrom = "" + Request.QueryString["fromd"]; sTo = "" + Request.QueryString["tod"]; sql = @"select '0' as type, L.Name as location_name, count(*) as product_count, P.Name as product_name, '" + sFrom + "' as from_date, '" + sTo + @"' as to_date from SalesMaster S, SalesDetails D, LocationMaster L, ProductMaster P, ProductDetail PD where S.LocationId = L.LocationId and S.SalesMasterId = D.SalesMasterId and D.ProductId = P.ProductId and P.ProductId = PD.ProductId and PD.SalesDetailId = D.SalesDetailId"; if (sFrom != "") { sql += " and S.SalesDate >= '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 00:00:00' "; } if (sTo != "") { sql += " and S.SalesDate <= '" + Convert.ToDateTime(sTo).ToString("yyyy-MM-dd") + @" 23:59:59'"; } sql += " group by L.LocationId, L.Name, P.ProductId, P.Name "; sql += @" union select '1' as type, L.Name as location_name, count(*) as product_count, P.Name as product_name, '" + sFrom + "' as from_date, '" + sTo + @"' as to_date from SalesReturnMaster S, SalesReturnDetails D, LocationMaster L, ProductMaster P, ProductDetail PD where S.LocationId = L.LocationId and S.SalesReturnMasterId = D.SalesReturnMasterId and D.ProductId = P.ProductId and P.ProductId = PD.ProductId and PD.SalesReturnDetailId = D.SalesReturnDetailId"; if (sFrom != "") { sql += " and S.SalesReturnDate >= '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 00:00:00' "; } if (sTo != "") { sql += " and S.SalesReturnDate <= '" + Convert.ToDateTime(sTo).ToString("yyyy-MM-dd") + @" 23:59:59'"; } sql += " group by type, L.LocationId, L.Name, P.ProductId, P.Name order by type, location_name, product_name"; _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; _reportname = "EventSoldCount.rpt"; break; case "CategorySummary": string CategoryId = "" + Request.QueryString["category_id"]; string CategoryName = "" + Request.QueryString["category_name"]; sFrom = "" + Request.QueryString["fromd"]; sTo = "" + Request.QueryString["tod"]; sql = "select * from Category where CategoryId = " + CategoryId; DataTable dt = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; if (("" + dt.Rows[0]["IsPhysicalInventory"].ToString()).ToString() == "1") { sql = @"select '0' as type, '" + CategoryName + " Pass Summary by Date' as Title, '" + sFrom + "' as from_date, '" + sTo + @"' as to_date, S.SalesDate as purchase_date, P.Name as product_name, 1 as product_count, '' as voucher_no, PD.SerialNo as serial_no, D.SalesAmount as purchase_price from SalesMaster S, SalesDetails D, ProductMaster P, ProductDetail PD where S.SalesMasterId = D.SalesMasterId and D.ProductId = P.ProductId and P.ProductId = PD.ProductId and PD.SalesDetailId = D.SalesDetailId and P.CategoryId = " + CategoryId; if (sFrom != "") { sql += " and S.SalesDate >= '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 00:00:00' "; } if (sTo != "") { sql += " and S.SalesDate <= '" + Convert.ToDateTime(sTo).ToString("yyyy-MM-dd") + @" 23:59:59'"; } sql += @" union select '1' as type, '" + CategoryName + " Pass Summary by Date' as Title, '" + sFrom + "' as from_date, '" + sTo + @"' as to_date, S.SalesReturnDate as purchase_date, P.Name as product_name, 1 as product_count, '' as voucher_no, PD.SerialNo as serial_no, D.Amount as purchase_price from SalesReturnMaster S, SalesReturnDetails D, ProductMaster P, ProductDetail PD where S.SalesReturnMasterId = D.SalesReturnMasterId and D.ProductId = P.ProductId and P.ProductId = PD.ProductId and PD.SalesReturnDetailId = D.SalesReturnDetailId and P.CategoryId = " + CategoryId; if (sFrom != "") { sql += " and S.SalesReturnDate >= '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 00:00:00' "; } if (sTo != "") { sql += " and S.SalesReturnDate <= '" + Convert.ToDateTime(sTo).ToString("yyyy-MM-dd") + @" 23:59:59'"; } sql += " order by type, purchase_date, product_name, serial_no"; } else { sql = @"select '0' as type, '" + CategoryName + " Pass Summary by Date' as Title, '" + sFrom + "' as from_date, '" + sTo + @"' as to_date, S.SalesDate as purchase_date, concat(IFNULL((SELECT Name FROM ProductMaster WHERE ProductMaster.ProductId = D.ProductId),''), IFNULL(D.ProductName,'')) as product_name, 1 as product_count, '' as voucher_no, case when IsSmartDest = 0 then (select SerialNo from ProductDetail where ProductId = D.ProductId and SalesDetailId = D.SalesDetailId) else '' as serial_no, D.SalesAmount as purchase_price from SalesMaster S, SalesDetails D, ProductDetail PD where S.SalesMasterId = D.SalesMasterId and D.ProductId = PD.ProductId and PD.SalesDetailId = D.SalesDetailId and P.CategoryId = " + CategoryId; if (sFrom != "") { sql += " and S.SalesDate >= '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 00:00:00' "; } if (sTo != "") { sql += " and S.SalesDate <= '" + Convert.ToDateTime(sTo).ToString("yyyy-MM-dd") + @" 23:59:59'"; } sql += @" union select '1' as type, '" + CategoryName + " Pass Summary by Date' as Title, '" + sFrom + "' as from_date, '" + sTo + @"' as to_date, S.SalesReturnDate as purchase_date, concat(IFNULL((SELECT Name FROM ProductMaster WHERE ProductMaster.ProductId = D.ProductId),''), IFNULL(D.ProductName,'')) as product_name, 1 as product_count, '' as voucher_no, PD.SerialNo as serial_no, D.Amount as purchase_price from SalesReturnMaster S, SalesReturnDetails D, ProductDetail PD where S.SalesReturnMasterId = D.SalesReturnMasterId and D.ProductId = P.ProductId and P.ProductId = PD.ProductId and PD.SalesReturnDetailId = D.SalesReturnDetailId and P.CategoryId = " + CategoryId; if (sFrom != "") { sql += " and S.SalesReturnDate >= '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 00:00:00' "; } if (sTo != "") { sql += " and S.SalesReturnDate <= '" + Convert.ToDateTime(sTo).ToString("yyyy-MM-dd") + @" 23:59:59'"; } sql += " order by purchase_date, product_name, serial_no"; } _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; _reportname = "CategorySummary.rpt"; break; case "ClerkSummary": string LocationId = "" + Request.QueryString["location_id"]; sFrom = "" + Request.QueryString["fromd"]; //sTo = "" + Request.QueryString["tod"]; sql = @"SELECT '0' as type, '" + sFrom + @"' as from_date, '' as to_date, L.Name as location_name, U.UserName as user_name, Sum(case when PaymentType = 1 then 1 else 0 end) as cash_count, Sum(case when PaymentType = 1 then P.Amount else 0 end) as cash_total, Sum(case when PaymentType = 2 then 1 else 0 end) as credit_count, Sum(case when PaymentType = 2 then P.Amount else 0 end) as credit_total, Sum(case when PaymentType = 3 then 1 else 0 end) as voucher_count, Sum(case when PaymentType = 3 then P.Amount else 0 end) as voucher_total FROM SalesMaster S, PaymentDetails P, LocationMaster L, UserMaster U WHERE S.SalesMasterId = P.SalesMasterId and P.TransType = 0 and S.LocationId = L.LocationId and S.ClerkId = U.UserId and S.LocationId = " + LocationId; if (sFrom != "") { sql += " and S.SalesDate between '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 00:00:00' and '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 23:59:59'"; } sql += " group by L.Name, U.UserName "; sql += " union "; sql += @"SELECT '1' as type, '" + sFrom + @"' as from_date, '' as to_date, L.Name as location_name, U.UserName as user_name, Sum(case when PaymentType = 1 then 1 else 0 end) as cash_count, Sum(case when PaymentType = 1 then P.Amount else 0 end) as cash_total, Sum(case when PaymentType = 2 then 1 else 0 end) as credit_count, Sum(case when PaymentType = 2 then P.Amount else 0 end) as credit_total, Sum(case when PaymentType = 3 then 1 else 0 end) as voucher_count, Sum(case when PaymentType = 3 then P.Amount else 0 end) as voucher_total FROM SalesReturnMaster S, PaymentDetails P, LocationMaster L, UserMaster U WHERE S.SalesReturnMasterId = P.SalesMasterId and P.TransType = 1 and S.LocationId = L.LocationId and S.ClerkId = U.UserId and S.LocationId = " + LocationId; if (sFrom != "") { sql += " and S.SalesReturnDate between '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 00:00:00' and '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 23:59:59'"; } sql += " group by L.Name, U.UserName "; _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; _reportname = "ClerkSummary.rpt"; break; case "VoucherSummary": CategoryId = "" + Request.QueryString["category_id"]; CategoryName = "" + Request.QueryString["category_name"]; sFrom = "" + Request.QueryString["fromd"]; sTo = "" + Request.QueryString["tod"]; if (sTo == "") { sTo = sFrom; } sql = @"select '" + CategoryName + "' as Title, '" + sFrom + "' FromDate, '" + sTo + @"' ToDate, SM.SalesMasterId, SM.SalesDate as `Date`, PD.CardCheckNo as VoucherNumber, PM.Name, SD.SerialNo as SerialNumber from SalesMaster SM, PaymentDetails PD, ProductMaster PM, SalesDetails SD where SM.SalesMasterId = PD.SalesMasterId AND SD.SalesMasterId = SM.SalesMasterId AND SD.ProductId = PM.ProductId AND PD.PaymentType = 3 AND PM.CategoryId = " + CategoryId; if (sFrom != "") { sql += " and SM.SalesDate between '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 00:00:00' and '" + Convert.ToDateTime(sTo).ToString("yyyy-MM-dd") + @" 23:59:59'"; } _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; _reportname = "VoucherSummary.rpt"; break; case "SDReturns": sFrom = "" + Request.QueryString["fromd"]; sTo = "" + Request.QueryString["tod"]; sql = @"SELECT 'Smart Destination Returns' as title, '" + sFrom + @"' as from_date, '" + sTo + @"' as to_date, SD.SalesMasterId as sales_id, date_format(SR.SalesReturnDate,'%m/%d/%Y') as return_date, SD.ProductName as product_name, SRD.qty, SRD.amount, UM.UserName as user_name, concat(' ',SDOrderNo) as SDOrderNo FROM SalesReturnMaster SR, SalesReturnDetails SRD, SalesMaster SM, SalesDetails SD, UserMaster UM WHERE SR.SalesReturnMasterId = SRD.SalesReturnMasterId and SRD.SalesDetailId = SD.SalesDetailId and SM.SalesMasterId = SD.SalesMasterId and SD.IsSmartDest = 1 and SRD.ProductId = SD.ProductId and SR.ClerkId = UM.UserId and SR.LocationId = " + Session["LocationId"].ToString(); if (sFrom != "") { sql += " and SR.SalesReturnDate >= '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 00:00:00' "; } if (sTo != "") { sql += " and SR.SalesReturnDate <= '" + Convert.ToDateTime(sTo).ToString("yyyy-MM-dd") + @" 23:59:59'"; } sql += ""; sql += " order by SR.SalesReturnDate"; _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; _reportname = "SDReturns.rpt"; break; case "UserLog": sFrom = "" + Request.QueryString["fromd"]; sTo = "" + Request.QueryString["tod"]; sql = @"SELECT username as user_name, LoginDateTime AS login_date, LogoutDatetime AS logout_date, IP FROM UserLog, UserMaster WHERE UserLog.UserId = UserMaster.UserId "; if (sFrom != "") { sql += " and LoginDateTime >= '" + Convert.ToDateTime(sFrom).ToString("yyyy-MM-dd") + " 00:00:00' "; } if (sTo != "") { sql += " and LoginDateTime <= '" + Convert.ToDateTime(sTo).ToString("yyyy-MM-dd") + @" 23:59:59'"; } sql += " ORDER BY UserName, LoginDateTime"; _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; _reportname = "UserLog.rpt"; break; case "SalesReturn": sFrom = "" + Request.QueryString["fromd"]; sTo = "" + Request.QueryString["tod"]; sql = " SELECT SalesReturnMasterId SRID, (SELECT SalesMasterId from SalesDetails, SalesReturnDetails WHERE SalesDetails.SalesDetailId = SalesReturnDetails.SalesDetailId and SalesReturnDetails.SalesReturnMasterId = SalesReturnMaster.SalesReturnMasterId limit 1) as ID, (select DATE_FORMAT(SalesDate,'%m/%d/%Y %h:%i %p') from SalesDetails, SalesReturnDetails, SalesMaster WHERE SalesMaster.`SalesMasterId` = SalesDetails.`SalesMasterId` AND SalesDetails.SalesDetailId = SalesReturnDetails.SalesDetailId and SalesReturnDetails.SalesReturnMasterId = SalesReturnMaster.SalesReturnMasterId limit 1) SalesDate, DATE_FORMAT(SalesReturnDate,'%m/%d/%Y %h:%i %p') SalesReturnDate, Amount, (SELECT Name FROM LocationMaster WHERE LocationMaster.LocationId = SalesReturnMaster.LocationId) as Location, (SELECT UserName FROM UserMaster WHERE UserMaster.UserId = SalesReturnMaster.ClerkId) as Clerk, '' as CustomerName, (SELECT SUM(Qty) FROM SalesReturnDetails WHERE SalesReturnMasterId = SalesReturnMaster.SalesReturnMasterId) ticket, "; if (sFrom.Trim() != "" && sTo.Trim() != "") { sql += "'" + sFrom + "' sFrom,'" + sTo + "' sTo FROM SalesReturnMaster where 1=1"; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and (SalesReturnDate between '" + sFrom + " 00:00:01' and '" + sTo + " 23:59:59')"; } else if (sFrom.Trim() != "") { sql += "'" + sFrom + "' sFrom,'' sTo FROM SalesReturnMaster where 1=1"; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); sql += " and SalesReturnDate >= '" + sFrom + " 00:00:01'"; } else if (sTo.Trim() != "") { sql += "'' sFrom,'" + sTo + "' sTo FROM SalesReturnMaster where 1=1"; dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and SalesReturnDate <= '" + sTo + " 23:59:59'"; } else { sql += "'' sFrom,'' sTo FROM SalesReturnMaster where 1=1"; } sql += " order by SalesReturnDate"; _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; _reportname = "SalesReturn.rpt"; break; case "SalesReturnDetails": sFrom = "" + Request.QueryString["fromd"]; sTo = "" + Request.QueryString["tod"]; sql = @" SELECT '1' as type, SalesReturnMaster.SalesReturnMasterId SalesMasterId, (select SalesMasterId from SalesDetails where SalesDetailId = SalesReturnDetails.SalesDetailId limit 1) as SalesId, DATE_FORMAT(SalesReturnDate,'%m/%d/%Y %h:%i %p') SalesReturnDate, SalesReturnMaster.Amount AS Amount, (select DATE_FORMAT(SalesDate,'%m/%d/%Y %h:%i %p') from SalesDetails, SalesReturnDetails, SalesMaster WHERE SalesMaster.`SalesMasterId` = SalesDetails.`SalesMasterId` AND SalesDetails.SalesDetailId = SalesReturnDetails.SalesDetailId and SalesReturnDetails.SalesReturnMasterId = SalesReturnMaster.SalesReturnMasterId limit 1) SalesDate, SalesReturnDetails.SerialNo, (SELECT NAME FROM LocationMaster WHERE LocationMaster.LocationId = SalesReturnMaster.LocationId) AS Location, (SELECT UserName FROM UserMaster WHERE UserMaster.UserId = SalesReturnMaster.ClerkId) AS Clerk, '' as CustomerName, (SELECT NAME FROM ProductMaster WHERE ProductMaster.ProductId = SalesReturnDetails.ProductId) AS Description, Qty AS Quantity, SalesReturnDetails.Amount AS Price, (SELECT CASE WHEN PaymentType=1 THEN 'Cash' WHEN PaymentType=2 THEN 'Card' Else 'Vouher' END FROM PaymentDetails WHERE SalesMasterId = SalesReturnMaster.SalesReturnMasterId) paytype, '' as authcode,"; if (sFrom.Trim() != "" && sTo.Trim() != "") { sql += "'" + sFrom + "' sFrom,'" + sTo + "' sTo FROM SalesReturnMaster, SalesReturnDetails WHERE SalesReturnMaster.SalesReturnMasterId = SalesReturnDetails.SalesReturnMasterId "; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and (SalesReturnMaster.SalesReturnDate between '" + sFrom + " 00:00:01' and '" + sTo + " 23:59:59')"; } else if (sFrom.Trim() != "") { sql += "'" + sFrom + "' sFrom,'' sTo FROM SalesReturnMaster,SalesReturnDetails WHERE SalesReturnMaster.SalesReturnMasterId = SalesReturnDetails.SalesReturnMasterId"; dt1 = DateTime.Parse(sFrom); sFrom = dt1.ToString("yyyy-MM-dd"); sql += " and SalesReturnMaster.SalesReturnDate >= '" + sFrom + " 00:00:01'"; } else if (sTo.Trim() != "") { sql += "'' sFrom,'" + sTo + "' sTo FROM SalesReturnMaster,SalesReturnDetails WHERE SalesReturnMaster.SalesReturnMasterId = SalesReturnDetails.SalesReturnMasterId"; dt1 = DateTime.Parse(sTo); sTo = dt1.ToString("yyyy-MM-dd"); sql += " and SalesReturnMaster.SalesReturnDate <= '" + sTo + " 23:59:59'"; } else { sql += "'' sFrom,'' sTo FROM SalesReturnMaster,SalesReturnDetails WHERE SalesReturnMaster.SalesReturnMasterId = SalesReturnDetails.SalesReturnMasterId"; } sql += " order by SalesDate"; _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; _reportname = "SalesReturnDetails.rpt"; break; case "Users": Users objUsers = new Users(); _datasource = objUsers.GetUsers(); _reportname = "Users.rpt"; break; } doc.Load(Server.MapPath("") + @"\" + _reportname); if (_datasource != null) { doc.SetDataSource(_datasource); if (_reportname == "Receipt.rpt") { string sql = "SELECT SalesDate, CustomerName,'' as `SalesTime`,CASE PaymentType WHEN 1 THEN 'Cash' WHEN 2 THEN CONCAT(CardType, ' ....',CardCheckNo) ELSE concat('Voucher No. ',CardCheckNo) END as PayType,case when CardAuthorizationId != 0 then CONCAT('Authorization:',CardAuthorizationId) else '' end as Authorization,Amount as PayAmount FROM SalesMaster,PaymentDetails where SalesMaster.SalesMasterId = PaymentDetails.SalesMasterId and SalesMaster.SalesMasterId= " + SalesId; _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; doc.Subreports[0].SetDataSource(_datasource); sql = @"SELECT concat(IFNULL((SELECT Name FROM ProductMaster WHERE ProductMaster.ProductId = SD.ProductId),''), IFNULL(SD.ProductName,'')) as Description, SUM(D.Qty) as Quantity, D.Amount as Price FROM SalesReturnDetails D, SalesDetails SD where D.SalesDetailId = SD.SalesDetailId and SD.SalesMasterId = " + SalesId + " GROUP by D.SalesDetailId"; _datasource = DBConn.ExecuteDataSet(sql, CommandType.Text).Tables[0]; doc.Subreports[1].SetDataSource(_datasource); if (Request.QueryString["Dup"] == "yes") { doc.Subreports[0].ReportDefinition.Sections["ReportFooterSection1"].SectionFormat.EnableSuppress = true; } } } doc.SummaryInfo.ReportTitle = _reporttitle; doc.RecordSelectionFormula = _reportselectionformula; if (_reportname == "CategorySummary.rpt" || _reportname == "VoucherSummary.rpt") { ((TextObject)doc.ReportDefinition.Sections["Section1"].ReportObjects["title"]).Text = "" + Request.QueryString["category_name"] + " Voucher Summary by Date"; } CrViewer.HyperlinkTarget = "_blank"; //repObj.LoadParameterFields(doc, Request.QueryString["DataSource"]); MaximizeWindow(); if (_printType == "DirectPrint")// Report.ReportOutPutEnum.DirectPrint.ToString()) { CrViewer.SeparatePages = false; //CrViewer.PrintMode = CrystalDecisions.Web.PrintMode.ActiveX; } /*else if (_printType == Report.ReportOutPutEnum.ExportToPDF.ToString()) * { * MemoryStream oStream; // using System.IO * oStream = (MemoryStream) * doc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); * Response.Clear(); * Response.Buffer = true; * if ("" + Request.QueryString["DataSource"] == "SIBREPORT") * { * string sFileName = ""; * if ("" + ConfigurationManager.AppSettings["ExchId"] == "LULU") * sFileName = "LNF"; * else * sFileName = "ANF"; * sFileName = sFileName + DateTime.Parse(repObj.DateParameter1).ToString("ddMMyyyy") + repObj.StringParameter2; //objFgen.GetSIBFileName(tFun.Text); * sFileName = sFileName.Replace("/", ""); * string fileName = Server.MapPath("files") + "\\" + sFileName; * Response.AddHeader("content-disposition", "attachment; filename=" + sFileName); * } * Response.ContentType = "application/pdf"; * Response.BinaryWrite(oStream.ToArray()); * Response.End(); * } * else if (_printType == Report.ReportOutPutEnum.ExportToExcel.ToString()) * { * MemoryStream oStream; // using System.IO * oStream = (MemoryStream) * doc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); * Response.Clear(); * Response.Buffer = true; * Response.ContentType = "application/vnd.ms-excel"; * Response.BinaryWrite(oStream.ToArray()); * Response.End(); * } * else if (_printType == Report.ReportOutPutEnum.ExportToDoc.ToString()) * { * MemoryStream oStream; // using System.IO * oStream = (MemoryStream) * doc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.WordForWindows); * Response.Clear(); * Response.Buffer = true; * Response.ContentType = "application/vnd.ms-word"; * Response.BinaryWrite(oStream.ToArray()); * Response.End(); * }*/ CrViewer.ReportSource = doc; CrViewer.DataBind(); } } catch (Exception E) { Response.Write(E.ToString()); } }
private void btnImprimir_Click(object sender, EventArgs e) { //Conexion a la base de datos MySqlConnection myConexion = new MySqlConnection(clsConexion.ConectionString); // Creando el command que ejecutare MySqlCommand myCommand = new MySqlCommand(); // Creando el Data Adapter MySqlDataAdapter myAdapter = new MySqlDataAdapter(); // Creando el String Builder StringBuilder sbQuery = new StringBuilder(); // Otras variables del entorno string cWhere = " WHERE 1 = 1"; string cUsuario = ""; string cTitulo = ""; try { // Abro conexion myConexion.Open(); // Creo comando myCommand = myConexion.CreateCommand(); // Adhiero el comando a la conexion myCommand.Connection = myConexion; // Filtros de la busqueda string fechadesde = dtDesde.Value.ToString("yyyy-MM-dd"); string fechahasta = dtHasta.Value.ToString("yyyy-MM-dd"); cWhere = cWhere + " AND combustible_salida.fecha >= " + "'" + fechadesde + "'" + " AND combustible_salida.fecha <= " + "'" + fechahasta + "'" + ""; cWhere = cWhere + " AND movimientocombustible.tipo_movimiento = 'S'"; // Filtros del tipo de Operaciones if (rbTerrestres.Checked == true) { cWhere = cWhere + " AND movimientocombustible.operaciones = 'T'"; } else if (rbMaritimas.Checked == true) { cWhere = cWhere + " AND movimientocombustible.operaciones = 'M'"; } if (chkDepartamentos.Checked == true) { cWhere = cWhere + " AND combustible_salida.beneficiario_depto = " + this.cmbCombustible.SelectedValue + ""; } if (chkAnuladas.Checked == true) { cWhere = cWhere + " AND movimientocombustible.anulada = '1'"; } else { cWhere = cWhere + " AND movimientocombustible.anulada = '0'"; } sbQuery.Clear(); sbQuery.Append(" SELECT combustible_salida.id, sum(movimientocombustible.cantidad) as cantidad,"); sbQuery.Append(" combustible_salida.beneficiario_depto, combustible_salida.fecha, "); sbQuery.Append(" tipo_combustible.combustible as tipo_combustible, departamento_autoriza.departamento as autorizadopor, "); sbQuery.Append(" deptobeneficiario.deptobeneficiario as tipobeneficiario, tipo_combustible.medida"); sbQuery.Append(" FROM combustible_salida"); sbQuery.Append(" INNER JOIN movimientocombustible ON movimientocombustible.id = combustible_salida.id"); sbQuery.Append(" INNER JOIN tipo_combustible ON tipo_combustible.id = movimientocombustible.tipo_combustible"); sbQuery.Append(" INNER JOIN departamento_autoriza ON departamento_autoriza.id = combustible_salida.autorizadopor"); sbQuery.Append(" INNER JOIN deptobeneficiario ON deptobeneficiario.id = combustible_salida.beneficiario_depto"); sbQuery.Append(cWhere); sbQuery.Append(" GROUP BY tipo_combustible, tipobeneficiario"); sbQuery.Append(" ORDER BY deptobeneficiario.id"); // Paso los valores de sbQuery al CommandText myCommand.CommandText = sbQuery.ToString(); // Creo el objeto Data Adapter y ejecuto el command en el myAdapter = new MySqlDataAdapter(myCommand); // Creo el objeto Data Table DataTable dtMovimientoCombustible = new DataTable(); // Lleno el data adapter myAdapter.Fill(dtMovimientoCombustible); // Cierro el objeto conexion myConexion.Close(); // Verifico cantidad de datos encontrados int nRegistro = dtMovimientoCombustible.Rows.Count; if (nRegistro == 0) { MessageBox.Show("No Hay Datos Para Mostrar, Favor Verificar", "Sistema de Gestion de Combustible", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { //1ero.HACEMOS LA COLECCION DE PARAMETROS //los campos de parametros contiene un objeto para cada campo de parametro en el informe ParameterFields oParametrosCR = new ParameterFields(); //Proporciona propiedades para la recuperacion y configuracion del tipo de los parametros ParameterValues oParametrosValuesCR = new ParameterValues(); //2do.CREAMOS LOS PARAMETROS ParameterField oUsuario = new ParameterField(); ParameterField oFechaInicial = new ParameterField(); ParameterField oFechaFinal = new ParameterField(); //parametervaluetype especifica el TIPO de valor de parametro //ParameterValueKind especifica el tipo de valor de parametro en la PARAMETERVALUETYPE de la Clase PARAMETERFIELD oUsuario.ParameterValueType = ParameterValueKind.StringParameter; oFechaInicial.ParameterValueType = ParameterValueKind.DateTimeParameter; oFechaFinal.ParameterValueType = ParameterValueKind.DateTimeParameter; //3ero.VALORES PARA LOS PARAMETROS //ParameterDiscreteValue proporciona propiedades para la recuperacion y configuracion de //parametros de valores discretos ParameterDiscreteValue oUsuarioDValue = new ParameterDiscreteValue(); oUsuarioDValue.Value = cUsuario; ParameterDiscreteValue oFechaDValue = new ParameterDiscreteValue(); oFechaDValue.Value = fechadesde; ParameterDiscreteValue oFechaFinDValue = new ParameterDiscreteValue(); oFechaFinDValue.Value = fechahasta; //4to. AGREGAMOS LOS VALORES A LOS PARAMETROS oUsuario.CurrentValues.Add(oUsuarioDValue); oFechaInicial.CurrentValues.Add(oFechaDValue); oFechaFinal.CurrentValues.Add(oFechaFinDValue); //5to. AGREGAMOS LOS PARAMETROS A LA COLECCION oParametrosCR.Add(oUsuario); oParametrosCR.Add(oFechaInicial); oParametrosCR.Add(oFechaFinal); //nombre del parametro en CR (Crystal Reports) oParametrosCR[0].Name = "cUsuario"; oParametrosCR[1].Name = "cFechaInicial"; oParametrosCR[2].Name = "cFechaFinal"; //nombre del TITULO DEL INFORME cTitulo = "Reporte Estadístico de Despacho de Combustible"; //6to Instanciamos nuestro REPORTE //Reportes.ListadoDoctores oListado = new Reportes.ListadoDoctores(); rptDespachoCombustibleResumido orptDespachoCombustibleResumido = new rptDespachoCombustibleResumido(); //pasamos el nombre del TITULO del Listado //SumaryInfo es un objeto que se utiliza para leer,crear y actualizar las propiedades del reporte // oListado.SummaryInfo.ReportTitle = cTitulo; orptDespachoCombustibleResumido.SummaryInfo.ReportTitle = cTitulo; //7mo. instanciamos nuestro el FORMULARIO donde esta nuestro ReportViewer frmPrinter ofrmPrinter = new frmPrinter(dtMovimientoCombustible, orptDespachoCombustibleResumido, cTitulo); //ParameterFieldInfo Obtiene o establece la colección de campos de parámetros. ofrmPrinter.CrystalReportViewer1.ParameterFieldInfo = oParametrosCR; ofrmPrinter.ShowDialog(); } } catch (Exception myEx) { MessageBox.Show("Error : " + myEx.Message, "Mostrando Reporte", MessageBoxButtons.OK, MessageBoxIcon.Information); //ExceptionLog.LogError(myEx, false); return; } }
public void AddValue(String name, String value) { ParameterValues.Add(new SingleParameter(name, value)); }
private async Task InsertAsync(DbContext context, bool skipSelect) { _parameters = new string[SqlColumns.Count]; // var ts = DateTime.UtcNow; SqlText.AppendLine("SET NOCOUNT ON;"); PrepareInsertSql(); var returned = PrepareSelectSql(skipSelect); await ExecSqlAndUpdateBackAsync(SqlText.ToString(), context, Entity, returned, ParameterValues.ToArray()); //Debug.WriteLine(" sql elapsed " + (DateTime.UtcNow - ts).TotalMilliseconds); /* * * string sql = @"SET NOCOUNT ON; * INSERT INTO [RecipeNodes] ([ArticleId], [EnrichedArticleId], [IsActive], [IsDefault], [MigrationSourceId], [Name]) * VALUES (@p0, @p1, @p2, @p3, @p4, @p5); * SELECT [Id] * FROM [RecipeNodes] * WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity();"; */ }
private void btnImprimir_Click(object sender, EventArgs e) { //Conexion a la base de datos MySqlConnection myConexion = new MySqlConnection(clsConexion.ConectionString); // Creando el command que ejecutare MySqlCommand myCommand = new MySqlCommand(); // Creando el Data Adapter MySqlDataAdapter myAdapter = new MySqlDataAdapter(); // Creando el String Builder StringBuilder sbQuery = new StringBuilder(); // Otras variables del entorno string cWhere = " WHERE 1 = 1"; string cUsuario = frmLogin.cUsuarioActual; string cTitulo = ""; try { // Abro conexion myConexion.Open(); // Creo comando myCommand = myConexion.CreateCommand(); // Adhiero el comando a la conexion myCommand.Connection = myConexion; // Filtros de la busqueda //if (rbTodas.Checked) //{ string fechadesde = dtDesde.Value.ToString("yyyy-MM-dd"); string fechahasta = dtHasta.Value.ToString("yyyy-MM-dd"); cWhere = cWhere + " AND secuencia_solicitudcombustible.fecha >= " + "'" + fechadesde + "'" + " AND secuencia_solicitudcombustible.fecha <= " + "'" + fechahasta + "'" + ""; if (chkAnuladas.Checked == true) { cWhere = cWhere + " AND secuencia_solicitudcombustible.anulada = 1"; } else { cWhere = cWhere + " AND secuencia_solicitudcombustible.anulada = 0"; } sbQuery.Clear(); sbQuery.Append("SELECT secuencia_solicitudcombustible.id, solicitud.descripcion_combustible as tipocombustible, solicitud.cantidad, "); sbQuery.Append(" secuencia_solicitudcombustible.fecha, secuencia_solicitudcombustible.nota"); sbQuery.Append(" FROM secuencia_solicitudcombustible "); sbQuery.Append(" INNER JOIN solicitud ON solicitud.id = secuencia_solicitudcombustible.id"); //sbQuery.Append(" INNER JOIN tipo_combustible ON tipo_combustible.id = solicitud.tipo_combustible"); sbQuery.Append(cWhere); //} //else if (rbAprobadas.Checked) //{ //string fechadesde = dtDesde.Value.ToString("yyyy-MM-dd"); //string fechahasta = dtHasta.Value.ToString("yyyy-MM-dd"); //cWhere = cWhere + " AND fecha >= " + "'" + fechadesde + "'" + " AND fecha <= " + "'" + fechahasta + "'" + ""; //cWhere = cWhere + " AND status = 0"; //sbQuery.Clear(); //sbQuery.Append("SELECT solicitud.id, tipo_combustible.combustible as tipocombustible, solicitud.cantidad, "); //sbQuery.Append(" solicitud.fecha, solicitud.nota"); //sbQuery.Append(" FROM solicitud "); //sbQuery.Append(" INNER JOIN tipo_combustible ON tipo_combustible.id = solicitud.tipo_combustible"); //sbQuery.Append(cWhere); //} //else if (rbPendientes.Checked) //{ //string fechadesde = dtDesde.Value.ToString("yyyy-MM-dd"); //string fechahasta = dtHasta.Value.ToString("yyyy-MM-dd"); //cWhere = cWhere + " AND fecha >= " + "'" + fechadesde + "'" + " AND fecha <= " + "'" + fechahasta + "'" + ""; //cWhere = cWhere + " AND status = 1"; //sbQuery.Clear(); //sbQuery.Append("SELECT solicitud.id, tipo_combustible.combustible as tipocombustible, solicitud.cantidad, "); //sbQuery.Append(" solicitud.fecha, solicitud.nota"); //sbQuery.Append(" FROM solicitud "); //sbQuery.Append(" INNER JOIN tipo_combustible ON tipo_combustible.id = solicitud.tipo_combustible"); //sbQuery.Append(cWhere); //} // Paso los valores de sbQuery al CommandText myCommand.CommandText = sbQuery.ToString(); // Creo el objeto Data Adapter y ejecuto el command en el myAdapter = new MySqlDataAdapter(myCommand); // Creo el objeto Data Table DataTable dtSolicitudCombustible = new DataTable(); // Lleno el data adapter myAdapter.Fill(dtSolicitudCombustible); // Cierro el objeto conexion myConexion.Close(); // Verifico cantidad de datos encontrados int nRegistro = dtSolicitudCombustible.Rows.Count; if (nRegistro == 0) { MessageBox.Show("No Hay Datos Para Mostrar, Favor Verificar", "Sistema de Gestion de Combustible", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { //1ero.HACEMOS LA COLECCION DE PARAMETROS //los campos de parametros contiene un objeto para cada campo de parametro en el informe ParameterFields oParametrosCR = new ParameterFields(); //Proporciona propiedades para la recuperacion y configuracion del tipo de los parametros ParameterValues oParametrosValuesCR = new ParameterValues(); //2do.CREAMOS LOS PARAMETROS ParameterField oUsuario = new ParameterField(); ParameterField oFechaInicial = new ParameterField(); ParameterField oFechaFinal = new ParameterField(); //parametervaluetype especifica el TIPO de valor de parametro //ParameterValueKind especifica el tipo de valor de parametro en la PARAMETERVALUETYPE de la Clase PARAMETERFIELD oUsuario.ParameterValueType = ParameterValueKind.StringParameter; oFechaInicial.ParameterValueType = ParameterValueKind.DateTimeParameter; oFechaFinal.ParameterValueType = ParameterValueKind.DateTimeParameter; //3ero.VALORES PARA LOS PARAMETROS //ParameterDiscreteValue proporciona propiedades para la recuperacion y configuracion de //parametros de valores discretos ParameterDiscreteValue oUsuarioDValue = new ParameterDiscreteValue(); oUsuarioDValue.Value = cUsuario; ParameterDiscreteValue oFechaDValue = new ParameterDiscreteValue(); oFechaDValue.Value = fechadesde; ParameterDiscreteValue oFechaFinDValue = new ParameterDiscreteValue(); oFechaFinDValue.Value = fechahasta; //4to. AGREGAMOS LOS VALORES A LOS PARAMETROS oUsuario.CurrentValues.Add(oUsuarioDValue); oFechaInicial.CurrentValues.Add(oFechaDValue); oFechaFinal.CurrentValues.Add(oFechaFinDValue); //5to. AGREGAMOS LOS PARAMETROS A LA COLECCION oParametrosCR.Add(oUsuario); oParametrosCR.Add(oFechaInicial); oParametrosCR.Add(oFechaFinal); //nombre del parametro en CR (Crystal Reports) oParametrosCR[0].Name = "cUsuario"; oParametrosCR[1].Name = "cFechaInicial"; oParametrosCR[2].Name = "cFechaFinal"; //nombre del TITULO DEL INFORME cTitulo = "REPORTE DE SOLICITUDES DE COMBUSTIBLE"; //6to Instanciamos nuestro REPORTE //Reportes.ListadoDoctores oListado = new Reportes.ListadoDoctores(); rptListadoSolicitudCombustible orptListadoSolicitudCombustible = new rptListadoSolicitudCombustible(); //pasamos el nombre del TITULO del Listado //SumaryInfo es un objeto que se utiliza para leer,crear y actualizar las propiedades del reporte // oListado.SummaryInfo.ReportTitle = cTitulo; orptListadoSolicitudCombustible.SummaryInfo.ReportTitle = cTitulo; //7mo. instanciamos nuestro el FORMULARIO donde esta nuestro ReportViewer frmPrinter ofrmPrinter = new frmPrinter(dtSolicitudCombustible, orptListadoSolicitudCombustible, cTitulo); //ParameterFieldInfo Obtiene o establece la colección de campos de parámetros. ofrmPrinter.CrystalReportViewer1.ParameterFieldInfo = oParametrosCR; ofrmPrinter.ShowDialog(); } } catch (Exception myEx) { MessageBox.Show("Error : " + myEx.Message, "Mostrando Reporte", MessageBoxButtons.OK, MessageBoxIcon.Information); //ExceptionLog.LogError(myEx, false); return; } }
private void frmRVentaTipoComprobante_Load(object sender, EventArgs e) { try { string bandera = frmReporteVentasTipoComprobante.f1.lblBandera.Text; string fechaInicio = ""; string fechaFin = ""; DateTime fecIn; if (bandera == "1") { fechaInicio = frmReporteVentasProducto.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd" + " 00:00:00"); fechaFin = frmReporteVentasProducto.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd" + " 23:59:59"); } else { fecIn = Convert.ToDateTime(frmPrincipal.f1.lblFechaApertura.Text); fechaInicio = fecIn.ToString("yyyy-MM-dd HH:mm:ss"); fechaFin = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } string tipo = frmReporteVentasTipoComprobante.f1.cbProducto.SelectedItem.ToString(); ReportDocument repdoc = new ReportDocument(); // repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RVentaProducto.rpt"); repdoc.Load(@"D:\Reportes\RVentaComprobante.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToDateTime(fechaInicio); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaInicio"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = Convert.ToDateTime(fechaFin); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaFin"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = tipo; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@tipo"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "BD_RESTAURANTE"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
private void btnImprimir_Click(object sender, EventArgs e) { //clsConexion a la base de datos MySqlConnection myclsConexion = new MySqlConnection(Conexion.ConectionString); // Creando el command que ejecutare MySqlCommand myCommand = new MySqlCommand(); // Creando el Data Adapter MySqlDataAdapter myAdapter = new MySqlDataAdapter(); // Creando el String Builder StringBuilder sbQuery = new StringBuilder(); // Otras variables del entorno string cWhere = " WHERE 1 = 1"; string cUsuario = ""; //frmLogin.cUsuarioActual; string cTitulo = ""; try { // Abro clsConexion myclsConexion.Open(); // Creo comando myCommand = myclsConexion.CreateCommand(); // Adhiero el comando a la clsConexion myCommand.Connection = myclsConexion; // Filtros de la busqueda if (rbTodos.Checked) { // CREANDO EL QUERY DE CONSULTA //string fechadesde = fechaDesde.Value.ToString("yyyy-MM-dd"); //string fechahasta = fechaHasta.Value.ToString("yyyy-MM-dd"); //cWhere = cWhere + " AND fechacita >= "+"'"+ fechadesde +"'" +" AND fechacita <= "+"'"+ fechahasta +"'"+""; //cWhere = cWhere + " AND year = '" + txtYear.Text + "'"; sbQuery.Clear(); sbQuery.Append("SELECT idcosecha as ID, fechacorte as Fecha, semana as Semana, campo as Campo, cinta_verde as Verde,"); sbQuery.Append(" cinta_azul as Azul, cinta_amarilla as Amarilla, cinta_marron as Marron, cinta_gris as Gris,"); sbQuery.Append(" cinta_roja as Roja, cinta_blanca as Blanca, cinta_negra as Negra, cantidadtotal as CantidadTotal,"); sbQuery.Append(" cantidadrechazos as CantidadRechazos"); //sbQuery.Append(" doctores.doctores_cedula,upper(CONCAT(doctores.doctores_nombre,' ',doctores.doctores_apellido)) as doctor,departamentos.departamento_descripcion"); sbQuery.Append(" FROM cosecha"); //sbQuery.Append(" INNER JOIN departamentos ON departamentos.departamento_id = cita.referimiento"); sbQuery.Append(cWhere); } else if (rbFecha.Checked) { // CREANDO EL QUERY DE CONSULTA string fechadesde = fechaDesde.Value.ToString("yyyy-MM-dd"); string fechahasta = fechaHasta.Value.ToString("yyyy-MM-dd"); cWhere = cWhere + " AND fechacorte >= "+"'"+ fechadesde +"'" +" AND fechacorte <= "+"'"+ fechahasta +"'"+""; //cWhere = cWhere + " AND year = '" + txtYear.Text + "'"; sbQuery.Clear(); sbQuery.Append("SELECT idcosecha as ID, fechacorte as Fecha, semana as Semana, campo as Campo, cinta_verde as Verde,"); sbQuery.Append(" cinta_azul as Azul, cinta_amarilla as Amarilla, cinta_marron as Marron, cinta_gris as Gris,"); sbQuery.Append(" cinta_roja as Roja, cinta_blanca as Blanca, cinta_negra as Negra, cantidadtotal as CantidadTotal,"); sbQuery.Append(" cantidadrechazos as CantidadRechazos"); //sbQuery.Append(" doctores.doctores_cedula,upper(CONCAT(doctores.doctores_nombre,' ',doctores.doctores_apellido)) as doctor,departamentos.departamento_descripcion"); sbQuery.Append(" FROM cosecha"); //sbQuery.Append(" INNER JOIN departamentos ON departamentos.departamento_id = cita.referimiento"); sbQuery.Append(cWhere); } else if (rbSemana.Checked) { // CREANDO EL QUERY DE CONSULTA //DateTime year = fechaDesde.Value.Date.Year(); //cWhere = cWhere + " AND fechacorte >= " + "'" + fechadesde + "'" + " AND fechacorte <= " + "'" + fechahasta + "'" + ""; cWhere = cWhere + " AND semana = " + cmbSemana.SelectedValue + ""; sbQuery.Clear(); sbQuery.Append("SELECT idcosecha as ID, fechacorte as Fecha, semana as Semana, campo as Campo, cinta_verde as Verde,"); sbQuery.Append(" cinta_azul as Azul, cinta_amarilla as Amarilla, cinta_marron as Marron, cinta_gris as Gris,"); sbQuery.Append(" cinta_roja as Roja, cinta_blanca as Blanca, cinta_negra as Negra, cantidadtotal as CantidadTotal,"); sbQuery.Append(" cantidadrechazos as CantidadRechazos"); //sbQuery.Append(" doctores.doctores_cedula,upper(CONCAT(doctores.doctores_nombre,' ',doctores.doctores_apellido)) as doctor,departamentos.departamento_descripcion"); sbQuery.Append(" FROM cosecha"); //sbQuery.Append(" INNER JOIN departamentos ON departamentos.departamento_id = cita.referimiento"); sbQuery.Append(cWhere); } else if (rbFechaCampo.Checked) { // CREANDO EL QUERY DE CONSULTA string fechadesde = fechaDesde.Value.ToString("yyyy-MM-dd"); string fechahasta = fechaHasta.Value.ToString("yyyy-MM-dd"); cWhere = cWhere + " AND fechacorte >= " + "'" + fechadesde + "'" + " AND fechacorte <= " + "'" + fechahasta + "'" + ""; cWhere = cWhere + " AND campo = " + cmbCampo.SelectedValue + ""; sbQuery.Clear(); sbQuery.Append("SELECT idcosecha as ID, fechacorte as Fecha, semana as Semana, campo as Campo, cinta_verde as Verde,"); sbQuery.Append(" cinta_azul as Azul, cinta_amarilla as Amarilla, cinta_marron as Marron, cinta_gris as Gris,"); sbQuery.Append(" cinta_roja as Roja, cinta_blanca as Blanca, cinta_negra as Negra, cantidadtotal as CantidadTotal,"); sbQuery.Append(" cantidadrechazos as CantidadRechazos"); //sbQuery.Append(" doctores.doctores_cedula,upper(CONCAT(doctores.doctores_nombre,' ',doctores.doctores_apellido)) as doctor,departamentos.departamento_descripcion"); sbQuery.Append(" FROM cosecha"); //sbQuery.Append(" INNER JOIN departamentos ON departamentos.departamento_id = cita.referimiento"); sbQuery.Append(cWhere); } else { MessageBox.Show("No se pueden generar reportes sin haber seleccionado un criterio..."); } // Paso los valores de sbQuery al CommandText myCommand.CommandText = sbQuery.ToString(); // Creo el objeto Data Adapter y ejecuto el command en el myAdapter = new MySqlDataAdapter(myCommand); // Creo el objeto Data Table DataTable dtCosecha = new DataTable(); // Lleno el data adapter myAdapter.Fill(dtCosecha); // Cierro el objeto clsConexion myclsConexion.Close(); // Verifico cantidad de datos encontrados int nRegistro = dtCosecha.Rows.Count; if (nRegistro == 0) { MessageBox.Show("No Hay Datos Para Mostrar, Favor Verificar", "Sistema de Gestion Bananera", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { //1ero.HACEMOS LA COLECCION DE PARAMETROS //los campos de parametros contiene un objeto para cada campo de parametro en el informe ParameterFields oParametrosCR = new ParameterFields(); //Proporciona propiedades para la recuperacion y configuracion del tipo de los parametros ParameterValues oParametrosValuesCR = new ParameterValues(); //2do.CREAMOS LOS PARAMETROS ParameterField oUsuario = new ParameterField(); //parametervaluetype especifica el TIPO de valor de parametro //ParameterValueKind especifica el tipo de valor de parametro en la PARAMETERVALUETYPE de la Clase PARAMETERFIELD oUsuario.ParameterValueType = ParameterValueKind.StringParameter; //3ero.VALORES PARA LOS PARAMETROS //ParameterDiscreteValue proporciona propiedades para la recuperacion y configuracion de //parametros de valores discretos ParameterDiscreteValue oUsuarioDValue = new ParameterDiscreteValue(); oUsuarioDValue.Value = cUsuario; //4to. AGREGAMOS LOS VALORES A LOS PARAMETROS oUsuario.CurrentValues.Add(oUsuarioDValue); //5to. AGREGAMOS LOS PARAMETROS A LA COLECCION oParametrosCR.Add(oUsuario); //nombre del parametro en CR (Crystal Reports) oParametrosCR[0].Name = "cUsuario"; //nombre del TITULO DEL INFORME cTitulo = "REPORTE ESTADISTICOS DE LAS COSECHAS"; //6to Instanciamos nuestro REPORTE //Reportes.ListadoDoctores oListado = new Reportes.ListadoDoctores(); REPORTES.rptCosechaCampo orptCosechaCampo = new REPORTES.rptCosechaCampo(); //pasamos el nombre del TITULO del Listado //SumaryInfo es un objeto que se utiliza para leer,crear y actualizar las propiedades del reporte // oListado.SummaryInfo.ReportTitle = cTitulo; orptCosechaCampo.SummaryInfo.ReportTitle = cTitulo; //7mo. instanciamos nuestro el FORMULARIO donde esta nuestro ReportViewer frmPrinter ofrmPrinter = new frmPrinter(dtCosecha, orptCosechaCampo, cTitulo); //ParameterFieldInfo Obtiene o establece la colección de campos de parámetros. ofrmPrinter.CrystalReportViewer1.ParameterFieldInfo = oParametrosCR; ofrmPrinter.ShowDialog(); } } catch (Exception myEx) { MessageBox.Show("Error : " + myEx.Message, "Mostrando Reporte", MessageBoxButtons.OK, MessageBoxIcon.Information); // clsExceptionLog.LogError(myEx, false); return; } }
private void Customer_Print_Load(object sender, EventArgs e) { if (typep) { ReportDocument cryRpt = new ReportDocument(); cryRpt.Load(Application.StartupPath + @"\Customer Returned Report.rpt"); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = Bill_ID; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@Bill_ID"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = typep; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@Bill_Type"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = custome_name; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Customer_Name"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Bill_Details; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Bill_Details"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Bill_ID; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["ID"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Bill_Total; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Bill_Total"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Discout; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Discout"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = old; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["old"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = payment; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["payment"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } else { 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 + @"\Customer Purchasing Rport.rpt"); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = Bill_ID; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@Bill_ID"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = typep; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@Bill_Type"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = custome_name; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Customer_Name"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Bill_Details; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Bill_Details"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Bill_ID; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["ID"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Bill_Total; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Bill_Total"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Discout; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Discout"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = old; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["old"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = payment; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["payment"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } }
private void SetParameters (ReportDocument Report) { ParameterFieldDefinition paramField; ParameterValues currentValues; ParameterDiscreteValue discreteParam; paramField = Report.DataDefinition.ParameterFields["CompanyName"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = CompanyDetails.CompanyName; currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); paramField = Report.DataDefinition.ParameterFields["PrintedBy"]; discreteParam = new ParameterDiscreteValue(); discreteParam.Value = Session["Name"].ToString(); currentValues = new ParameterValues(); currentValues.Add(discreteParam); paramField.ApplyCurrentValues(currentValues); }
private void frmRAbono_Load(object sender, EventArgs e) { try { ExcelFormatOptions objExcel = new ExcelFormatOptions(); string bandera = frmReporteAbono.f1.lblBandera.Text; string fechaInicio = ""; string fechaFin = ""; DateTime fecIn; if (bandera == "1") { fechaInicio = frmReporteAbono.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd" + " 00:00:00"); fechaFin = frmReporteAbono.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd" + " 23:59:59"); } else { fecIn = Convert.ToDateTime(frmPrincipal.f1.lblFechaApertura.Text); fechaInicio = fecIn.ToString("yyyy-MM-dd HH:mm:ss"); fechaFin = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } ReportDocument repdoc = new ReportDocument(); // repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SISTEMAUCHPA_Barra1\CapaPresentacion\Reportes/RVentasCliente.rpt"); repdoc.Load(@"D:\Reportes\RAbono.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToDateTime(fechaInicio); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaInicio"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = Convert.ToDateTime(fechaFin); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaFin"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "SIS_AVICOLA"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; /*crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; * crConnectionInfo.DatabaseName = "db_restauranteAlmacen"; * crConnectionInfo.UserID = "martin"; * crConnectionInfo.Password = "******";*/ CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
public static ReportDocument SetReportDoc(params string[] nums) { ReportDocument doc = new ReportDocument(); try { string ReportPath = nums[0].ToString(); doc.Load(ReportPath); for (int i = 3; i < nums.Length; i++) { string paramValue = nums[i].ToString(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = paramValue; ParameterValues pv = new ParameterValues(); pv.Add(pdv); doc.DataDefinition.ParameterFields[i - 3].ApplyCurrentValues(pv); } if (doc.Database.Tables.Count > 0) { //for (int i = 0; i < doc.Database.Tables.Count; i++) //{ // doc.Database.Tables[i].ApplyLogOnInfo(LoginInfo()); //} doc.Database.Tables[0].ApplyLogOnInfo(LoginInfo()); } //Sections sections = doc.ReportDefinition.Sections; //foreach (Section section in sections) //{ // ReportObjects reportObjects = section.ReportObjects; // foreach (ReportObject reportObject in reportObjects) // { // if (reportObject.Kind == ReportObjectKind.SubreportObject) // { // SubreportObject subreportObject = (SubreportObject)reportObject; // ReportDocument subReportDocument = subreportObject.OpenSubreport(subreportObject.SubreportName); // if (subReportDocument.Database.Tables.Count > 0) // { // for (int i = 0; i < subReportDocument.Database.Tables.Count; i++) // { // subReportDocument.Database.Tables[i].ApplyLogOnInfo(LoginInfo()); // } // //subReportDocument.Database.Tables[0].ApplyLogOnInfo(LoginInfo()); // } // } // } //} if (nums[1].ToString().StartsWith("Y")) { //打印机名字 doc.PrintOptions.PrinterName = nums[2].ToString(); //设置打印边距 //PageMargins margins; //margins = doc.PrintOptions.PageMargins; //margins.topMargin = 240; //567 //margins.leftMargin = 240; //margins.rightMargin = 240; //margins.bottomMargin = 240; //doc.PrintOptions.ApplyPageMargins(margins); if (nums[1].ToString() == "Y1") { doc.PrintOptions.PaperSize = PaperSize.PaperA4; } //else //{ // doc.PrintOptions.PaperOrientation = PaperOrientation.DefaultPaperOrientation; // doc.PrintOptions.PaperSize = PaperSize.DefaultPaperSize; //} //打印份数,是否逐份打印,打印第一页,最后一页 doc.PrintToPrinter(1, false, 0, 0); } } catch { } return(doc); }
private void Button5_Click(object sender, EventArgs e) { try { cryRpt.Load(CHEMINRPT); ConnectionInfo connectionInfo = new ConnectionInfo(); ConnectionInfo connectionInfo2 = connectionInfo; connectionInfo2.ServerName = "erp_db"; connectionInfo2.DatabaseName = ""; connectionInfo2.UserID = Globals.BDUSER; connectionInfo2.Password = Globals.BDPW; connectionInfo2.IntegratedSecurity = true; connectionInfo2 = null; TableLogOnInfos tableLogOnInfos = new TableLogOnInfos(); TableLogOnInfo tableLogOnInfo = new TableLogOnInfo(); Tables tables = cryRpt.Database.Tables; IEnumerator enumerator = default(IEnumerator); try { enumerator = tables.GetEnumerator(); while (enumerator.MoveNext()) { Table table = (Table)enumerator.Current; tableLogOnInfo = table.LogOnInfo; tableLogOnInfo.ConnectionInfo = connectionInfo; table.ApplyLogOnInfo(tableLogOnInfo); } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } ParameterValues parameterValues = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); parameterDiscreteValue.Value = NUMFACT.Text; ParameterFieldDefinitions parameterFields = cryRpt.DataDefinition.ParameterFields; ParameterFieldDefinition parameterFieldDefinition = parameterFields[PARAMFACT]; parameterValues = parameterFieldDefinition.CurrentValues; parameterValues.Clear(); parameterValues.Add(parameterDiscreteValue); parameterFieldDefinition.ApplyCurrentValues(parameterValues); CRV.ReportSource = cryRpt; CRV.Refresh(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; MessageBox.Show(ex2.Message); ProjectData.ClearProjectError(); } finally { if (Globals.conn != null) { Globals.conn.Close(); } } try { DiskFileDestinationOptions diskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions formatOptions = new PdfRtfWordFormatOptions(); NOMFICHJOINT = Nommail + " " + DateTime.Now.ToString("yyyy_MM_dd HH_mm_ss"); diskFileDestinationOptions.DiskFileName = "C:\\SIGC utility\\Fichier joint\\" + NOMFICHJOINT + ".pdf"; MyProject.Forms.Mail.chemin.Text = "C:\\SIGC utility\\Fichier joint\\" + NOMFICHJOINT + ".pdf"; ExportOptions exportOptions = cryRpt.ExportOptions; ExportOptions exportOptions2 = exportOptions; exportOptions2.ExportDestinationType = ExportDestinationType.DiskFile; exportOptions2.ExportFormatType = ExportFormatType.PortableDocFormat; exportOptions2.DestinationOptions = diskFileDestinationOptions; exportOptions2.FormatOptions = formatOptions; exportOptions2 = null; cryRpt.Export(); MyProject.Forms.Mail.Show(); MyProject.Forms.Mail.BringToFront(); MyProject.Forms.Mail.pathT.Text = "C:\\SIGC utility\\Fichier joint\\" + NOMFICHJOINT + ".pdf"; MyProject.Forms.Mail.AjoutFJ_Click(RuntimeHelpers.GetObjectValue(sender), e); } catch (Exception ex3) { ProjectData.SetProjectError(ex3); Exception ex4 = ex3; Interaction.MsgBox(ex4.ToString(), MsgBoxStyle.OkOnly, null); ProjectData.ClearProjectError(); } }
public void SetParameter(string parameterName, params object[] parameters) { ParameterValues currentParameterValues = new ParameterValues(); for (int i = 0; i < parameters.Length; i++) { ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); parameterDiscreteValue.Value = parameters[i].ToString(); currentParameterValues.Add(parameterDiscreteValue); } ParameterFieldDefinitions parameterFieldDefinitions = _report.DataDefinition.ParameterFields; ParameterFieldDefinition parameterFieldDefinition = parameterFieldDefinitions[parameterName]; parameterFieldDefinition.ApplyCurrentValues(currentParameterValues); }
private void btnImprimir_Click(object sender, EventArgs e) { string cTitulo = ""; string cUsuario = frmLogin.cUsuarioActual;; if (txtCedula.Text == "" || txtID.Text == "") { MessageBox.Show("El Campo Cedulo o ID no Debe Estar en Blanco, Favor Verificar", "Sistema Medico", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { try { StringBuilder sbQuery = new StringBuilder(); MySqlConnection oMiclsConexion = new MySqlConnection(cclsConexion); MySqlCommand oComando = new MySqlCommand(); MySqlDataAdapter oAdaptador = new MySqlDataAdapter(); DataTable dtPaciente = new DataTable(); oMiclsConexion.Open(); oComando = oMiclsConexion.CreateCommand(); oComando.Connection = oMiclsConexion; sbQuery.Clear(); sbQuery.Append("SELECT paciente.id_paciente,paciente.cedula,paciente.nombre,"); sbQuery.Append("paciente.apellido,paciente.edad,paciente.sexo,paciente.dato_nacimiento,"); sbQuery.Append("paciente.dato_alimentacion, paciente.dato_condicionespsicologicas, "); sbQuery.Append("paciente.dato_sexualidad, paciente.dato_operaciones, "); sbQuery.Append("paciente.dato_intoleranciamedicinal, paciente.dato_saludpadres, "); sbQuery.Append("paciente.dato_saludhermanos, paciente.dato_saludesposahijos,"); sbQuery.Append("paciente.dato_saludfamiliargeneral, paciente.fecharegistro, paciente.fechaupdate,"); sbQuery.Append("rangos.rango_descripcion"); sbQuery.Append(" from paciente"); sbQuery.Append(" inner join rangos on rangos.rango_id = paciente.rango"); sbQuery.Append(" where paciente.id_paciente = " + txtID.Text + ""); //sbQuery.Append(""); //sbQuery.Append(""); //sbQuery.Append(""); oComando.CommandText = sbQuery.ToString(); oAdaptador = new MySqlDataAdapter(oComando); oAdaptador.Fill(dtPaciente); //oComando.Dispose(); //oMiclsConexion.Close(); int nRegistros = dtPaciente.Rows.Count; if (nRegistros == 0) { MessageBox.Show("No Hay Datos Para Mostrar, Favor Verificar", "Sistema Medico", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { //1ero.HACEMOS LA COLECCION DE PARAMETROS //los campos de parametros contiene un objeto para cada campo de parametro en el informe ParameterFields oParametrosCR = new ParameterFields(); //Proporciona propiedades para la recuperacion y configuracion del tipo de los parametros ParameterValues oParametrosValuesCR = new ParameterValues(); //2do.CREAMOS LOS PARAMETROS ParameterField oUsuario = new ParameterField(); //parametervaluetype especifica el TIPO de valor de parametro //ParameterValueKind especifica el tipo de valor de parametro en la PARAMETERVALUETYPE de la Clase PARAMETERFIELD oUsuario.ParameterValueType = ParameterValueKind.StringParameter; //3ero.VALORES PARA LOS PARAMETROS //ParameterDiscreteValue proporciona propiedades para la recuperacion y configuracion de //parametros de valores discretos ParameterDiscreteValue oUsuarioDValue = new ParameterDiscreteValue(); oUsuarioDValue.Value = cUsuario; //4to. AGREGAMOS LOS VALORES A LOS PARAMETROS oUsuario.CurrentValues.Add(oUsuarioDValue); //5to. AGREGAMOS LOS PARAMETROS A LA COLECCION oParametrosCR.Add(oUsuario); //nombre del parametro en CR (Crystal Reports) oParametrosCR[0].Name = "cUsuario"; //nombre del TITULO DEL INFORME cTitulo = "ANTECEDENTES PERSONALES"; //6to Instanciamos nuestro REPORTE Reportes.RepAntecedentes oRepAntecedente = new Reportes.RepAntecedentes(); //pasamos el nombre del TITULO del Listado //SumaryInfo es un objeto que se utiliza para leer,crear y actualizar las propiedades del reporte oRepAntecedente.SummaryInfo.ReportTitle = cTitulo; frmPrinter oFrmPrinter = new frmPrinter(dtPaciente, oRepAntecedente, cTitulo); oFrmPrinter.CrystalReportViewer1.ParameterFieldInfo = oParametrosCR; oFrmPrinter.ShowDialog(); } } catch (Exception myEx) { //MessageBox.Show(myEx.Message); //throw; } } }