public override void SetDatasource()
{
var resultado = ClsPanelDeControl.ExecuteGenericquery(Datasource);
Datareader = resultado.ObjetoTransaccion as IDataReader;
if (Datareader != null)
{
while (Datareader.Read())
{
if (!String.IsNullOrEmpty(Datareader["value"].ToString()))
{
Value = Datareader["value"].ToString();
}
}
var gc = Control as GaugeControl;
if (gc != null)
{
var foo = gc.Gauges[0] as DevExpress.XtraGauges.Win.Gauges.Digital.DigitalGauge;
if (foo != null)
{
foo.Text = Value;
foo.DigitCount = foo.Text.Length;
}
}
}
}
private void GenerarPanelDeControl(ClsPanelDeControl panelDeControl)
{
if (panelDecontrols != null)
{
PanelDecontrol foo = new PanelDecontrol();
foo.LoadControls(panelDeControl.XmlFile);
foo.Generate();
foo.Dispose(this);
}
}
public override void SetDatasource()
{
var cantidad = 0;
var color = String.Empty;
_labelNumero.Text = 24.ToString();
var resultado = ClsPanelDeControl.ExecuteGenericquery(Datasource);
Datareader = resultado.ObjetoTransaccion as IDataReader;
if (Datareader != null)
{
while (Datareader.Read())
{
if (!String.IsNullOrEmpty(Datareader["cantidad"].ToString()))
{
cantidad = Convert.ToInt16(Datareader["cantidad"].ToString());
}
color = Datareader["color"].ToString();
}
var gc = Control as GaugeControl;
if (gc != null)
{
var foo = gc.Gauges[0] as StateIndicatorGauge;
if (foo != null)
{
foo.BeginUpdate();
switch (color.Trim().ToUpper())
{
case "RED":
foo.Indicators[0].StateIndex = 1;
break;
case "ORANGE":
foo.Indicators[0].StateIndex = 2;
break;
case "GREEN":
foo.Indicators[0].StateIndex = 3;
break;
default:
foo.Indicators[0].StateIndex = 0;
break;
}
_labelNumero.Text = String.Format("<b>{0}</b>", cantidad);
foo.EndUpdate();
}
}
}
}
public void ChangePanelDeControl(object sender, EventArgs e)
{
var idPanel = ((ToolStripMenuItem)sender).Name;
idPanel = idPanel.Replace("panel_", "");
var panel = panelDecontrols.Find(delegate(ClsPanelDeControl foo) { return(foo.Id.ToString() == idPanel); });
if (panel != null)
{
panelDeControlSeleccionado = panel;
DestruirPanelDeControl();
GenerarPanelDeControl(panel);
}
}
private Hashtable GenerateData()
{
var resultado = ClsPanelDeControl.ExecuteGenericquery(XmlDocument.SelectSingleNode("control/datasource").InnerText);
var Datareader = resultado.ObjetoTransaccion as IDataReader;
var _ht = new Hashtable();
if (Datareader != null)
{
while (Datareader.Read())
{
_ht.Add(Datareader["color"].ToString(), Datareader["cantidad"].ToString());
}
}
return(_ht);
}
public override void SetDatasource()
{
var c = this.Control as ChartControl;
if (c == null)
{
return;
}
var resultado = ClsPanelDeControl.ExecuteGenericqueryDataset(Datasource);
var ds = resultado.ObjetoTransaccion as DataSet;
c.BorderOptions.Visible = true;
// Specify data members to bind the chart's series template.
c.SeriesDataMember = ds.Tables[0].Columns[0].ColumnName;
c.SeriesTemplate.ArgumentDataMember = ds.Tables[0].Columns[1].ColumnName;
c.SeriesTemplate.ValueDataMembers.AddRange(new string[] { ds.Tables[0].Columns[2].ColumnName });
c.DataSource = ds.Tables[0];
}
private void formDetailPanelDeControl_Load(object sender, EventArgs e)
{
var resultado = ClsPanelDeControl.ExecuteGenericqueryDataset(query);
var colorsGreen = new List <int>();
var colorsRed = new List <int>();
var hide = new List <int>();
var dt = resultado.ObjetoTransaccion as DataSet;
IsPaperless = query.ToUpper().Contains("PAPERLESS");
IsPreAlerta = query.ToUpper().Contains("PREALERTA");
var i = 0;
foreach (DataColumn column in dt.Tables[0].Columns)
{
if (column.ColumnName.Trim().ToUpper().Contains("_GREEN"))
{
colorsGreen.Add(i);
column.ColumnName = column.ColumnName.Replace("_GREEN", "");
column.ColumnName = column.ColumnName.Replace("_green", "");
}
if (column.ColumnName.Trim().ToUpper().Contains("_RED"))
{
colorsRed.Add(i);
column.ColumnName = column.ColumnName.Replace("_RED", "");
column.ColumnName = column.ColumnName.Replace("_red", "");
}
if (column.ColumnName.Trim().ToUpper().Contains("_HIDDEN"))
{
hide.Add(i);
column.ColumnName = column.ColumnName.Replace("_HIDDEN", "");
column.ColumnName = column.ColumnName.Replace("_hidden", "");
}
i++;
}
gridControl1.DataSource = dt.Tables[0];
foreach (var i1 in colorsGreen)
{
gridView1.Columns[i1].AppearanceCell.BackColor = System.Drawing.Color.Green;
gridView1.Columns[i1].AppearanceCell.ForeColor = System.Drawing.Color.White;
}
foreach (var i1 in colorsRed)
{
gridView1.Columns[i1].AppearanceCell.BackColor = System.Drawing.Color.Red;
gridView1.Columns[i1].AppearanceCell.ForeColor = System.Drawing.Color.White;
}
foreach (var i1 in hide)
{
gridView1.Columns[i1].Visible = false;
}
if (!IsPaperless)
{
MenuAsignacion.Visible = Menu1raEtapa.Visible = Menu2daEtapa.Visible = false;
}
gridControl1.RefreshDataSource();
//gridView1.BestFitColumns();
}
public clsPerfil()
{
PanelDeControl = new ClsPanelDeControl();
}
public clsPerfil()
{
PanelDeControl = new ClsPanelDeControl();
}
private void MDICraft_Load(object sender, EventArgs e)
{
// #1
foreach (Control control in this.Controls)
{
// #2
MdiClient client = control as MdiClient;
if (!(client == null))
{
// #3
client.BackColor = System.Drawing.SystemColors.GradientInactiveCaption;
// 4#
break;
}
}
Text = "Sistema Comercial Craft V." + SCCMultimodal.SCCVersion.CurrentVersion;
ValidarUsuarioConectado();
//HABILITAR PARA VALIDAR FUNCIONALIDADES
HabilitarFuncionalidades();
navBarControl1.Groups[0].Expanded = true;
//mostrando el panel de control
if (Base.Usuario.UsuarioConectado.Usuario.Perfiles != null && Base.Usuario.UsuarioConectado.Usuario.Perfiles.Count > 0)
{
//if (Base.Usuario.UsuarioConectado.Usuario.Perfiles[0].PanelDeControl != null)
//{
foreach (var clsPerfil in Base.Usuario.UsuarioConectado.Usuario.Perfiles)
{
if (clsPerfil.PanelDeControl != null && !String.IsNullOrEmpty(clsPerfil.PanelDeControl.XmlFile))
{
panelDecontrols.Add(clsPerfil.PanelDeControl);
}
}
}
//}
foreach (var clsPanelDeControl in panelDecontrols)
{
ToolStripMenuItem item1 = new ToolStripMenuItem(clsPanelDeControl.Nombre);
item1.Name = "panel_" + clsPanelDeControl.Id.ToString();
//item1.Click += changePanelDeControl(item1,new EventHandler());
item1.Click += new EventHandler(ChangePanelDeControl);
toolStripDropDownButton1.DropDown.Items.Add(item1);
}
timer2.Interval = 90;
timer2.Start();
toolStripSplitButton2.Alignment = ToolStripItemAlignment.Right;
toolStripSplitButton1.Alignment = ToolStripItemAlignment.Right;
toolStripDropDownButton1.Alignment = ToolStripItemAlignment.Right;
if (panelDecontrols.Count == 0)
{
toolStripSplitButton2.Visible =
toolStripSplitButton1.Visible =
toolStripDropDownButton1.Visible = false;
timer2.Stop();
}
if (panelDecontrols.Count == 1)
{
toolStripDropDownButton1.Visible = false;
}
if (panelDecontrols.Count > 0)
{
try {
panelDeControlSeleccionado = panelDecontrols[0];
GenerarPanelDeControl();
} catch (Exception ex) {
Console.Write(ex);
}
}
//Cargamos la configuracion
var configuracion = Base.Configuracion.Configuracion.Instance();
ClsLogPerformance.Save(new LogPerformance(Base.Usuario.UsuarioConectado.Usuario, TimerMDI.Elapsed.TotalSeconds, "Carga Inicial de SCC"));
//verifica Pais
var conf = Base.Configuracion.Configuracion.Instance();
var op = conf.GetValue("Paperless_ParcialBrasil"); //puede retornar un true, false o null
if (op.HasValue && op.Value.Equals(true))
{
IsBrasil = true;
}
}
public override void SetDatasource()
{
var resultado = ClsPanelDeControl.ExecuteGenericquery(Datasource);
Datareader = resultado.ObjetoTransaccion as IDataReader;
if (Datareader != null)
{
while (Datareader.Read())
{
if (!String.IsNullOrEmpty(Datareader["min"].ToString()))
{
min = Convert.ToSingle(Datareader["min"]);
}
if (!String.IsNullOrEmpty(Datareader["max"].ToString()))
{
max = Convert.ToSingle(Datareader["max"]);
}
if (!String.IsNullOrEmpty(Datareader["value"].ToString()))
{
value = Convert.ToSingle(Datareader["value"]);
}
if (!String.IsNullOrEmpty(Datareader["overmax"].ToString()))
{
overmax = Convert.ToSingle(Datareader["overmax"]);
}
}
var gc = Control as GaugeControl;
if (gc != null)
{
var foo = gc.Gauges[0] as DevExpress.XtraGauges.Win.Gauges.Linear.LinearGauge;
if (foo != null)
{
var scale = foo.Scales[0];
scale.MinValue = min;
scale.MaxValue = max + overmax;
scale.Value = value;
var color = Color.Black;
if (value >= max)
{
color = Color.Red;
}
if (value < max)
{
color = Color.Orange;
}
if (value < max / 2)
{
color = Color.Green;
}
foo.Levels[0].ShapeType = LevelShapeSetType.Style11;
StyleShader shader = new StyleShader();
shader.StyleColor1 = color;
shader.StyleColor2 = Color.Transparent;
foo.Levels[0].Shader = shader;
}
}
}
}
