public UI_Usuarios(DevExpress.XtraBars.BarButtonItem opcionMenu, ref DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra, object objetoExtra1, object objetoExtra2, object objetoExtra3, object objetoExtra4) : base(opcionMenu, ref headerMenu, objetoExtra, objetoExtra1, objetoExtra2, objetoExtra3, objetoExtra4) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Usuarios..."); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Espere un momento por favor... Cargando y Validando Datos... ."); // InitializeComponent(); // usuarios = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Usuarios>(DevExpress.Xpo.XpoDefault.Session, true); // //usuarios.Where(e => e.login.Trim() == "gustavo"); //usuarios.Reload(); //bindingSource1.DataSource = usuarios.Where(e => e.login.Trim() == "gustavo"); //bindingSource1.Filter.Where(e => e.login == "gustavo"); // this.lookUpEdit_sucursales.Properties.DataSource = Fundraising_PT.Clases.Setting_Sucursales.data_sucursales(); bindingSource1.DataSource = usuarios; bindingSource1.Sort = "usuario"; // this.textBox_clave.textEdit1.Properties.PasswordChar = char.Parse("*"); // }
public UI_Configuracion_general(int ln_modo, DevExpress.XtraBars.BarButtonItem opcionMenu, DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra, object objetoExtra1, object objetoExtra2, object objetoExtra3, object objetoExtra4) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); if (ln_modo == 1) { DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Preferencias del Usuario..."); lAccion = "Preferencias del Usuario - Editando"; } else { DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Configuracion General..."); lAccion = "Configuracion General - Editando"; } DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Espere un momento por favor... Cargando y Validando Datos... ."); // InitializeComponent(); this.SetStyle(ControlStyles.ResizeRedraw, true); // Ln_modo = ln_modo; OpcionMenu = opcionMenu; HeaderMenu = headerMenu; ObjetoExtra = objetoExtra; ObjetoExtra1 = (DevExpress.XtraBars.BarButtonItem)objetoExtra1; ObjetoExtra2 = (DevExpress.XtraBars.BarButtonItem)objetoExtra2; ObjetoExtra3 = (DevExpress.XtraBars.BarButtonItem)objetoExtra3; ObjetoExtra4 = (DevExpress.XtraBars.BarButtonItem)objetoExtra4; lHeader_ant = HeaderMenu.Caption; }
public UI_Sesiones(DevExpress.XtraBars.BarButtonItem opcionMenu, ref DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra, object objetoExtra1, object objetoExtra2, object objetoExtra3, object objetoExtra4) : base(opcionMenu, ref headerMenu, objetoExtra, objetoExtra1, objetoExtra2, objetoExtra3, objetoExtra4) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Sesiones..."); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Espere un momento por favor... Cargando y Validando Datos... ."); // this.lookUpEdit_sucursales.Properties.DataSource = Fundraising_PT.Clases.Setting_Sucursales.data_sucursales(); InitializeComponent(); // usuarios = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Usuarios>(DevExpress.Xpo.XpoDefault.Session, true); //usuarios = new DevExpress.Xpo.XPCollection<Fundraising_PTDM.FUNDRAISING_PT.Usuarios>(PersistentCriteriaEvaluationBehavior.BeforeTransaction, DevExpress.Xpo.XpoDefault.Session, CriteriaOperator.Parse("1 = 1")); cajas = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Cajas>(DevExpress.Xpo.XpoDefault.Session, true); //cajas = new DevExpress.Xpo.XPCollection<Fundraising_PTDM.FUNDRAISING_PT.Cajas>(PersistentCriteriaEvaluationBehavior.BeforeTransaction, DevExpress.Xpo.XpoDefault.Session, CriteriaOperator.Parse(my_sucursal_filter)); cajeros = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Cajeros>(DevExpress.Xpo.XpoDefault.Session, true); //cajeros = new DevExpress.Xpo.XPCollection<Fundraising_PTDM.FUNDRAISING_PT.Cajeros>(PersistentCriteriaEvaluationBehavior.BeforeTransaction, DevExpress.Xpo.XpoDefault.Session, CriteriaOperator.Parse("1 = 1")); sucursales = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Sucursales>(DevExpress.Xpo.XpoDefault.Session, true); //sucursales = new DevExpress.Xpo.XPCollection<Fundraising_PTDM.FUNDRAISING_PT.Sucursales>(PersistentCriteriaEvaluationBehavior.BeforeTransaction, DevExpress.Xpo.XpoDefault.Session, CriteriaOperator.Parse("1 = 1")); sesiones = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Sesiones>(DevExpress.Xpo.XpoDefault.Session, true); //sesiones = new DevExpress.Xpo.XPCollection<Fundraising_PTDM.FUNDRAISING_PT.Sesiones>(PersistentCriteriaEvaluationBehavior.BeforeTransaction, DevExpress.Xpo.XpoDefault.Session, CriteriaOperator.Parse(my_sucursal_filter)); // bindingSource1.DataSource = sesiones; bindingSource1.Sort = "fecha_hora desc"; // }
public UI_Estado_Cuenta(DevExpress.XtraBars.BarButtonItem opcionMenu, DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Estado de Cuentas..."); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Espere un momento por favor... Cargando y Validando Datos... ."); // InitializeComponent(); this.SetStyle(ControlStyles.ResizeRedraw, true); // OpcionMenu = opcionMenu; HeaderMenu = headerMenu; ObjetoExtra = objetoExtra; lHeader_ant = HeaderMenu.Caption; // CriteriaOperator filtro_status = (new OperandProperty("status") == new OperandValue(1)); DevExpress.Xpo.SortingCollection orden_formas_pagos = new DevExpress.Xpo.SortingCollection(new DevExpress.Xpo.SortProperty("tpago", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_formas_pagos.Add(new DevExpress.Xpo.SortProperty("codigo", DevExpress.Xpo.DB.SortingDirection.Ascending)); DevExpress.Xpo.SortingCollection orden_saldos_recauda_dep = new DevExpress.Xpo.SortingCollection(new DevExpress.Xpo.SortProperty("recaudador.usuario", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_saldos_recauda_dep.Add(new DevExpress.Xpo.SortProperty("fecha_string", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_saldos_recauda_dep.Add(new DevExpress.Xpo.SortProperty("forma_pago.tpago", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_saldos_recauda_dep.Add(new DevExpress.Xpo.SortProperty("forma_pago.codigo", DevExpress.Xpo.DB.SortingDirection.Ascending)); // saldos_recauda_dep = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Saldos_Recauda_dep>(DevExpress.Xpo.XpoDefault.Session); formas_pagos = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Formas_Pagos>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("tpago", DevExpress.Xpo.DB.SortingDirection.Ascending)); usuarios = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Usuarios>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("usuario", DevExpress.Xpo.DB.SortingDirection.Ascending)); // bindingSource_formas_pagos.DataSource = formas_pagos; bindingSource_usuarios.DataSource = usuarios; formas_pagos.Sorting = orden_formas_pagos; saldos_recauda_dep.Sorting = orden_saldos_recauda_dep; }
public UI_Sesion_Recauda(DevExpress.XtraBars.BarButtonItem opcionMenu, DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra, object objetoExtra1, object objetoExtra2, object objetoExtra3, object objetoExtra4) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Sesiones Activas..."); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Espere un momento por favor... Cargando y Validando Datos... ."); // InitializeComponent(); this.SetStyle(ControlStyles.ResizeRedraw, true); // OpcionMenu = opcionMenu; HeaderMenu = headerMenu; ObjetoExtra = objetoExtra; ObjetoExtra1 = objetoExtra1; ObjetoExtra2 = objetoExtra2; ObjetoExtra3 = objetoExtra3; ObjetoExtra4 = objetoExtra4; lHeader_ant = HeaderMenu.Caption; // llena los datos de colecciones // CriteriaOperator filtro_sesiones = (new OperandProperty("status") == new OperandValue(1)) | (new OperandProperty("status") == new OperandValue(2)) | (new OperandProperty("status") == new OperandValue(3)) | (new OperandProperty("status") == new OperandValue(5)); sesiones = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Sesiones>(DevExpress.Xpo.XpoDefault.Session, true); orden_sesiones = new DevExpress.Xpo.SortingCollection(new DevExpress.Xpo.SortProperty("id_sesion", DevExpress.Xpo.DB.SortingDirection.Descending)); // bindeo de datos al bindingsource principal // string_filter_principal = Fundraising_PT.Properties.Settings.Default.sucursal_filter + " and (" + filtro_sesiones.ToString().Trim() + ")"; bindingSource1.DataSource = sesiones; sesiones.CriteriaString = string_filter_principal; sesiones.Sorting = orden_sesiones; sesiones.BeginLoad(true); }
public UI_Puntos_Bancarios(DevExpress.XtraBars.BarButtonItem opcionMenu, ref DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra, object objetoExtra1, object objetoExtra2, object objetoExtra3, object objetoExtra4) : base(opcionMenu, ref headerMenu, objetoExtra, objetoExtra1, objetoExtra2, objetoExtra3, objetoExtra4) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Puntos Bancarios..."); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Espere un momento por favor... Cargando y Validando Datos... ."); // InitializeComponent(); // this.lookUpEdit_sucursales.Properties.DataSource = Fundraising_PT.Clases.Setting_Sucursales.data_sucursales(); puntos_bancarios = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Puntos_Bancarios>(DevExpress.Xpo.XpoDefault.Session, true); bindingSource1.DataSource = puntos_bancarios; bindingSource1.Sort = "banco_cuenta.codigo_cuenta"; // }
// public UI_Sucursales(DevExpress.XtraBars.BarButtonItem opcionMenu, ref DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra, object objetoExtra1, object objetoExtra2, object objetoExtra3, object objetoExtra4) : base(opcionMenu, ref headerMenu, objetoExtra, objetoExtra1, objetoExtra2, objetoExtra3, objetoExtra4) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Sucursales..."); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Espere un momento por favor... Cargando y Validando Datos... ."); // InitializeComponent(); // sucursales = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Sucursales>(DevExpress.Xpo.XpoDefault.Session, true); // bindingSource1.DataSource = sucursales; bindingSource1.Sort = "codigo"; // }
public UI_Report_Deposito(DevExpress.XtraBars.BarButtonItem opcionMenu, DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Reporte de DĆ©positos Bancarios..."); // InitializeComponent(); this.SetStyle(ControlStyles.ResizeRedraw, true); // OpcionMenu = opcionMenu; HeaderMenu = headerMenu; ObjetoExtra = objetoExtra; lHeader_ant = HeaderMenu.Caption; // CriteriaOperator filtro_status = (new OperandProperty("status") == new OperandValue(1)); CriteriaOperator filtro_depositos = CriteriaOperator.Parse("1 = 2"); SortProperty orden_depositos = (new DevExpress.Xpo.SortProperty("fecha_hora", DevExpress.Xpo.DB.SortingDirection.Ascending)); // orden_fecha_ascendente_depositos.Add(new DevExpress.Xpo.SortProperty("sucursal", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_fecha_ascendente_depositos.Add(new DevExpress.Xpo.SortProperty("banco_cuenta.banco.nombre", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_fecha_ascendente_depositos.Add(new DevExpress.Xpo.SortProperty("banco_cuenta.codigo_cuenta", DevExpress.Xpo.DB.SortingDirection.Ascending)); // orden_fecha_descendente_depositos.Add(new DevExpress.Xpo.SortProperty("sucursal", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_fecha_descendente_depositos.Add(new DevExpress.Xpo.SortProperty("banco_cuenta.banco.nombre", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_fecha_descendente_depositos.Add(new DevExpress.Xpo.SortProperty("banco_cuenta.codigo_cuenta", DevExpress.Xpo.DB.SortingDirection.Ascending)); // depositos = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Depositos_Bancarios>(DevExpress.Xpo.XpoDefault.Session, filtro_depositos, orden_depositos); depositos.Sorting = orden_fecha_ascendente_depositos; // sucursales = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Sucursales>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("codigo", DevExpress.Xpo.DB.SortingDirection.Ascending)); bancos = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Bancos>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("nombre", DevExpress.Xpo.DB.SortingDirection.Ascending)); cuentas = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Bancos_Cuentas>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("codigo_cuenta", DevExpress.Xpo.DB.SortingDirection.Ascending)); responsables = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Responsable_depositos>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("nombre", DevExpress.Xpo.DB.SortingDirection.Ascending)); elaborados = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Usuarios>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("usuario", DevExpress.Xpo.DB.SortingDirection.Ascending)); revisados = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Usuarios>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("usuario", DevExpress.Xpo.DB.SortingDirection.Ascending)); // bindingSource_sucursales.DataSource = sucursales; bindingSource_banco.DataSource = bancos; bindingSource_cuenta.DataSource = cuentas; bindingSource_responsable.DataSource = responsables; bindingSource_elaborado.DataSource = elaborados; bindingSource_revisado.DataSource = revisados; }
public UI_Denominacion_Monedas(DevExpress.XtraBars.BarButtonItem opcionMenu, ref DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra, object objetoExtra1, object objetoExtra2, object objetoExtra3, object objetoExtra4) : base(opcionMenu, ref headerMenu, objetoExtra, objetoExtra1, objetoExtra2, objetoExtra3, objetoExtra4) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("DenominaciĆ³n de Monedas..."); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Espere un momento por favor... Cargando y Validando Datos... ."); // this.lookUpEdit_sucursales.Properties.DataSource = Fundraising_PT.Clases.Setting_Sucursales.data_sucursales(); InitializeComponent(); // Denominacion_Monedas = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Denominacion_Monedas>(DevExpress.Xpo.XpoDefault.Session, true); // DevExpress.Xpo.SortingCollection orden_denominacion_monedas = new DevExpress.Xpo.SortingCollection(new DevExpress.Xpo.SortProperty("tipo", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_denominacion_monedas.Add(new DevExpress.Xpo.SortProperty("valor", DevExpress.Xpo.DB.SortingDirection.Descending)); Denominacion_Monedas.Sorting = orden_denominacion_monedas; // bindingSource1.DataSource = Denominacion_Monedas; // }
public UI_Report_Estado_Cuenta(DevExpress.XtraBars.BarButtonItem opcionMenu, DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Reporte del Estado de Cuenta (Recaudado-DĆ©positado)..."); // InitializeComponent(); this.SetStyle(ControlStyles.ResizeRedraw, true); // OpcionMenu = opcionMenu; HeaderMenu = headerMenu; ObjetoExtra = objetoExtra; lHeader_ant = HeaderMenu.Caption; // CriteriaOperator filtro_status = (new OperandProperty("status") == new OperandValue(1)); CriteriaOperator filtro_saldos_recauda_dep = CriteriaOperator.Parse("1 = 2"); DevExpress.Xpo.SortingCollection orden_formas_pagos = new DevExpress.Xpo.SortingCollection(new DevExpress.Xpo.SortProperty("tpago", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_formas_pagos.Add(new DevExpress.Xpo.SortProperty("codigo", DevExpress.Xpo.DB.SortingDirection.Ascending)); DevExpress.Xpo.SortingCollection orden_saldos_recauda_dep = new DevExpress.Xpo.SortingCollection(new DevExpress.Xpo.SortProperty("forma_pago.tpago", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_saldos_recauda_dep.Add(new DevExpress.Xpo.SortProperty("recaudador.usuario", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_saldos_recauda_dep.Add(new DevExpress.Xpo.SortProperty("forma_pago.codigo", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_saldos_recauda_dep.Add(new DevExpress.Xpo.SortProperty("Substring(fecha_string,6,4)+Substring(fecha_string,3,2)+Substring(fecha_string,0,2)", DevExpress.Xpo.DB.SortingDirection.Ascending)); //orden_saldos_recauda_dep.Add(new DevExpress.Xpo.SortProperty("fecha_string", DevExpress.Xpo.DB.SortingDirection.Ascending)); // sucursales = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Sucursales>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("codigo", DevExpress.Xpo.DB.SortingDirection.Ascending)); saldos_recauda_dep = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Saldos_Recauda_dep>(DevExpress.Xpo.XpoDefault.Session, filtro_saldos_recauda_dep, new DevExpress.Xpo.SortProperty("forma_pago.tpago", DevExpress.Xpo.DB.SortingDirection.Ascending)); saldos_recauda_dep.Sorting = orden_saldos_recauda_dep; formas_pagos = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Formas_Pagos>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("tpago", DevExpress.Xpo.DB.SortingDirection.Ascending)); formas_pagos.Sorting = orden_formas_pagos; usuarios = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Usuarios>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("usuario", DevExpress.Xpo.DB.SortingDirection.Ascending)); // bindingSource_sucursales.DataSource = sucursales; bindingSource_recaudadores.DataSource = usuarios; bindingSource_formas_pagos.DataSource = formas_pagos; }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition3 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition4 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition5 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition6 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition7 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition8 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition9 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition10 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition11 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition12 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition13 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition14 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition15 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition16 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); this.calcAPOSVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField(); this.calcAPOSVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField(); this.calcINVVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField(); this.calcINVVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField(); this.calcNPSVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField(); this.calcNPSVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField(); this.calcDSVsTargetDay = new DevExpress.XtraPivotGrid.PivotGridField(); this.calcDSVsTargetMonth = new DevExpress.XtraPivotGrid.PivotGridField(); this.repositoryItemTextEditPers = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); this.repositoryItemTextEditf2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); this.repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); this.popupMenuMain = new DevExpress.XtraBars.PopupMenu(this.components); this.barManagerMain = new DevExpress.XtraBars.BarManager(this.components); this.bar1 = new DevExpress.XtraBars.Bar(); this.barHeaderItem1 = new DevExpress.XtraBars.BarHeaderItem(); this.bbiStartDate = new DevExpress.XtraBars.BarEditItem(); this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit(); this.barHeaderItem2 = new DevExpress.XtraBars.BarHeaderItem(); this.bbiEndDate = new DevExpress.XtraBars.BarEditItem(); this.repositoryItemDateEdit3 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit(); this.bbiGetData = new DevExpress.XtraBars.BarLargeButtonItem(); this.bbiExport = new DevExpress.XtraBars.BarButtonItem(); this.barDockControlTop = new DevExpress.XtraBars.BarDockControl(); this.barDockControlBottom = new DevExpress.XtraBars.BarDockControl(); this.barDockControlLeft = new DevExpress.XtraBars.BarDockControl(); this.barDockControlRight = new DevExpress.XtraBars.BarDockControl(); this.repositoryItemDateEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit(); this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl(); this.pro0001BindingSource = new System.Windows.Forms.BindingSource(this.components); this.dsNMQry = new NestleICSales.DataSources.dsQry(); this.fieldRouteNumber1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldRouteName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldSupervisor1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldRouteBrand1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPlantSalesDistrict1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPlantName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPlantBaseName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldDistributionChannel1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldAPOSLD = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldTargetAPOSDay = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldAPOS = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldTargetAPOS = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldINVLD = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldTargetINVDay = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldINV = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldTargetINV = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldNPSLD = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldTargetNPSDay = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldNPS = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldTargetNPS = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldDSLD1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldTargetDSDay = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldDS = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldTargetDS = new DevExpress.XtraPivotGrid.PivotGridField(); this.dxValidationProviderMain = new DevExpress.XtraEditors.DXErrorProvider.DXValidationProvider(this.components); this.pro_0001TableAdapter = new NestleICSales.DataSources.dsQryTableAdapters.Pro_0001TableAdapter(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pro0001BindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).BeginInit(); this.SuspendLayout(); // // calcAPOSVsTargetDay // this.calcAPOSVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcAPOSVsTargetDay.AreaIndex = 2; this.calcAPOSVsTargetDay.Caption = "APOS Vs Target LD"; this.calcAPOSVsTargetDay.EmptyCellText = "0"; this.calcAPOSVsTargetDay.EmptyValueText = "0"; this.calcAPOSVsTargetDay.GrandTotalCellFormat.FormatString = "p"; this.calcAPOSVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcAPOSVsTargetDay.Name = "calcAPOSVsTargetDay"; this.calcAPOSVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average; this.calcAPOSVsTargetDay.UnboundExpression = "([APOSLD] * 1.0) / [TargetAPOSDay]"; this.calcAPOSVsTargetDay.UnboundFieldName = "calcAPOSVsTarget"; this.calcAPOSVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // // calcAPOSVsTargetMonth // this.calcAPOSVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcAPOSVsTargetMonth.AreaIndex = 5; this.calcAPOSVsTargetMonth.Caption = "APOS Vs Target MTD"; this.calcAPOSVsTargetMonth.EmptyCellText = "0"; this.calcAPOSVsTargetMonth.EmptyValueText = "0"; this.calcAPOSVsTargetMonth.GrandTotalCellFormat.FormatString = "p"; this.calcAPOSVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcAPOSVsTargetMonth.Name = "calcAPOSVsTargetMonth"; this.calcAPOSVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average; this.calcAPOSVsTargetMonth.UnboundExpression = "([APOS] * 1.0) / [TargetAPOS]"; this.calcAPOSVsTargetMonth.UnboundFieldName = "calcAPOSVsTargetMonth"; this.calcAPOSVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // // calcINVVsTargetDay // this.calcINVVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcINVVsTargetDay.AreaIndex = 8; this.calcINVVsTargetDay.Caption = "INV Vs Target LD"; this.calcINVVsTargetDay.EmptyCellText = "0"; this.calcINVVsTargetDay.EmptyValueText = "0"; this.calcINVVsTargetDay.GrandTotalCellFormat.FormatString = "p"; this.calcINVVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcINVVsTargetDay.Name = "calcINVVsTargetDay"; this.calcINVVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average; this.calcINVVsTargetDay.UnboundExpression = "([INVLD] * 1.0) / [TargetINVDay]"; this.calcINVVsTargetDay.UnboundFieldName = "calcINVVsTargetDay"; this.calcINVVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // // calcINVVsTargetMonth // this.calcINVVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcINVVsTargetMonth.AreaIndex = 11; this.calcINVVsTargetMonth.Caption = "INV Vs Target MTD"; this.calcINVVsTargetMonth.EmptyCellText = "0"; this.calcINVVsTargetMonth.EmptyValueText = "0"; this.calcINVVsTargetMonth.GrandTotalCellFormat.FormatString = "p"; this.calcINVVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcINVVsTargetMonth.Name = "calcINVVsTargetMonth"; this.calcINVVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average; this.calcINVVsTargetMonth.UnboundExpression = "([INV] * 1.0) / [TargetINV]"; this.calcINVVsTargetMonth.UnboundFieldName = "calcINVVsTargetMonth"; this.calcINVVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // // calcNPSVsTargetDay // this.calcNPSVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcNPSVsTargetDay.AreaIndex = 14; this.calcNPSVsTargetDay.Caption = "NPS Vs Target LD"; this.calcNPSVsTargetDay.EmptyCellText = "0"; this.calcNPSVsTargetDay.EmptyValueText = "0"; this.calcNPSVsTargetDay.GrandTotalCellFormat.FormatString = "p"; this.calcNPSVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcNPSVsTargetDay.Name = "calcNPSVsTargetDay"; this.calcNPSVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average; this.calcNPSVsTargetDay.UnboundExpression = "([NPSLD] * 1.0) / [TargetNPSDay]"; this.calcNPSVsTargetDay.UnboundFieldName = "calcNPSVsTargetDay"; this.calcNPSVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // // calcNPSVsTargetMonth // this.calcNPSVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcNPSVsTargetMonth.AreaIndex = 17; this.calcNPSVsTargetMonth.Caption = "NPS Vs Target MTD"; this.calcNPSVsTargetMonth.EmptyCellText = "0"; this.calcNPSVsTargetMonth.EmptyValueText = "0"; this.calcNPSVsTargetMonth.GrandTotalCellFormat.FormatString = "p"; this.calcNPSVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcNPSVsTargetMonth.Name = "calcNPSVsTargetMonth"; this.calcNPSVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average; this.calcNPSVsTargetMonth.UnboundExpression = "([NPS] * 1.0) / [TargetNPS]"; this.calcNPSVsTargetMonth.UnboundFieldName = "calcNPSVsTargetMonth"; this.calcNPSVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // // calcDSVsTargetDay // this.calcDSVsTargetDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcDSVsTargetDay.AreaIndex = 20; this.calcDSVsTargetDay.Caption = "DS Vs Target LD"; this.calcDSVsTargetDay.EmptyCellText = "0"; this.calcDSVsTargetDay.EmptyValueText = "0"; this.calcDSVsTargetDay.GrandTotalCellFormat.FormatString = "p"; this.calcDSVsTargetDay.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcDSVsTargetDay.Name = "calcDSVsTargetDay"; this.calcDSVsTargetDay.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average; this.calcDSVsTargetDay.UnboundExpression = "([DSLD] * 1.0) / [TargetDSDay]"; this.calcDSVsTargetDay.UnboundFieldName = "calcDSVsTargetDay"; this.calcDSVsTargetDay.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // // calcDSVsTargetMonth // this.calcDSVsTargetMonth.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcDSVsTargetMonth.AreaIndex = 23; this.calcDSVsTargetMonth.Caption = "DS Vs Target MTD"; this.calcDSVsTargetMonth.EmptyCellText = "0"; this.calcDSVsTargetMonth.EmptyValueText = "0"; this.calcDSVsTargetMonth.GrandTotalCellFormat.FormatString = "p"; this.calcDSVsTargetMonth.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcDSVsTargetMonth.Name = "calcDSVsTargetMonth"; this.calcDSVsTargetMonth.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Average; this.calcDSVsTargetMonth.UnboundExpression = "([DS] * 1.0) / [TargetDS]"; this.calcDSVsTargetMonth.UnboundFieldName = "calcDSVsTargetMonth"; this.calcDSVsTargetMonth.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // // repositoryItemTextEditPers // this.repositoryItemTextEditPers.AutoHeight = false; this.repositoryItemTextEditPers.EditFormat.FormatString = "P1"; this.repositoryItemTextEditPers.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.repositoryItemTextEditPers.ExportMode = DevExpress.XtraEditors.Repository.ExportMode.DisplayText; this.repositoryItemTextEditPers.Mask.EditMask = "P1"; this.repositoryItemTextEditPers.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; this.repositoryItemTextEditPers.Mask.UseMaskAsDisplayFormat = true; this.repositoryItemTextEditPers.Name = "repositoryItemTextEditPers"; // // repositoryItemTextEditf2 // this.repositoryItemTextEditf2.AutoHeight = false; this.repositoryItemTextEditf2.DisplayFormat.FormatString = "f2"; this.repositoryItemTextEditf2.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.repositoryItemTextEditf2.Mask.EditMask = "f2"; this.repositoryItemTextEditf2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; this.repositoryItemTextEditf2.Name = "repositoryItemTextEditf2"; // // repositoryItemTextEdit1 // this.repositoryItemTextEdit1.AutoHeight = false; this.repositoryItemTextEdit1.Name = "repositoryItemTextEdit1"; // // popupMenuMain // this.popupMenuMain.Manager = this.barManagerMain; this.popupMenuMain.Name = "popupMenuMain"; // // barManagerMain // this.barManagerMain.Bars.AddRange(new DevExpress.XtraBars.Bar[] { this.bar1}); this.barManagerMain.DockControls.Add(this.barDockControlTop); this.barManagerMain.DockControls.Add(this.barDockControlBottom); this.barManagerMain.DockControls.Add(this.barDockControlLeft); this.barManagerMain.DockControls.Add(this.barDockControlRight); this.barManagerMain.Form = this; this.barManagerMain.Items.AddRange(new DevExpress.XtraBars.BarItem[] { this.bbiExport, this.bbiStartDate, this.barHeaderItem1, this.bbiGetData, this.barHeaderItem2, this.bbiEndDate}); this.barManagerMain.MaxItemId = 12; this.barManagerMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { this.repositoryItemDateEdit1, this.repositoryItemDateEdit2, this.repositoryItemDateEdit3}); // // bar1 // this.bar1.BarName = "Main"; this.bar1.DockCol = 0; this.bar1.DockRow = 0; this.bar1.DockStyle = DevExpress.XtraBars.BarDockStyle.Top; this.bar1.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] { new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem1), new DevExpress.XtraBars.LinkPersistInfo(this.bbiStartDate), new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem2), new DevExpress.XtraBars.LinkPersistInfo(this.bbiEndDate), new DevExpress.XtraBars.LinkPersistInfo(DevExpress.XtraBars.BarLinkUserDefines.PaintStyle, this.bbiGetData, DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph), new DevExpress.XtraBars.LinkPersistInfo(this.bbiExport)}); this.bar1.Text = "Custom 2"; // // barHeaderItem1 // this.barHeaderItem1.Caption = "Start Date"; this.barHeaderItem1.Id = 3; this.barHeaderItem1.Name = "barHeaderItem1"; // // bbiStartDate // this.bbiStartDate.Caption = "Start Date"; this.bbiStartDate.Edit = this.repositoryItemDateEdit1; this.bbiStartDate.Id = 2; this.bbiStartDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D1)); this.bbiStartDate.Name = "bbiStartDate"; this.bbiStartDate.Width = 120; // // repositoryItemDateEdit1 // this.repositoryItemDateEdit1.AutoHeight = false; this.repositoryItemDateEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit1.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit1.Name = "repositoryItemDateEdit1"; // // barHeaderItem2 // this.barHeaderItem2.Caption = "EndDate"; this.barHeaderItem2.Id = 10; this.barHeaderItem2.Name = "barHeaderItem2"; // // bbiEndDate // this.bbiEndDate.Caption = "End Date"; this.bbiEndDate.Edit = this.repositoryItemDateEdit3; this.bbiEndDate.Id = 11; this.bbiEndDate.Name = "bbiEndDate"; this.bbiEndDate.Width = 120; // // repositoryItemDateEdit3 // this.repositoryItemDateEdit3.AutoHeight = false; this.repositoryItemDateEdit3.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit3.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit3.Name = "repositoryItemDateEdit3"; // // bbiGetData // this.bbiGetData.Caption = "Get Data"; this.bbiGetData.CaptionAlignment = DevExpress.XtraBars.BarItemCaptionAlignment.Right; this.bbiGetData.Glyph = global::NestleICSales.Properties.Resources.apply_16x16; this.bbiGetData.Id = 9; this.bbiGetData.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.G)); this.bbiGetData.Name = "bbiGetData"; this.bbiGetData.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiGetData_ItemClick); // // bbiExport // this.bbiExport.Caption = "Export"; this.bbiExport.Glyph = global::NestleICSales.Properties.Resources.Export; this.bbiExport.Id = 1; this.bbiExport.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.E)); this.bbiExport.Name = "bbiExport"; this.bbiExport.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExport_ItemClick); // // barDockControlTop // this.barDockControlTop.CausesValidation = false; this.barDockControlTop.Dock = System.Windows.Forms.DockStyle.Top; this.barDockControlTop.Location = new System.Drawing.Point(0, 0); this.barDockControlTop.Size = new System.Drawing.Size(1132, 31); // // barDockControlBottom // this.barDockControlBottom.CausesValidation = false; this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom; this.barDockControlBottom.Location = new System.Drawing.Point(0, 311); this.barDockControlBottom.Size = new System.Drawing.Size(1132, 0); // // barDockControlLeft // this.barDockControlLeft.CausesValidation = false; this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left; this.barDockControlLeft.Location = new System.Drawing.Point(0, 31); this.barDockControlLeft.Size = new System.Drawing.Size(0, 280); // // barDockControlRight // this.barDockControlRight.CausesValidation = false; this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right; this.barDockControlRight.Location = new System.Drawing.Point(1132, 31); this.barDockControlRight.Size = new System.Drawing.Size(0, 280); // // repositoryItemDateEdit2 // this.repositoryItemDateEdit2.AutoHeight = false; this.repositoryItemDateEdit2.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit2.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit2.Name = "repositoryItemDateEdit2"; // // pivotGridControlMain // this.pivotGridControlMain.DataSource = this.pro0001BindingSource; this.pivotGridControlMain.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControlMain.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldRouteNumber1, this.fieldRouteName1, this.fieldSupervisor1, this.fieldRouteBrand1, this.fieldPlantSalesDistrict1, this.fieldPlantName1, this.fieldPlantBaseName1, this.fieldDistributionChannel1, this.fieldAPOSLD, this.fieldTargetAPOSDay, this.fieldAPOS, this.fieldTargetAPOS, this.fieldINVLD, this.fieldTargetINVDay, this.fieldINV, this.fieldTargetINV, this.fieldNPSLD, this.fieldTargetNPSDay, this.fieldNPS, this.fieldTargetNPS, this.fieldDSLD1, this.fieldTargetDSDay, this.fieldDS, this.fieldTargetDS, this.calcAPOSVsTargetDay, this.calcAPOSVsTargetMonth, this.calcINVVsTargetDay, this.calcINVVsTargetMonth, this.calcNPSVsTargetDay, this.calcNPSVsTargetMonth, this.calcDSVsTargetDay, this.calcDSVsTargetMonth}); pivotGridStyleFormatCondition1.Appearance.BackColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition1.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition1.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition1.Field = this.calcAPOSVsTargetDay; pivotGridStyleFormatCondition1.FieldName = "calcAPOSVsTargetDay"; pivotGridStyleFormatCondition1.Value1 = "1"; pivotGridStyleFormatCondition2.Appearance.BackColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition2.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition2.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition2.Field = this.calcAPOSVsTargetDay; pivotGridStyleFormatCondition2.FieldName = "calcAPOSVsTargetDay"; pivotGridStyleFormatCondition2.Value1 = "1"; pivotGridStyleFormatCondition3.Appearance.BackColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition3.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition3.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition3.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition3.Field = this.calcAPOSVsTargetMonth; pivotGridStyleFormatCondition3.FieldName = "calcAPOSVsTargetMonth"; pivotGridStyleFormatCondition3.Value1 = "1"; pivotGridStyleFormatCondition4.Appearance.BackColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition4.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition4.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition4.Field = this.calcAPOSVsTargetMonth; pivotGridStyleFormatCondition4.FieldName = "calcAPOSVsTargetMonth"; pivotGridStyleFormatCondition4.Value1 = "1"; pivotGridStyleFormatCondition5.Appearance.BackColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition5.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition5.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition5.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition5.Field = this.calcINVVsTargetDay; pivotGridStyleFormatCondition5.FieldName = "calcINVVsTargetDay"; pivotGridStyleFormatCondition5.Value1 = "1"; pivotGridStyleFormatCondition6.Appearance.BackColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition6.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition6.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition6.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition6.Field = this.calcINVVsTargetDay; pivotGridStyleFormatCondition6.FieldName = "calcINVVsTargetDay"; pivotGridStyleFormatCondition6.Value1 = "1"; pivotGridStyleFormatCondition7.Appearance.BackColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition7.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition7.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition7.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition7.Field = this.calcINVVsTargetMonth; pivotGridStyleFormatCondition7.FieldName = "calcINVVsTargetMonth"; pivotGridStyleFormatCondition7.Value1 = "1"; pivotGridStyleFormatCondition8.Appearance.BackColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition8.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition8.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition8.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition8.Field = this.calcINVVsTargetMonth; pivotGridStyleFormatCondition8.FieldName = "calcINVVsTargetMonth"; pivotGridStyleFormatCondition8.Value1 = "1"; pivotGridStyleFormatCondition9.Appearance.BackColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition9.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition9.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition9.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition9.Field = this.calcNPSVsTargetDay; pivotGridStyleFormatCondition9.FieldName = "calcNPSVsTargetDay"; pivotGridStyleFormatCondition9.Value1 = "1"; pivotGridStyleFormatCondition10.Appearance.BackColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition10.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition10.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition10.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition10.Field = this.calcNPSVsTargetDay; pivotGridStyleFormatCondition10.FieldName = "calcNPSVsTargetDay"; pivotGridStyleFormatCondition10.Value1 = "1"; pivotGridStyleFormatCondition11.Appearance.BackColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition11.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition11.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition11.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition11.Field = this.calcNPSVsTargetMonth; pivotGridStyleFormatCondition11.FieldName = "calcNPSVsTargetMonth"; pivotGridStyleFormatCondition11.Value1 = "1"; pivotGridStyleFormatCondition12.Appearance.BackColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition12.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition12.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition12.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition12.Field = this.calcNPSVsTargetMonth; pivotGridStyleFormatCondition12.FieldName = "calcNPSVsTargetMonth"; pivotGridStyleFormatCondition12.Value1 = "1"; pivotGridStyleFormatCondition13.Appearance.BackColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition13.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition13.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition13.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition13.Field = this.calcDSVsTargetDay; pivotGridStyleFormatCondition13.FieldName = "calcDSVsTargetDay"; pivotGridStyleFormatCondition13.Value1 = "1"; pivotGridStyleFormatCondition14.Appearance.BackColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition14.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition14.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition14.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition14.Field = this.calcDSVsTargetDay; pivotGridStyleFormatCondition14.FieldName = "calcDSVsTargetDay"; pivotGridStyleFormatCondition14.Value1 = "1"; pivotGridStyleFormatCondition15.Appearance.BackColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition15.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition15.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition15.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition15.Field = this.calcDSVsTargetMonth; pivotGridStyleFormatCondition15.FieldName = "calcDSVsTargetMonth"; pivotGridStyleFormatCondition15.Value1 = "1"; pivotGridStyleFormatCondition16.Appearance.BackColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition16.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition16.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition16.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition16.Field = this.calcDSVsTargetMonth; pivotGridStyleFormatCondition16.FieldName = "calcDSVsTargetMonth"; pivotGridStyleFormatCondition16.Value1 = "1"; this.pivotGridControlMain.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] { pivotGridStyleFormatCondition1, pivotGridStyleFormatCondition2, pivotGridStyleFormatCondition3, pivotGridStyleFormatCondition4, pivotGridStyleFormatCondition5, pivotGridStyleFormatCondition6, pivotGridStyleFormatCondition7, pivotGridStyleFormatCondition8, pivotGridStyleFormatCondition9, pivotGridStyleFormatCondition10, pivotGridStyleFormatCondition11, pivotGridStyleFormatCondition12, pivotGridStyleFormatCondition13, pivotGridStyleFormatCondition14, pivotGridStyleFormatCondition15, pivotGridStyleFormatCondition16}); this.pivotGridControlMain.Location = new System.Drawing.Point(0, 31); this.pivotGridControlMain.Name = "pivotGridControlMain"; this.pivotGridControlMain.OptionsPrint.PrintColumnHeaders = DevExpress.Utils.DefaultBoolean.False; this.pivotGridControlMain.OptionsPrint.PrintDataHeaders = DevExpress.Utils.DefaultBoolean.False; this.pivotGridControlMain.OptionsPrint.PrintFilterHeaders = DevExpress.Utils.DefaultBoolean.False; this.pivotGridControlMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { this.repositoryItemTextEditPers}); this.pivotGridControlMain.Size = new System.Drawing.Size(1132, 280); this.pivotGridControlMain.TabIndex = 9; // // pro0001BindingSource // this.pro0001BindingSource.DataMember = "Pro_0001"; this.pro0001BindingSource.DataSource = this.dsNMQry; // // dsNMQry // this.dsNMQry.DataSetName = "dsNMQry"; this.dsNMQry.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // fieldRouteNumber1 // this.fieldRouteNumber1.AreaIndex = 0; this.fieldRouteNumber1.Caption = "Route Number"; this.fieldRouteNumber1.FieldName = "RouteNumber"; this.fieldRouteNumber1.Name = "fieldRouteNumber1"; // // fieldRouteName1 // this.fieldRouteName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldRouteName1.AreaIndex = 1; this.fieldRouteName1.Caption = "Route Name"; this.fieldRouteName1.FieldName = "RouteName"; this.fieldRouteName1.Name = "fieldRouteName1"; // // fieldSupervisor1 // this.fieldSupervisor1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldSupervisor1.AreaIndex = 0; this.fieldSupervisor1.Caption = "Supervisor"; this.fieldSupervisor1.FieldName = "Supervisor"; this.fieldSupervisor1.Name = "fieldSupervisor1"; // // fieldRouteBrand1 // this.fieldRouteBrand1.AreaIndex = 1; this.fieldRouteBrand1.Caption = "Route Brand"; this.fieldRouteBrand1.FieldName = "RouteBrand"; this.fieldRouteBrand1.Name = "fieldRouteBrand1"; // // fieldPlantSalesDistrict1 // this.fieldPlantSalesDistrict1.AreaIndex = 2; this.fieldPlantSalesDistrict1.Caption = "Plant Sales District"; this.fieldPlantSalesDistrict1.FieldName = "PlantSalesDistrict"; this.fieldPlantSalesDistrict1.Name = "fieldPlantSalesDistrict1"; // // fieldPlantName1 // this.fieldPlantName1.AreaIndex = 3; this.fieldPlantName1.Caption = "Plant Name"; this.fieldPlantName1.FieldName = "PlantName"; this.fieldPlantName1.Name = "fieldPlantName1"; // // fieldPlantBaseName1 // this.fieldPlantBaseName1.AreaIndex = 4; this.fieldPlantBaseName1.Caption = "Plant Base Name"; this.fieldPlantBaseName1.FieldName = "PlantBaseName"; this.fieldPlantBaseName1.Name = "fieldPlantBaseName1"; // // fieldDistributionChannel1 // this.fieldDistributionChannel1.AreaIndex = 5; this.fieldDistributionChannel1.Caption = "Distribution Channel"; this.fieldDistributionChannel1.FieldName = "DistributionChannel"; this.fieldDistributionChannel1.Name = "fieldDistributionChannel1"; // // fieldAPOSLD // this.fieldAPOSLD.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldAPOSLD.AreaIndex = 0; this.fieldAPOSLD.Caption = "APOS LD"; this.fieldAPOSLD.CellFormat.FormatString = "f2"; this.fieldAPOSLD.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldAPOSLD.EmptyCellText = "0"; this.fieldAPOSLD.EmptyValueText = "0"; this.fieldAPOSLD.FieldName = "APOSLD"; this.fieldAPOSLD.Name = "fieldAPOSLD"; // // fieldTargetAPOSDay // this.fieldTargetAPOSDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldTargetAPOSDay.AreaIndex = 1; this.fieldTargetAPOSDay.Caption = "APOS Target LD"; this.fieldTargetAPOSDay.CellFormat.FormatString = "f2"; this.fieldTargetAPOSDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldTargetAPOSDay.EmptyCellText = "0"; this.fieldTargetAPOSDay.EmptyValueText = "0"; this.fieldTargetAPOSDay.FieldName = "TargetAPOSDay"; this.fieldTargetAPOSDay.Name = "fieldTargetAPOSDay"; // // fieldAPOS // this.fieldAPOS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldAPOS.AreaIndex = 3; this.fieldAPOS.Caption = "APOS MTD"; this.fieldAPOS.CellFormat.FormatString = "f2"; this.fieldAPOS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldAPOS.EmptyCellText = "0"; this.fieldAPOS.EmptyValueText = "0"; this.fieldAPOS.FieldName = "APOS"; this.fieldAPOS.Name = "fieldAPOS"; // // fieldTargetAPOS // this.fieldTargetAPOS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldTargetAPOS.AreaIndex = 4; this.fieldTargetAPOS.Caption = "APOS Target MTD"; this.fieldTargetAPOS.CellFormat.FormatString = "f2"; this.fieldTargetAPOS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldTargetAPOS.EmptyCellText = "0"; this.fieldTargetAPOS.EmptyValueText = "0"; this.fieldTargetAPOS.FieldName = "TargetAPOS"; this.fieldTargetAPOS.Name = "fieldTargetAPOS"; // // fieldINVLD // this.fieldINVLD.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldINVLD.AreaIndex = 6; this.fieldINVLD.Caption = "INV LD"; this.fieldINVLD.CellFormat.FormatString = "f2"; this.fieldINVLD.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldINVLD.EmptyCellText = "0"; this.fieldINVLD.EmptyValueText = "0"; this.fieldINVLD.FieldName = "INVLD"; this.fieldINVLD.Name = "fieldINVLD"; // // fieldTargetINVDay // this.fieldTargetINVDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldTargetINVDay.AreaIndex = 7; this.fieldTargetINVDay.Caption = "INV Target LD"; this.fieldTargetINVDay.CellFormat.FormatString = "f2"; this.fieldTargetINVDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldTargetINVDay.EmptyCellText = "0"; this.fieldTargetINVDay.EmptyValueText = "0"; this.fieldTargetINVDay.FieldName = "TargetINVDay"; this.fieldTargetINVDay.Name = "fieldTargetINVDay"; // // fieldINV // this.fieldINV.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldINV.AreaIndex = 9; this.fieldINV.Caption = "INV MTD"; this.fieldINV.CellFormat.FormatString = "f2"; this.fieldINV.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldINV.EmptyCellText = "0"; this.fieldINV.EmptyValueText = "0"; this.fieldINV.FieldName = "INV"; this.fieldINV.Name = "fieldINV"; // // fieldTargetINV // this.fieldTargetINV.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldTargetINV.AreaIndex = 10; this.fieldTargetINV.Caption = "INV Target MTD"; this.fieldTargetINV.CellFormat.FormatString = "f2"; this.fieldTargetINV.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldTargetINV.EmptyCellText = "0"; this.fieldTargetINV.EmptyValueText = "0"; this.fieldTargetINV.FieldName = "TargetINV"; this.fieldTargetINV.Name = "fieldTargetINV"; // // fieldNPSLD // this.fieldNPSLD.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldNPSLD.AreaIndex = 12; this.fieldNPSLD.Caption = "NPS LD"; this.fieldNPSLD.CellFormat.FormatString = "f2"; this.fieldNPSLD.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldNPSLD.EmptyCellText = "0"; this.fieldNPSLD.EmptyValueText = "0"; this.fieldNPSLD.FieldName = "NPSLD"; this.fieldNPSLD.Name = "fieldNPSLD"; // // fieldTargetNPSDay // this.fieldTargetNPSDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldTargetNPSDay.AreaIndex = 13; this.fieldTargetNPSDay.Caption = "NPS Target LD"; this.fieldTargetNPSDay.CellFormat.FormatString = "f2"; this.fieldTargetNPSDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldTargetNPSDay.EmptyCellText = "0"; this.fieldTargetNPSDay.EmptyValueText = "0"; this.fieldTargetNPSDay.FieldName = "TargetNPSDay"; this.fieldTargetNPSDay.Name = "fieldTargetNPSDay"; // // fieldNPS // this.fieldNPS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldNPS.AreaIndex = 15; this.fieldNPS.Caption = "NPS MTD"; this.fieldNPS.CellFormat.FormatString = "f2"; this.fieldNPS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldNPS.EmptyCellText = "0"; this.fieldNPS.EmptyValueText = "0"; this.fieldNPS.FieldName = "NPS"; this.fieldNPS.Name = "fieldNPS"; // // fieldTargetNPS // this.fieldTargetNPS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldTargetNPS.AreaIndex = 16; this.fieldTargetNPS.Caption = "NPS Target MTD"; this.fieldTargetNPS.CellFormat.FormatString = "f2"; this.fieldTargetNPS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldTargetNPS.EmptyCellText = "0"; this.fieldTargetNPS.EmptyValueText = "0"; this.fieldTargetNPS.FieldName = "TargetNPS"; this.fieldTargetNPS.Name = "fieldTargetNPS"; // // fieldDSLD1 // this.fieldDSLD1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldDSLD1.AreaIndex = 18; this.fieldDSLD1.Caption = "DS LD"; this.fieldDSLD1.CellFormat.FormatString = "f2"; this.fieldDSLD1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldDSLD1.EmptyCellText = "0"; this.fieldDSLD1.EmptyValueText = "0"; this.fieldDSLD1.FieldName = "DSLD"; this.fieldDSLD1.Name = "fieldDSLD1"; // // fieldTargetDSDay // this.fieldTargetDSDay.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldTargetDSDay.AreaIndex = 19; this.fieldTargetDSDay.Caption = "DS Target LD"; this.fieldTargetDSDay.CellFormat.FormatString = "f2"; this.fieldTargetDSDay.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldTargetDSDay.EmptyCellText = "0"; this.fieldTargetDSDay.EmptyValueText = "0"; this.fieldTargetDSDay.FieldName = "TargetDSDay"; this.fieldTargetDSDay.Name = "fieldTargetDSDay"; // // fieldDS // this.fieldDS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldDS.AreaIndex = 21; this.fieldDS.Caption = "DS MTD"; this.fieldDS.CellFormat.FormatString = "f2"; this.fieldDS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldDS.EmptyCellText = "0"; this.fieldDS.EmptyValueText = "0"; this.fieldDS.FieldName = "DS"; this.fieldDS.Name = "fieldDS"; // // fieldTargetDS // this.fieldTargetDS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldTargetDS.AreaIndex = 22; this.fieldTargetDS.Caption = "DS Target MTD"; this.fieldTargetDS.CellFormat.FormatString = "f2"; this.fieldTargetDS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldTargetDS.EmptyCellText = "0"; this.fieldTargetDS.EmptyValueText = "0"; this.fieldTargetDS.FieldName = "TargetDS"; this.fieldTargetDS.Name = "fieldTargetDS"; // // pro_0001TableAdapter // this.pro_0001TableAdapter.ClearBeforeFill = true; // // QryPro_0001BFrm // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(1132, 311); this.Controls.Add(this.pivotGridControlMain); this.Controls.Add(this.barDockControlLeft); this.Controls.Add(this.barDockControlRight); this.Controls.Add(this.barDockControlBottom); this.Controls.Add(this.barDockControlTop); this.Icon = global::NestleICSales.Properties.Resources.Qry16; this.Name = "QryPro_0001BFrm"; this.Text = "Actual KPI Vs Target"; ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pro0001BindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition3 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition4 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition5 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition6 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition7 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition8 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); this.calcCases = new DevExpress.XtraPivotGrid.PivotGridField(); this.calcNPS = new DevExpress.XtraPivotGrid.PivotGridField(); this.calcVolume = new DevExpress.XtraPivotGrid.PivotGridField(); this.calcPPL = new DevExpress.XtraPivotGrid.PivotGridField(); this.repositoryItemTextEditf2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); this.repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); this.popupMenuMain = new DevExpress.XtraBars.PopupMenu(this.components); this.barManagerMain = new DevExpress.XtraBars.BarManager(this.components); this.bar1 = new DevExpress.XtraBars.Bar(); this.barHeaderItem1 = new DevExpress.XtraBars.BarHeaderItem(); this.bbiStartDate = new DevExpress.XtraBars.BarEditItem(); this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit(); this.barHeaderItem2 = new DevExpress.XtraBars.BarHeaderItem(); this.bbiEndDate = new DevExpress.XtraBars.BarEditItem(); this.repositoryItemDateEdit3 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit(); this.bbiGetData = new DevExpress.XtraBars.BarLargeButtonItem(); this.bbiExport = new DevExpress.XtraBars.BarButtonItem(); this.barDockControlTop = new DevExpress.XtraBars.BarDockControl(); this.barDockControlBottom = new DevExpress.XtraBars.BarDockControl(); this.barDockControlLeft = new DevExpress.XtraBars.BarDockControl(); this.barDockControlRight = new DevExpress.XtraBars.BarDockControl(); this.repositoryItemDateEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit(); this.dxValidationProviderMain = new DevExpress.XtraEditors.DXErrorProvider.DXValidationProvider(this.components); this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl(); this.pro0004BindingSource = new System.Windows.Forms.BindingSource(this.components); this.dsNMQry = new NestleICSales.DataSources.dsQry(); this.fieldMaterialNumber1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldTypeName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldDistributionChannel1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldMaterialName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProductBase1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldBrand1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProductGroup31 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProductGroup21 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldProductGroup11 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPriceChanges1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPricePointRang1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldMaterialType1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldFlavor1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldNPDS1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPricePoint1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCases1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldNPS1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldVolume1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPPL1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldYearNo = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCustHierLevel3Name = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCustomerGroup = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCustomerType = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCustomerType2 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldRouteNumber = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldSubchannelName = new DevExpress.XtraPivotGrid.PivotGridField(); this.repositoryItemTextEditPer = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); this.pro_0004TableAdapter = new NestleICSales.DataSources.dsQryTableAdapters.Pro_0004TableAdapter(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pro0004BindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPer)).BeginInit(); this.SuspendLayout(); // // calcCases // this.calcCases.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcCases.AreaIndex = 1; this.calcCases.Caption = "Cases%"; this.calcCases.CellFormat.FormatString = "p2"; this.calcCases.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcCases.DisplayFolder = "0.0%"; this.calcCases.EmptyCellText = "0.0%"; this.calcCases.FieldName = "Cases"; this.calcCases.GrandTotalCellFormat.FormatString = "p2"; this.calcCases.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcCases.Name = "calcCases"; this.calcCases.Options.ShowGrandTotal = false; this.calcCases.Options.ShowUnboundExpressionMenu = true; this.calcCases.TotalCellFormat.FormatString = "p2"; this.calcCases.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcCases.TotalValueFormat.FormatString = "p2"; this.calcCases.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcCases.ValueFormat.FormatString = "p2"; this.calcCases.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // calcNPS // this.calcNPS.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcNPS.AreaIndex = 3; this.calcNPS.Caption = "NPS%"; this.calcNPS.CellFormat.FormatString = "p2"; this.calcNPS.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcNPS.DisplayFolder = "0.0%"; this.calcNPS.EmptyCellText = "0.0%"; this.calcNPS.FieldName = "NPS"; this.calcNPS.GrandTotalCellFormat.FormatString = "p2"; this.calcNPS.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcNPS.Name = "calcNPS"; this.calcNPS.Options.ShowGrandTotal = false; this.calcNPS.Options.ShowUnboundExpressionMenu = true; this.calcNPS.TotalCellFormat.FormatString = "p2"; this.calcNPS.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcNPS.TotalValueFormat.FormatString = "p2"; this.calcNPS.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcNPS.ValueFormat.FormatString = "p2"; this.calcNPS.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // calcVolume // this.calcVolume.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcVolume.AreaIndex = 5; this.calcVolume.Caption = "Volume%"; this.calcVolume.CellFormat.FormatString = "p2"; this.calcVolume.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcVolume.DisplayFolder = "0.0%"; this.calcVolume.EmptyCellText = "0.0%"; this.calcVolume.FieldName = "Volume"; this.calcVolume.GrandTotalCellFormat.FormatString = "p2"; this.calcVolume.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcVolume.Name = "calcVolume"; this.calcVolume.Options.ShowGrandTotal = false; this.calcVolume.Options.ShowUnboundExpressionMenu = true; this.calcVolume.TotalCellFormat.FormatString = "p2"; this.calcVolume.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcVolume.TotalValueFormat.FormatString = "p2"; this.calcVolume.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcVolume.ValueFormat.FormatString = "p2"; this.calcVolume.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // calcPPL // this.calcPPL.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcPPL.AreaIndex = 7; this.calcPPL.Caption = "PPL%"; this.calcPPL.CellFormat.FormatString = "p2"; this.calcPPL.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcPPL.DisplayFolder = "0.0%"; this.calcPPL.EmptyCellText = "0.0%"; this.calcPPL.FieldName = "PPL"; this.calcPPL.GrandTotalCellFormat.FormatString = "p2"; this.calcPPL.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcPPL.Name = "calcPPL"; this.calcPPL.Options.ShowGrandTotal = false; this.calcPPL.Options.ShowUnboundExpressionMenu = true; this.calcPPL.TotalCellFormat.FormatString = "p2"; this.calcPPL.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcPPL.TotalValueFormat.FormatString = "p2"; this.calcPPL.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.calcPPL.ValueFormat.FormatString = "p2"; this.calcPPL.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // repositoryItemTextEditf2 // this.repositoryItemTextEditf2.AutoHeight = false; this.repositoryItemTextEditf2.DisplayFormat.FormatString = "f2"; this.repositoryItemTextEditf2.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.repositoryItemTextEditf2.Mask.EditMask = "f2"; this.repositoryItemTextEditf2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; this.repositoryItemTextEditf2.Name = "repositoryItemTextEditf2"; // // repositoryItemTextEdit1 // this.repositoryItemTextEdit1.AutoHeight = false; this.repositoryItemTextEdit1.Name = "repositoryItemTextEdit1"; // // popupMenuMain // this.popupMenuMain.Manager = this.barManagerMain; this.popupMenuMain.Name = "popupMenuMain"; // // barManagerMain // this.barManagerMain.Bars.AddRange(new DevExpress.XtraBars.Bar[] { this.bar1}); this.barManagerMain.DockControls.Add(this.barDockControlTop); this.barManagerMain.DockControls.Add(this.barDockControlBottom); this.barManagerMain.DockControls.Add(this.barDockControlLeft); this.barManagerMain.DockControls.Add(this.barDockControlRight); this.barManagerMain.Form = this; this.barManagerMain.Items.AddRange(new DevExpress.XtraBars.BarItem[] { this.bbiExport, this.bbiStartDate, this.barHeaderItem1, this.bbiGetData, this.barHeaderItem2, this.bbiEndDate}); this.barManagerMain.MaxItemId = 13; this.barManagerMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { this.repositoryItemDateEdit1, this.repositoryItemDateEdit2, this.repositoryItemDateEdit3}); // // bar1 // this.bar1.BarName = "Main"; this.bar1.DockCol = 0; this.bar1.DockRow = 0; this.bar1.DockStyle = DevExpress.XtraBars.BarDockStyle.Top; this.bar1.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] { new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem1), new DevExpress.XtraBars.LinkPersistInfo(this.bbiStartDate), new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem2), new DevExpress.XtraBars.LinkPersistInfo(this.bbiEndDate), new DevExpress.XtraBars.LinkPersistInfo(DevExpress.XtraBars.BarLinkUserDefines.PaintStyle, this.bbiGetData, DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph), new DevExpress.XtraBars.LinkPersistInfo(this.bbiExport)}); this.bar1.Text = "Custom 2"; // // barHeaderItem1 // this.barHeaderItem1.Caption = "Select Date"; this.barHeaderItem1.Id = 3; this.barHeaderItem1.Name = "barHeaderItem1"; // // bbiStartDate // this.bbiStartDate.Caption = "Date Start"; this.bbiStartDate.Edit = this.repositoryItemDateEdit1; this.bbiStartDate.Id = 2; this.bbiStartDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D1)); this.bbiStartDate.Name = "bbiStartDate"; this.bbiStartDate.Width = 120; // // repositoryItemDateEdit1 // this.repositoryItemDateEdit1.AutoHeight = false; this.repositoryItemDateEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit1.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit1.Name = "repositoryItemDateEdit1"; // // barHeaderItem2 // this.barHeaderItem2.Caption = "End Date"; this.barHeaderItem2.Id = 11; this.barHeaderItem2.Name = "barHeaderItem2"; // // bbiEndDate // this.bbiEndDate.Caption = "Date End"; this.bbiEndDate.Edit = this.repositoryItemDateEdit3; this.bbiEndDate.Id = 12; this.bbiEndDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D2)); this.bbiEndDate.Name = "bbiEndDate"; this.bbiEndDate.Width = 120; // // repositoryItemDateEdit3 // this.repositoryItemDateEdit3.AutoHeight = false; this.repositoryItemDateEdit3.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit3.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit3.Name = "repositoryItemDateEdit3"; // // bbiGetData // this.bbiGetData.Caption = "Get Data"; this.bbiGetData.CaptionAlignment = DevExpress.XtraBars.BarItemCaptionAlignment.Right; this.bbiGetData.Glyph = global::NestleICSales.Properties.Resources.apply_16x16; this.bbiGetData.Id = 9; this.bbiGetData.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.G)); this.bbiGetData.Name = "bbiGetData"; this.bbiGetData.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiGetData_ItemClick); // // bbiExport // this.bbiExport.Caption = "Export"; this.bbiExport.Glyph = global::NestleICSales.Properties.Resources.Export; this.bbiExport.Id = 1; this.bbiExport.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.E)); this.bbiExport.Name = "bbiExport"; this.bbiExport.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExport_ItemClick); // // barDockControlTop // this.barDockControlTop.CausesValidation = false; this.barDockControlTop.Dock = System.Windows.Forms.DockStyle.Top; this.barDockControlTop.Location = new System.Drawing.Point(0, 0); this.barDockControlTop.Size = new System.Drawing.Size(1132, 31); // // barDockControlBottom // this.barDockControlBottom.CausesValidation = false; this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom; this.barDockControlBottom.Location = new System.Drawing.Point(0, 311); this.barDockControlBottom.Size = new System.Drawing.Size(1132, 0); // // barDockControlLeft // this.barDockControlLeft.CausesValidation = false; this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left; this.barDockControlLeft.Location = new System.Drawing.Point(0, 31); this.barDockControlLeft.Size = new System.Drawing.Size(0, 280); // // barDockControlRight // this.barDockControlRight.CausesValidation = false; this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right; this.barDockControlRight.Location = new System.Drawing.Point(1132, 31); this.barDockControlRight.Size = new System.Drawing.Size(0, 280); // // repositoryItemDateEdit2 // this.repositoryItemDateEdit2.AutoHeight = false; this.repositoryItemDateEdit2.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit2.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit2.Name = "repositoryItemDateEdit2"; // // pivotGridControlMain // this.pivotGridControlMain.DataSource = this.pro0004BindingSource; this.pivotGridControlMain.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControlMain.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldMaterialNumber1, this.fieldTypeName1, this.fieldDistributionChannel1, this.fieldMaterialName1, this.fieldProductBase1, this.fieldBrand1, this.fieldProductGroup31, this.fieldProductGroup21, this.fieldProductGroup11, this.fieldPriceChanges1, this.fieldPricePointRang1, this.fieldMaterialType1, this.fieldFlavor1, this.fieldNPDS1, this.fieldPricePoint1, this.fieldCases1, this.fieldNPS1, this.fieldVolume1, this.fieldPPL1, this.calcCases, this.calcNPS, this.calcVolume, this.calcPPL, this.fieldYearNo, this.fieldCustHierLevel3Name, this.fieldCustomerGroup, this.fieldCustomerType, this.fieldCustomerType2, this.fieldRouteNumber, this.fieldSubchannelName}); pivotGridStyleFormatCondition1.Appearance.ForeColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition1.Appearance.Options.UseForeColor = true; pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition1.Field = this.calcCases; pivotGridStyleFormatCondition1.FieldName = "calcCases"; pivotGridStyleFormatCondition1.Value1 = "1"; pivotGridStyleFormatCondition2.Appearance.ForeColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition2.Appearance.Options.UseForeColor = true; pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition2.Field = this.calcCases; pivotGridStyleFormatCondition2.FieldName = "calcCases"; pivotGridStyleFormatCondition2.Value1 = "1"; pivotGridStyleFormatCondition3.Appearance.ForeColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition3.Appearance.Options.UseForeColor = true; pivotGridStyleFormatCondition3.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition3.Field = this.calcNPS; pivotGridStyleFormatCondition3.FieldName = "calcNPS"; pivotGridStyleFormatCondition3.Value1 = "1"; pivotGridStyleFormatCondition4.Appearance.ForeColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition4.Appearance.Options.UseForeColor = true; pivotGridStyleFormatCondition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition4.Field = this.calcNPS; pivotGridStyleFormatCondition4.FieldName = "calcNPS"; pivotGridStyleFormatCondition4.Value1 = "1"; pivotGridStyleFormatCondition5.Appearance.ForeColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition5.Appearance.Options.UseForeColor = true; pivotGridStyleFormatCondition5.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition5.Field = this.calcVolume; pivotGridStyleFormatCondition5.FieldName = "calcVolume"; pivotGridStyleFormatCondition5.Value1 = "1"; pivotGridStyleFormatCondition6.Appearance.ForeColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition6.Appearance.Options.UseForeColor = true; pivotGridStyleFormatCondition6.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition6.Field = this.calcVolume; pivotGridStyleFormatCondition6.FieldName = "calcVolume"; pivotGridStyleFormatCondition6.Value1 = "1"; pivotGridStyleFormatCondition7.Appearance.ForeColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition7.Appearance.Options.UseForeColor = true; pivotGridStyleFormatCondition7.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition7.Field = this.calcPPL; pivotGridStyleFormatCondition7.FieldName = "calcPPL"; pivotGridStyleFormatCondition7.Value1 = "1"; pivotGridStyleFormatCondition8.Appearance.ForeColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition8.Appearance.Options.UseForeColor = true; pivotGridStyleFormatCondition8.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition8.Field = this.calcPPL; pivotGridStyleFormatCondition8.FieldName = "calcPPL"; pivotGridStyleFormatCondition8.Value1 = "1"; this.pivotGridControlMain.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] { pivotGridStyleFormatCondition1, pivotGridStyleFormatCondition2, pivotGridStyleFormatCondition3, pivotGridStyleFormatCondition4, pivotGridStyleFormatCondition5, pivotGridStyleFormatCondition6, pivotGridStyleFormatCondition7, pivotGridStyleFormatCondition8}); this.pivotGridControlMain.Location = new System.Drawing.Point(0, 31); this.pivotGridControlMain.Name = "pivotGridControlMain"; this.pivotGridControlMain.OptionsData.DataFieldUnboundExpressionMode = DevExpress.XtraPivotGrid.DataFieldUnboundExpressionMode.UseSummaryValues; this.pivotGridControlMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { this.repositoryItemTextEditPer}); this.pivotGridControlMain.Size = new System.Drawing.Size(1132, 280); this.pivotGridControlMain.TabIndex = 14; this.pivotGridControlMain.CustomCellValue += new System.EventHandler<DevExpress.XtraPivotGrid.PivotCellValueEventArgs>(this.pivotGridControlMain_CustomCellValue); this.pivotGridControlMain.CellDoubleClick += new DevExpress.XtraPivotGrid.PivotCellEventHandler(this.pivotGridControlMain_CellDoubleClick); // // pro0004BindingSource // this.pro0004BindingSource.DataMember = "Pro_0004"; this.pro0004BindingSource.DataSource = this.dsNMQry; // // dsNMQry // this.dsNMQry.DataSetName = "dsNMQry"; this.dsNMQry.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // fieldMaterialNumber1 // this.fieldMaterialNumber1.AreaIndex = 0; this.fieldMaterialNumber1.Caption = "Material Number"; this.fieldMaterialNumber1.FieldName = "MaterialNumber"; this.fieldMaterialNumber1.Name = "fieldMaterialNumber1"; // // fieldTypeName1 // this.fieldTypeName1.AreaIndex = 1; this.fieldTypeName1.Caption = "Type Name"; this.fieldTypeName1.FieldName = "TypeName"; this.fieldTypeName1.Name = "fieldTypeName1"; // // fieldDistributionChannel1 // this.fieldDistributionChannel1.AreaIndex = 2; this.fieldDistributionChannel1.Caption = "Distribution Channel"; this.fieldDistributionChannel1.FieldName = "DistributionChannel"; this.fieldDistributionChannel1.Name = "fieldDistributionChannel1"; // // fieldMaterialName1 // this.fieldMaterialName1.AreaIndex = 3; this.fieldMaterialName1.Caption = "Material Name"; this.fieldMaterialName1.FieldName = "MaterialName"; this.fieldMaterialName1.Name = "fieldMaterialName1"; // // fieldProductBase1 // this.fieldProductBase1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldProductBase1.AreaIndex = 1; this.fieldProductBase1.Caption = "Product Base"; this.fieldProductBase1.FieldName = "ProductBase"; this.fieldProductBase1.Name = "fieldProductBase1"; // // fieldBrand1 // this.fieldBrand1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldBrand1.AreaIndex = 0; this.fieldBrand1.Caption = "Brand"; this.fieldBrand1.FieldName = "Brand"; this.fieldBrand1.Name = "fieldBrand1"; this.fieldBrand1.Width = 255; // // fieldProductGroup31 // this.fieldProductGroup31.AreaIndex = 4; this.fieldProductGroup31.Caption = "Product Group3"; this.fieldProductGroup31.FieldName = "ProductGroup3"; this.fieldProductGroup31.Name = "fieldProductGroup31"; // // fieldProductGroup21 // this.fieldProductGroup21.AreaIndex = 5; this.fieldProductGroup21.Caption = "Product Group2"; this.fieldProductGroup21.FieldName = "ProductGroup2"; this.fieldProductGroup21.Name = "fieldProductGroup21"; // // fieldProductGroup11 // this.fieldProductGroup11.AreaIndex = 6; this.fieldProductGroup11.Caption = "Product Group1"; this.fieldProductGroup11.FieldName = "ProductGroup1"; this.fieldProductGroup11.Name = "fieldProductGroup11"; // // fieldPriceChanges1 // this.fieldPriceChanges1.AreaIndex = 7; this.fieldPriceChanges1.Caption = "Price Changes"; this.fieldPriceChanges1.FieldName = "PriceChanges"; this.fieldPriceChanges1.Name = "fieldPriceChanges1"; // // fieldPricePointRang1 // this.fieldPricePointRang1.AreaIndex = 8; this.fieldPricePointRang1.Caption = "Price Point Rang"; this.fieldPricePointRang1.FieldName = "PricePointRang"; this.fieldPricePointRang1.Name = "fieldPricePointRang1"; // // fieldMaterialType1 // this.fieldMaterialType1.AreaIndex = 9; this.fieldMaterialType1.Caption = "Material Type"; this.fieldMaterialType1.FieldName = "MaterialType"; this.fieldMaterialType1.Name = "fieldMaterialType1"; // // fieldFlavor1 // this.fieldFlavor1.AreaIndex = 10; this.fieldFlavor1.Caption = "Flavor"; this.fieldFlavor1.FieldName = "Flavor"; this.fieldFlavor1.Name = "fieldFlavor1"; // // fieldNPDS1 // this.fieldNPDS1.AreaIndex = 11; this.fieldNPDS1.Caption = "NPDS"; this.fieldNPDS1.FieldName = "NPDS"; this.fieldNPDS1.Name = "fieldNPDS1"; // // fieldPricePoint1 // this.fieldPricePoint1.AreaIndex = 12; this.fieldPricePoint1.Caption = "Price Point"; this.fieldPricePoint1.FieldName = "PricePoint"; this.fieldPricePoint1.Name = "fieldPricePoint1"; // // fieldCases1 // this.fieldCases1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldCases1.AreaIndex = 0; this.fieldCases1.Caption = "Cases"; this.fieldCases1.CellFormat.FormatString = "f2"; this.fieldCases1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldCases1.EmptyCellText = "0.0"; this.fieldCases1.EmptyValueText = "0.0"; this.fieldCases1.FieldName = "Cases"; this.fieldCases1.GrandTotalCellFormat.FormatString = "f2"; this.fieldCases1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldCases1.Name = "fieldCases1"; this.fieldCases1.Options.ShowGrandTotal = false; this.fieldCases1.TotalCellFormat.FormatString = "f2"; this.fieldCases1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldCases1.TotalValueFormat.FormatString = "f2"; this.fieldCases1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldCases1.ValueFormat.FormatString = "f2"; this.fieldCases1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // fieldNPS1 // this.fieldNPS1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldNPS1.AreaIndex = 2; this.fieldNPS1.Caption = "NPS"; this.fieldNPS1.CellFormat.FormatString = "f2"; this.fieldNPS1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldNPS1.EmptyCellText = "0.0"; this.fieldNPS1.EmptyValueText = "0.0"; this.fieldNPS1.FieldName = "NPS"; this.fieldNPS1.GrandTotalCellFormat.FormatString = "f2"; this.fieldNPS1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldNPS1.Name = "fieldNPS1"; this.fieldNPS1.Options.ShowGrandTotal = false; this.fieldNPS1.TotalCellFormat.FormatString = "f2"; this.fieldNPS1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldNPS1.TotalValueFormat.FormatString = "f2"; this.fieldNPS1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldNPS1.ValueFormat.FormatString = "f2"; this.fieldNPS1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // fieldVolume1 // this.fieldVolume1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldVolume1.AreaIndex = 4; this.fieldVolume1.Caption = "Volume"; this.fieldVolume1.CellFormat.FormatString = "f2"; this.fieldVolume1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldVolume1.EmptyCellText = "0.0"; this.fieldVolume1.EmptyValueText = "0.0"; this.fieldVolume1.FieldName = "Volume"; this.fieldVolume1.GrandTotalCellFormat.FormatString = "f2"; this.fieldVolume1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldVolume1.Name = "fieldVolume1"; this.fieldVolume1.Options.ShowGrandTotal = false; this.fieldVolume1.TotalCellFormat.FormatString = "f2"; this.fieldVolume1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldVolume1.TotalValueFormat.FormatString = "f2"; this.fieldVolume1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldVolume1.ValueFormat.FormatString = "f2"; this.fieldVolume1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // fieldPPL1 // this.fieldPPL1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldPPL1.AreaIndex = 6; this.fieldPPL1.Caption = "PPL"; this.fieldPPL1.CellFormat.FormatString = "f2"; this.fieldPPL1.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldPPL1.EmptyCellText = "0.0"; this.fieldPPL1.EmptyValueText = "0.0"; this.fieldPPL1.FieldName = "PPL"; this.fieldPPL1.GrandTotalCellFormat.FormatString = "f2"; this.fieldPPL1.GrandTotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldPPL1.Name = "fieldPPL1"; this.fieldPPL1.Options.ShowGrandTotal = false; this.fieldPPL1.TotalCellFormat.FormatString = "f2"; this.fieldPPL1.TotalCellFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldPPL1.TotalValueFormat.FormatString = "f2"; this.fieldPPL1.TotalValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.fieldPPL1.ValueFormat.FormatString = "f2"; this.fieldPPL1.ValueFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // fieldYearNo // this.fieldYearNo.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldYearNo.AreaIndex = 0; this.fieldYearNo.Caption = "Year"; this.fieldYearNo.FieldName = "YearNo"; this.fieldYearNo.Name = "fieldYearNo"; // // fieldCustHierLevel3Name // this.fieldCustHierLevel3Name.AreaIndex = 13; this.fieldCustHierLevel3Name.Caption = "CustHierLevel3"; this.fieldCustHierLevel3Name.FieldName = "CustHierLevel3Name"; this.fieldCustHierLevel3Name.Name = "fieldCustHierLevel3Name"; // // fieldCustomerGroup // this.fieldCustomerGroup.AreaIndex = 14; this.fieldCustomerGroup.Caption = "CustomerGroup"; this.fieldCustomerGroup.FieldName = "CustomerGroup"; this.fieldCustomerGroup.Name = "fieldCustomerGroup"; // // fieldCustomerType // this.fieldCustomerType.AreaIndex = 15; this.fieldCustomerType.Caption = "CustomerType"; this.fieldCustomerType.FieldName = "CustomerType"; this.fieldCustomerType.Name = "fieldCustomerType"; // // fieldCustomerType2 // this.fieldCustomerType2.AreaIndex = 16; this.fieldCustomerType2.Caption = "CustomerType2"; this.fieldCustomerType2.FieldName = "CustomerType2"; this.fieldCustomerType2.Name = "fieldCustomerType2"; // // fieldRouteNumber // this.fieldRouteNumber.AreaIndex = 17; this.fieldRouteNumber.Caption = "RouteNumber"; this.fieldRouteNumber.FieldName = "RouteNumber"; this.fieldRouteNumber.Name = "fieldRouteNumber"; // // fieldSubchannelName // this.fieldSubchannelName.AreaIndex = 18; this.fieldSubchannelName.Caption = "Subchannel"; this.fieldSubchannelName.FieldName = "SubchannelName"; this.fieldSubchannelName.Name = "fieldSubchannelName"; // // repositoryItemTextEditPer // this.repositoryItemTextEditPer.AutoHeight = false; this.repositoryItemTextEditPer.DisplayFormat.FormatString = "c"; this.repositoryItemTextEditPer.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.repositoryItemTextEditPer.Mask.EditMask = "p"; this.repositoryItemTextEditPer.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; this.repositoryItemTextEditPer.Mask.UseMaskAsDisplayFormat = true; this.repositoryItemTextEditPer.Name = "repositoryItemTextEditPer"; // // pro_0004TableAdapter // this.pro_0004TableAdapter.ClearBeforeFill = true; // // QryPro_0004Frm // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(1132, 311); this.Controls.Add(this.pivotGridControlMain); this.Controls.Add(this.barDockControlLeft); this.Controls.Add(this.barDockControlRight); this.Controls.Add(this.barDockControlBottom); this.Controls.Add(this.barDockControlTop); this.Icon = global::NestleICSales.Properties.Resources.Qry16; this.Name = "QryPro_0004Frm"; this.Text = "Sales Per SKU"; ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3.CalendarTimeProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pro0004BindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPer)).EndInit(); this.ResumeLayout(false); }
public UI_Report_Recauda(DevExpress.XtraBars.BarButtonItem opcionMenu, DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); switch ((int)objetoExtra) { case 1: DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Reporte de Recaudaciones..."); break; case 2: DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Reporte de Totales de Ventas..."); break; case 3: DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Reporte de Diferencias (Ventas-Recaudaciones)..."); break; default: DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Reporte de Recaudaciones..."); break; } // InitializeComponent(); this.SetStyle(ControlStyles.ResizeRedraw, true); // OpcionMenu = opcionMenu; HeaderMenu = headerMenu; ObjetoExtra = objetoExtra; lHeader_ant = HeaderMenu.Caption; if (objetoExtra != null) { lntipo_reporte = (int)objetoExtra; } // orden_fecha_ascendente_recaudaciones.Add(new DevExpress.Xpo.SortProperty("sucursal", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_fecha_descendente_recaudaciones.Add(new DevExpress.Xpo.SortProperty("sucursal", DevExpress.Xpo.DB.SortingDirection.Ascending)); // CriteriaOperator filtro_status = (new OperandProperty("status") == new OperandValue(1)); CriteriaOperator filtro_recaudaciones = CriteriaOperator.Parse("1 = 2"); DevExpress.Xpo.SortingCollection orden_formas_pagos = new DevExpress.Xpo.SortingCollection(new DevExpress.Xpo.SortProperty("tpago", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_formas_pagos.Add(new DevExpress.Xpo.SortProperty("codigo", DevExpress.Xpo.DB.SortingDirection.Ascending)); DevExpress.Xpo.SortProperty orden_recaudaciones = (new DevExpress.Xpo.SortProperty("fecha_hora", DevExpress.Xpo.DB.SortingDirection.Ascending)); // sucursales = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Sucursales>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("codigo", DevExpress.Xpo.DB.SortingDirection.Ascending)); recaudaciones = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Recaudaciones>(DevExpress.Xpo.XpoDefault.Session, filtro_recaudaciones, orden_recaudaciones); formas_pagos = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Formas_Pagos>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("tpago", DevExpress.Xpo.DB.SortingDirection.Ascending)); formas_pagos.Sorting = orden_formas_pagos; usuarios = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Usuarios>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("usuario", DevExpress.Xpo.DB.SortingDirection.Ascending)); cajas = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Cajas>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("codigo", DevExpress.Xpo.DB.SortingDirection.Ascending)); cajeros = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Cajeros>(DevExpress.Xpo.XpoDefault.Session, filtro_status, new DevExpress.Xpo.SortProperty("cajero", DevExpress.Xpo.DB.SortingDirection.Ascending)); // bindingSource_sucursales.DataSource = sucursales; bindingSource_recaudadores.DataSource = usuarios; bindingSource_supersisores.DataSource = usuarios; bindingSource_cajas.DataSource = cajas; bindingSource_cajeros.DataSource = cajeros; bindingSource_formas_pagos.DataSource = formas_pagos; }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition2 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition3 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition pivotGridStyleFormatCondition4 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); this.fieldRouteBrand1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.repositoryItemTextEditPers = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); this.repositoryItemTextEditf2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); this.repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); this.popupMenuMain = new DevExpress.XtraBars.PopupMenu(this.components); this.barManagerMain = new DevExpress.XtraBars.BarManager(this.components); this.bar1 = new DevExpress.XtraBars.Bar(); this.barHeaderItem1 = new DevExpress.XtraBars.BarHeaderItem(); this.bbiStartDate = new DevExpress.XtraBars.BarEditItem(); this.repositoryItemDateEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit(); this.bbiGetData = new DevExpress.XtraBars.BarLargeButtonItem(); this.bbiExport = new DevExpress.XtraBars.BarButtonItem(); this.barDockControlTop = new DevExpress.XtraBars.BarDockControl(); this.barDockControlBottom = new DevExpress.XtraBars.BarDockControl(); this.barDockControlLeft = new DevExpress.XtraBars.BarDockControl(); this.barDockControlRight = new DevExpress.XtraBars.BarDockControl(); this.repositoryItemDateEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit(); this.pivotGridControlMain = new DevExpress.XtraPivotGrid.PivotGridControl(); this.dsNMQry = new NestleICSales.DataSources.dsQry(); this.fieldRouteNumber1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldRouteName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldSupervisor1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPlantSalesDistrict1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPlantName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldPlantBaseName1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldDistributionChannel1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldActive1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldEquipment1 = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCustomer = new DevExpress.XtraPivotGrid.PivotGridField(); this.calcEqAvg = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCType = new DevExpress.XtraPivotGrid.PivotGridField(); this.fieldCustomerType = new DevExpress.XtraPivotGrid.PivotGridField(); this.dxValidationProviderMain = new DevExpress.XtraEditors.DXErrorProvider.DXValidationProvider(this.components); this.pro0002BindingSource = new System.Windows.Forms.BindingSource(this.components); this.pro_0002TableAdapter = new NestleICSales.DataSources.dsQryTableAdapters.Pro_0002TableAdapter(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pro0002BindingSource)).BeginInit(); this.SuspendLayout(); // // fieldRouteBrand1 // this.fieldRouteBrand1.AreaIndex = 1; this.fieldRouteBrand1.Caption = "Route Brand"; this.fieldRouteBrand1.FieldName = "RouteBrand"; this.fieldRouteBrand1.Name = "fieldRouteBrand1"; // // repositoryItemTextEditPers // this.repositoryItemTextEditPers.AutoHeight = false; this.repositoryItemTextEditPers.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.repositoryItemTextEditPers.EditFormat.FormatString = "P1"; this.repositoryItemTextEditPers.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.repositoryItemTextEditPers.ExportMode = DevExpress.XtraEditors.Repository.ExportMode.DisplayText; this.repositoryItemTextEditPers.Mask.EditMask = "P1"; this.repositoryItemTextEditPers.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; this.repositoryItemTextEditPers.Mask.UseMaskAsDisplayFormat = true; this.repositoryItemTextEditPers.Name = "repositoryItemTextEditPers"; // // repositoryItemTextEditf2 // this.repositoryItemTextEditf2.AutoHeight = false; this.repositoryItemTextEditf2.DisplayFormat.FormatString = "f2"; this.repositoryItemTextEditf2.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; this.repositoryItemTextEditf2.Mask.EditMask = "f2"; this.repositoryItemTextEditf2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; this.repositoryItemTextEditf2.Name = "repositoryItemTextEditf2"; // // repositoryItemTextEdit1 // this.repositoryItemTextEdit1.AutoHeight = false; this.repositoryItemTextEdit1.Name = "repositoryItemTextEdit1"; // // popupMenuMain // this.popupMenuMain.Manager = this.barManagerMain; this.popupMenuMain.Name = "popupMenuMain"; // // barManagerMain // this.barManagerMain.Bars.AddRange(new DevExpress.XtraBars.Bar[] { this.bar1}); this.barManagerMain.DockControls.Add(this.barDockControlTop); this.barManagerMain.DockControls.Add(this.barDockControlBottom); this.barManagerMain.DockControls.Add(this.barDockControlLeft); this.barManagerMain.DockControls.Add(this.barDockControlRight); this.barManagerMain.Form = this; this.barManagerMain.Items.AddRange(new DevExpress.XtraBars.BarItem[] { this.bbiExport, this.bbiStartDate, this.barHeaderItem1, this.bbiGetData}); this.barManagerMain.MaxItemId = 10; this.barManagerMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { this.repositoryItemDateEdit1, this.repositoryItemDateEdit2}); // // bar1 // this.bar1.BarName = "Main"; this.bar1.DockCol = 0; this.bar1.DockRow = 0; this.bar1.DockStyle = DevExpress.XtraBars.BarDockStyle.Top; this.bar1.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] { new DevExpress.XtraBars.LinkPersistInfo(this.barHeaderItem1), new DevExpress.XtraBars.LinkPersistInfo(this.bbiStartDate), new DevExpress.XtraBars.LinkPersistInfo(DevExpress.XtraBars.BarLinkUserDefines.PaintStyle, this.bbiGetData, DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph), new DevExpress.XtraBars.LinkPersistInfo(this.bbiExport)}); this.bar1.Text = "Custom 2"; // // barHeaderItem1 // this.barHeaderItem1.Caption = "Select Date"; this.barHeaderItem1.Id = 3; this.barHeaderItem1.Name = "barHeaderItem1"; // // bbiStartDate // this.bbiStartDate.Caption = "Start Date"; this.bbiStartDate.Edit = this.repositoryItemDateEdit1; this.bbiStartDate.Id = 2; this.bbiStartDate.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.D1)); this.bbiStartDate.Name = "bbiStartDate"; this.bbiStartDate.Width = 120; // // repositoryItemDateEdit1 // this.repositoryItemDateEdit1.AutoHeight = false; this.repositoryItemDateEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit1.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit1.Name = "repositoryItemDateEdit1"; // // bbiGetData // this.bbiGetData.Caption = "Get Data"; this.bbiGetData.CaptionAlignment = DevExpress.XtraBars.BarItemCaptionAlignment.Right; this.bbiGetData.Glyph = global::NestleICSales.Properties.Resources.apply_16x16; this.bbiGetData.Id = 9; this.bbiGetData.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.G)); this.bbiGetData.Name = "bbiGetData"; this.bbiGetData.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiGetData_ItemClick); // // bbiExport // this.bbiExport.Caption = "Export"; this.bbiExport.Glyph = global::NestleICSales.Properties.Resources.Export; this.bbiExport.Id = 1; this.bbiExport.ItemShortcut = new DevExpress.XtraBars.BarShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.E)); this.bbiExport.Name = "bbiExport"; this.bbiExport.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.bbiExport_ItemClick); // // barDockControlTop // this.barDockControlTop.CausesValidation = false; this.barDockControlTop.Dock = System.Windows.Forms.DockStyle.Top; this.barDockControlTop.Location = new System.Drawing.Point(0, 0); this.barDockControlTop.Size = new System.Drawing.Size(1132, 31); // // barDockControlBottom // this.barDockControlBottom.CausesValidation = false; this.barDockControlBottom.Dock = System.Windows.Forms.DockStyle.Bottom; this.barDockControlBottom.Location = new System.Drawing.Point(0, 311); this.barDockControlBottom.Size = new System.Drawing.Size(1132, 0); // // barDockControlLeft // this.barDockControlLeft.CausesValidation = false; this.barDockControlLeft.Dock = System.Windows.Forms.DockStyle.Left; this.barDockControlLeft.Location = new System.Drawing.Point(0, 31); this.barDockControlLeft.Size = new System.Drawing.Size(0, 280); // // barDockControlRight // this.barDockControlRight.CausesValidation = false; this.barDockControlRight.Dock = System.Windows.Forms.DockStyle.Right; this.barDockControlRight.Location = new System.Drawing.Point(1132, 31); this.barDockControlRight.Size = new System.Drawing.Size(0, 280); // // repositoryItemDateEdit2 // this.repositoryItemDateEdit2.AutoHeight = false; this.repositoryItemDateEdit2.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit2.CalendarTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemDateEdit2.Name = "repositoryItemDateEdit2"; // // pivotGridControlMain // this.pivotGridControlMain.DataSource = this.pro0002BindingSource; this.pivotGridControlMain.Dock = System.Windows.Forms.DockStyle.Fill; this.pivotGridControlMain.Fields.AddRange(new DevExpress.XtraPivotGrid.PivotGridField[] { this.fieldRouteNumber1, this.fieldRouteName1, this.fieldSupervisor1, this.fieldRouteBrand1, this.fieldPlantSalesDistrict1, this.fieldPlantName1, this.fieldPlantBaseName1, this.fieldDistributionChannel1, this.fieldActive1, this.fieldEquipment1, this.fieldCustomer, this.calcEqAvg, this.fieldCType, this.fieldCustomerType}); pivotGridStyleFormatCondition1.Appearance.BackColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition1.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition1.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal; pivotGridStyleFormatCondition1.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition1.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition1.Field = this.fieldRouteBrand1; pivotGridStyleFormatCondition1.FieldName = "fieldRouteBrand1"; pivotGridStyleFormatCondition1.Value1 = "1"; pivotGridStyleFormatCondition2.Appearance.BackColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition2.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition2.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal; pivotGridStyleFormatCondition2.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition2.Field = this.fieldRouteBrand1; pivotGridStyleFormatCondition2.FieldName = "fieldRouteBrand1"; pivotGridStyleFormatCondition2.Value1 = "1"; pivotGridStyleFormatCondition3.Appearance.BackColor = System.Drawing.Color.Red; pivotGridStyleFormatCondition3.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition3.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal; pivotGridStyleFormatCondition3.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition3.Condition = DevExpress.XtraGrid.FormatConditionEnum.Less; pivotGridStyleFormatCondition3.Field = this.fieldRouteBrand1; pivotGridStyleFormatCondition3.FieldName = "fieldRouteBrand1"; pivotGridStyleFormatCondition3.Value1 = "1"; pivotGridStyleFormatCondition4.Appearance.BackColor = System.Drawing.Color.Green; pivotGridStyleFormatCondition4.Appearance.BackColor2 = System.Drawing.Color.White; pivotGridStyleFormatCondition4.Appearance.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.ForwardDiagonal; pivotGridStyleFormatCondition4.Appearance.Options.UseBackColor = true; pivotGridStyleFormatCondition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual; pivotGridStyleFormatCondition4.Field = this.fieldRouteBrand1; pivotGridStyleFormatCondition4.FieldName = "fieldRouteBrand1"; pivotGridStyleFormatCondition4.Value1 = "1"; this.pivotGridControlMain.FormatConditions.AddRange(new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition[] { pivotGridStyleFormatCondition1, pivotGridStyleFormatCondition2, pivotGridStyleFormatCondition3, pivotGridStyleFormatCondition4}); this.pivotGridControlMain.Location = new System.Drawing.Point(0, 31); this.pivotGridControlMain.Name = "pivotGridControlMain"; this.pivotGridControlMain.OptionsPrint.PrintColumnHeaders = DevExpress.Utils.DefaultBoolean.False; this.pivotGridControlMain.OptionsPrint.PrintDataHeaders = DevExpress.Utils.DefaultBoolean.False; this.pivotGridControlMain.OptionsPrint.PrintFilterHeaders = DevExpress.Utils.DefaultBoolean.False; this.pivotGridControlMain.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { this.repositoryItemTextEditPers}); this.pivotGridControlMain.Size = new System.Drawing.Size(1132, 280); this.pivotGridControlMain.TabIndex = 9; // // dsNMQry // this.dsNMQry.DataSetName = "dsNMQry"; this.dsNMQry.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // fieldRouteNumber1 // this.fieldRouteNumber1.AreaIndex = 0; this.fieldRouteNumber1.Caption = "Route Number"; this.fieldRouteNumber1.FieldName = "RouteNumber"; this.fieldRouteNumber1.Name = "fieldRouteNumber1"; // // fieldRouteName1 // this.fieldRouteName1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldRouteName1.AreaIndex = 1; this.fieldRouteName1.Caption = "Route Name"; this.fieldRouteName1.FieldName = "RouteName"; this.fieldRouteName1.Name = "fieldRouteName1"; // // fieldSupervisor1 // this.fieldSupervisor1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; this.fieldSupervisor1.AreaIndex = 0; this.fieldSupervisor1.Caption = "Supervisor"; this.fieldSupervisor1.FieldName = "Supervisor"; this.fieldSupervisor1.Name = "fieldSupervisor1"; // // fieldPlantSalesDistrict1 // this.fieldPlantSalesDistrict1.AreaIndex = 2; this.fieldPlantSalesDistrict1.Caption = "Plant Sales District"; this.fieldPlantSalesDistrict1.FieldName = "PlantSalesDistrict"; this.fieldPlantSalesDistrict1.Name = "fieldPlantSalesDistrict1"; // // fieldPlantName1 // this.fieldPlantName1.AreaIndex = 3; this.fieldPlantName1.Caption = "Plant Name"; this.fieldPlantName1.FieldName = "PlantName"; this.fieldPlantName1.Name = "fieldPlantName1"; // // fieldPlantBaseName1 // this.fieldPlantBaseName1.AreaIndex = 4; this.fieldPlantBaseName1.Caption = "Plant Base Name"; this.fieldPlantBaseName1.FieldName = "PlantBaseName"; this.fieldPlantBaseName1.Name = "fieldPlantBaseName1"; // // fieldDistributionChannel1 // this.fieldDistributionChannel1.AreaIndex = 5; this.fieldDistributionChannel1.Caption = "Distribution Channel"; this.fieldDistributionChannel1.FieldName = "DistributionChannel"; this.fieldDistributionChannel1.Name = "fieldDistributionChannel1"; // // fieldActive1 // this.fieldActive1.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; this.fieldActive1.AreaIndex = 0; this.fieldActive1.Caption = "Active"; this.fieldActive1.FieldName = "Active"; this.fieldActive1.Name = "fieldActive1"; // // fieldEquipment1 // this.fieldEquipment1.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldEquipment1.AreaIndex = 1; this.fieldEquipment1.Caption = "Frz"; this.fieldEquipment1.FieldName = "Equipment"; this.fieldEquipment1.Name = "fieldEquipment1"; // // fieldCustomer // this.fieldCustomer.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.fieldCustomer.AreaIndex = 0; this.fieldCustomer.Caption = "Customer"; this.fieldCustomer.FieldName = "Customer"; this.fieldCustomer.Name = "fieldCustomer"; // // calcEqAvg // this.calcEqAvg.Appearance.Cell.ForeColor = System.Drawing.Color.Red; this.calcEqAvg.Appearance.Cell.Options.UseForeColor = true; this.calcEqAvg.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; this.calcEqAvg.AreaIndex = 2; this.calcEqAvg.Caption = "Arg Frz"; this.calcEqAvg.FieldName = "Equipment"; this.calcEqAvg.Name = "calcEqAvg"; this.calcEqAvg.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.PercentOfRow; // // fieldCType // this.fieldCType.AreaIndex = 6; this.fieldCType.Caption = "Frz Type"; this.fieldCType.FieldName = "CType"; this.fieldCType.Name = "fieldCType"; // // fieldCustomerType // this.fieldCustomerType.AreaIndex = 7; this.fieldCustomerType.Caption = "Customer Type"; this.fieldCustomerType.FieldName = "CustomerType"; this.fieldCustomerType.Name = "fieldCustomerType"; // // pro0002BindingSource // this.pro0002BindingSource.DataMember = "Pro_0002"; this.pro0002BindingSource.DataSource = this.dsNMQry; // // pro_0002TableAdapter // this.pro_0002TableAdapter.ClearBeforeFill = true; // // QryPro_0002Frm // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(1132, 311); this.Controls.Add(this.pivotGridControlMain); this.Controls.Add(this.barDockControlLeft); this.Controls.Add(this.barDockControlRight); this.Controls.Add(this.barDockControlBottom); this.Controls.Add(this.barDockControlTop); this.Icon = global::NestleICSales.Properties.Resources.Qry16; this.Name = "QryPro_0002Frm"; this.Text = "Zero Sales MTD"; ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditPers)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEditf2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemTextEdit1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.popupMenuMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.barManagerMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1.CalendarTimeProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2.CalendarTimeProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEdit2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pivotGridControlMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsNMQry)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dxValidationProviderMain)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pro0002BindingSource)).EndInit(); this.ResumeLayout(false); }
public UI_Depositos_Bancarios_Det(object form_padre, int lntpago) { WaitForm1 WaitForm1 = new WaitForm1(); DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Saldos Pendientes para DepĆ³sitar..."); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Espere un momento por favor... Cargando y Validando Datos... ."); // // asignacion de valores a objetos publicos // Form_padre = form_padre; //totales_deposito_aux = ((Fundraising_PT.Formularios.UI_Depositos_Bancarios)Form_padre).totales_deposito; //Totales_deposito = totales_deposito; lg_deposito_bancario = ((Fundraising_PTDM.FUNDRAISING_PT.Depositos_Bancarios)((Fundraising_PT.Formularios.UI_Depositos_Bancarios)form_padre).bindingSource1.Current).oid; ln_status_deposito = ((Fundraising_PTDM.FUNDRAISING_PT.Depositos_Bancarios)((Fundraising_PT.Formularios.UI_Depositos_Bancarios)form_padre).bindingSource1.Current).status; ln_sucursal_dep_det = ((Fundraising_PTDM.FUNDRAISING_PT.Depositos_Bancarios)((Fundraising_PT.Formularios.UI_Depositos_Bancarios)form_padre).bindingSource1.Current).sucursal; obj_headerMenu_ant = ((Fundraising_PT.Formularios.UI_Depositos_Bancarios)form_padre).HeaderMenu; lHeader_ant = ((Fundraising_PT.Formularios.UI_Depositos_Bancarios)form_padre).HeaderMenu.Caption; lAccion = "Detalle del depĆ³sito por forma de pago"; ln_modo = (((Fundraising_PT.Formularios.UI_Depositos_Bancarios)form_padre).lAccion == "Insertar" ? 1 : ((Fundraising_PT.Formularios.UI_Depositos_Bancarios)form_padre).lAccion == "Editar" ? 2 : 0); ln_tpago = lntpago; // InitializeComponent(); this.SetStyle(ControlStyles.ResizeRedraw, true); // // llena los datos de la coleccion de las formas de pago y usuarios // CriteriaOperator filtro_status = (new OperandProperty("status") == new OperandValue(1)); DevExpress.Xpo.SortProperty orden_formas_pagos = (new DevExpress.Xpo.SortProperty("codigo", DevExpress.Xpo.DB.SortingDirection.Ascending)); DevExpress.Xpo.SortProperty orden_usuarios = (new DevExpress.Xpo.SortProperty("usuario", DevExpress.Xpo.DB.SortingDirection.Ascending)); // formas_pagos = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Formas_Pagos>(DevExpress.Xpo.XpoDefault.Session, filtro_status, orden_formas_pagos); // se crean las columnas al datatable de saldos /// saldos_formas_pagos.Columns.Add("oid_forma_pago", typeof(Guid)); saldos_formas_pagos.Columns.Add("oid_recaudador", typeof(Guid)); saldos_formas_pagos.Columns.Add("cod_forma_pago", typeof(string)); saldos_formas_pagos.Columns.Add("recaudador", typeof(string)); saldos_formas_pagos.Columns.Add("forma_pago", typeof(string)); saldos_formas_pagos.Columns.Add("monto_precargado", typeof(decimal)); saldos_formas_pagos.Columns.Add("monto", typeof(decimal)); saldos_formas_pagos.Columns.Add("saldo", typeof(decimal)); saldos_formas_pagos.PrimaryKey = new DataColumn[] { saldos_formas_pagos.Columns["oid_forma_pago"], saldos_formas_pagos.Columns["oid_recaudador"] }; // se crean las columnas a la vista que llenara los datos del datatable de saldos /// vsaldos_formas_pagos = new XPView(XpoDefault.Session, typeof(Fundraising_PTDM.FUNDRAISING_PT.Saldos_Recauda_dep)); vsaldos_formas_pagos.AddProperty("oid_forma_pago", "forma_pago.oid", true, true, DevExpress.Xpo.SortDirection.None); vsaldos_formas_pagos.AddProperty("oid_recaudador", "recaudador.oid", true, true, DevExpress.Xpo.SortDirection.None); vsaldos_formas_pagos.AddProperty("cod_forma_pago", "forma_pago.codigo", true, true, DevExpress.Xpo.SortDirection.Ascending); vsaldos_formas_pagos.AddProperty("recaudador", "recaudador.usuario", true, true, DevExpress.Xpo.SortDirection.Ascending); vsaldos_formas_pagos.AddProperty("forma_pago", "forma_pago.nombre", true, true, DevExpress.Xpo.SortDirection.None); vsaldos_formas_pagos.AddProperty("recaudado", "Sum(recaudado)", false, true, DevExpress.Xpo.SortDirection.None); vsaldos_formas_pagos.AddProperty("depositado", "Sum(depositado)", false, true, DevExpress.Xpo.SortDirection.None); vsaldos_formas_pagos.AddProperty("saldo", "Sum(recaudado-depositado)", false, true, DevExpress.Xpo.SortDirection.None); // llena los datos de la coleccion del detalle del deposito // filtro_deposito_bancario_det = (new OperandProperty("deposito_bancario.oid") == new OperandValue(lg_deposito_bancario) & new OperandProperty("forma_pago.tpago") == new OperandValue(ln_tpago)); DevExpress.Xpo.SortProperty orden_deposito_bancario_det = (new DevExpress.Xpo.SortProperty("forma_pago.tpago", DevExpress.Xpo.DB.SortingDirection.Ascending)); DevExpress.Xpo.SortingCollection orden_deposito_bancario_det1 = new DevExpress.Xpo.SortingCollection(new DevExpress.Xpo.SortProperty("forma_pago.tpago", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_deposito_bancario_det1.Add(new DevExpress.Xpo.SortProperty("forma_pago.codigo", DevExpress.Xpo.DB.SortingDirection.Ascending)); orden_deposito_bancario_det1.Add(new DevExpress.Xpo.SortProperty("recaudador.usuario", DevExpress.Xpo.DB.SortingDirection.Ascending)); // depositos_bancarios_det = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Depositos_Bancarios_Det>(DevExpress.Xpo.XpoDefault.Session, filtro_deposito_bancario_det, orden_deposito_bancario_det); depositos_bancarios_det.Sorting = orden_deposito_bancario_det1; // seteo_nivel_seguridad(); // // bindeo de datos a los bindingsource principales // bindingSource_recaudador.DataSource = usuarios; bindingSource_depositos_bancarios_det.DataSource = depositos_bancarios_det; }