Výpis zdrojového kódu súboru CDTitul.aspx.cs


using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using PxControls;
using PxFiles;

public partial class CDTitul : BasePage
{

     protected void Page_Load(object sender, EventArgs e)
     {
         //rutina na vypnutie BackButonu v Browsery
         this.Context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
         this.Context.Response.Cache.SetAllowResponseInBrowserHistory(false);

         if (Request.Browser.MSDomVersion.Major == 0) // Non IE Browser?)
             this.Context.Response.Cache.SetNoStore();

        if (/*(!IsPostBack)&&*/(wquQAuthor.Active==false))
        {
            wquQAuthor.ConnectString = AppConst.ConnectString;
            wquQAuthor.SQLSelect = "select IDAuthor, CONCAT_WS(' ', Last_Name, First_Name) as Name  from Author";

            wquQAuthor.Open();

            wquQAuthor.AutomaticRefresh = true;
            wquQAuthor.IntervalQueryRefresh = 30;

        }
        else
        {

        }

        if (/*(!IsPostBack)&&*/(wquQZaner.Active==false))
        {
            wquQZaner.ConnectString = AppConst.ConnectString;
            wquQZaner.SQLSelect = "select     Zaner.IDZaner as IDZaner,   Zaner.Name as Zaner,     Zaner.IDKateg_Zaner as IDKateg_Zaner,   Kateg_Zaner.Name as Kateg_Zaner  from   Zaner, Kateg_Zaner where Kateg_Zaner.IDKateg_Zaner=Zaner.IDKateg_Zaner";

            wquQZaner.Open();

            wquQZaner.AutomaticRefresh = true;
            wquQZaner.IntervalQueryRefresh = 30;

            wquQZaner.Columns["IDKateg_Zaner"].Caption = "";

            wquQZaner.Columns["Kateg_Zaner"].Caption = "Kategória";

            wquQZaner.Columns["IDZaner"].Caption = "";

            wquQZaner.Columns["Zaner"].Caption = "Žáner";



        }
        else
        {

        }

        if (/*(!IsPostBack)&&*/(wquCdTitul.Active == false))
        {
            filterCdTitul.AddParamFilter("Titul", "<b>CD Titul</b>", "");
            filterCdTitul.AddParamFilter("Author", "<b>Autor</b>", "IdAuthor1");
            filterCdTitul.AddParamFilter("ZanerFull", "<b>Kategória Žánra</b>", "IDKateg_Zaner");
            filterCdTitul.AddParamFilter("ZanerFull", "<b>Žáner</b>", "IDZaner");
            filterCdTitul.OrigSQLSelect = "select IDCDTitul, Titul, IDKATEG_ZANER, IDZaner, IdVydavatel, IdCDNosic, IDCDFormat, Create_Date, IdAuthor1, IdAuthor2, IdAuthor3, IdAuthor4 from CdTitul";

            string sSQLText1 = "select IdCDNosic as aKey, Name as aValue from CDNosic Order By aValue";
            string sSQLText2 = "select IDCDFormat as aKey, Name as aValue from CDFormat Order By aValue";
            string sSQLText3 = "select IdVydavatel as aKey, Vydavatel as aValue from Vydavatel Order By aValue";

            wquCdTitul.ConnectString = AppConst.ConnectString;
            wquCdTitul.SQLSelect = "select IDCDTitul, Titul, IDKATEG_ZANER, IDZaner, IdVydavatel, IdCDNosic, IDCDFormat, Create_Date, IdAuthor1, IdAuthor2, IdAuthor3, IdAuthor4 from CdTitul";

            wquCdTitul.AddParamKey("IdCDNosic", "aKey", "aValue", "aValue", "aKey", sSQLText1);
            wquCdTitul.AddParamKey("IDCDFormat", "aKey", "aValue", "aValue", "aKey", sSQLText2);
            wquCdTitul.AddParamKey("IdVydavatel", "aKey", "aValue", "aValue", "aKey", sSQLText3);


            wquCdTitul.AddParamWebQuery("IdAuthor1", "IDAuthor", "Name", "Name", "IDAuthor", "wquQAuthor");
            wquCdTitul.AddParamWebQuery("IdAuthor2", "IDAuthor", "Name", "Name", "IDAuthor", "wquQAuthor");
            wquCdTitul.AddParamWebQuery("IdAuthor3", "IDAuthor", "Name", "Name", "IDAuthor", "wquQAuthor");
            wquCdTitul.AddParamWebQuery("IdAuthor4", "IDAuthor", "Name", "Name", "IDAuthor", "wquQAuthor");

            wquCdTitul.AddParamGreatWebQuery("Author", "IdAuthor1", "IdAuthor1", 4, "mvBreakHR");
            wquCdTitul.AddParamFlyComboBox("ZanerFull", "IDKATEG_ZANER;IDZaner", "IDKateg_Zaner;IDZaner", "Kateg_Zaner;Zaner", "Kateg_Zaner;Zaner","wquQZaner", "mvNameAndBR");
            wquCdTitul.AddParamValidation("Titul", "vtIsNotNull");

            wquCdTitul.Open();

            wquCdTitul.AutomaticRefresh = true;
            wquCdTitul.IntervalQueryRefresh = 30;

            wquCdTitul.Columns["IDCDTitul"].Caption = "Id Titul";

            wquCdTitul.Columns["Titul"].Caption = "CD Titul";

            wquCdTitul.Columns["IDKATEG_ZANER"].Caption = "Kategória Žáner";

            wquCdTitul.Columns["IDZaner"].Caption = "Žáner";

            wquCdTitul.Columns["IdVydavatel"].Caption = "Vydavate¾";

            wquCdTitul.Columns["IdCDNosic"].Caption = "CD Nosiè";

            wquCdTitul.Columns["IDCDFormat"].Caption = "CD Formát";

            wquCdTitul.Columns["Create_Date"].Caption = "Dátum vytvorenia";

            wquCdTitul.Columns["IdAuthor1"].Caption = "Autor";

            wquCdTitul.Columns["IdAuthor2"].Caption = "Autor";

            wquCdTitul.Columns["IdAuthor3"].Caption = "Autor";

            wquCdTitul.Columns["IdAuthor4"].Caption = "Autor";

            wquCdTitul.Columns["Author"].Caption = "Autor";

            wquCdTitul.Columns["ZanerFull"].Caption = "Kategória / Žáner";

        }
        else
        {

        }

            filterCdTitul.PxDataSource = wquCdTitul;

            grdCdTitul.VisibleFields = "IDCDTitul:40;Titul:120;Author:120;IdCDNosic:40;IDCDFormat:40;IdVydavatel;ZanerFull";
            grdCdTitul.PxDataSource = wquCdTitul;
            //grdCdTitul.AllowSorting = true;
            grdCdTitul.DataBind();
            navCdTitul.PxDataSource = wquCdTitul;
            navCdTitul.PxVisibleButtons = "FRNL";

            Uploader.IdUploadFile = 17771;
            Uploader.UploadDir = @"uploads/data";
            Uploader.ButtonImageUrl = "./images/AddFiles.png";
            Uploader.ButtonWidth = 122;
            Uploader.ButtonHeight = 34;
            Uploader.ProgressBarColor = "#FF9933";
     }

}
Návrat na pôvodnú stránku