protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
int cuenta = UltraWebGrid1.Columns.Count;
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Tipo de artículo");
UltraWebGrid1.Columns.Add("Artículo");
UltraWebGrid1.Columns.Add("Color");
UltraWebGrid1.Columns.Add("Calidad");
UltraWebGrid1.Columns.Add("Cantidad");
UltraWebGrid1.Columns[0].Header.Caption = "Proceso";
UltraWebGrid1.Columns[1].Header.Caption = "Tipo de artículo";
UltraWebGrid1.Columns[2].Header.Caption = "Articulo";
UltraWebGrid1.Columns[3].Header.Caption = "Color";
UltraWebGrid1.Columns[4].Header.Caption = "Calidad";
UltraWebGrid1.Columns[5].Header.Caption = "Cantidad";
UltraWebGrid1.Columns[0].Width = 130;
UltraWebGrid1.Columns[1].Width = 130;
UltraWebGrid1.Columns[2].Width = 130;
UltraWebGrid1.DisplayLayout.ScrollBar = ScrollBar.Never;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave Proceso");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("MFG/PRO");
UltraWebGrid1.Columns.Add("Requerido");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns[0].Header.Caption = "Clave Proceso";
UltraWebGrid1.Columns[1].Header.Caption = "Descripción";
UltraWebGrid1.Columns[2].Header.Caption = "MFG/PRO";
UltraWebGrid1.Columns[3].Header.Caption = "Requerido";
UltraWebGrid1.Columns[4].Header.Caption = "Activo";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Width = 70;
UltraWebGrid1.Columns[3].Width = 70;
UltraWebGrid1.Columns[4].Width = 70;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave única");
UltraWebGrid1.Columns.Add("Clave máquina");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("Tipo de máquina");
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Centro de trabajo");
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave máquina";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Header.Caption = "Tipo de máquina";
UltraWebGrid1.Columns[4].Header.Caption = "Proceso";
UltraWebGrid1.Columns[5].Header.Caption = "Centro de trabajo";
UltraWebGrid1.Columns[2].Width = 160;
UltraWebGrid1.Columns[3].Width = 120;
UltraWebGrid1.Columns[5].Width = 120;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Código");
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Proceso Padre");
UltraWebGrid1.Columns.Add("Manufacturing");
UltraWebGrid1.Columns.Add("Requerido");
UltraWebGrid1.Columns.Add("Orden");
UltraWebGrid1.Columns[0].Header.Caption = "Código";
UltraWebGrid1.Columns[1].Header.Caption = "Proceso";
UltraWebGrid1.Columns[2].Header.Caption = "Proceso Padre";
UltraWebGrid1.Columns[3].Header.Caption = "MFG";
UltraWebGrid1.Columns[4].Header.Caption = "Requerido";
UltraWebGrid1.Columns[5].Header.Caption = "Orden";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Width = 70;
UltraWebGrid1.Columns[4].Width = 70;
UltraWebGrid1.Columns[5].Width = 70;
}
protected void btnReset_Click(object sender, System.EventArgs e)
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.ResetBands();
PerformSearch();
PerformDataBind();
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave única");
UltraWebGrid1.Columns.Add("Clave centro trabajo");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Línea de producción");
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave centro de trabajo";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Header.Caption = "Proceso";
UltraWebGrid1.Columns[4].Header.Caption = "Línea de producción";
UltraWebGrid1.Columns[1].Header.Style.Wrap = true;
UltraWebGrid1.Columns[4].Header.Style.Wrap = true;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[0].Width = 100;
UltraWebGrid1.Columns[1].Width = 100;
UltraWebGrid1.Columns[2].Width = 150;
UltraWebGrid1.Columns[3].Width = 120;
UltraWebGrid1.Columns[4].Width = 120;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Fecha");
UltraWebGrid1.Columns.Add("Temperatura");
UltraWebGrid1.Columns.Add("Humedad");
UltraWebGrid1.Columns.Add("Autorización");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns[0].Header.Caption = "Fecha";
UltraWebGrid1.Columns[1].Header.Caption = "Temperatura";
UltraWebGrid1.Columns[2].Header.Caption = "Humedad";
UltraWebGrid1.Columns[3].Header.Caption = "Autorización";
UltraWebGrid1.Columns[4].Header.Caption = "Activo";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Width = 100;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave turno");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("Hora inicio");
UltraWebGrid1.Columns.Add("Hora fin");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns[0].Header.Caption = "Clave turno";
UltraWebGrid1.Columns[1].Header.Caption = "Descripción";
UltraWebGrid1.Columns[2].Header.Caption = "Hora inicio";
UltraWebGrid1.Columns[3].Header.Caption = "Hora fin";
UltraWebGrid1.Columns[4].Header.Caption = "Activo";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Width = 70;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave única");
UltraWebGrid1.Columns.Add("Clave artículo");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("Tipo artículo");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave artículo";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Header.Caption = "Tipo artículo";
UltraWebGrid1.Columns[4].Header.Caption = "Activo";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Width = 110;
UltraWebGrid1.Columns[3].Width = 110;
}
public void SetGridHeader()
{
int iRow = UltraWebGrid1.Columns.Count;
for (int i = iRow; i > 0; i--)
{
UltraWebGrid1.Columns.RemoveAt(iRow);
}
UltraWebGrid1.ResetColumns();
DataTable dtCol = this.CODE_TABLE;
iRow = dtCol.Rows.Count;
UltraGridColumn cn = null;
cn = new UltraGridColumn("YY", "년도", ColumnType.NotSet, "");
cn.BaseColumnName = "YY";
cn.Width = Unit.Pixel(120);
cn.CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns.Add(cn);
for (int i = 0; i < iRow; i++)
{
cn = new UltraGridColumn(dtCol.Rows[i][0].ToString(), dtCol.Rows[i][1].ToString(), ColumnType.NotSet, 0);
cn.BaseColumnName = dtCol.Rows[i][0].ToString();
cn.Width = Unit.Pixel(165);
cn.DataType = "System.Double";
cn.Format = "#,###,###,###,###,###,###,###,###,##0.00";
cn.CellStyle.HorizontalAlign = HorizontalAlign.Right;
UltraWebGrid1.Columns.Add(cn);
}
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave única");
UltraWebGrid1.Columns.Add("Clave defecto");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("Tipo defecto");
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Responsable");
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave defecto";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Header.Caption = "Tipo defecto";
UltraWebGrid1.Columns[4].Header.Caption = "Proceso";
UltraWebGrid1.Columns[5].Header.Caption = "Responsable";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Fecha");
UltraWebGrid1.Columns.Add("Densidad");
UltraWebGrid1.Columns.Add("BU");
UltraWebGrid1.Columns.Add("Autorización");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns.Add("Baroi");
UltraWebGrid1.Columns.Add("Turno");
UltraWebGrid1.Columns[0].Header.Caption = "Fecha";
UltraWebGrid1.Columns[1].Header.Caption = "Densidad";
UltraWebGrid1.Columns[2].Header.Caption = "BU";
UltraWebGrid1.Columns[3].Header.Caption = "Autorización";
UltraWebGrid1.Columns[4].Header.Caption = "Activo";
UltraWebGrid1.Columns[5].Header.Caption = "Baroi";
UltraWebGrid1.Columns[6].Header.Caption = "Turno";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Width = 80;
UltraWebGrid1.Columns[1].Width = 70;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Almacén");
UltraWebGrid1.Columns.Add("Planta");
UltraWebGrid1.Columns.Add("Linea de producción");
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Centro de trabajo");
UltraWebGrid1.Columns.Add("Área");
UltraWebGrid1.Columns.Add("Máquina");
UltraWebGrid1.Columns[0].Header.Caption = "Almacén";
UltraWebGrid1.Columns[1].Header.Caption = "Planta";
UltraWebGrid1.Columns[2].Header.Caption = "Linea de prod.";
UltraWebGrid1.Columns[3].Header.Caption = "Proceso";
UltraWebGrid1.Columns[4].Header.Caption = "Centro de trabajo";
UltraWebGrid1.Columns[5].Header.Caption = "Área";
UltraWebGrid1.Columns[6].Header.Caption = "Máquina";
UltraWebGrid1.Columns[2].Width = 135;
UltraWebGrid1.Columns[4].Width = 120;
UltraWebGrid1.Columns[2].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave única");
UltraWebGrid1.Columns.Add("Clave artículo");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns.Add("Número de Impresiones");
UltraWebGrid1.Columns.Add("Fecha");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave artículo";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Header.Caption = "Número de Impresiones";
UltraWebGrid1.Columns[4].Header.Caption = "Fecha";
UltraWebGrid1.Columns[5].Header.Caption = "Activo";
UltraWebGrid1.Columns[3].Header.Style.Wrap = true;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Width = 110;
UltraWebGrid1.Columns[3].Width = 120;
UltraWebGrid1.Columns[5].Width = 150;
}
protected void llenarvacioP()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Fecha");
UltraWebGrid1.Columns.Add("Proceso");
UltraWebGrid1.Columns.Add("Centro de trabajo");
UltraWebGrid1.Columns.Add("Maquina");
UltraWebGrid1.Columns.Add("Posicion");
UltraWebGrid1.Columns.Add("Operador");
UltraWebGrid1.Columns.Add("Defectos");
UltraWebGrid1.Columns[0].Header.Caption = "Fecha";
UltraWebGrid1.Columns[1].Header.Caption = "Proceso";
UltraWebGrid1.Columns[2].Header.Caption = "Centro de trabajo";
UltraWebGrid1.Columns[3].Header.Caption = "Maquina";
UltraWebGrid1.Columns[4].Header.Caption = "Posicion";
UltraWebGrid1.Columns[5].Header.Caption = "Operador";
UltraWebGrid1.Columns[6].Header.Caption = "Defectos";
UltraWebGrid1.Columns[4].Hidden = true;
UltraWebGrid1.Columns[2].Width = 120;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Fecha");
UltraWebGrid1.Columns.Add("Tiempo espejo");
UltraWebGrid1.Columns.Add("Viscosidad");
UltraWebGrid1.Columns.Add("Densidad");
UltraWebGrid1.Columns.Add("Espesor");
UltraWebGrid1.Columns.Add("Autorización");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns[0].Header.Caption = "Fecha";
UltraWebGrid1.Columns[1].Header.Caption = "Tiempo espejo";
UltraWebGrid1.Columns[2].Header.Caption = "Viscosidad";
UltraWebGrid1.Columns[3].Header.Caption = "Densidad";
UltraWebGrid1.Columns[4].Header.Caption = "Espesor";
UltraWebGrid1.Columns[5].Header.Caption = "Autorización";
UltraWebGrid1.Columns[6].Header.Caption = "Activo";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Width = 100;
}
protected void llenargrid()
{
svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient();
List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerAlmacen();
UltraWebGrid1.DataSource = Lista;
if (Lista.Count <= 0)
{
llenarvacio();
}
else
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns[3].Hidden = true;
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave almacén";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Width = 180;
UltraWebGrid1.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].CellStyle.HorizontalAlign = HorizontalAlign.Center;
}
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Piezas procesadas");
UltraWebGrid1.Columns.Add("Cantidad inventarios");
UltraWebGrid1.Columns.Add("Piezas malas");
UltraWebGrid1.Columns.Add("Piezas malas verdes");
UltraWebGrid1.Columns.Add("Piezas malas quemado");
UltraWebGrid1.Columns.Add("% calidad de 1");
UltraWebGrid1.Columns.Add("% calidad de 2");
UltraWebGrid1.Columns.Add("% calidad de 3");
UltraWebGrid1.Columns.Add("% calidad de 4");
UltraWebGrid1.Columns.Add("Activo");
UltraWebGrid1.Columns[0].Header.Caption = "Piezas procesadas";
UltraWebGrid1.Columns[1].Header.Caption = "Cantidad inventarios";
UltraWebGrid1.Columns[2].Header.Caption = "Piezas malas";
UltraWebGrid1.Columns[3].Header.Caption = "Piezas malas verdes";
UltraWebGrid1.Columns[4].Header.Caption = "Piezas malas quemado";
UltraWebGrid1.Columns[5].Header.Caption = "% calidad de 1";
UltraWebGrid1.Columns[6].Header.Caption = "% calidad de 2";
UltraWebGrid1.Columns[7].Header.Caption = "% calidad de 3";
UltraWebGrid1.Columns[8].Header.Caption = "% calidad de 4";
UltraWebGrid1.Columns[9].Header.Caption = "Activo";
UltraWebGrid1.Columns[0].Width = 100;
UltraWebGrid1.Columns[1].Width = 100;
UltraWebGrid1.Columns[3].Width = 100;
UltraWebGrid1.Columns[4].Width = 100;
UltraWebGrid1.Columns[5].Width = 120;
UltraWebGrid1.Columns[6].Width = 120;
UltraWebGrid1.Columns[7].Width = 120;
UltraWebGrid1.Columns[8].Width = 120;
UltraWebGrid1.Columns[9].Width = 70;
UltraWebGrid1.Columns[0].Header.Style.Wrap = true;
UltraWebGrid1.Columns[1].Header.Style.Wrap = true;
UltraWebGrid1.Columns[2].Header.Style.Wrap = true;
UltraWebGrid1.Columns[3].Header.Style.Wrap = true;
UltraWebGrid1.Columns[4].Header.Style.Wrap = true;
UltraWebGrid1.Columns[5].Header.Style.Wrap = true;
UltraWebGrid1.Columns[6].Header.Style.Wrap = true;
UltraWebGrid1.Columns[7].Header.Style.Wrap = true;
UltraWebGrid1.Columns[8].Header.Style.Wrap = true;
UltraWebGrid1.Columns[9].Header.Style.Wrap = true;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[7].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[8].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[9].Header.Style.HorizontalAlign = HorizontalAlign.Center;
}
protected void CmbCodTipoArticulo_SelectedIndexChanged(object sender, EventArgs e)
{
// LLenar el combo Molde.
BE.ArticuloPars artPars = new BE.ArticuloPars();
artPars.CodTipoArticulo = Convert.ToInt32(this.CmbCodTipoArticulo.SelectedItem.Value);
svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient();
List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerMoldes(artPars);
UltraWebGrid1.DataSource = Lista;
if (Lista.Count <= 0)
{
llenarvacio();
}
else
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns[5].Hidden = true;
UltraWebGrid1.Columns[7].Hidden = true;
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave artículo";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Header.Caption = "Número de Impresiones";
UltraWebGrid1.Columns[4].Header.Caption = "Fecha";
UltraWebGrid1.Columns[6].Header.Caption = "Activo";
UltraWebGrid1.Columns[3].Header.Style.Wrap = true;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].CellStyle.HorizontalAlign = HorizontalAlign.Left;
UltraWebGrid1.Columns[3].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Format = "dd-MM-yyyy";
UltraWebGrid1.Columns[2].Width = 250;
UltraWebGrid1.Columns[3].Width = 135;
UltraWebGrid1.Columns[6].Width = 70;
}
}
protected void cmbProceso_SelectedIndexChanged(object sender, EventArgs e)
{
svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient();
List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerPruebas(int.Parse(cmbProceso.SelectedValue));
UltraWebGrid1.DataSource = Lista;
if (Lista.Count <= 0)
{
llenarvacio();
}
else
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Width = 682;
UltraWebGrid1.Columns[0].Header.Caption = "Clave prueba";
UltraWebGrid1.Columns[1].Header.Caption = "Descripción";
UltraWebGrid1.Columns[2].Hidden = true;
UltraWebGrid1.Columns[3].Header.Caption = "Proceso";
UltraWebGrid1.Columns[4].Hidden = true;
UltraWebGrid1.Columns[5].Header.Caption = "Proceso final";
UltraWebGrid1.Columns[6].Header.Caption = "Fecha";
UltraWebGrid1.Columns[7].Header.Caption = "Activo";
UltraWebGrid1.Columns[8].Header.Caption = "Residencia Max";
UltraWebGrid1.Columns[9].Hidden = true;
UltraWebGrid1.Columns[10].Hidden = true;
UltraWebGrid1.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[7].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[8].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[7].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[8].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[9].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[10].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Format = "dd-MM-yyyy";
UltraWebGrid1.Columns[5].Header.Style.Wrap = true;
UltraWebGrid1.Columns[1].Width = 150;
UltraWebGrid1.Columns[3].Width = 80;
UltraWebGrid1.Columns[4].Width = 80;
UltraWebGrid1.Columns[5].Width = 100;
UltraWebGrid1.Columns[6].Width = 80;
UltraWebGrid1.Columns[7].Width = 70;
}
}
protected void cmbProceso_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList cmbPlanta = ((DropDownList)Page.Master.FindControl("cmbPlanta"));
svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient();
cmbProceso.DataSource = svc.ObtenerProcesoCbo(int.Parse(cmbPlanta.SelectedValue));
List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerCentroTrabajo(int.Parse(cmbPlanta.SelectedValue), int.Parse(cmbProceso.SelectedValue));
UltraWebGrid1.DataSource = Lista;
if (Lista.Count <= 0)
{
llenarvacio();
}
else
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave centro de trabajo";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Hidden = true;
UltraWebGrid1.Columns[4].Header.Caption = "Proceso";
UltraWebGrid1.Columns[5].Header.Caption = "Línea de producción";
UltraWebGrid1.Columns[6].Hidden = true;
UltraWebGrid1.Columns[7].Hidden = true;
UltraWebGrid1.Columns[8].Hidden = true;
UltraWebGrid1.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.Wrap = true;
UltraWebGrid1.Columns[5].Header.Style.Wrap = true;
UltraWebGrid1.Columns[2].Width = 200;
UltraWebGrid1.Columns[4].Width = 150;
UltraWebGrid1.Columns[5].Width = 150;
}
}
protected void llenargrid()
{
llenarvacio();
svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient();
List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerKardexProducto(int.Parse(TextCodPieza.Text));
if (Lista.Count <= 0)
{
llenarvacioP();
}
else
{
List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista2 = svc.ObtenerKardexProducto(int.Parse(TextCodPieza.Text));
UltraWebGrid1.DataSource = Lista2;
BE.KardexProducto kp = Lista2[0] as BE.KardexProducto;
CodPiezaTransaccion.Value = kp.CodPiezaTransaccion.ToString();
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns[5].Hidden = true;
UltraWebGrid1.Columns[7].Hidden = true;
UltraWebGrid1.Columns[0].Header.Caption = "Fecha";
UltraWebGrid1.Columns[1].Hidden = true;
UltraWebGrid1.Columns[2].Header.Caption = "Proceso";
UltraWebGrid1.Columns[3].Hidden = true;
UltraWebGrid1.Columns[4].Header.Caption = "Centro de trabajo";
UltraWebGrid1.Columns[5].Hidden = true;
UltraWebGrid1.Columns[6].Header.Caption = "Maquina";
UltraWebGrid1.Columns[7].Header.Caption = "Posicion";
UltraWebGrid1.Columns[8].Hidden = true;
UltraWebGrid1.Columns[9].Header.Caption = "Operador";
UltraWebGrid1.Columns[10].Hidden = true;
UltraWebGrid1.Columns[11].Header.Caption = "Defectos";
UltraWebGrid1.Columns[11].Type = Infragistics.WebUI.UltraWebGrid.ColumnType.Button;
UltraWebGrid1.Columns[0].Format = "dd-MM-yyyy";
UltraWebGrid1.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[7].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Width = 120;
UltraWebGrid1.Columns[6].Width = 150;
UltraWebGrid1.Columns[9].Width = 160;
}
}
protected void btnReset_Click(object sender, System.EventArgs e)
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.ResetBands();
PerformSearch();
PerformDataBind();
if (this.CheckBox1.Checked)
{
PerformGroupby();
}
else
{
PerformFlat();
}
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave MFG");
UltraWebGrid1.Columns.Add("Clave nómina");
UltraWebGrid1.Columns.Add("Nombre");
UltraWebGrid1.Columns.Add("Apellido paterno");
UltraWebGrid1.Columns.Add("Apellido materno");
UltraWebGrid1.Columns.Add("Puesto");
UltraWebGrid1.Columns.Add("Centro de trabajo");
UltraWebGrid1.Columns.Add("Fecha");
UltraWebGrid1.Columns[0].Header.Caption = "Clave MFG";
UltraWebGrid1.Columns[1].Header.Caption = "Clave nómina";
UltraWebGrid1.Columns[2].Header.Caption = "Nombre";
UltraWebGrid1.Columns[3].Header.Caption = "Apellido paterno";
UltraWebGrid1.Columns[4].Header.Caption = "Apellido materno";
UltraWebGrid1.Columns[5].Header.Caption = "Puesto";
UltraWebGrid1.Columns[6].Header.Caption = "Centro de trabajo";
UltraWebGrid1.Columns[7].Header.Caption = "Fecha";
UltraWebGrid1.Columns[0].Header.Style.Wrap = true;
UltraWebGrid1.Columns[1].Header.Style.Wrap = true;
UltraWebGrid1.Columns[2].Header.Style.Wrap = true;
UltraWebGrid1.Columns[3].Header.Style.Wrap = true;
UltraWebGrid1.Columns[4].Header.Style.Wrap = true;
UltraWebGrid1.Columns[5].Header.Style.Wrap = true;
UltraWebGrid1.Columns[6].Header.Style.Wrap = true;
UltraWebGrid1.Columns[7].Header.Style.Wrap = true;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[7].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.DisplayLayout.ScrollBar = ScrollBar.Never;
UltraWebGrid1.Columns[3].Width = 110;
UltraWebGrid1.Columns[4].Width = 110;
UltraWebGrid1.Columns[6].Width = 110;
}
protected void llenarvacio()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns.Add("Clave única");
UltraWebGrid1.Columns.Add("Clave almacén");
UltraWebGrid1.Columns.Add("Descripción");
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave almacén";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
}
protected void llenargrid()
{
DropDownList cmbPlanta = ((DropDownList)Page.Master.FindControl("cmbPlanta"));
TxtPlanta.Text = cmbPlanta.SelectedItem.Text;
svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient();
List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerEstructuraPlanta(int.Parse(cmbPlanta.SelectedValue));
UltraWebGrid1.DataSource = Lista;
if (Lista.Count <= 0)
{
llenarvacio();
}
else
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns[7].Hidden = true;
UltraWebGrid1.Columns[0].Header.Caption = "Almacén";
UltraWebGrid1.Columns[2].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Caption = "Linea de producción";
UltraWebGrid1.Columns[4].Header.Caption = "Centro de trabajo";
UltraWebGrid1.Columns[5].Header.Caption = "Área";
UltraWebGrid1.Columns[6].Header.Caption = "Máquina";
UltraWebGrid1.Columns[3].Header.Style.Wrap = true;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[7].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[0].Width = 150;
UltraWebGrid1.Columns[1].Width = 85;
UltraWebGrid1.Columns[4].Width = 130;
UltraWebGrid1.Columns[5].Width = 160;
UltraWebGrid1.Columns[6].Width = 130;
}
}
private void llenaGrid()
{
// Planta.Value = ((DropDownList)Page.Master.FindControl("cmbPlanta")).SelectedItem.Text;
svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient();
List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerTurnos();
UltraWebGrid1.DataSource = Lista;
if (Lista.Count <= 0)
{
llenarvacio();
}
else
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns[4].Hidden = true;
UltraWebGrid1.Columns[5].Hidden = true;
UltraWebGrid1.Columns[7].Hidden = true;
UltraWebGrid1.Columns[0].Header.Caption = "Clave turno";
UltraWebGrid1.Columns[1].Header.Caption = "Descripción";
UltraWebGrid1.Columns[2].Header.Caption = "Hora inicio";
UltraWebGrid1.Columns[3].Header.Caption = "Hora fin";
UltraWebGrid1.Columns[6].Header.Caption = "Activo";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[3].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[6].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Format = "HH:mm";
UltraWebGrid1.Columns[3].Format = "HH:mm";
}
}
private void llenaGrid()
{
svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient();
List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerRol();
UltraWebGrid1.DataSource = Lista;
if (Lista.Count <= 0)
{
llenarvacio();
}
else
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns[3].Hidden = true;
UltraWebGrid1.Columns[0].AllowResize = AllowSizing.Fixed;
UltraWebGrid1.Columns[1].AllowResize = AllowSizing.Fixed;
UltraWebGrid1.Columns[2].AllowResize = AllowSizing.Fixed;
UltraWebGrid1.Columns[3].AllowResize = AllowSizing.Fixed;
UltraWebGrid1.Columns[0].Width = 100;
UltraWebGrid1.Columns[1].Width = 200;
UltraWebGrid1.Columns[2].Width = 70;
UltraWebGrid1.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].CellStyle.HorizontalAlign = HorizontalAlign.Left;
UltraWebGrid1.Columns[2].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[0].Header.Caption = "Clave rol";
UltraWebGrid1.Columns[1].Header.Caption = "Descripción";
UltraWebGrid1.Columns[2].Header.Caption = "Activo";
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Type = ColumnType.CheckBox;
}
}
private void PerformGetCusData(string strCommandText)
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.ResetBands();
ConnectStr = (new igFunctions.DB().getConStr()); SqlConnection Con = new SqlConnection(ConnectStr);
SqlCommand cmdCusData = new SqlCommand(strCommandText, Con);
SqlDataAdapter Adap = new SqlDataAdapter();
Con.Open();
Adap.SelectCommand = cmdCusData;
Adap.Fill(ds, "CusData");
Con.Close();
UltraWebGrid1.DataSource = ds.Tables["CusData"].DefaultView;
UltraWebGrid1.DataBind();
}
protected void cmbProceso_SelectedIndexChanged(object sender, EventArgs e)
{
svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient();
List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerPlanta(int.Parse(cmbAlmacen.SelectedValue));
UltraWebGrid1.DataSource = Lista;
if (Lista.Count <= 0)
{
llenarvacio();
}
else
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.DataBind();
UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
UltraWebGrid1.Columns[1].Header.Caption = "Clave planta";
UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
UltraWebGrid1.Columns[3].Hidden = true;
UltraWebGrid1.Columns[4].Header.Caption = "Almacén";
UltraWebGrid1.Columns[5].Hidden = true;
UltraWebGrid1.Columns[6].Hidden = true;
UltraWebGrid1.Columns[4].Width = 180;
UltraWebGrid1.Columns[2].Width = 250;
UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;
UltraWebGrid1.Columns[1].CellStyle.HorizontalAlign = HorizontalAlign.Center;
}
}