zhihuishuiwuDataSyn/TimedUpload/app.config

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <appSettings>
    <add key="DbConncetion" value="Data Source=47.92.134.169;Initial Catalog=jingshan;uid=sa;password=wwkj@2136807" />
    <add key="WaterFactoryDbConncetion" value="Data Source=39.99.237.110;Initial Catalog=大安水厂;uid=sa;password=wwkj@2136807" />
    <add key="ChargeDB" value="Data Source=222.163.159.218,10433;Initial Catalog=ChargeManage;uid=sa;password=Daswwwkj@123" />
    <add key="zhihuishuiwuDB" value="server=39.99.237.110;user id=root;password=wwkj@2136807;database=smartwater_daan;charset=utf8" />
    <add key="changleWaterFactoryDb" value=""/>
    <add key="ChangLeWaterQualityDb" value="Data Source=47.105.90.108;Initial Catalog=舜水水质;uid=sa;password=wwkj@2136807" />
    <!-- 智慧水务系统RabbitMQ信息 start -->
    <add key="UploadUrl" value="119.188.171.115" />
    <add key="UploadPort" value="5672" />
    <add key="UploadUserName" value="wwkj" />
    <add key="UploadPassword" value="wwkj123!" />
    <!-- 智慧水务系统RabbitMQ信息 end -->
    <add key="ManufacturerCode" value="1" />
    <add key="MeterId" value="636" />
    <!-- 二供数据是否推送到分区记录 1：是；0：否-->
    <add key="SecondaryToDMA" value="1" />
    <!-- 二供设备已同步到分区计量的设备编码 -->
    <add key="SecondaryToDMACode" value="" />
    <add key="ChangLeWaterQualityId" value="0" />
    <add key="ChangLeWaterQualityHisId" value="0" />

    <add key="BmId" value="154" />
    <add key="UserMeterId" value="78843" />
    <add key="UserMeterDate" value="20220225" />
    <add key="UserMeterReadId" value="8389976" />
    <add key="UserMeterReadDate" value="2022-02-25 00:00:00" />
    
    
    <add key="WaterFactoryColumn" value="MeterCode,ReadTime,NetCumulativeFlow,InstantaneousFlow,Pressure,PH,Chlorine,Turbidity" />

    <add key="SecondaryPumpColumn" value="PumpCode,ReadTime,Frequency,Current,RunState,Power,Voltage" />


    <add key="ServiceName" value="二供和水厂同步智慧水务系统" />
    <!-- 和同智慧水务系统RabbitMQ信息 start -->
    <add key="DbMySQL" value="data source=182.92.149.41;database=smartwater;user id=root;password=wwkj@2136807;pooling=false;charset=utf8" />
    <add key="UploadUrlHeTong" value="47.104.100.143" />
    <add key="UploadPortHeTong" value="5672" />
    <add key="UploadUserNameHeTong" value="admin" />
    <add key="UploadPasswordHeTong" value="Hetong@2022$05" />
    <add key="VirtualHostHeTong" value="sw_vhost" />
    <!-- 和同智慧水务系统RabbitMQ信息 end -->
  </appSettings>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="log4net" publicKeyToken="669e0ddf0bb1aa2a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-2.0.8.0" newVersion="2.0.8.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="MySql.Data" publicKeyToken="c5687fc88969c44d" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-6.9.12.0" newVersion="6.9.12.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
<system.data>
    <DbProviderFactories>
      <remove invariant="MySql.Data.MySqlClient" />
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.12.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
  </system.data></configuration>