SqlFilterBuilder<ContractColumn> filter = new SqlFilterBuilder<ContractColumn>(); //test SqlFilterBuilder
filter.Junction = SqlUtil.AND;
filter.Append(ContractColumn.FContractPerson, "Jack , Ban , Tom"); //or jack or ban or tom
filter.Append(ContractColumn.FName, "*-02-01"); // like
filter.AppendIsNotNull(ContractColumn.FName); //is not null
filter.BeginGroup(SqlUtil.AND); //开始一个分组
filter.Junction = String.Empty; //"("后面没有and
filter.AppendIn(ContractColumn.FHouseId, "1,2,3,4");
filter.Junction = SqlUtil.OR;
string begindate = new DateTime(2005, 1, 1).ToString();
string enddate = DateTime.Now.ToString();
filter.AppendRange(ContractColumn.FDate, begindate,enddate); //范围
filter.EndGroup(); //结束分组
string result = filter.ToString();
DataRepository.UsersProvider.Find(result );
为什么报错报错:Unable to use this part of the where clause in this version of Find: uppermoduleid>2
还有你上面提到的“ (find 不支持直接写sql,用 TModuleQuery对象 的append xxx 来添加条件,最后调用 query 的GetParameters() 来获find需要查询条件)”
我不是份理解。你能不能针对我提出来的问题举个例来说明一下怎么给Find添加SQL语句,
能给个详细点的关于给FIND添加SQL语句的例子吗?
在线等 谢谢!
@金成
主要是在web.config中添加多个nettiers的节点, 发一个config给你参考下
<?xml version="1.0"?>
<configuration>
<configSections>
<!--pet shop-->
<!--<section name="Stars.PetShop.Data" type="Stars.PetShop.Data.Bases.NetTiersServiceSection, Stars.PetShop.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true" />-->
<!--SerialNumber-->
<!--<section name="Stars.SerialNumber.Data" type="Stars.SerialNumber.Data.Bases.NetTiersServiceSection, Stars.SerialNumber.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true" />-->
<!--Rbac-->
<section name="Stars.Rbac.Data" type="Stars.Rbac.Data.Bases.NetTiersServiceSection, Stars.Rbac.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true"/>
<!--CMS-->
<section name="Stars.CMS.Data" type="Stars.CMS.Data.Bases.NetTiersServiceSection, Stars.CMS.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true"/>
<!--HRM-->
<section name="Stars.HRM.Data" type="Stars.HRM.Data.Bases.NetTiersServiceSection, Stars.HRM.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true"/>
<!--Configuration-->
<section name="Stars.Configuration.Data" type="Stars.Configuration.Data.Bases.NetTiersServiceSection, Stars.Configuration.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true"/>
<!--3rd party-->
<!--<section name="RewriterConfig" type="URLRewriter.Config.RewriterConfigSerializerSectionHandler, URLRewriter" />-->
<sectionGroup name="DCWeb">
<section name="HttpCompress" type="DC.Web.HttpCompress.Configuration, DC.Web.HttpCompress"/>
</sectionGroup>
<!--entlib-->
<section name="enterpriseLibrary.ConfigurationSource" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ConfigurationSourceSection, Microsoft.Practices.EnterpriseLibrary.Common, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<!--microsoft-->
<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>
<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
<section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
</sectionGroup>
</sectionGroup>
</sectionGroup>
</configSections>
<DCWeb>
<HttpCompress compressionType="GZip">
<CacheSettings cacheFiles="true" path="cache"/>
<PathSettings jsPath="Script" cssPath="Style"/>
<IncludedMimeTypes>
<add mime="text/html"/>
</IncludedMimeTypes>
<!--
<ExcludedMimeTypes>
<add mime="text/html" />
</ExcludedMimeTypes>
-->
<!--<ExcludedPaths>
<add path="~/Default.aspx" />
<add path="~/Login.aspx" />
<add path="~/oa/Desktop/Desktop.aspx" />
<add path="~/ftm/ImportAirway/ImportAirwayList.aspx" />
</ExcludedPaths>-->
</HttpCompress>
</DCWeb>
<appSettings>
<add key="HEADER_PREFIX" value="S.T.A.R.S CMS :: {0}"/>
<!--单用户登入-->
<add key="SINGLE_USER" value="0"/>
<!--Configuration-->
<add key="SYSTEM_CODE" value="21f49b64-e2fd-4c6b-bda4-9aca012eda81"/>
<!--CMS-->
<add key="OUTPUT_PATH" value="D:\S.T.A.R.S\Web-Root\PetShopSite"/>
<add key="RELATIVE_PATH" value=""/>
<add key="FILE_EXT" value="htm"/>
<add key="MAX_THREAD" value="10"/>
<!-- 1-5 -->
<add key="THREAD_LEVEL" value="3"/>
<add key="USE_CAPTCHA" value="0"/>
</appSettings>
<connectionStrings>
<!--petshop-->
<add name="Stars.PetShop.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=PetShop;user=sa;pwd=111;Connect Timeout=30;"/>
<!--SerialNumber-->
<add name="Stars.SerialNumber.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=SerialNumber;user=sa;pwd=111;Connect Timeout=30;"/>
<!--rbac-->
<add name="Stars.Rbac.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=rbac;user=sa;pwd=111;Connect Timeout=30;"/>
<!--CMS-->
<add name="Stars.CMS.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=CMS;user=sa;pwd=111;Connect Timeout=30;"/>
<!--HRM-->
<add name="Stars.HRM.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=CMS;user=sa;pwd=111;Connect Timeout=30;"/>
<!--Configuration-->
<add name="Stars.Configuration.Data.ConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Configuration;user=sa;pwd=111;Connect Timeout=30;"/>
</connectionStrings>
<!--PetShop-->
<!--<Stars.CMS.Data>
<providers>
<add name="SqlNetTiersProvider" type="Stars.PetShop.Data.SqlClient.SqlNetTiersProvider, Stars.PetShop.Data.SqlClient" connectionStringName="Stars.PetShop.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.PetShop.Entities.EntityFactory" useEntityFactory="true" enableEntityTracking="true" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30" />
</providers>
</Stars.CMS.Data>-->
<!--SerialNumber-->
<!--<Stars.SerialNumber.Data defaultProvider="SqlNetTiersProvider">
<providers>
<add name="SqlNetTiersProvider" type="Stars.SerialNumber.Data.SqlClient.SqlNetTiersProvider, Stars.SerialNumber.Data.SqlClient" connectionStringName="Stars.SerialNumber.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.SerialNumber.Entities.EntityFactory" useEntityFactory="true" enableEntityTracking="true" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30" />
</providers>
</Stars.SerialNumber.Data>-->
<!--Rbac-->
<Stars.Rbac.Data defaultProvider="SqlNetTiersProvider">
<providers>
<add name="SqlNetTiersProvider" type="Stars.Rbac.Data.SqlClient.SqlNetTiersProvider, Stars.Rbac.Data.SqlClient" connectionStringName="Stars.Rbac.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.Rbac.Entities.EntityFactory" useEntityFactory="true" enableEntityTracking="true" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30"/>
</providers>
</Stars.Rbac.Data>
<!--CMS-->
<Stars.CMS.Data defaultProvider="SqlNetTiersProvider">
<providers>
<add name="SqlNetTiersProvider" type="Stars.CMS.Data.SqlClient.SqlNetTiersProvider, Stars.CMS.Data.SqlClient" connectionStringName="Stars.CMS.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.CMS.Entities.EntityFactory" useEntityFactory="false" enableEntityTracking="false" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30"/>
</providers>
</Stars.CMS.Data>
<!--HRM-->
<Stars.HRM.Data defaultProvider="SqlNetTiersProvider">
<providers>
<add name="SqlNetTiersProvider" type="Stars.HRM.Data.SqlClient.SqlNetTiersProvider, Stars.HRM.Data.SqlClient" connectionStringName="Stars.HRM.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.HRM.Entities.EntityFactory" useEntityFactory="false" enableEntityTracking="true" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30"/>
</providers>
</Stars.HRM.Data>
<!--Configuration-->
<Stars.Configuration.Data defaultProvider="SqlNetTiersProvider">
<providers>
<add name="SqlNetTiersProvider" type="Stars.Configuration.Data.SqlClient.SqlNetTiersProvider, Stars.Configuration.Data.SqlClient" connectionStringName="Stars.Configuration.Data.ConnectionString" providerInvariantName="System.Data.SqlClient" entityFactoryType="Stars.Configuration.Entities.EntityFactory" useEntityFactory="true" enableEntityTracking="true" enableMethodAuthorization="false" useStoredProcedure="false" defaultCommandTimeout="30"/>
</providers>
</Stars.Configuration.Data>
<system.web>
<machineKey validationKey="F398AE70C98A10D6611D7F78DD2F94CA36FA7097" decryptionKey="15DAF21530C667300905EFF62C5F8FD0FD0E016C80EDE1B7" decryption="3DES" validation="SHA1"/>
<httpModules>
<!--PetShop-->
<!--<add name="PetShop.EntityTransactionModule" type="Stars.CMS.Web.Data.EntityTransactionModule, Stars.CMS.Web" />-->
<!--SerialNumber-->
<!-- <add name="SerialNumber.EntityTransactionModule" type="Stars.SerialNumber.Web.Data.EntityTransactionModule" />-->
<!--Rbac-->
<!--<add name="EntityTransactionModule" type="Stars.Rbac.Web.Data.EntityTransactionModule" />-->
<!--CMS-->
<add name="EntityTransactionModule" type="Stars.CMS.Web.Data.EntityTransactionModule"/>
<!--Configuration-->
<!--<add name="EntityTransactionModule" type="Stars.Configuration.Web.Data.EntityTransactionModule" />-->
<!--3rd party-->
<!--<add name="QueryStringUrlRemapper" type="Stars.Web.HttpModule.UrlRemapper, Stars.Web.HttpModule"/>-->
<!--<add name="ModuleRewriter" type="URLRewriter.ModuleRewriter, URLRewriter" />-->
<!--microsoft ajax-->
<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</httpModules>
<compilation debug="true">
<assemblies>
<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
</assemblies>
</compilation>
<!--<authentication mode="Windows" />-->
<authentication mode="Forms">
<forms name=".Stars.PetShop" defaultUrl="Default.aspx" loginUrl="Login.aspx" protection="All" timeout="30" path="/" requireSSL="false" slidingExpiration="true" enableCrossAppRedirects="false" cookieless="AutoDetect"></forms>
</authentication>
<authorization>
<deny users="?"/>
</authorization>
<customErrors mode="Off" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm"/>
<error statusCode="404" redirect="FileNotFound.htm"/>
</customErrors>
<trace enabled="false" pageOutput="true" traceMode="SortByCategory" localOnly="true" mostRecent="true" writeToDiagnosticsTrace="true"/>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
<pages theme="default" pageBaseType="Stars.Web.UI.PageBase" userControlBaseType="Stars.Web.UI.UserControlBase" maintainScrollPositionOnPostBack="true" masterPageFile="~/MasterPage.Master" validateRequest="false" enableViewStateMac="true">
<controls>
<!--user controls-->
<add tagPrefix="stars" src="~/Hrms/UserInfo.ascx" tagName="UserInfo"/>
<add tagPrefix="stars" src="~/Debug/DebugInfo.ascx" tagName="DebugInfo"/>
<add tagPrefix="stars" src="~/Help/Tags.ascx" tagName="UcTags"/>
<add tagPrefix="stars" namespace="Stars.Web.UI" assembly="Stars.Web.UI"/>
<!--pet shop-->
<!--<add tagPrefix="stars" namespace="Stars.CMS.Web.Data" assembly="Stars.CMS.Web" />
<add tagPrefix="stars" namespace="Stars.CMS.Web.UI" assembly="Stars.CMS.Web" />-->
<!--SerialNumber-->
<!-- <add tagPrefix="stars" namespace="Stars.SerialNumber.Web.Data" assembly="Stars.SerialNumber.Web" />
<add tagPrefix="stars" namespace="Stars.SerialNumber.Web.UI" assembly="Stars.SerialNumber.Web" />-->
<!--Rbac-->
<!--<add tagPrefix="stars" namespace="Stars.Rbac.Web.Data" assembly="Stars.Rbac.Web" />
<add tagPrefix="stars" namespace="Stars.Rbac.Web.UI" assembly="Stars.Rbac.Web" />-->
<!--CMS-->
<add tagPrefix="cms" namespace="Stars.CMS.Web.Data" assembly="Stars.CMS.Web"/>
<add tagPrefix="cms" namespace="Stars.CMS.Web.UI" assembly="Stars.CMS.Web"/>
<!--HRM-->
<add tagPrefix="hrm" namespace="Stars.HRM.Web.Data" assembly="Stars.HRM.Web"/>
<add tagPrefix="hrm" namespace="Stars.HRM.Web.UI" assembly="Stars.HRM.Web"/>
<!--Configuration-->
<add tagPrefix="config" namespace="Stars.Configuration.Web.Data" assembly="Stars.Configuration.Web"/>
<add tagPrefix="config" namespace="Stars.Configuration.Web.UI" assembly="Stars.Configuration.Web"/>
<!--3rd party-->
<add tagPrefix="Ext" namespace="Coolite.Ext.Web" assembly="Coolite.Ext.Web"/>
<add tagPrefix="Captcha" namespace="WebControlCaptcha" assembly="WebControlCaptcha"/>
<!--microsoft-->
<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</controls>
</pages>
<httpHandlers>
<remove path="*.asmx" verb="*"/>
<!--CaptchaImage-->
<add verb="GET" path="CaptchaImage.axd" type="WebControlCaptcha.CaptchaImageHandler, WebControlCaptcha"/>
<!--3rd party-->
<add path="*/coolite.axd" verb="*" type="Coolite.Ext.Web.ResourceManager, Coolite.Ext.Web" validate="false"/>
<!--microsoft-->
<add path="*.asmx" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
<add path="*_AppService.axd" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
<add path="ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
</httpHandlers>
<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="AutoDetect" timeout="20"/>
<!--<sessionState mode="SQLServer" sqlConnectionString="Data Source=.\SQLEXPRESS;user=sa;pwd=111;" timeout="30" cookieName=".CMS" cookieless="AutoDetect" />-->
<!--upload files limit 10mb-->
<httpRuntime maxRequestLength="10240"/>
</system.web>
<!--security config-->
<location path="Javascript">
<system.web>
<authorization>
<allow users="?"/>
</authorization>
</system.web>
</location>
<location path="Images">
<system.web>
<authorization>
<allow users="?"/>
</authorization>
</system.web>
</location>
<!--<location path="ig_common">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<!--<location path="App_Themes">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<!--<location path="css">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<!--<location path="RadControls">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<!--<location path="MasterPages">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<!--<location path="Logs">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<location path="Templete">
<system.web>
<authorization>
<allow users="?"/>
</authorization>
</system.web>
</location>
<location path="css">
<system.web>
<authorization>
<allow users="?"/>
</authorization>
</system.web>
</location>
<!--<location path="Script">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>-->
<location path="CaptchaImage.axd">
<system.web>
<authorization>
<allow users="?"/>
</authorization>
</system.web>
</location>
<!--ent lib-->
<enterpriseLibrary.ConfigurationSource selectedSource="File Configuration Source">
<sources>
<add name="File Configuration Source" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.FileConfigurationSource, Microsoft.Practices.EnterpriseLibrary.Common, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" filePath="entlib.config"/>
</sources>
</enterpriseLibrary.ConfigurationSource>
<!--<RewriterConfig>
<Rules>-->
<!-- Rules for Product Lister -->
<!--
-->
<!--<RewriterRule>
<LookFor>~/([^/]*)/([^/.]*)</LookFor>
<SendTo>~/$1.aspx$2</SendTo>
</RewriterRule>
<RewriterRule>
<LookFor>~/([^/]*)/([^/]*)/([^/.]*)</LookFor>
<SendTo>~/$1/$2.aspx$3</SendTo>
</RewriterRule>
<RewriterRule>
<LookFor>~/([^/]*)/([^/]*)/([^/]*)/([^/.]*)</LookFor>
<SendTo>~/$1/$2/$3.aspx$4</SendTo>
</RewriterRule>-->
<!--</Rules>
</RewriterConfig>-->
<system.codedom>
<compilers>
<compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider,System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
<providerOption name="CompilerVersion" value="v3.5"/>
<providerOption name="WarnAsError" value="false"/>
</compiler>
</compilers>
</system.codedom>
<!--
IIS 7.0
-->
<system.webServer>
<validation validateIntegratedModeConfiguration="false"/>
<modules>
<remove name="ScriptModule"/>
<add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</modules>
<handlers>
<remove name="WebServiceHandlerFactory-Integrated"/>
<remove name="ScriptHandlerFactory"/>
<remove name="ScriptHandlerFactoryAppServices"/>
<remove name="ScriptResource"/>
<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</handlers>
</system.webServer>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>
1. TPmtRegisterTermQuery filter = new TPmtRegisterTermQuery();
filter.AppendEquals(TPmtRegisterTermColumn.Companyid, "1");
DataRepository.TPmtRegisterTermProvider.Find(filter.GetParameters(), "", 0, 100, out count);
2. 不能指定字段, 查询结果就是一个对象, 绑定下拉菜单的话, 设置下拉菜单的datatextfield ,datavaluefield
3. 级联的话跟数据源没什么关系吧, 该怎么做还是怎么做
public TList<TModule> SelectModelByUpID(int id)
{
return DataRepository.TModuleProvider.Find("UpperModuleID>" + id);
}
报错:Unable to use this part of the where clause in this version of Find: uppermoduleid>2
Find有很多版本么?
谢谢,没想到博主这么快回消息!