private void ProductReport_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
if (Parameters["CategoryID"] != null)
{
productsTableAdapter.FillByCategoryID(northwind1.Products, (int)Parameters["CategoryID"].Value);
}
}
private void DeclarationReport_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
_sum = 0;
_sumBrut1 = 0;
_sumBrut2 = 0;
_sumBrut3 = 0;
}
private void Rpt_Tranfer_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
foreach (ParameterInfo info in e.ParametersInformation)
{
if (info.Parameter.Name == "ItemCode1")
{
_PItemName1 = ((LookUpEdit)info.Editor).Properties.GetDisplayText(info.Parameter.Value);
//break;
}
if (info.Parameter.Name == "ItemCode2")
{
_PItemName2 = ((LookUpEdit)info.Editor).Properties.GetDisplayText(info.Parameter.Value);
//break;
}
if (info.Parameter.Name == "ItemGroup1")
{
_PItemGroup1 = ((LookUpEdit)info.Editor).Properties.GetDisplayText(info.Parameter.Value);
//break;
}
if (info.Parameter.Name == "ItemGroup2")
{
_PItemGroup2 = ((LookUpEdit)info.Editor).Properties.GetDisplayText(info.Parameter.Value);
//break;
}
}
}
private void XRep02_ParametersRequestBeforeShow(object sender, ParametersRequestEventArgs e)
{
foreach (ParameterInfo pram in e.ParametersInformation)
{
if (pram.Parameter.Name == "pramGovId")
{
LookUpEdit lue = (LookUpEdit)pram.Editor;
lue.Properties.DataSource = dsGM.Gov;
lue.Properties.DisplayMember = "GovName";
lue.Properties.ValueMember = "GovId";
lue.Properties.Columns.Add(new LookUpColumnInfo("GovName", 0, "أسم المحافظة"));
lue.Properties.BestFit();
lue.Properties.NullText = string.Empty;
lue.Properties.TextEditStyle = TextEditStyles.Standard;
lue.EditValueChanged += lue_EditValueChanged;
continue;
}
if (pram.Parameter.Name == "pramAreaId")
{
LookUpEdit lue = (LookUpEdit)pram.Editor;
lue.Properties.DataSource = dsGM.Area;
lue.Properties.DisplayMember = "AreaName";
lue.Properties.ValueMember = "AreaId";
lue.Properties.Columns.Add(new LookUpColumnInfo("AreaName", 0, "أسم المنطقة"));
lue.Properties.BestFit();
lue.Properties.NullText = string.Empty;
lue.Properties.TextEditStyle = TextEditStyles.Standard;
//lue.EditValueChanged += lue_EditValueChanged;
continue;
}
}
}
private static void OnParametersRequest(object sender, ParametersRequestEventArgs eventArgs)
{
// Some archives are encrypted or require parameters to be set.
// Let's just use the default values for now.
var format = (IResource)sender;
//Console.WriteLine(eventArgs.Notice);
eventArgs.InputResult = true;
eventArgs.Options = format.GetDefaultOptions();
}
private void XtraReport1_ParametersRequestSubmit(object sender,
ParametersRequestEventArgs e)
{
if ((int)e.ParametersInformation[0].Parameter.Value > 10 ||
(int)e.ParametersInformation[0].Parameter.Value < 0)
{
e.ParametersInformation[0].Parameter.Value = parameter;
e.ParametersInformation[0].Editor.Text = parameter.ToString();
}
}
private void CombinedReport_ParametersRequestBeforeShow(object sender, ParametersRequestEventArgs e)
{
List <int> resourcesIdsList = new List <int>();
var resources = _appointmentsService.GetAllResources(CurrentTenantId).Where(x => x.InternalStaff == true).ToList();
foreach (var res in resources)
{
resourcesIdsList.Add(res.ResourceId);
}
e.ParametersInformation[0].Parameter.Value = resourcesIdsList;
}
private void PreviewReport_ParametersRequestBeforeShow(object sender, ParametersRequestEventArgs e)
{
//customize parameters
if (e.ParametersInformation.Length == 0)
{
return;
}
ParameterInfo info = e.ParametersInformation[0];
if (info.Parameter.Type == typeof(Int32))
{
info.Editor = new SpinEdit();
info.Parameter.Value = 100;
}
}
private void OrderViewRptParametersRequestBeforeShow(object sender, ParametersRequestEventArgs e)
{
foreach (ParameterInfo info in e.ParametersInformation)
{
if (info.Parameter.Name == "prGroup")
{
var lookUpEdit = new LookUpEdit();
var ds = new CatDs();
ds.Load(ReportDataConnection);
lookUpEdit.Properties.DataSource = ds;
lookUpEdit.Properties.DisplayMember = "CategoryName";
lookUpEdit.Properties.ValueMember = "CategoryName";
lookUpEdit.Properties.Columns.Add(new LookUpColumnInfo("CategoryName", 200, "Группа товара"));
info.Editor = lookUpEdit;
}
if (info.Parameter.Name == "prShop")
{
var lookUpEdit = new LookUpEdit()
{
Width = 300
};
var ds = new ShopDs();
ds.Load(ReportDataConnection);
lookUpEdit.Properties.DataSource = ds;
lookUpEdit.Properties.DisplayMember = "ShopName";
lookUpEdit.Properties.ValueMember = "ShopCode";
lookUpEdit.Properties.Columns.Add(new LookUpColumnInfo("ShopCode", 50, "Код магазина"));
lookUpEdit.Properties.Columns.Add(new LookUpColumnInfo("ShopName", 100, "Название магазина"));
lookUpEdit.Properties.Columns.Add(new LookUpColumnInfo("ShopAddress", 150, "Адрес магазина"));
info.Editor = lookUpEdit;
}
if (info.Parameter.Name == "prSupplier")
{
var lookUpEdit = new LookUpEdit();
var ds = new SupplierDs();
ds.Load(ReportDataConnection);
lookUpEdit.Properties.DataSource = ds;
lookUpEdit.Properties.DisplayMember = "SupplierName";
lookUpEdit.Properties.ValueMember = "SupplierName";
lookUpEdit.Properties.Columns.Add(new LookUpColumnInfo("SupplierName", 200, "Поставщик"));
info.Editor = lookUpEdit;
}
}
}
private void XRDofatDetails_ParametersRequestBeforeShow(object sender, ParametersRequestEventArgs e)
{
DataSources.dsTeachersUnionTableAdapters.AppOptionsTableAdapter adpOptions = new DataSources.dsTeachersUnionTableAdapters.AppOptionsTableAdapter();
adpOptions.Fill(dsTeachersUnion1.AppOptions);
foreach (ParameterInfo info in e.ParametersInformation)
{
if (info.Parameter.Name == "PrmSyndicateId")
{
((LookUpEdit)info.Editor).EditValueChanged += lueSyndicateId_EditValueChanged;
((LookUpEdit)info.Editor).Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
}
if (info.Parameter.Name == "PrmSubCommitteId")
{
((LookUpEdit)info.Editor).Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
}
}
}
private void OrderViewRptParametersRequestBeforeShow(object sender, ParametersRequestEventArgs e)
{
foreach (ParameterInfo info in e.ParametersInformation)
{
if (info.Parameter.Name == "prGroup")
{
var lookUpEdit = new LookUpEdit();
var ds = new CatDs();
ds.Load(ReportDataConnection);
lookUpEdit.Properties.DataSource = ds;
lookUpEdit.Properties.DisplayMember = "CategoryName";
lookUpEdit.Properties.ValueMember = "CategoryName";
lookUpEdit.Properties.Columns.Add(new LookUpColumnInfo("CategoryName", 200, "Группа товара"));
info.Editor = lookUpEdit;
}
if (info.Parameter.Name == "prShop")
{
var lookUpEdit = new LookUpEdit(){Width = 300};
var ds = new ShopDs();
ds.Load(ReportDataConnection);
lookUpEdit.Properties.DataSource = ds;
lookUpEdit.Properties.DisplayMember = "ShopName";
lookUpEdit.Properties.ValueMember = "ShopCode";
lookUpEdit.Properties.Columns.Add(new LookUpColumnInfo("ShopCode", 50, "Код магазина"));
lookUpEdit.Properties.Columns.Add(new LookUpColumnInfo("ShopName", 100, "Название магазина"));
lookUpEdit.Properties.Columns.Add(new LookUpColumnInfo("ShopAddress", 150, "Адрес магазина"));
info.Editor = lookUpEdit;
}
if (info.Parameter.Name == "prSupplier")
{
var lookUpEdit = new LookUpEdit();
var ds = new SupplierDs();
ds.Load(ReportDataConnection);
lookUpEdit.Properties.DataSource = ds;
lookUpEdit.Properties.DisplayMember = "SupplierName";
lookUpEdit.Properties.ValueMember = "SupplierName";
lookUpEdit.Properties.Columns.Add(new LookUpColumnInfo("SupplierName", 200, "Поставщик"));
info.Editor = lookUpEdit;
}
}
}
private void OrderViewRptParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
if (DataSource is IOrderReportDataSource)
{
var ds = (IOrderReportDataSource)DataSource;
foreach (ParameterInfo info in e.ParametersInformation)
{
if (info.Parameter.Name == "prDataBegin")
{
ds.DateBegin = (DateTime)info.Parameter.Value;
}
if (info.Parameter.Name == "prDataEnd")
{
ds.DateEnd = (DateTime)info.Parameter.Value;
}
if (info.Parameter.Name == "prShop")
{
ds.ShopCode = (string)info.Parameter.Value;
}
if (info.Parameter.Name == "prGroup")
{
ds.Group = (string)info.Parameter.Value;
}
if (info.Parameter.Name == "prSupplier")
{
ds.Supplier = (string)info.Parameter.Value;
}
if (info.Parameter.Name == "prBarcode")
{
ds.Barcode = (string)info.Parameter.Value;
}
}
ds.Load(ReportDataConnection);
}
}
void OrderFormReport_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
string paramSalesDrive = (string)e.ParametersInformation[0].Parameter.Value;
string paramAnimation = string.Empty;
string collAnim = (string)e.ParametersInformation[1].Parameter.Value;
if (!string.IsNullOrEmpty(collAnim))
{
string[] list1 = collAnim.Split(',');
foreach (string s in list1)
{
paramAnimation = string.IsNullOrEmpty(paramAnimation) ? s : paramAnimation + "," + s;
}
}
string paramSalesArea = (string)e.ParametersInformation[2].Parameter.Value;
string paramItemGroup = string.Empty;
string collItemGroup = (string)e.ParametersInformation[3].Parameter.Value;
string[] list2 = collItemGroup.Split(',');
foreach (string s in list2)
{
paramItemGroup = string.IsNullOrEmpty(paramItemGroup) ? s : paramItemGroup + "," + s;
}
ParameterSalesDrive = string.IsNullOrEmpty(paramSalesDrive) ? null : paramSalesDrive;
ParameterAnimation = string.IsNullOrEmpty(paramAnimation) ? null : paramAnimation;
ParameterSalesArea = string.IsNullOrEmpty(paramSalesArea) ? null : paramSalesArea;
ParameterItemGroup = string.IsNullOrEmpty(paramItemGroup) ? null : paramItemGroup;
rep_OrderFormReportTableAdapter.Fill(lorealDataSet1.rep_OrderFormReport,
ParameterSalesDrive,
ParameterAnimation,
ParameterSalesArea,
ParameterItemGroup);
}
private void XtraReport1_ParametersRequestBeforeShow(object sender, ParametersRequestEventArgs e)
{
CategoriesDataSet dataSet = new CategoriesDataSet();
CategoriesDataSetTableAdapters.CategoriesTableAdapter adapter =
new CategoriesDataSetTableAdapters.CategoriesTableAdapter();
adapter.Fill(dataSet.Categories);
foreach (ParameterInfo info in e.ParametersInformation)
{
if (info.Parameter.Name == "parameter1")
{
LookUpEdit lookUpEdit = new LookUpEdit();
lookUpEdit.Properties.DataSource = dataSet.Categories;
lookUpEdit.Properties.DisplayMember = "CategoryName";
lookUpEdit.Properties.ValueMember = "CategoryID";
lookUpEdit.Properties.Columns.Add(new LookUpColumnInfo("CategoryName", 0, "Category Name"));
lookUpEdit.Properties.NullText = "<Select Category>";
info.Editor = lookUpEdit;
info.Parameter.Value = DBNull.Value;
}
}
}
private void OnParametersRequest(object sender, ParametersRequestEventArgs e)
{
var format = sender as IResource;
if (null != format)
{
var control = format.GetAccessWidget() as UIElement;
if (null != control)
{
bool busy_state = m_busy_state;
var param_dialog = new ArcParametersDialog(control, e.Notice);
param_dialog.Owner = this;
e.InputResult = param_dialog.ShowDialog() ?? false;
if (e.InputResult)
{
e.Options = format.GetOptions(control);
}
if (busy_state)
{
SetBusyState();
}
}
}
}
private void PessoaJuridicaDetalhadaReport_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
}
private void LancamentoParceiroNegocioPessoaJuridicaResumidoPeriodoReport_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
bindingSource.DataSource = LancamentoParceiroNegocioPessoaJuridicaRepository.GetListAtivos(GetExpression());
}
private void XRep07_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
if (e.ParametersInformation[0].Parameter.Value == null || e.ParametersInformation[1].Parameter.Value == null)
return;
xrtVarCell.DataBindings.Clear();
rep07TableAdapter.FillByhafzaid(dsTeachersUnionQuery1.Rep07, Convert.ToDouble(e.ParametersInformation[0].Parameter.Value));
//827
if ((int)e.ParametersInformation[1].Parameter.Value == 1)
{
xrlFilterType.Text = "ما تم طباعتة";
Report.FilterString = "printdate is not null";
DetailGeneral.MultiColumn.ColumnCount = 2;
xrTableHeader.Rows[0].Cells.Clear();
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "اللجنه", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight});
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "الاسم", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight });
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "الرقم", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight });
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "اللجنه", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight });
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "الاسم", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight });
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "الرقم", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight });
xrTableHeader.LocationF = new PointF(0, 0); xrTableHeader.WidthF = PageWidth;
xrTableHeader.Rows[0].Cells[0].WidthF = 120;
xrTableHeader.Rows[0].Cells[1].WidthF = 200;
xrTableHeader.Rows[0].Cells[2].WidthF = 80;
xrTableHeader.Rows[0].Cells[3].WidthF = 120;
xrTableHeader.Rows[0].Cells[4].WidthF = 200;
xrTableHeader.Rows[0].Cells[5].WidthF = 80;
xrTableDetails.Rows[0].Cells[0].WidthF = 120;
xrTableDetails.Rows[0].Cells[1].WidthF = 200;
xrTableDetails.Rows[0].Cells[2].WidthF = 80;
//foreach (XRTableCell cell in xrTableHeader.Rows[0].Cells)
// cell.WidthF = PageWidth / 6;
//foreach (XRTableCell cell in xrTableDetails.Rows[0].Cells)
// cell.WidthF = PageWidth / 6;
xrtVarCell.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", null, "Rep07.SubCommitte"));
}
else
{
xrlFilterType.Text = "ما لم يتم طباعتة";
Report.FilterString = "estefaa = 'true'";
DetailGeneral.MultiColumn.ColumnCount = 2;
xrTableHeader.Rows[0].Cells.Clear();
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "السبب", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight });
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "الاسم", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight });
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "الرقم", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight });
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "السبب", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight });
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "الاسم", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight });
xrTableHeader.Rows[0].Cells.Add(new XRTableCell() { Text = "الرقم", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight });
xrTableHeader.LocationF = new PointF(0, 0); xrTableHeader.WidthF = PageWidth;
xrTableHeader.Rows[0].Cells[0].WidthF = 170;
xrTableHeader.Rows[0].Cells[1].WidthF = 170;
xrTableHeader.Rows[0].Cells[2].WidthF = 60;
xrTableHeader.Rows[0].Cells[3].WidthF = 170;
xrTableHeader.Rows[0].Cells[4].WidthF = 170;
xrTableHeader.Rows[0].Cells[5].WidthF = 60;
xrTableDetails.Rows[0].Cells[0].WidthF = 170;
xrTableDetails.Rows[0].Cells[1].WidthF = 170;
xrTableDetails.Rows[0].Cells[2].WidthF = 60;
//foreach (XRTableCell cell in xrTableHeader.Rows[0].Cells)
// cell.WidthF = PageWidth / 6;
//foreach (XRTableCell cell in xrTableDetails.Rows[0].Cells)
// cell.WidthF = PageWidth / 6;
xrtVarCell.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", null, "Rep07.estefareson"));
}
ApplyFiltering();
xrlTotal.Text = this.RowCount.ToString();
}
private void TituloPeriodoReport_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
bindingSource.DataSource = TituloRepository.GetListAtivos(GetExpression());
}
private void ParameterSubmit(object sender, ParametersRequestEventArgs e)
{
bindingSource.DataSource = CustoFixoParceiroNegocioPessoaJuridicaRepository.GetListAtivos(GetExpression());
}
private void sub(object sender, ParametersRequestEventArgs e)
{
}
private void XRep05_ParametersRequestBeforeShow(object sender, ParametersRequestEventArgs e)
{
foreach (ParameterInfo info in e.ParametersInformation)
{
if (info.Parameter.Name == "pramPlumberId")
{
DevExpress.XtraEditors.SearchLookUpEdit LUE = new DevExpress.XtraEditors.SearchLookUpEdit();
//XPSCSPlumber = new DevExpress.Xpo.XPServerCollectionSource
LUE.Properties.DataSource = PlumberbindingSource;
LUE.Properties.DisplayMember = "PlumberName";
LUE.Properties.ValueMember = "PlumberId";
//LUE.Properties.Columns.Add(new LookUpColumnInfo("PlumberName", 0, "اسم السباك"));
//LUE.Properties.BestFit();
//LUE.Properties.NullText = string.Empty;
//LUE.Properties.TextEditStyle = TextEditStyles.Standard;
DevExpress.XtraGrid.Columns.GridColumn gridColumn1 = new DevExpress.XtraGrid.Columns.GridColumn();
DevExpress.XtraGrid.Columns.GridColumn gridColumn2 = new DevExpress.XtraGrid.Columns.GridColumn();
DevExpress.XtraGrid.Columns.GridColumn gridColumn3 = new DevExpress.XtraGrid.Columns.GridColumn();
DevExpress.XtraGrid.Columns.GridColumn gridColumn4 = new DevExpress.XtraGrid.Columns.GridColumn();
gridColumn1.Caption = "الاسم";
gridColumn1.FieldName = "PlumberName";
gridColumn1.Name = "gridColumn1";
gridColumn1.Visible = true;
gridColumn1.VisibleIndex = 0;
gridColumn2.Caption = "تليفون";
gridColumn2.FieldName = "PlumberPhone";
gridColumn2.Name = "gridColumn2";
gridColumn2.Visible = true;
gridColumn2.VisibleIndex = 1;
gridColumn3.Caption = "موبيل";
gridColumn3.FieldName = "PlumberMobile";
gridColumn3.Name = "gridColumn3";
gridColumn3.Visible = true;
gridColumn3.VisibleIndex = 2;
gridColumn4.Caption = "الرقم القومي";
gridColumn4.FieldName = "NationalId";
gridColumn4.Name = "gridColumn4";
gridColumn4.Visible = true;
gridColumn4.VisibleIndex = 3;
DevExpress.XtraGrid.Views.Grid.GridView searchLookUpEdit1View = new DevExpress.XtraGrid.Views.Grid.GridView();
searchLookUpEdit1View.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
gridColumn1,
gridColumn2,
gridColumn3,
gridColumn4});
searchLookUpEdit1View.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
searchLookUpEdit1View.Name = "searchLookUpEdit1View";
searchLookUpEdit1View.OptionsSelection.EnableAppearanceFocusedCell = false;
searchLookUpEdit1View.OptionsView.ShowAutoFilterRow = true;
searchLookUpEdit1View.OptionsView.ShowGroupPanel = false;
LUE.Properties.View = searchLookUpEdit1View;
LUE.EditValue = "";
LUE.Name = "LUE";
LUE.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo) });
LUE.Properties.DisplayMember = "PlumberName";
LUE.Properties.NullText = "";
LUE.Properties.ValueMember = "PlumberId";
//this.LUE.Properties.View = this.searchLookUpEdit1View;
LUE.Size = new System.Drawing.Size(182, 20);
LUE.TabIndex = 0;
info.Editor = LUE;
info.Parameter.Value = DBNull.Value;
continue;
}
}
}
void MyXtraReport_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
//RefreshData();
}
private void OrderViewRptParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
if (DataSource is IOrderReportDataSource)
{
var ds = (IOrderReportDataSource) DataSource;
foreach (ParameterInfo info in e.ParametersInformation)
{
if (info.Parameter.Name == "prDataBegin")
ds.DateBegin = (DateTime)info.Parameter.Value;
if (info.Parameter.Name == "prDataEnd")
ds.DateEnd = (DateTime)info.Parameter.Value;
if (info.Parameter.Name == "prShop")
ds.ShopCode = (string)info.Parameter.Value;
if (info.Parameter.Name == "prGroup")
ds.Group = (string)info.Parameter.Value;
if (info.Parameter.Name == "prSupplier")
ds.Supplier = (string)info.Parameter.Value;
if (info.Parameter.Name == "prBarcode")
ds.Barcode = (string)info.Parameter.Value;
}
ds.Load(ReportDataConnection);
}
}
void rptProgressItem_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
string reportBy = "Units";
foreach (ParameterInfo info in e.ParametersInformation)
{
if (info.Parameter.Name == "reportBy")
{
reportBy = (string)info.Parameter.Value;
}
}
xrDataSummaryCumulativeBurnedPercent.DataBindings.Clear();
xrDataSummaryCumulativeEarnedPercent.DataBindings.Clear();
xrDataSummaryCumulativePlannedPercent.DataBindings.Clear();
xrDataSummaryPeriodBurnedPercent.DataBindings.Clear();
xrDataSummaryPeriodEarnedPercent.DataBindings.Clear();
xrDataSummaryPeriodPlannedPercent.DataBindings.Clear();
xrDataBaselineBudgeted.DataBindings.Clear();
xrDataCumulativePlannedUOM.DataBindings.Clear();
xrDataCumulativePlannedPercentage.DataBindings.Clear();
xrDataCumulativeEarnedUOM.DataBindings.Clear();
xrDataCumulativeEarnedPercentage.DataBindings.Clear();
xrDataPeriodPlannedUOM.DataBindings.Clear();
xrDataPeriodPlannedPercentage.DataBindings.Clear();
xrDataPeriodCurrentUOM.DataBindings.Clear();
xrDataPeriodCurrentPercentage.DataBindings.Clear();
string strReplaceFrom;
string strReplaceTo;
string formatString;
if (reportBy == "Costs")
{
strReplaceFrom = "Units";
strReplaceTo = "Costs";
formatString = "{0:c}";
}
else
{
strReplaceFrom = "Costs";
strReplaceTo = "Units";
formatString = "{0:n1}";
}
xrDataSummaryCumulativeBurnedPercent.DataBindings.Add(new XRBinding("Text", objectDataSource1, "Summary_CumulativeBurned." + reportBy + "Percentage", "{0:0.00%}"));
xrDataSummaryCumulativeEarnedPercent.DataBindings.Add(new XRBinding("Text", objectDataSource1, "Summary_CumulativeEarned." + reportBy + "Percentage", "{0:0.00%}"));
xrDataSummaryCumulativePlannedPercent.DataBindings.Add(new XRBinding("Text", objectDataSource1, "Summary_CumulativePlanned." + reportBy + "Percentage", "{0:0.00%}"));
xrDataSummaryPeriodBurnedPercent.DataBindings.Add(new XRBinding("Text", objectDataSource1, "Summary_PeriodBurned." + reportBy + "Percentage", "{0:0.00%}"));
xrDataSummaryPeriodEarnedPercent.DataBindings.Add(new XRBinding("Text", objectDataSource1, "Summary_PeriodEarned." + reportBy + "Percentage", "{0:0.00%}"));
xrDataSummaryPeriodPlannedPercent.DataBindings.Add(new XRBinding("Text", objectDataSource1, "Summary_PeriodPlanned." + reportBy + "Percentage", "{0:0.00%}"));
if (reportBy == "Units")
{
xrDataBaselineBudgeted.DataBindings.Add(new XRBinding("Text", objectDataSource1, "ReportableObjects.BASELINE_ITEMJoinRATE.BASELINE_ITEM.ESTIMATED_HOURS", formatString));
}
else
{
xrDataBaselineBudgeted.DataBindings.Add(new XRBinding("Text", objectDataSource1, "ReportableObjects.BASELINE_ITEMJoinRATE.ESTIMATED_COSTS", formatString));
}
xrDataCumulativePlannedUOM.DataBindings.Add(new XRBinding("Text", objectDataSource1, "ReportableObjects.Summary_CumulativeOriginal." + reportBy, formatString));
xrDataCumulativePlannedPercentage.DataBindings.Add(new XRBinding("Text", objectDataSource1, "ReportableObjects.Summary_CumulativeOriginal." + reportBy + "Percentage", "{0:0.00%}"));
xrDataCumulativeEarnedUOM.DataBindings.Add(new XRBinding("Text", objectDataSource1, "ReportableObjects.Summary_CumulativeEarned.Units", formatString));
xrDataCumulativeEarnedPercentage.DataBindings.Add(new XRBinding("Text", objectDataSource1, "ReportableObjects.Summary_CumulativeEarned." + reportBy + "Percentage", "{0:0.00%}"));
xrDataPeriodPlannedUOM.DataBindings.Add(new XRBinding("Text", objectDataSource1, "ReportableObjects.Summary_PeriodPlanned.Units", formatString));
xrDataPeriodPlannedPercentage.DataBindings.Add(new XRBinding("Text", objectDataSource1, "ReportableObjects.Summary_PeriodPlanned." + reportBy + "Percentage", "{0:0.00%}"));
xrDataPeriodCurrentUOM.DataBindings.Add(new XRBinding("Text", objectDataSource1, "ReportableObjects.Summary_PeriodEarned.Units", formatString));
xrDataPeriodCurrentPercentage.DataBindings.Add(new XRBinding("Text", objectDataSource1, "ReportableObjects.Summary_PeriodEarned." + reportBy + "Percentage", "{0:0.00%}"));
this.xrChart1.Series["Planned"].ValueDataMembersSerializable = "Summary_CumulativePlannedDataPoints." + reportBy + "Percentage";
this.xrChart1.Series["Earned"].ValueDataMembersSerializable = "Summary_CumulativeEarnedDataPoints." + reportBy + "Percentage";
this.xrChart1.Series["Burned"].ValueDataMembersSerializable = "Summary_CumulativeBurnedDataPoints." + reportBy + "Percentage";
this.xrChart1.Series["Remaining"].ValueDataMembersSerializable = "Summary_CumulativeRemainingPlannedDataPoints." + reportBy + "Percentage";
this.xrChart1.Series["Period Planned"].ValueDataMembersSerializable = "Summary_PeriodPlannedDataPoints." + reportBy;
this.xrChart1.Series["Period Earned"].ValueDataMembersSerializable = "Summary_PeriodEarnedDataPoints." + reportBy;
this.xrChart1.Series["Period Burned"].ValueDataMembersSerializable = "Summary_PeriodBurnedDataPoints." + reportBy;
this.xrChart1.Series["Period Remaining"].ValueDataMembersSerializable = "Summary_PeriodRemainingPlannedDataPoints." + reportBy;
//labels
xrLblCumulativeEarnedUOM.Text = xrLblCumulativeEarnedUOM.Text.Replace(strReplaceFrom, strReplaceTo);
xrLblCumulativePlannedUOM.Text = xrLblCumulativePlannedUOM.Text.Replace(strReplaceFrom, strReplaceTo);
xrLblPeriodCurrentUOM.Text = xrLblPeriodCurrentUOM.Text.Replace(strReplaceFrom, strReplaceTo);
xrLblPeriodPlannedUOM.Text = xrLblPeriodPlannedUOM.Text.Replace(strReplaceFrom, strReplaceTo);
//conditional formatting
this.ItemCumulativeEarnedEfficiency_Good.Condition = this.ItemCumulativeEarnedEfficiency_Good.Condition.Replace(strReplaceFrom, strReplaceTo);
this.ItemCumulativeEarnedEfficiency_Good.Condition = this.ItemCumulativeEarnedEfficiency_Good.Condition.Replace(strReplaceFrom, strReplaceTo);
this.ItemPeriodEarnedEfficiency_Good.Condition = this.ItemPeriodEarnedEfficiency_Good.Condition.Replace(strReplaceFrom, strReplaceTo);
this.SummaryPeriodBurnedEfficiency_Good.Condition = this.SummaryPeriodBurnedEfficiency_Good.Condition.Replace(strReplaceFrom, strReplaceTo);
this.SummaryCumulativeBurnedEfficiency_Good.Condition = this.SummaryCumulativeBurnedEfficiency_Good.Condition.Replace(strReplaceFrom, strReplaceTo);
this.SummaryCumulativeEarnedEfficiency_Good.Condition = this.SummaryCumulativeEarnedEfficiency_Good.Condition.Replace(strReplaceFrom, strReplaceTo);
this.SummaryPeriodEarnedEfficiency_Good.Condition = this.SummaryPeriodEarnedEfficiency_Good.Condition.Replace(strReplaceFrom, strReplaceTo);
this.ItemCumulativeEarnedEfficiency_Bad.Condition = this.ItemCumulativeEarnedEfficiency_Bad.Condition.Replace(strReplaceFrom, strReplaceTo);
this.ItemPeriodEarnedEfficiency_Bad.Condition = this.ItemPeriodEarnedEfficiency_Bad.Condition.Replace(strReplaceFrom, strReplaceTo);
this.SummaryPeriodBurnedEfficiency_Bad.Condition = this.SummaryPeriodBurnedEfficiency_Bad.Condition.Replace(strReplaceFrom, strReplaceTo);
this.SummaryCumulativeBurnedEfficiency_Bad.Condition = this.SummaryCumulativeBurnedEfficiency_Bad.Condition.Replace(strReplaceFrom, strReplaceTo);
this.SummaryCumulativeEarnedEfficiency_Bad.Condition = this.SummaryCumulativeEarnedEfficiency_Bad.Condition.Replace(strReplaceFrom, strReplaceTo);
this.SummaryPeriodEarnedEfficiency_Bad.Condition = this.SummaryPeriodEarnedEfficiency_Bad.Condition.Replace(strReplaceFrom, strReplaceTo);
}
private void TituloParceiroNegocioPessoaJuridicaPeriodoGrupoTipoReport_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
bindingSource.DataSource = TituloParceiroNegocioPessoaJuridicaRepository.GetListAtivos(GetExpression());
}
private void ParceiroNegocioPessoaFisicaDetalhadaReport_ParametersRequestSubmit(object sender, ParametersRequestEventArgs e)
{
}
