public void INHOADON(string ms)
{
//----------1.Khai báo CrystalReport: CrystalReportHD.rpt
rp_DonHang rp = new rp_DonHang();
//----------2.Cung cấp thông tin đăng nhập cho CrystalReport: CrystalReportHD
ConnectionInfo myConn = new ConnectionInfo();
myConn.ServerName = frmDangnhap.SV;
myConn.DatabaseName = frmDangnhap.DB;
myConn.UserID = frmDangnhap.ID;
myConn.Password = frmDangnhap.PASS;
TableLogOnInfo myTable = new TableLogOnInfo();
myTable.ConnectionInfo = myConn;
rp.Database.Tables[0].ApplyLogOnInfo(myTable);
//----------3.Khai báo kết nối tham số với CrystalReport
CrystalDecisions.Shared.ParameterValues myVL = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue PDVMaHD = new CrystalDecisions.Shared.ParameterDiscreteValue();
//----------4. Truyền tham số Từ ngày - Đến ngày (Form)
//-----4.1. Truyền tham số Từ ngày
PDVMaHD.Value = ms;
myVL.Add(PDVMaHD);
rp.DataDefinition.ParameterFields["@MSHD"].ApplyCurrentValues(myVL);
myVL.Clear();
//-----------5.Gán CrystalReport vào crystalReportViewerP
crystalReportViewerHD.ReportSource = rp;
}
/// <summary>
/// Sets the parameters that have been added using the SetParameter method
/// </summary>
private void SetParameters()
{
foreach (ParameterFieldDefinition parameter in _reportDocument.DataDefinition.ParameterFields)
{
try
{
// Now get the current value for the parameter
CrystalDecisions.Shared.ParameterValues currentValues = parameter.CurrentValues;
currentValues.Clear();
// Create a value object for Crystal reports and assign the specified value.
CrystalDecisions.Shared.ParameterDiscreteValue newValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
if (_parameters.ContainsKey(parameter.Name))
{
newValue.Value = _parameters[parameter.Name];
// Now add the new value to the values collection and apply the
// collection to the report.
currentValues.Add(newValue);
parameter.ApplyCurrentValues(currentValues);
}
else
{
parameter.ApplyCurrentValues(parameter.DefaultValues);
}
}
catch
{
// Ignore any errors
}
}
}
public void PassParameter(int ParameterIndex, string ParameterValue)
{
// '
// ' Declare the parameter related objects.
// '
ParameterDiscreteValue crParameterDiscreteValue;
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldLocation;
ParameterValues crParameterValues;
// '
// ' Get the report's parameters collection.
// '
//string msg = "Improper parameter list, Parameter defined at report do not match with parameter passed to report " +
// "\nReport Path = " + ReportPath +
// "\n" + originalParamList +
// "\n" + passedParameterList;
//LM_BaseClass.LM_LogError(msg);
//throw new Exception(msg);
crParameterFieldDefinitions = crReportDocument.DataDefinition.ParameterFields;
crParameterFieldLocation = (ParameterFieldDefinition)crParameterFieldDefinitions[ParameterIndex];
crParameterValues = crParameterFieldLocation.CurrentValues;
crParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
crParameterDiscreteValue.Value = System.Convert.ToString(ParameterValue);
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldLocation.ApplyCurrentValues(crParameterValues);
}
private void btnReport_Click(object sender, EventArgs e)
{
CR_MHTuDen rp = new CR_MHTuDen();
CrystalDecisions.Shared.ParameterValues myValue = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue PDVTuNgay = new CrystalDecisions.Shared.ParameterDiscreteValue();
CrystalDecisions.Shared.ParameterDiscreteValue PDVDenNgay = new CrystalDecisions.Shared.ParameterDiscreteValue();
CrystalDecisions.Shared.ConnectionInfo con = new CrystalDecisions.Shared.ConnectionInfo();
con.ServerName = frmDangnhap.SV;
con.DatabaseName = frmDangnhap.DB;
con.UserID = frmDangnhap.ID;
con.Password = frmDangnhap.PASS;
TableLogOnInfo table = new TableLogOnInfo();
table.ConnectionInfo = con;
rp.Database.Tables[0].ApplyLogOnInfo(table);
PDVTuNgay.Value = this.txtDayStart.Value;
myValue.Add(PDVTuNgay);
rp.DataDefinition.ParameterFields["@TUNGAY"].ApplyCurrentValues(myValue);
myValue.Clear();
PDVDenNgay.Value = this.txtDayEnd.Value;
myValue.Add(PDVDenNgay);
rp.DataDefinition.ParameterFields["@DENNGAY"].ApplyCurrentValues(myValue);
myValue.Clear();
this.crystalReportViewer1.ReportSource = rp;
}
public static void PrintReceipt(string salesOrderNo)
{
try
{
string receiptPath = factory.MasterDataBroker.GetReceiptPath();
if (string.IsNullOrEmpty(receiptPath))
return;
ReportDocument receipt = new ReportDocument();
receipt.Load(receiptPath);
string conString = BMResto.BO.General.ConnectionHelper.BMRestoConnectionString;
string[] conStringDetails = conString.Split(';');
string server = conStringDetails.SingleOrDefault(o => o.Contains("Data Source")).Split('=')[1];
string db = conStringDetails.SingleOrDefault(o => o.Contains("Initial Catalog")).Split('=')[1];
string userName = conStringDetails.SingleOrDefault(o => o.Contains("User ID")).Split('=')[1];
string password = conStringDetails.SingleOrDefault(o => o.Contains("Password")).Split('=')[1];
receipt.SetDatabaseLogon(userName, password, server, db);
foreach (CrystalDecisions.CrystalReports.Engine.Table table in receipt.Database.Tables)
{
TableLogOnInfo logOnInfo = table.LogOnInfo;
if (logOnInfo != null)
{
logOnInfo.TableName = table.Name;
logOnInfo.ConnectionInfo.DatabaseName = db;
logOnInfo.ConnectionInfo.Password = password;
logOnInfo.ConnectionInfo.UserID = userName;
logOnInfo.ConnectionInfo.ServerName = server;
table.ApplyLogOnInfo(logOnInfo);
}
}
// order no
ParameterDiscreteValue pfDiscrete = new CrystalDecisions.Shared.ParameterDiscreteValue();
pfDiscrete.Value = salesOrderNo;
SetParameterValue("orderNo", receipt, pfDiscrete);
// cashier
ParameterDiscreteValue pfCashier = new CrystalDecisions.Shared.ParameterDiscreteValue();
pfCashier.Value = MembershipHelper.CurrentUserName;
SetParameterValue("cashier", receipt, pfCashier);
receipt.PrintToPrinter(1, false, 0, 1);
}
catch
{
throw;
}
}
private void button3_Click(object sender, EventArgs e)
{
if (!PowerCheckCsClass.IfHasPower(LoginClass.LogID, CommFunction.GSYSNAME, sender, CommFunction.ConnectString))
{
return;
}
if ((tbGzbdh.Text.Trim() == "") || tbGzbdh.Text == null)
{
return;
}
LYFunctionCs.frmReportView frv = new LYFunctionCs.frmReportView();
ReportDocument Rpt = new ReportDocument();
string pRptNmae = "";
pRptNmae = LYFunctionCs.LYFunctionCsClass.cmdScalar("select cm.report_file from cc_cold_chain_c cc left join cc_cold_chain_z cz on cc.pkunid=cz.unid left join cc_item_master cm on cc.size_desc=cm.size_desc and cm.season=cz.season where pkunid='" + tbGzbdh.Text + "' and cm.report_file is not null and rownum=1 ", CommFunction.ConnectString);
if ((pRptNmae.Trim() == "") || (pRptNmae == null))
{
pRptNmae = "Rep_CC_ITEM_TRACK.rpt";
}
Rpt.Load(AppDomain.CurrentDomain.SetupInformation.ApplicationBase + pRptNmae);
TableLogOnInfo logOnInfo = new TableLogOnInfo();
logOnInfo.ConnectionInfo.ServerName = CommFunction.cfServerName;
logOnInfo.ConnectionInfo.UserID = CommFunction.cfUserID;
logOnInfo.ConnectionInfo.Password = CommFunction.cfPassword;
Rpt.Database.Tables[0].ApplyLogOnInfo(logOnInfo);
//Rpt.Refresh();
frv.crystalReportViewer1.ReportSource = Rpt;
CrystalDecisions.Shared.ParameterValues mypaVal = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue mypaDVal = new CrystalDecisions.Shared.ParameterDiscreteValue();
mypaDVal.Value = tbGzbdh.Text;
mypaVal.Add(mypaDVal);
Rpt.DataDefinition.ParameterFields["GZBDH"].ApplyCurrentValues(mypaVal);
frv.ShowDialog();
}
///
/// Set parameter value in crystal report on corresponding index
///
public void PassParameter(int ParameterIndex, string ParameterValue)
{
// '
// ' Declare the parameter related objects.
// '
ParameterDiscreteValue crParameterDiscreteValue;
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldLocation;
ParameterValues crParameterValues;
crParameterFieldDefinitions = crReportDocument.DataDefinition.ParameterFields;
crParameterFieldLocation = (ParameterFieldDefinition)crParameterFieldDefinitions[ParameterIndex];
crParameterValues = crParameterFieldLocation.CurrentValues;
crParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
crParameterDiscreteValue.Value = System.Convert.ToString(ParameterValue);
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldLocation.ApplyCurrentValues(crParameterValues);
}
///
/// Set parameter value in crystal report on corresponding index
///
public void PassParameter(int ParameterIndex, string ParameterValue)
{
// '
// ' Declare the parameter related objects.
// '
ParameterDiscreteValue crParameterDiscreteValue;
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldLocation;
ParameterValues crParameterValues;
crParameterFieldDefinitions = crReportDocument.DataDefinition.ParameterFields;
crParameterFieldLocation = (ParameterFieldDefinition)crParameterFieldDefinitions[ParameterIndex];
crParameterValues = crParameterFieldLocation.CurrentValues;
crParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
crParameterDiscreteValue.Value = System.Convert.ToString(ParameterValue);
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldLocation.ApplyCurrentValues(crParameterValues);
}
///
/// Set parameter value in crystal report on corresponding index
///
private void PassParameter(string Name, object Value)
{
// '
// ' Declare the parameter related objects.
// '
ParameterDiscreteValue crParameterDiscreteValue;
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldLocation;
ParameterValues crParameterValues;
crParameterFieldDefinitions = rptDoc.DataDefinition.ParameterFields;
crParameterFieldLocation = (ParameterFieldDefinition)crParameterFieldDefinitions[Name];
crParameterValues = crParameterFieldLocation.CurrentValues;
crParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
crParameterDiscreteValue.Value = Value;
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldLocation.ApplyCurrentValues(crParameterValues);
}
/// <summary>
/// Adds a discrete parameteer value
/// </summary>
/// <param name="ParameterName">The namee of the parameter to set</param>
/// <param name="value">The value of the parameter</param>
public void AddDiscreteValue(string ParameterName, object value)
{
try
{
//Create a new Parameter Field
CrystalDecisions.Shared.ParameterField oParameterField = new CrystalDecisions.Shared.ParameterField();
oParameterField.Name = ParameterName;
//Create a new Discrete Value
CrystalDecisions.Shared.ParameterDiscreteValue oParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
oParameterDiscreteValue.Value = value;
//Add the value
oParameterField.CurrentValues.Add(oParameterDiscreteValue);
//Add the parameter field
this.CampuriParametrii.Add(oParameterField);
}
catch (Exception)
{
throw;
}
}
private void button3_Click(object sender, EventArgs e)
{
if (!PowerCheckCsClass.IfHasPower(LoginClass.LogID, CommFunction.GSYSNAME, sender, CommFunction.ConnectString)) return;
if ((tbUnid.Text.Trim() == "") || tbUnid.Text == null) { return; }
LYFunctionCs.frmReportView frv = new LYFunctionCs.frmReportView();
ReportDocument Rpt = new ReportDocument();
string pRptNmae = "";
pRptNmae = LYFunctionCs.LYFunctionCsClass.cmdScalar("select cm.report_file from cc_cold_chain_c cc left join cc_cold_chain_z cz on cc.pkunid=cz.unid left join cc_item_master cm on cc.size_desc=cm.size_desc and cm.season=cz.season where pkunid='" + tbUnid.Text + "' and cm.report_file is not null and rownum=1 ", CommFunction.ConnectString);
if ((pRptNmae.Trim() == "") || (pRptNmae == null))
pRptNmae = "Rep_CC_ITEM_TRACK.rpt";
Rpt.Load(AppDomain.CurrentDomain.SetupInformation.ApplicationBase + pRptNmae);
TableLogOnInfo logOnInfo = new TableLogOnInfo();
logOnInfo.ConnectionInfo.ServerName = CommFunction.cfServerName;
logOnInfo.ConnectionInfo.UserID = CommFunction.cfUserID;
logOnInfo.ConnectionInfo.Password = CommFunction.cfPassword;
Rpt.Database.Tables[0].ApplyLogOnInfo(logOnInfo);
//Rpt.Refresh();
frv.crystalReportViewer1.ReportSource = Rpt;
CrystalDecisions.Shared.ParameterValues mypaVal = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue mypaDVal = new CrystalDecisions.Shared.ParameterDiscreteValue();
mypaDVal.Value = tbUnid.Text;
mypaVal.Add(mypaDVal);
Rpt.DataDefinition.ParameterFields["GZBDH"].ApplyCurrentValues(mypaVal);
frv.ShowDialog();
LYFunctionCs.LYFunctionCsClass.cmd("update cc_cold_chain_z set ifprint='1' where UNID='"+tbUnid.Text+"'", CommFunction.ConnectString);
}
public void PassParameter(int ParameterIndex, string ParameterValue)
{
// '
// ' Declare the parameter related objects.
// '
ParameterDiscreteValue crParameterDiscreteValue;
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldLocation;
ParameterValues crParameterValues;
// '
// ' Get the report's parameters collection.
// '
//string msg = "Improper parameter list, Parameter defined at report do not match with parameter passed to report " +
// "\nReport Path = " + ReportPath +
// "\n" + originalParamList +
// "\n" + passedParameterList;
//LM_BaseClass.LM_LogError(msg);
//throw new Exception(msg);
crParameterFieldDefinitions = crReportDocument.DataDefinition.ParameterFields;
crParameterFieldLocation = (ParameterFieldDefinition)crParameterFieldDefinitions[ParameterIndex];
crParameterValues = crParameterFieldLocation.CurrentValues;
crParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
crParameterDiscreteValue.Value = System.Convert.ToString(ParameterValue);
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldLocation.ApplyCurrentValues(crParameterValues);
}
private void CargaRpt()
{
reporte = new ReportDocument();
try
{
// ReportDocument reporte = new ReportDocument();
//reporte.Close();
//reporte.
string RutaRpt = Reporte.Ruta_Reporte;// "C:/Reportes/" + Reporte;
reporte.Load(RutaRpt);
ConnectionInfo CnnReport = new ConnectionInfo();
Tables MyTablas = reporte.Database.Tables;
CnnReport.ServerName = Reporte.Base_de_Datos;
CnnReport.UserID = Reporte.User_de_Datos;
CnnReport.Password = Reporte.Pass_de_Datos;
foreach (CrystalDecisions.CrystalReports.Engine.Table MyTabla in MyTablas)
{
TableLogOnInfo Tbl_LoginInfo = MyTabla.LogOnInfo;
Tbl_LoginInfo.ConnectionInfo = CnnReport;
MyTabla.ApplyLogOnInfo(Tbl_LoginInfo);
}
ParameterDiscreteValue NewParamVal = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterValues CurrParamVal;
//Busca automaticamente tdos los parametros de entrada includo los parametros de los subreportes
for (int intI = 0; (intI <= reporte.DataDefinition.ParameterFields.Count - 1); intI++)
{
if (reporte.ParameterFields[intI].ReportParameterType != ParameterType.ReportParameter)
{
string nombre = reporte.DataDefinition.ParameterFields[intI].Name;
string X = reporte.DataDefinition.ParameterFields[intI].ValueType.ToString();
NewParamVal.Value = Reporte.Rpt_RetornaValorParam(nombre);
NewParamVal.Description = nombre;
CurrParamVal = reporte.DataDefinition.ParameterFields[intI].CurrentValues;
CurrParamVal.Clear();
CurrParamVal.Add(NewParamVal);
reporte.DataDefinition.ParameterFields[intI].ApplyCurrentValues(CurrParamVal);
}
}
if (Pordonde == 1)
{
CRV.ReportSource = reporte; // Asigno los resultados del reporte al Visor de Crystal Report
}
else
{
if (Formulario == null)
{
if (Impresora == null)
{
reporte.PrintToPrinter(1, false, 0, 0); //copies, collated, startpage, endpage
}
else
{
reporte.PrintToPrinter(Impresora, Pagina, false);
}
return;
}
else
{
CRV.ReportSource = reporte;
this.Show(Formulario);
}
}
//reporte.Close();
}
catch (Exception er)
{
reporte = null;
Reporte = null;
MessageBox.Show("Error: " + er.Message);
return;
}
}
private void AsignarParametros(double p)
{
CrystalDecisions.Shared.ParameterValues myVals = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue myDiscrete = new CrystalDecisions.Shared.ParameterDiscreteValue();
myDiscrete.Value = NumALet.ToCardinal(Convert.ToDecimal(p));
myVals.Add(myDiscrete);
facturaRpt.DataDefinition.ParameterFields[0].ApplyCurrentValues(myVals);
}
/// <summary>
/// Constructor de la clase
/// </summary>
/// <param name="Reporte">Ruta y Nombre del reporte</param>
/// <param name="Parametros">Parámetros que requiere el reporte ejemplo: clave=1</param>
/// <param name="Servidor">Servidor donde se encuentra la base de datos</param>
/// <param name="Base">Nombre de la Base de Datos</param>
/// <param name="Usuario">Nombre de usuario con permiso de acceso</param>
/// <param name="PW">Contraseña o Password del usuario</param>
public ClaseReporte(string Reporte, ArrayList Parametros, string Servidor, string Base, string Usuario, string PW)
{
if (File.Exists(Reporte))
{
try
{
this._strReporte = Reporte;
this._arrPar = (ArrayList)Parametros.Clone();
this._strServidor = Servidor;
this._strBase = Base;
this._strUsuario = Usuario;
this._strPW = PW;
try
{
RepDoc.FileName = Reporte;
}
catch
{
}
RepDoc.Load(Reporte);
//Variables
TableLogOnInfo _LogonInfo;
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
CrystalDecisions.Shared.ParameterValues crParametervalues;
CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscretValue;
string TablaNombre = "";
string strValor = "";
//Pasa los datos de la conexion al reporte principal
RepDoc.SetDatabaseLogon(Usuario, PW, Servidor, Base);
foreach (CrystalDecisions.CrystalReports.Engine.Table _TablaReporte in RepDoc.Database.Tables)
{
_LogonInfo = _TablaReporte.LogOnInfo;
_LogonInfo.ConnectionInfo.ServerName = Servidor;
_LogonInfo.ConnectionInfo.DatabaseName = Base;
_LogonInfo.ConnectionInfo.UserID = Usuario;
_LogonInfo.ConnectionInfo.Password = PW;
try
{
_TablaReporte.ApplyLogOnInfo(_LogonInfo);
}
catch (Exception ex)
{
this._strError = ex.ToString();
}
//pasa un datatable al reporte
TablaNombre = "";
if (_TablaReporte.Name.IndexOf(";") > 0)
{
TablaNombre = _TablaReporte.Name.Substring(0, _TablaReporte.Name.IndexOf(";"));
}
else
{
TablaNombre = _TablaReporte.Name;
}
}
//Pasa los valores a los parametros
System.Data.SqlClient.SqlCommand cmdRep = SeguridadCB.Seguridad.Conexion.CreateCommand();
cmdRep.CommandType = CommandType.StoredProcedure;
cmdRep.CommandText = TablaNombre;
crParameterFieldDefinitions = RepDoc.DataDefinition.ParameterFields;
foreach (ParameterFieldDefinition par in RepDoc.DataDefinition.ParameterFields)
{
try
{
if (Existe_Parametro(Parametros, par.Name))
{
crParameterFieldDefinition = crParameterFieldDefinitions[par.Name];
//crParameterFieldDefinition = crParameterFieldDefinitions[par.Name, par.ReportName];
crParametervalues = crParameterFieldDefinition.CurrentValues;
crParameterDiscretValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
strValor = Leer_Valor_Parametro(Parametros, par.Name);
crParameterDiscretValue.Value = strValor;
crParametervalues.Add(crParameterDiscretValue);
crParameterFieldDefinition.ApplyCurrentValues(crParametervalues);
//RepDoc.SetParameterValue(par.Name, strValor);
System.Data.SqlClient.SqlParameter parNuevo = new System.Data.SqlClient.SqlParameter();
parNuevo.ParameterName = par.Name;
parNuevo.Value = strValor;
if (!cmdRep.Parameters.Contains(par.Name))
{
cmdRep.Parameters.Add(parNuevo);
}
}
}
catch (Exception ex)
{
this._strError = ex.ToString();
}
}
System.Data.SqlClient.SqlDataAdapter daRep = new System.Data.SqlClient.SqlDataAdapter();
daRep.SelectCommand = cmdRep;
System.Data.DataTable dtRep = new DataTable(TablaNombre);
daRep.Fill(dtRep);
RepDoc.SetDataSource(dtRep);
//Pasa los parametros a los subreportes
foreach (CrystalDecisions.CrystalReports.Engine.ReportDocument lRepDoc in RepDoc.Subreports)
//foreach (CrystalDecisions.CrystalReports.Engine.ReportObject sRepObj in RepDoc.ReportDefinition.ReportObjects)
{
//ReportDocument lRepDoc = OpenSubreport(RepDoc, sRepObj.Name);
if (lRepDoc != null)
{
lRepDoc.SetDatabaseLogon(Usuario, PW, Servidor, Base);
foreach (CrystalDecisions.CrystalReports.Engine.Table _TablasReporte in lRepDoc.Database.Tables)
{
_LogonInfo = _TablasReporte.LogOnInfo;
_LogonInfo.ConnectionInfo.ServerName = Servidor;
_LogonInfo.ConnectionInfo.DatabaseName = Base;
_LogonInfo.ConnectionInfo.UserID = Usuario;
_LogonInfo.ConnectionInfo.Password = PW;
try
{
_TablasReporte.ApplyLogOnInfo(_LogonInfo);
}
catch (Exception ex)
{
this._strError = ex.ToString();
}
//pasa un datatable al reporte
TablaNombre = "";
if (_TablasReporte.Name.IndexOf(";") > 0)
{
TablaNombre = _TablasReporte.Name.Substring(0, _TablasReporte.Name.IndexOf(";"));
}
else
{
TablaNombre = _TablasReporte.Name;
}
}
//Pasa los valores a los parametros
System.Data.SqlClient.SqlCommand cmdsRep = SeguridadCB.Seguridad.Conexion.CreateCommand();
cmdsRep.CommandType = CommandType.StoredProcedure;
cmdsRep.CommandText = TablaNombre;
crParameterFieldDefinitions = lRepDoc.DataDefinition.ParameterFields;
foreach (ParameterFieldDefinition par in lRepDoc.DataDefinition.ParameterFields)
{
try
{
if (Existe_Parametro(Parametros, par.Name))
{
crParameterFieldDefinition = crParameterFieldDefinitions[par.Name];
//crParameterFieldDefinition = crParameterFieldDefinitions[par.Name, par.ReportName];
crParametervalues = crParameterFieldDefinition.CurrentValues;
crParameterDiscretValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
strValor = Leer_Valor_Parametro(Parametros, par.Name);
crParameterDiscretValue.Value = strValor;
crParametervalues.Add(crParameterDiscretValue);
crParameterFieldDefinition.ApplyCurrentValues(crParametervalues);
//lRepDoc.SetParameterValue(par.Name, strValor);
System.Data.SqlClient.SqlParameter parNuevo = new System.Data.SqlClient.SqlParameter();
parNuevo.ParameterName = par.Name;
parNuevo.Value = strValor;
if (!cmdsRep.Parameters.Contains(par.Name))
{
cmdsRep.Parameters.Add(parNuevo);
}
}
}
catch (Exception ex)
{
this._strError = ex.ToString();
}
}
System.Data.SqlClient.SqlDataAdapter dasRep = new System.Data.SqlClient.SqlDataAdapter();
cmdsRep.CommandType = CommandType.StoredProcedure;
dasRep.SelectCommand = cmdsRep;
System.Data.DataTable dtsRep = new DataTable(TablaNombre);
dasRep.Fill(dtsRep);
try
{
lRepDoc.SetDataSource(dtsRep);
}
catch (Exception exs)
{
this._strError = exs.ToString();
}
}
//RepDoc.VerifyDatabase();
}
}
catch (Exception ex)
{
this._strError = ex.ToString();
}
}
else
{
this._strError = "No existe el reporte en la ruta especificada";
}
}
private void SetCrysParams(string respar, string IdConcretera, string IdDiam, string Prueba)
{
ParameterValues pvs = new CrystalDecisions.Shared.ParameterValues();
ParameterDiscreteValue pdvRazonsocial = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvObraUbicacion = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvObraColonia = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvTipoPrueba = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvExp3 = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvExp7 = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvUnidad = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvSINO = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvConsecutivo = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvRes = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvConcre = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvDiam = new CrystalDecisions.Shared.ParameterDiscreteValue();
pdvRazonsocial.Value = strRazonSocial;
pvs.Add(pdvRazonsocial);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Razonsocial"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvObraUbicacion.Value = strObraUbicacion;
pvs.Add(pdvObraUbicacion);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["ObraUbicacion"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvObraColonia.Value = strObraColonia;
pvs.Add(pdvObraColonia);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["ObraColonia"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvTipoPrueba.Value = Prueba;
pvs.Add(pdvTipoPrueba);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["TipoPrueba"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvUnidad.Value = dsUnidad1.Unidad.Rows[Mpa][0].ToString();
pvs.Add(pdvUnidad);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Unidad"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvSINO.Value = 0;
pvs.Add(pdvSINO);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Logotipo"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvConsecutivo.Value = "0";
pvs.Add(pdvConsecutivo);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Consecutivo"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvRes.Value = respar;
pvs.Add(pdvRes);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Res"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvConcre.Value = IdConcretera;
pvs.Add(pdvConcre);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Concre"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvDiam.Value = IdDiam;
pvs.Add(pdvDiam);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Diam"].ApplyCurrentValues(pvs);
pvs.Clear();
// pdvRes1.Value = double.Parse(resis) ;
// pvs.Add(pdvRes1);
// cryRepCartaEdadTemprana.DataDefinition.ParameterFields["Res1"].ApplyCurrentValues(pvs);
// pvs.Clear();
}
/// <summary>
/// Constructor de la clase
/// </summary>
/// <param name="Reporte">Ruta y Nombre del reporte</param>
/// <param name="Parametros">Parámetros que requiere el reporte ejemplo: clave=1</param>
/// <param name="Servidor">Servidor donde se encuentra la base de datos</param>
/// <param name="Base">Nombre de la Base de Datos</param>
/// <param name="Usuario">Nombre de usuario con permiso de acceso</param>
/// <param name="PW">Contraseña o Password del usuario</param>
public Clase_Reporte(string Reporte, ArrayList Parametros, string Servidor, string Base, string Usuario, string PW)
{
if (File.Exists(Reporte))
{
try
{
this._strReporte = Reporte;
this._arrPar = (ArrayList)Parametros.Clone();
if (Servidor.Trim().Length > 0)
{
this._strServidor = Servidor;
}
if (Base.Trim().Length > 0)
{
this._strBase = Base;
}
if (Usuario.Trim().Length > 0)
{
this._strUsuario = Usuario;
}
if (PW.Trim().Length > 0)
{
this._strPW = PW;
}
RepDoc.Load(Reporte);
//Pasa los datos de la conexion
TableLogOnInfo _LogonInfo;
foreach (CrystalDecisions.CrystalReports.Engine.Table _TablaReporte in RepDoc.Database.Tables)
{
_LogonInfo = _TablaReporte.LogOnInfo;
if (Servidor.Trim().Length > 0 && Servidor.Trim() != _LogonInfo.ConnectionInfo.ServerName)
{
_LogonInfo.ConnectionInfo.ServerName = Servidor.Trim();
}
if (Base.Trim().Length > 0 && Base.Trim() != _LogonInfo.ConnectionInfo.DatabaseName)
{
_LogonInfo.ConnectionInfo.DatabaseName = Base.Trim();
}
if (Usuario.Trim().Length > 0 && Usuario.Trim() != _LogonInfo.ConnectionInfo.UserID)
{
_LogonInfo.ConnectionInfo.UserID = Usuario.Trim();
}
if (PW.Trim().Length > 0 && PW.Trim() != _LogonInfo.ConnectionInfo.Password)
{
_LogonInfo.ConnectionInfo.Password = PW.Trim();
}
try
{
_TablaReporte.ApplyLogOnInfo(_LogonInfo);
}
catch (ArgumentNullException exArgumentos)
{
}
catch (Exception ex)
{
}
}
//Pasa los valores a los parametros
string strValor = "";
int inti = 0;
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
CrystalDecisions.Shared.ParameterValues crParametervalues;
CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscretValue;
crParameterFieldDefinitions = RepDoc.DataDefinition.ParameterFields;
foreach (ParameterFieldDefinition par in RepDoc.DataDefinition.ParameterFields)
{
try
{
if (Existe_Parametro(Parametros, par.Name))
{
//crParameterFieldDefinition = crParameterFieldDefinitions[par.Name];
crParameterFieldDefinition = crParameterFieldDefinitions[par.Name];
crParametervalues = crParameterFieldDefinition.CurrentValues;
crParameterDiscretValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
strValor = Leer_Valor(Parametros, par.Name);
crParameterDiscretValue.Value = strValor;
crParametervalues.Add(crParameterDiscretValue);
crParameterFieldDefinition.ApplyCurrentValues(crParametervalues);
inti = inti + 1;
}
}
catch (Exception ex)
{
this._strError = ex.ToString();
}
}
}
catch (Exception ex)
{
this._strError = ex.ToString();
}
}
else
{
this._strError = "No existe el reporte en la ruta especificada";
}
}
/// <summary>
/// Sets the parameters that have been added using the SetParameter method
/// </summary>
private void SetParameters()
{
foreach (ParameterFieldDefinition parameter in _reportDocument.DataDefinition.ParameterFields)
{
try
{
// Now get the current value for the parameter
CrystalDecisions.Shared.ParameterValues currentValues = parameter.CurrentValues;
currentValues.Clear();
// Create a value object for Crystal reports and assign the specified value.
CrystalDecisions.Shared.ParameterDiscreteValue newValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
if (_parameters.ContainsKey(parameter.Name))
{
newValue.Value = _parameters[parameter.Name];
// Now add the new value to the values collection and apply the
// collection to the report.
currentValues.Add(newValue);
parameter.ApplyCurrentValues(currentValues);
}
else
{
parameter.ApplyCurrentValues(parameter.DefaultValues);
}
}
catch
{
// Ignore any errors
}
}
}
void previewID()
{
try
{
CrystalDecisions.CrystalReports.Engine.ReportDocument objReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
CrystalDecisions.Shared.TableLogOnInfos crtableLogoninfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
CrystalDecisions.Shared.ConnectionInfo crConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
CrystalDecisions.CrystalReports.Engine.Tables CrTables;
CrystalDecisions.Shared.ParameterValues crParameterValues = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
//objReport.Load(LoadReport());
objReport.Load(_path + _reportName_Outside);
string sUserID = "sa";
string sPassword = "******";
string sServerName = "192.168.1.42";
string sDatabaseName = "HRIS";
crConnectionInfo.ServerName = sServerName;
crConnectionInfo.DatabaseName = sDatabaseName;
crConnectionInfo.UserID = sUserID;
crConnectionInfo.Password = sPassword;
CrTables = objReport.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
ConInfo = CrTable.LogOnInfo;
ConInfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(ConInfo);
}
reportViewer.ViewerCore.ReportSource = objReport;
//rekta print
//objReport.PrintToPrinter(1, true, 0, 0);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void FillParams(PLCrystalReportViewer view)
{
if (mParameters != null)
{
CrystalDecisions.Shared.ParameterFields pars = new CrystalDecisions.Shared.ParameterFields();
foreach (string varKey in mParameters.Keys)
{
object tempValue;
mParameters.TryGetValue(varKey, out tempValue);
CrystalDecisions.Shared.ParameterField paramField = new CrystalDecisions.Shared.ParameterField();
paramField.Name = varKey;
CrystalDecisions.Shared.ParameterDiscreteValue paramDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
paramDiscreteValue.Value = tempValue;
paramField.CurrentValues.Add(paramDiscreteValue);
pars.Add(paramField);
}
//view._I.ParameterFieldInfo = pars;//phien bản 12
view.ParameterFieldInfo = pars;//phien bản 10
}
}
