protected void llenarvacio()
        {
            UltraWebGrid2.ResetColumns();
            UltraWebGrid2.DataBind();

            UltraWebGrid2.DisplayLayout.ScrollBar = ScrollBar.Never;
            UltraWebGrid2.Columns.Add("Centro trabajo");
            UltraWebGrid2.Columns.Add("Banco");

            UltraWebGrid2.Columns.Add("Fecha inicio");
            UltraWebGrid2.Columns.Add("Fecha fin");
            UltraWebGrid2.Columns.Add("Autorizado");
            UltraWebGrid2.Columns.Add("Autoriza");
            UltraWebGrid2.Columns.Add("Activo");


            UltraWebGrid2.Columns[0].Header.Caption = "Centro de trabajo";
            UltraWebGrid2.Columns[1].Header.Caption = "Banco";

            UltraWebGrid2.Columns[2].Header.Caption = "Fecha inicio";
            UltraWebGrid2.Columns[3].Header.Caption = "Fecha fin";
            UltraWebGrid2.Columns[4].Header.Caption = "Autorizado";
            UltraWebGrid2.Columns[5].Header.Caption = "Autoriza";
            UltraWebGrid2.Columns[6].Header.Caption = "Activo";

            UltraWebGrid2.Columns[0].Header.Style.Wrap = true;



            UltraWebGrid2.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid2.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid2.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid2.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid2.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid2.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid2.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;



            UltraWebGrid2.Columns[0].Width = 100;
            UltraWebGrid2.Columns[1].Width = 65;
            UltraWebGrid2.Columns[4].Width = 75;
            UltraWebGrid2.Columns[5].Width = 90;
            UltraWebGrid2.Columns[6].Width = 70;
        }
Exemplo n.º 2
0
        private void PerformGetAllData(string strCommandText)
        {
            UltraWebGrid2.ResetColumns();
            UltraWebGrid2.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, "AllData");

            Con.Close();

            UltraWebGrid2.DataSource = ds.Tables["AllData"].DefaultView;
            UltraWebGrid2.DataBind();
        }
        protected void btnBuscar_click(object sender, EventArgs e)
        {
            try
            {
                DropDownList       cmbPlanta = ((DropDownList)Page.Master.FindControl("cmbPlanta"));
                svcSCPP.SCPPClient svc       = new svcSCPP.SCPPClient();
                int planta     = int.Parse(cmbPlanta.SelectedValue);
                int centroTrab = int.Parse(cmbCentroTrabajo.SelectedValue);
                int maquina    = int.Parse(cmbMaquina.SelectedValue);
                int active     = Convert.ToInt32(ddlActivos.SelectedValue);
                List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerConfiguracionBanco(planta, centroTrab, maquina, active);
                UltraWebGrid2.DataSource = Lista;
                if (Lista.Count <= 0)
                {
                    llenarvacio();
                }
                else
                {
                    UltraWebGrid2.ResetColumns();
                    UltraWebGrid2.DataBind();
                    UltraWebGrid2.DisplayLayout.ScrollBar = ScrollBar.Auto;

                    UltraWebGrid2.Columns[0].Header.Caption  = "Centro de trabajo";
                    UltraWebGrid2.Columns[1].Header.Caption  = "Banco";
                    UltraWebGrid2.Columns[2].Header.Caption  = "Límite de vaciadas";
                    UltraWebGrid2.Columns[3].Header.Caption  = "Vaciadas acumuladas";
                    UltraWebGrid2.Columns[4].Header.Caption  = "Fecha inicio";
                    UltraWebGrid2.Columns[5].Header.Caption  = "Fecha fin";
                    UltraWebGrid2.Columns[6].Header.Caption  = "Autorizado";
                    UltraWebGrid2.Columns[7].Header.Caption  = "Autoriza";
                    UltraWebGrid2.Columns[8].Header.Caption  = "Activo";
                    UltraWebGrid2.Columns[9].Header.Caption  = "CodCT";
                    UltraWebGrid2.Columns[10].Header.Caption = "CodMaquina";
                    UltraWebGrid2.Columns[11].Header.Caption = "CodUsuarioAutoriza";
                    UltraWebGrid2.Columns[12].Header.Caption = "CodUsuarioAlta";
                    UltraWebGrid2.Columns[13].Header.Caption = "CodConfigBanco";
                    UltraWebGrid2.Columns[14].Header.Caption = "ExceptionMessage";

                    UltraWebGrid2.Columns[0].Header.Style.Wrap = true;
                    UltraWebGrid2.Columns[2].Header.Style.Wrap = true;
                    UltraWebGrid2.Columns[3].Header.Style.Wrap = true;


                    UltraWebGrid2.Columns[6].Width = 80;
                    UltraWebGrid2.Columns[7].Width = 130;
                    UltraWebGrid2.Columns[8].Width = 70;

                    UltraWebGrid2.Columns[0].Width = 150;
                    UltraWebGrid2.Columns[1].Width = 150;

                    UltraWebGrid2.Columns[4].Width = 90;
                    UltraWebGrid2.Columns[5].Width = 90;


                    UltraWebGrid2.Columns[0].AllowResize = AllowSizing.Fixed;
                    UltraWebGrid2.Columns[1].AllowResize = AllowSizing.Fixed;
                    UltraWebGrid2.Columns[2].AllowResize = AllowSizing.Fixed;
                    UltraWebGrid2.Columns[3].AllowResize = AllowSizing.Fixed;
                    UltraWebGrid2.Columns[4].AllowResize = AllowSizing.Fixed;
                    UltraWebGrid2.Columns[5].AllowResize = AllowSizing.Fixed;
                    UltraWebGrid2.Columns[6].AllowResize = AllowSizing.Fixed;
                    UltraWebGrid2.Columns[7].AllowResize = AllowSizing.Fixed;
                    UltraWebGrid2.Columns[8].AllowResize = AllowSizing.Fixed;

                    UltraWebGrid2.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Left;
                    UltraWebGrid2.Columns[1].CellStyle.HorizontalAlign = HorizontalAlign.Left;
                    UltraWebGrid2.Columns[2].CellStyle.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[3].CellStyle.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[4].CellStyle.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[5].CellStyle.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[6].CellStyle.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[7].CellStyle.HorizontalAlign = HorizontalAlign.Left;
                    UltraWebGrid2.Columns[8].CellStyle.HorizontalAlign = HorizontalAlign.Center;

                    UltraWebGrid2.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[7].Header.Style.HorizontalAlign = HorizontalAlign.Center;
                    UltraWebGrid2.Columns[8].Header.Style.HorizontalAlign = HorizontalAlign.Center;

                    UltraWebGrid2.Columns[4].Format = "dd-MM-yyyy";
                    UltraWebGrid2.Columns[5].Format = "dd-MM-yyyy";

                    UltraWebGrid2.Columns[2].Hidden  = true;
                    UltraWebGrid2.Columns[3].Hidden  = true;
                    UltraWebGrid2.Columns[9].Hidden  = true;
                    UltraWebGrid2.Columns[10].Hidden = true;
                    UltraWebGrid2.Columns[11].Hidden = true;
                    UltraWebGrid2.Columns[12].Hidden = true;
                    UltraWebGrid2.Columns[13].Hidden = true;
                    UltraWebGrid2.Columns[14].Hidden = true;
                    UltraWebGrid2.Width = 800;
                }
            }
            catch (Exception ex)
            {
                CallBackManager.AddScriptBlock(this.Page, WebAsyncRefreshPanel1, "<script type='text/javascript'>alert('No se encontraron datos');</script>");
            }
        }