コード例 #1
0
        private List <Comun> GetList()
        {
            try
            {
                List <Comun> List = new List <Comun>();

                Session["BuscarPrecio" + Session.SessionID] = null;
                CN_CatCliente clsCatCliente = new CN_CatCliente();
                Sesion        session2      = new Sesion();
                session2 = (Sesion)Session["Sesion" + Session.SessionID];
                Clientes cte = new Clientes();
                cte.Id_Emp = session2.Id_Emp;
                cte.Id_Cd  = session2.Id_Cd_Ver;
                cte.Id_Cte = Convert.ToInt32(Request.QueryString["cte"]);

                clsCatCliente.ConsultaEstadistica(cte, session2.Emp_Cnx, ref List, RadNumericTextBox1.Value, RadTextBox1.Text == "" ? null : RadTextBox1.Text);

                RadGrid1.Columns[3].Display = CmbEn.SelectedValue == "1";
                RadGrid1.Columns[4].Display = CmbEn.SelectedValue == "1";
                RadGrid1.Columns[5].Display = CmbEn.SelectedValue == "1";

                RadGrid1.Columns[6].Display = !(CmbEn.SelectedValue == "1");
                RadGrid1.Columns[7].Display = !(CmbEn.SelectedValue == "1");
                RadGrid1.Columns[8].Display = !(CmbEn.SelectedValue == "1");

                CN_CatCalendario cn_calendario = new CN_CatCalendario();
                Calendario       calendario    = new Calendario();
                cn_calendario.ConsultaCalendarioActual(ref calendario, session2);

                DateTime mes_actual = Convert.ToDateTime("01/" + calendario.Cal_Mes.ToString() + "/" + calendario.Cal_Año.ToString());

                RadGrid1.Columns[3].HeaderText = mes_actual.AddMonths(-3).ToString("MM/yyyy");
                RadGrid1.Columns[6].HeaderText = mes_actual.AddMonths(-3).ToString("MM/yyyy");

                RadGrid1.Columns[4].HeaderText = mes_actual.AddMonths(-2).ToString("MM/yyyy");
                RadGrid1.Columns[7].HeaderText = mes_actual.AddMonths(-2).ToString("MM/yyyy");

                RadGrid1.Columns[5].HeaderText = mes_actual.AddMonths(-1).ToString("MM/yyyy");
                RadGrid1.Columns[8].HeaderText = mes_actual.AddMonths(-1).ToString("MM/yyyy");

                if (List.Count > 0)
                {
                    //RadGrid1.Columns[3].HeaderText = List[0].ValorStr.PadLeft(7, '0');
                    // List[0].ValorStr2.PadLeft(7, '0');
                    //List[0].ValorStr3.PadLeft(7, '0');
                    //RadGrid1.Columns[6].HeaderText = List[0].ValorStr.PadLeft(7, '0');
                    // List[0].ValorStr2.PadLeft(7, '0');
                    //List[0].ValorStr3.PadLeft(7, '0');
                }
                return(List);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }