本文整理汇总了C#中ParameterFields类的典型用法代码示例。如果您正苦于以下问题:C# ParameterFields类的具体用法?C# ParameterFields怎么用?C# ParameterFields使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
ParameterFields类属于命名空间,在下文中一共展示了ParameterFields类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: btnSearch_Click_1
private void btnSearch_Click_1(object sender, EventArgs e)
{
try
{
string DoctorName;
int MedicalShopID;
int ProductID;
string StartDate;
string EndDate;
DoctorName = Convert.ToString(cbDoctor.Text);
MedicalShopID = Convert.ToInt32(cbMedicalShop.SelectedValue.ToString());
ProductID = Convert.ToInt32(cbProduct.SelectedValue.ToString());
StartDate = Convert.ToString(dtpStartDate.Text);
EndDate = Convert.ToString(dtpEndDate.Text);
ReportDocument reportDocument = new ReportDocument();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
string ReportPath = ConfigurationManager.AppSettings["ReportPath"];
paramField.Name = "@DoctorName";
paramField.Name = "@MedicalShopID";
paramField.Name = "@ProductID";
paramField.Name = "@StartDate";
paramField.Name = "@EndDate";
paramDiscreteValue.Value = 1;
reportDocument.Load(ReportPath+"Report\\Commission_CrystalReport.rpt");
ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.DatabaseName = "DB_MedicalShop_02Sept20159PM";
//connectionInfo.UserID = "wms";
//connectionInfo.Password = "wms";
connectionInfo.IntegratedSecurity = true;
SetDBLogonForReport(connectionInfo, reportDocument);
reportDocument.SetParameterValue("@DoctorName", DoctorName);
reportDocument.SetParameterValue("@MedicalShopID", MedicalShopID);
reportDocument.SetParameterValue("@ProductID", ProductID);
reportDocument.SetParameterValue("@StartDate", StartDate);
reportDocument.SetParameterValue("@EndDate", EndDate);
CommissionCrystalRpt.ReportSource = reportDocument;
CommissionCrystalRpt.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
开发者ID:Anshul0305,项目名称:lotas,代码行数:51,代码来源:Form_Commission_Details_Report.cs
示例2: ConfigureCrystalReports
/// <summary>
/// 產生報表
/// </summary>
private void ConfigureCrystalReports()
{
try
{
string strDate = Session[string.Format("{0}QueryDateRange", Request["TimeStamp"].ToString())].ToString();
if (strDate == "~") strDate = "";
string strTime = Session[string.Format("{0}QueryTimeRange", Request["TimeStamp"].ToString())].ToString();
if (strTime == "~") strTime = "";
customerReport = new ReportDocument();
//取得報表格式檔RPT
customerReport.Load(Server.MapPath("ITM061R.rpt"));
customerReport.SetDataSource((DataTable)Session[string.Format("{0}ITM061", Request["TimeStamp"].ToString())]);
ParameterFields par1 = new ParameterFields();
AddParameter("ProgramName", PageProgramName, par1);
ParameterFields par2 = new ParameterFields();
AddParameter("UserName", Session["UID"].ToString(), par2);
ParameterFields par3 = new ParameterFields();
AddParameter("QueryDateRange", strDate, par3);
ParameterFields par4 = new ParameterFields();
AddParameter("QueryTime", strTime, par4);
CRV1.ParameterFieldInfo.Add(par1[0]);
CRV1.ParameterFieldInfo.Add(par2[0]);
CRV1.ParameterFieldInfo.Add(par3[0]);
CRV1.ParameterFieldInfo.Add(par4[0]);
CRV1.ReportSource = customerReport;
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message;
}
}//ConfigureCrystalReports
开发者ID:ChiangHanLung,项目名称:PIC_VDS,代码行数:35,代码来源:ITM061R.aspx.cs
示例3: ReportDocument
private void Reporte_de_Gastos_de_Inversión_Load(object sender, EventArgs e)
{
//Diseño de la ventana
this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(237)))), ((int)(((byte)(228)))), ((int)(((byte)(196)))));
this.Icon = global::Sistema_Shajobe.Properties.Resources.Caja_ICO;
//REPORTE CRISTAL REPORT
//PRIMER PARAMETRO
ReportDocument reporte = new ReportDocument();
ParameterField parametro = new ParameterField();
ParameterFields parametros = new ParameterFields();
ParameterDiscreteValue discretos = new ParameterDiscreteValue();
parametro.Name = "@Apartir";
discretos.Value = Convert.ToDateTime(_Apartir);
parametro.CurrentValues.Add(discretos);
parametros.Add(parametro);
//SEGUNDO PARAMETRO
ParameterField parametro1 = new ParameterField();
ParameterDiscreteValue discretos1 = new ParameterDiscreteValue();
parametro1.Name = "@Hasta";
discretos1.Value = Convert.ToDateTime(_Hasta);
parametro1.CurrentValues.Add(discretos1);
parametros.Add(parametro1);
crystalReportViewer1.ParameterFieldInfo = parametros;
crystalReportViewer1.ReportSource = RGastosInventario1;
}
开发者ID:josericardo-ac,项目名称:Titulacion,代码行数:25,代码来源:Reporte+de+Gastos+de+Inversión.cs
示例4: FormSupplierPayment_Print_Load
private void FormSupplierPayment_Print_Load(object sender, EventArgs e)
{
try
{
// int TransactionID;
//SaleTransactionID = Convert.ToInt32(cbSupplier.SelectedValue.ToString());
ReportDocument reportDocument = new ReportDocument();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
string ReportPath = ConfigurationManager.AppSettings["ReportPath"];
paramField.Name = "@SupplierPaymentID";
paramDiscreteValue.Value = @SupplierPaymentID;
reportDocument.Load(ReportPath+"SupplierPay_Print_CrystalReport.rpt");
ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.DatabaseName = "DB_MedicalShop_02Sept20159PM";
//connectionInfo.UserID = "wms";
//connectionInfo.Password = "wms";
connectionInfo.IntegratedSecurity = true;
SetDBLogonForReport(connectionInfo, reportDocument);
reportDocument.SetParameterValue("@SupplierPaymentID", SupplierPaymentID);
SupplierPyCrystalPrint.ReportSource = reportDocument;
SupplierPyCrystalPrint.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
开发者ID:Anshul0305,项目名称:lotas,代码行数:34,代码来源:FormSupplierPayment_Print.cs
示例5: btnSearch_Click
private void btnSearch_Click(object sender, EventArgs e)
{
int GroupId;
GroupId = Convert.ToInt32(cbgroupNames.SelectedValue.ToString());
ReportDocument reportDocument = new ReportDocument();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
string ReportPath = ConfigurationManager.AppSettings["ReportPath"];
paramField.Name = "@GroupId";
paramDiscreteValue.Value = 1;
reportDocument.Load(ReportPath + "Reports\\GroupWise_CrystalReport.rpt");
ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.DatabaseName = "DB_LoanApplication";
//connectionInfo.UserID = "wms";
//connectionInfo.Password = "wms";
connectionInfo.IntegratedSecurity = true;
SetDBLogonForReport(connectionInfo, reportDocument);
reportDocument.SetParameterValue("@GroupId", GroupId);
GroupWisecrystalReport.ReportSource = reportDocument;
GroupWisecrystalReport.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
}
开发者ID:ttss2272,项目名称:bc,代码行数:26,代码来源:Groupwisereport.cs
示例6: InitializeReport
public void InitializeReport()
{
ReportDocument PullOutSummaryPerCustomer;
PullOutSummaryPerCustomer = new PullOutSummaryPerOutletRpt();
DataBaseLogIn(PullOutSummaryPerCustomer);
ParameterField prmCustomerNumber = new ParameterField();
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmCustomerNumber.ParameterFieldName = "customer_number";
prmDateFrom.ParameterFieldName = "date_from";
prmDateTo.ParameterFieldName = "date_to";
ParameterDiscreteValue prmCustomerNumberValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmCustomerNumberValue.Value = Request.QueryString["CustomerNumber"];
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmCustomerNumber.CurrentValues.Add(prmCustomerNumberValue);
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmCustomerNumber);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
this.crViewerMonthlyPullOutSummaryPerCustomer.ParameterFieldInfo = prmList;
crViewerMonthlyPullOutSummaryPerCustomer.ReportSource = PullOutSummaryPerCustomer;
}
开发者ID:DennisPitallano,项目名称:IRMS-ACCOUNTING,代码行数:35,代码来源:MonthlyPullOutSummaryPerCustomer.aspx.cs
示例7: InitializeReport
public void InitializeReport()
{
ReportDocument PullOutConsolidated;
PullOutConsolidated = new PullOutConsolidatedMonthly();
DataBaseLogIn(PullOutConsolidated);
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmDateFrom.ParameterFieldName = "date_from";
prmDateTo.ParameterFieldName = "date_to";
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
this.crViewerMonthlyConsolidatedReport.ParameterFieldInfo = prmList;
crViewerMonthlyConsolidatedReport.ReportSource = PullOutConsolidated;
}
开发者ID:DennisPitallano,项目名称:IRMS-ACCOUNTING,代码行数:27,代码来源:MonthlyConsolidatedReport.aspx.cs
示例8: InitializeReport
private void InitializeReport()
{
ReportDocument REPORT_DOC = new ReportDocument();
REPORT_DOC = new RptSummaryMonthlySOIPilferageByLocation();
DataBaseLogIn(REPORT_DOC);
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmDateFrom.ParameterFieldName = "@DateFrom";
prmDateTo.ParameterFieldName = "@DateTo";
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
this.SummaryOfMonthlyPilferageByLocation.ParameterFieldInfo = prmList;
SummaryOfMonthlyPilferageByLocation.ReportSource = REPORT_DOC;
}
开发者ID:DennisPitallano,项目名称:IRMS-ACCOUNTING,代码行数:27,代码来源:MonthlySummaryPilferagePerLocation.aspx.cs
示例9: btnSearch_Click
private void btnSearch_Click(object sender, EventArgs e)
{
int DoctorID;
DoctorID = Convert.ToInt32(cbDoctor.SelectedValue.ToString());
ReportDocument reportDocument = new ReportDocument();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
string ReportPath = ConfigurationManager.AppSettings["ReportPath"];
paramField.Name = "@DoctorID";
paramDiscreteValue.Value = DoctorID;
reportDocument.Load(ReportPath + "Report\\DoctorCrystalReport.rpt");
ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.DatabaseName = "DB_MedicalShop_02Sept20159PM";
//connectionInfo.UserID = "wms";
//connectionInfo.Password = "wms";
connectionInfo.IntegratedSecurity = true;
SetDBLogonForReport(connectionInfo, reportDocument);
reportDocument.SetParameterValue("@DoctorID", DoctorID);
DoctorCrystalRpt.ReportSource = reportDocument;
DoctorCrystalRpt.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
}
开发者ID:Anshul0305,项目名称:lotas,代码行数:27,代码来源:Form_Doctor_Detail_Report.cs
示例10: InitializeReport
private void InitializeReport()
{
ReportDocument REPORT_DOC = new ReportDocument();
REPORT_DOC = new RptSummaryMonthlyPilferageDeptStores();
DataBaseLogIn(REPORT_DOC);
ParameterField prmBrand = new ParameterField();
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmBrand.ParameterFieldName = "@BRAND_NAME";
prmDateFrom.ParameterFieldName = "@DATE_FROM";
prmDateTo.ParameterFieldName = "@DATE_TO";
ParameterDiscreteValue prmBrandValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmBrandValue.Value = Request.QueryString["Brand"];
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmBrand.CurrentValues.Add(prmBrandValue);
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmBrand);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
this.SummaryOfMonthlyPilferagePerDepartmentStores.ParameterFieldInfo = prmList;
SummaryOfMonthlyPilferagePerDepartmentStores.ReportSource = REPORT_DOC;
}
开发者ID:DennisPitallano,项目名称:IRMS-ACCOUNTING,代码行数:33,代码来源:MonthlySummaryPilferageReportDepartmentStore.aspx.cs
示例11: RptCetakKwitansi_Load
private void RptCetakKwitansi_Load(object sender, EventArgs e)
{
string strPath = Application.StartupPath + @"\Form\Report\Kwitansi\RptKwitansi.rpt";
// Object for load report.
ReportDocument rpt = new ReportDocument();
rpt.Load(strPath);
//Set Parameter
ParameterFields pfields = new ParameterFields();
ParameterField pfield = new ParameterField();
ParameterDiscreteValue disValue = new ParameterDiscreteValue();
pfield.Name = "spell";
disValue.Value = spell;
pfield.CurrentValues.Add(disValue);
pfields.Add(pfield);
pfield = new ParameterField();
pfield.Name = "price";
disValue = new ParameterDiscreteValue();
disValue.Value = harga;
pfield.CurrentValues.Add(disValue);
pfields.Add(pfield);
pfield = new ParameterField();
pfield.Name = "keterangan";
disValue = new ParameterDiscreteValue();
disValue.Value = ket;
pfield.CurrentValues.Add(disValue);
pfields.Add(pfield);
crystalReportViewer1.ParameterFieldInfo = pfields;
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
}
开发者ID:ViniciusConsultor,项目名称:mas-app,代码行数:35,代码来源:RptCetakKwitansi.cs
示例12: setParameters
public void setParameters(ReportDocument Rpt)
{
ParameterFields paramFields = new ParameterFields();
if (HttpContext.Current.Request.QueryString["MailingId"] != null && HttpContext.Current.Request.QueryString["MailingId"] != string.Empty)
{
ParameterField MailingId = new ParameterField();
MailingId.ParameterFieldName = "@CampaignId";
ParameterDiscreteValue dcMailingId = new ParameterDiscreteValue();
dcMailingId.Value = Convert.ToInt32(Request.QueryString["MailingId"].ToString());
MailingId.CurrentValues.Add(dcMailingId);
paramFields.Add(MailingId);
}
else
{
ParameterField CampId = new ParameterField();
CampId.ParameterFieldName = "@AssignedCampaignID";
ParameterDiscreteValue dcCampId = new ParameterDiscreteValue();
dcCampId.Value = Convert.ToInt32(Request.QueryString["CampId"].ToString());
CampId.CurrentValues.Add(dcCampId);
paramFields.Add(CampId);
}
CrystalReportViewer1.ParameterFieldInfo = paramFields;
CrystalReportViewer1.ReportSource = Rpt;
CrystalReportViewer1.DataBind();
}
开发者ID:shekar348,项目名称:1PointOne,代码行数:25,代码来源:FormSubmittedReports.aspx.cs
示例13: LoadReport
private void LoadReport()
{
try
{
string strSql = "select work_id,shipsup,cargosup,to_char(appdate,'yyyy-mm-dd') appdate, cargo_name,cargo_num from zjgdou_declare where to_char(appdate,'yyyy-mm-dd')>='2009-05-08'";
// DataTable tab = rpDocDB.GetDataTable(strSql);
string strPath = Server.MapPath("../../rpt/declare.rpt");
this.rpDoc.Load(strPath);
// rpDoc.SetDataSource(tab);
this.Login(rpDoc);
ParameterFields pfs = new ParameterFields();
ParameterField pf = new ParameterField();
ParameterDiscreteValue pfv = new ParameterDiscreteValue();
string strCode = "信息中心";
pfv.Value = strCode;
pf.Name = "corp";
pf.CurrentValues.Add(pfv);
pfs.Add(pf);
this.CrystalReportViewer1.ParameterFieldInfo = pfs;
this.CrystalReportViewer1.ReportSource = rpDoc;
this.CrystalReportViewer1.DataBind();
//this.CrystalReportViewer1.RefreshReport();
//this.Session["REPORT"] = rpDoc;
}
catch (Exception err)
{
}
}
开发者ID:inspire88,项目名称:TcportGroupOA,代码行数:35,代码来源:declare.aspx.cs
示例14: btnSearch_Click
private void btnSearch_Click(object sender, EventArgs e)
{
string BcDate;
string DueDate;
BcDate = Convert.ToString(dtpfromdate.Text);
DueDate = Convert.ToString(dtpTodate.Text);
ReportDocument reportDocument = new ReportDocument();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
string ReportPath = ConfigurationManager.AppSettings["ReportPath"];
paramField.Name = "@BcDate";
paramField.Name = "@DueDate";
paramDiscreteValue.Value = 1;
reportDocument.Load(ReportPath + "Reports\\DateWiseTransactionReport.rpt");
ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.DatabaseName = "DB_LoanApplication";
//connectionInfo.UserID = "wms";
//connectionInfo.Password = "wms";
connectionInfo.IntegratedSecurity = true;
SetDBLogonForReport(connectionInfo, reportDocument);
reportDocument.SetParameterValue("@BcDate", BcDate);
reportDocument.SetParameterValue("@DueDate", DueDate);
DatewisecrystalReport.ReportSource = reportDocument;
DatewisecrystalReport.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
}
开发者ID:ttss2272,项目名称:bc,代码行数:31,代码来源:Datewise_Monthly_Transaction_Report.cs
示例15: setParameters
public void setParameters(ReportDocument Rpt)
{
if (HttpContext.Current.Request.QueryString["StartDate"] != null && HttpContext.Current.Request.QueryString["EndDate"] != null)
{
ParameterFields paramFields = new ParameterFields();
ParameterField StartDay, EndDay;
ParameterDiscreteValue dcStartDay, dcEndDay;
StartDay = new ParameterField();
StartDay.ParameterFieldName = "@FromDate";
dcStartDay = new ParameterDiscreteValue();
dcStartDay.Value = Request.QueryString["StartDate"].ToString();
EndDay = new ParameterField();
EndDay.ParameterFieldName = "@ToDate";
dcEndDay = new ParameterDiscreteValue();
dcEndDay.Value = Request.QueryString["EndDate"].ToString();
StartDay.CurrentValues.Add(dcStartDay);
EndDay.CurrentValues.Add(dcEndDay);
paramFields.Add(StartDay);
paramFields.Add(EndDay);
AdminActivityCRViewer.ParameterFieldInfo = paramFields;
AdminActivityCRViewer.ReportSource = Rpt;
AdminActivityCRViewer.DataBind();
}
}
开发者ID:shekar348,项目名称:1PointOne,代码行数:27,代码来源:AdminActivityRpts.aspx.cs
示例16: PrintSI
public PrintSI(string Supplier, string city, string kapal, string date)
{
InitializeComponent();
reportDocument = new ReportDocument();
paramFields = new ParameterFields();
paramField = new ParameterField();
paramField.Name = "supplier";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = Supplier;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramField = new ParameterField();
paramField.Name = "kapal";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = kapal;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramField = new ParameterField();
paramField.Name = "tujuan";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = city;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramField = new ParameterField();
paramField.Name = "ATD";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = date;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
开发者ID:ViniciusConsultor,项目名称:mas-app,代码行数:35,代码来源:PrintSI.cs
示例17: crystalReportViewer1_Load
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
reportDataBind();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue discreteVal1 = new ParameterDiscreteValue();
paramField1.ParameterFieldName = "drawingno";
discreteVal1.Value = drawingno;
paramField1.CurrentValues.Add(discreteVal1);
paramFields.Add(paramField1);
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue discreteVal2 = new ParameterDiscreteValue();
paramField2.ParameterFieldName = "blockno";
discreteVal2.Value = blockno;
paramField2.CurrentValues.Add(discreteVal2);
paramFields.Add(paramField2);
ParameterField paramField3 = new ParameterField();
ParameterDiscreteValue discreteVal3 = new ParameterDiscreteValue();
paramField3.ParameterFieldName = "project";
discreteVal3.Value = project;
paramField3.CurrentValues.Add(discreteVal3);
paramFields.Add(paramField3);
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
开发者ID:freudshow,项目名称:raffles-codes,代码行数:26,代码来源:AccessoriesRpt.cs
示例18: crystalReportViewer1_Load
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = GetDs();
if (UserSecurity.HavingPrivilege(User.cur_user, "SPOOLWAREHOUSEUSERS"))
{
NestProjectMaterialRpt pmrpt = new NestProjectMaterialRpt();
pmrpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = pmrpt;
}
else
{
ProjectMaterialRpt pmrpt = new ProjectMaterialRpt();
pmrpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = pmrpt;
}
//crystalReportViewer1.DisplayGroupTree = false;
ParameterFields paramFields = new ParameterFields();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
// 第一个参数是具有多个值的离散参数。设置参数字段的名称,它必须和报表中的参数相符。
paramField1.ParameterFieldName = "kickoffdate";
// 设置离散值并将其传递给该参数。
discreteVal.Value = User .KickOffDate ;
paramField1.CurrentValues.Add(discreteVal);
// 将该参数添加到参数字段集合。
paramFields.Add(paramField1);
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue discreteVal2 = new ParameterDiscreteValue();
paramField2.ParameterFieldName = "TotalBaseLength";
discreteVal2.Value = User.TotalBaseLength;
paramField2.CurrentValues.Add(discreteVal2);
paramFields.Add(paramField2);
ParameterField paramField5 = new ParameterField();
ParameterDiscreteValue discreteVal5 = new ParameterDiscreteValue();
paramField5.ParameterFieldName = "kickoffdateStart";
discreteVal5.Value = User.KickOffDate_start;
paramField5.CurrentValues.Add(discreteVal5);
paramFields.Add(paramField5);
ParameterField paramField6 = new ParameterField();
ParameterDiscreteValue discreteVal6 = new ParameterDiscreteValue();
paramField6.ParameterFieldName = "kickoffdateEnd";
discreteVal6.Value = User.KickOffDate_end;
paramField6.CurrentValues.Add(discreteVal6);
paramFields.Add(paramField6);
ParameterField paramField7 = new ParameterField();
ParameterDiscreteValue discreteVal7 = new ParameterDiscreteValue();
paramField7.ParameterFieldName = "TotalWeight";
discreteVal7.Value = User.PipeBaseTotalWeight;
paramField7.CurrentValues.Add(discreteVal7);
paramFields.Add(paramField7);
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
开发者ID:freudshow,项目名称:raffles-codes,代码行数:59,代码来源:ProjectMaterial.cs
示例19: NestingDetailViewer_Load
private void NestingDetailViewer_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = GetDs();
if (UserSecurity.HavingPrivilege(User.cur_user, "SPOOLWAREHOUSEUSERS"))
{
NestingPipeRpt pmrpt = new NestingPipeRpt();
pmrpt.SetDataSource(ds);
NestingDetailViewer.ReportSource = pmrpt;
}
ParameterFields paramFields = new ParameterFields();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
paramField1.ParameterFieldName = "kickoffdate";
discreteVal.Value = User.KickOffDate;
paramField1.CurrentValues.Add(discreteVal);
paramFields.Add(paramField1);
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue discreteVa2 = new ParameterDiscreteValue();
paramField2.ParameterFieldName = "Margin";
discreteVa2.Value = User.Margin;
paramField2.CurrentValues.Add(discreteVa2);
paramFields.Add(paramField2);
ParameterField paramField3 = new ParameterField();
ParameterDiscreteValue discreteVal3 = new ParameterDiscreteValue();
paramField3.ParameterFieldName = "TotalBaseLength";
discreteVal3.Value = User.TotalBaseLength;
paramField3.CurrentValues.Add(discreteVal3);
paramFields.Add(paramField3);
ParameterField paramField4 = new ParameterField();
ParameterDiscreteValue discreteVal4 = new ParameterDiscreteValue();
paramField4.ParameterFieldName = "PipeRatio";
discreteVal4.Value = User.PipeRatio;
paramField4.CurrentValues.Add(discreteVal4);
paramFields.Add(paramField4);
ParameterField paramField5 = new ParameterField();
ParameterDiscreteValue discreteVal5 = new ParameterDiscreteValue();
paramField5.ParameterFieldName = "kickoffdateStart";
discreteVal5.Value = User.KickOffDate_start;
paramField5.CurrentValues.Add(discreteVal5);
paramFields.Add(paramField5);
ParameterField paramField6 = new ParameterField();
ParameterDiscreteValue discreteVal6= new ParameterDiscreteValue();
paramField6.ParameterFieldName = "kickoffdateEnd";
discreteVal6.Value = User.KickOffDate_end;
paramField6.CurrentValues.Add(discreteVal6);
paramFields.Add(paramField6);
NestingDetailViewer.ParameterFieldInfo = paramFields;
}
开发者ID:freudshow,项目名称:raffles-codes,代码行数:57,代码来源:NestingPipeDetail.cs
示例20: btnGenerar_Click
private void btnGenerar_Click(object sender, EventArgs e)
{
if(todos)
{
//C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteProveedor.rpt
FormProveedor formulario = new FormProveedor();
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(@"C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteProveedor.rpt");
formulario.crystalReportViewer1.ReportSource = crystalrpt;
formulario.crystalReportViewer1.Refresh();
formulario.Show();
}
else
{
DateTime fecha = dateDesde.Value;
string fechaDesde = fecha.ToString("d");
DateTime fecha2 = dateHasta.Value;
string fechaHasta = fecha2.ToString("d");
FormProveedoresParametros form = new FormProveedoresParametros();
ReportDocument oRep = new ReportDocument();
ParameterField pf = new ParameterField();
ParameterFields pfs = new ParameterFields();
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
pf.Name = "@fechaDesde";
pdv.Value = fechaDesde;
pf.CurrentValues.Add(pdv);
pfs.Add(pf);
pfs.Clear();
pf.Name = "@fechaHasta";
pdv.Value = fechaHasta;
pf.CurrentValues.Add(pdv);
pfs.Add(pf);
form.crystalReportViewer1.ParameterFieldInfo = pfs;
oRep.Load(@"C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteProveedoresParametros.rpt");
form.crystalReportViewer1.ReportSource = oRep;
form.Show();
}
}
开发者ID:Fernando3030,项目名称:ProyectoProgramacion5,代码行数:56,代码来源:ReporteProveedores.cs
注:本文中的ParameterFields类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论