<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="QueryParameter.ascx.cs" Inherits="AVA.ResourcesPlatform.AdminUI.Pub.Video.QueryParameter" %> <% switch (this.Key) { case "Version": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "Version")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "SortNumber": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "SortNumber")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "Status": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "Status")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_User._Domain.Name": %> <%= new HtmlHidden("$TableAlias","_User._Domain")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_User._Domain.Code": %> <%= new HtmlHidden("$TableAlias","_User._Domain")%> <%= new HtmlHidden("$Field", "Code")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_User._UserType.Name": %> <%= new HtmlHidden("$TableAlias","_User._UserType")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_User.TrueName": %> <%= new HtmlHidden("$TableAlias","_User")%> <%= new HtmlHidden("$Field", "TrueName")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_User.UserName": %> <%= new HtmlHidden("$TableAlias","_User")%> <%= new HtmlHidden("$Field", "UserName")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_Category.Name": %> <%= new HtmlHidden("$TableAlias","_Category")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_Lesson._Textbook._Press.Name": %> <%= new HtmlHidden("$TableAlias","_Lesson._Textbook._Press")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_Lesson._Textbook._Grade.Name": %> <%= new HtmlHidden("$TableAlias","_Lesson._Textbook._Grade")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_Lesson._Textbook._Category.Name": %> <%= new HtmlHidden("$TableAlias","_Lesson._Textbook._Category")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_Lesson._Textbook.Name": %> <%= new HtmlHidden("$TableAlias","_Lesson._Textbook")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_Lesson.Name": %> <%= new HtmlHidden("$TableAlias","_Lesson")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_Press.Name": %> <%= new HtmlHidden("$TableAlias","_Press")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_Grade.Name": %> <%= new HtmlHidden("$TableAlias","_Grade")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "Name": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_PlaySaveServer.Name": %> <%= new HtmlHidden("$TableAlias","_PlaySaveServer")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "Cover": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "Cover")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "Summary": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "Summary")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "FileType": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "FileType")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "FileSize": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "FileSize")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._double)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "Period": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "Period")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "VideoView": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "VideoView")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "CommentCount": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "CommentCount")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "CollectCount": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "CollectCount")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "Copyright": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "Copyright")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "Share": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "Share")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "LockVideo": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "LockVideo")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_LockUser._Domain.Name": %> <%= new HtmlHidden("$TableAlias","_LockUser._Domain")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_LockUser._Domain.Code": %> <%= new HtmlHidden("$TableAlias","_LockUser._Domain")%> <%= new HtmlHidden("$Field", "Code")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_LockUser._UserType.Name": %> <%= new HtmlHidden("$TableAlias","_LockUser._UserType")%> <%= new HtmlHidden("$Field", "Name")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_LockUser.TrueName": %> <%= new HtmlHidden("$TableAlias","_LockUser")%> <%= new HtmlHidden("$Field", "TrueName")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_LockUser.UserName": %> <%= new HtmlHidden("$TableAlias","_LockUser")%> <%= new HtmlHidden("$Field", "UserName")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "LockDateTime": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "LockDateTime")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._DateTime)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "LockDescription": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "LockDescription")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "Examine": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "Examine")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "Description": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "Description")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "RecTime": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "RecTime")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._DateTime)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "CreateTime": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "CreateTime")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._DateTime)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "VideoConvertStatus": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "VideoConvertStatus")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "HasDownload": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "HasDownload")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._bool)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "Spreaker": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "Spreaker")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "TeacherRatio": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "TeacherRatio")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "StudentRatio": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "StudentRatio")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "TransferRatio": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "TransferRatio")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "TeachingType": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "TeachingType")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "CaptionsFile": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "CaptionsFile")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "_Application.Title": %> <%= new HtmlHidden("$TableAlias","_Application")%> <%= new HtmlHidden("$Field", "Title")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "FioderName": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "FioderName")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "HDURL": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "HDURL")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "NRURL": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "NRURL")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._string)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "IsWeiKe": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "IsWeiKe")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._bool)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "Marking0": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "GuidCount")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%--<%= new HtmlHidden("$ExpressionKey", "EXISTS (SELECT Guid FROM Pub_Marking WHERE (MKType = 0) AND (MKTarget = '视频') AND (MKGuid = {alias}.Guid) GROUP BY Guid HAVING (COUNT(Guid) = {value}))")%> --%> <%--MySql?--%> <%= new HtmlHidden("$ExpressionKey", AVA.ResourcesPlatform.Factory.CreateInstance.SQLDao.AdminUI_Pub_Video_QueryParameter_ExpressionKey())%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; case "TrainYear": %> <%= new HtmlHidden("$TableAlias","_Alias")%> <%= new HtmlHidden("$Field", "TrainYear")%> <%= new HtmlHidden("$FieldType", (int)Z.Core.NHibernateCore.Search.FieldTypeEnum._int)%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; default: %> <%= new HtmlHidden("$TableAlias","")%> <%= new HtmlHidden("$Field", "")%> <%= new HtmlHidden("$FieldType", "")%> <%= new HtmlHidden("$ExpressionKey", null)%> <%= new HtmlHidden("$IgnoreEmpty", "0")%> <% break; } %>