D:\feplat_demo\Web.config 配置
<?xml version="1.0" encoding="utf-8"?>
<!--
有关如何配置 ASP.NET 应用程序的详细信息，请访问
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<system.web>
<compilation debug="false" targetFramework="4.0" />
<!-- 20M -->
<httpRuntime maxRequestLength="20971520" requestValidationMode="2.0" executionTimeout="600" />
<pages validateRequest="false"></pages>
<!-- 对应已安装Oracle客户端 -->
<!--<healthMonitoring>
<providers>
<remove name="OracleWebEvnetProvider"/>
</providers>
</healthMonitoring>-->
</system.web>
<system.data>
<DbProviderFactories>
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data" />
<!--<add name="Npgsql Data Provider" invariant="Npgsql" description="Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql" />-->
<!--<add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />-->
<!--<add name="sqlserver Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for sqlserver" type="System.Data.SqlClient.SqlClientFactory,System.Data" />-->
</DbProviderFactories>
</system.data>
<appSettings>
<add key="PlatUser" value="dev|123456;dev2|654321" />
</appSettings>
<system.webServer>
<modules>
<add type="ES.LibraryV2.Web.Handler.ESCommonModule,ES.LibraryV2" name="commonModule" />
</modules>
<handlers>
<add verb="*" path="*.do" type="ES.LibraryV2.Web.Handler.ESHttpHandlerFactory, ES.LibraryV2" name="esHandlerFactory" />
</handlers>
<security>
<requestFiltering>
<!-- 20M -->
<requestLimits maxAllowedContentLength="20971520"></requestLimits>
</requestFiltering>
</security>
<staticContent>
<mimeMap fileExtension=".apk" mimeType="application/vnd.android.package-archive" />
<mimeMap fileExtension=".properties" mimeType="application/x-javascript" />
</staticContent>
<defaultDocument>
<files>
<add value="login.html" />
</files>
</defaultDocument>
<directoryBrowse enabled="true" />
</system.webServer>
</configuration>
<configuration>
<connectionStrings>
<add name="ESUI" displayName="平台库" connectionString="Database=eset_erp10;Data Source=127.0.0.1;User Id=root;Password=root;pooling=false;CharSet=utf8;port=3306" providerName="MySql55Inno" showSql="true" formatSql="false" schema="HAIER_ESUI_20" throwInitError="false" isShow4Dev="false" />
<add name="ESWF" displayName="平台工作流" connectionString="Database=eset_erp10;Data Source=127.0.0.1;User Id=root;Password=root;pooling=false;CharSet=utf8;port=3306" providerName="MySql55Inno" showSql="false" formatSql="true" schema="HAIER_ESWF_10" isShow4Dev="false"/>
<add name="ESET" displayName="业务库" connectionString="Database=eset_erp10;Data Source=127.0.0.1;User Id=root;Password=root;pooling=false;CharSet=utf8;port=3306" providerName="MySql55Inno" showSql="true" formatSql="true" schema="HAIER_BUSINESS" throwInitError="false" />
<!-- 连接name不同连接相同推荐使用ref的配置demo -->
<!-- <add name="ESWeixin" refName="ESET" displayName="微信库" /> -->
<!-- <add name="ESSC" refName="ESET" displayName="智云APP业务库" /> -->
<!-- 不同数据库连接字符串配置demo -->
<!-- SQL Server -->
<!-- <add name="ESET_SQLSERVER" displayName="业务库SQLServer" connectionString="Database=ESET_ERP10;server=.;uid=********;pwd=********" providerName="MSSqlServer2008" showSql="true" formatSql="true" schema="dbo" throwInitError="false" /> -->
<!-- SQL Azure -->
<!-- <add name="ESET_SQLAZURE" displayName="业务库SQLAzure" connectionString="Server=tcp:**********.database.windows.net,1433;Database=*****;Persist Security Info=False;User ID=********;Password=**********;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;" providerName="MSSqlServer2008" showSql="true" formatSql="true" isShow4Dev="true"/> -->
<!-- MySQL -->
<add name="ESET_MYSQL" displayName="业务库MYSQL" connectionString="Database=eset_erp10;Data Source=127.0.0.1;User Id=root;Password=root;pooling=false;CharSet=utf8;port=3306" providerName="MySql55Inno" showSql="true" formatSql="true" schema="ESET_ERP10" throwInitError="false" />
<!-- Oracle -->
<!-- <add name="ESET_ORCL" displayName="业务库ORCL" connectionString="Data Source=ORCL;User Id=********;Password=********;" providerName="Oracle10g" showSql="true" formatSql="true" schema="ESET_ERP10" throwInitError="false" /> -->
<!-- postgresql -->
<!-- <add name="ESET_PGSQL" displayName="业务库PGSQL" connectionString="Host=localhost;Port=5432;Username=********;Password=********;Database=ESET_ERP10" providerName="PostgreSql" showSql="true" formatSql="true" schema="public" throwInitError="false" /> -->
<!-- DB2 -->
<!-- <add name="ESET_DB2" displayName="业务库DB2" connectionString="Server=localhost;Database=ESET_ERP;UID=********;PWD=********;" providerName="DB2" showSql="true" formatSql="true" schema="FEPLAT" throwInitError="false" /> -->
<!-- DB2 400 -->
<!-- <add name="ESET_DB2400" displayName="业务库DB2400" connectionString="DataSource=172.20.1.1;DefaultCollection=AS400;UserID=********;Password=********;" providerName="DB2400" showSql="false" isShow4Dev="true" schema="AS400" /> -->
<!-- Sqlite -->
<!-- <add name="Sqlite" dbFilePath="~/db/esui.db" connectionString="Pooling=true;FailIfMissing=false" providerName="SQLite" schema="" showSql="true" formatSql="true"/> -->
</connectionStrings>
</configuration>
用账户dev 123456登陆 后返回
{"data":null,"code":31000,"msg":"系统发生异常，请联系管理员"}{"data":{"UserId":"dev","Token":"b89b498c92ad409aba8265f741130edc","UserCode":null,"UserName":"dev","NickName":null,"Photo":null,"Gender":0},"code":200,"msg":"/Platform/UIV2/Tree/ShowTree.html?treeId=46bb533e4ab646fa88a7257efd81be81"}
2020-04-29 22:04:24,421 [10] ERROR ES.LibraryV2.Web.Handler.ESCommonModule [(null)] - 未处理异常
System.Exception: DbProviderFactories配置错误:MySql - web.config/configuration/system.data/DbProviderFactories
在 ES.LibraryV2.Database.DataAccess.ESDatabase..ctor(DbProviderFactory A_0, String A_1, ESBaseDialect A_2, ESDriverBase A_3, Boolean A_4)
在 ES.LibraryV2.Database.DataAccess.ESDatabaseFactory.OpenDatabase()
在 g.c(String A_0)
在 g.b(String A_0)
在 ES.LibraryV2.Database.ESSessionFactoryManager.GetCurrentSession(String instanceName)
在 ES.LibraryV2.Database.ESSqlQuery.GetListView[T]()
在 ES.UIV2.WebControl.Grid.Handler.ESGridDataApiInitHandler.Process(HttpApplication httpApplication)
在 ES.LibraryV2.Web.Handler.ESCommonModule.a(HttpApplication A_0, IList`1 A_1)
在 ES.LibraryV2.Web.Handler.ESCommonModule.d(Object A_0, EventArgs A_1)
在 System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
