リビジョン 359
クラス名変更
日付計算修正
| branches/src/DataCheckExcute/DataCheckExcute/Common/Process/ClsSystemOnceExecute.cs | ||
|---|---|---|
| 1157 | 1157 |
|
| 1158 | 1158 |
StringBuilder strSQL = new StringBuilder(); |
| 1159 | 1159 |
// 営業期更新 |
| 1160 |
strSQL.Append(" Where DATE(NOW()) = DATE (BusinessCompDate)");
|
|
| 1160 |
strSQL.Append(" Where DATE(DATE_ADD(NOW(),INTERVAL -1 DAY)) = DATE (BusinessCompDate)");
|
|
| 1161 | 1161 |
List<SystemMaster> SystemList = new List<SystemMaster>(); |
| 1162 | 1162 |
SystemDB.SelectAction(strSQL.ToString(), ref SystemList, false); |
| 1163 | 1163 |
if (SystemList.Count > 0) |
| ... | ... | |
| 1186 | 1186 |
|
| 1187 | 1187 |
// 工事年度更新 |
| 1188 | 1188 |
strSQL.Clear(); |
| 1189 |
strSQL.Append(" Where DATE(NOW()) = DATE (ConstrCompDate)");
|
|
| 1189 |
strSQL.Append(" Where DATE(DATE_ADD(NOW(),INTERVAL -1 DAY)) = DATE (ConstrCompDate)");
|
|
| 1190 | 1190 |
SystemList.Clear(); |
| 1191 | 1191 |
SystemDB.SelectAction(strSQL.ToString(), ref SystemList, false); |
| 1192 | 1192 |
if (SystemList.Count > 0) |
| branches/src/DataCheckExcute/DataCheckExcute/DataCheckExcute.csproj | ||
|---|---|---|
| 136 | 136 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DataModel\ComponentMaster.cs"> |
| 137 | 137 |
<Link>DataModel\ComponentMaster.cs</Link> |
| 138 | 138 |
</Compile> |
| 139 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DataModel\ComponentToTypeMaster.cs"> |
|
| 140 |
<Link>DataModel\ComponentToTypeMaster.cs</Link> |
|
| 141 |
</Compile> |
|
| 142 | 139 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DataModel\ConstructionBaseInfo.cs"> |
| 143 | 140 |
<Link>DataModel\ConstructionBaseInfo.cs</Link> |
| 144 | 141 |
</Compile> |
| ... | ... | |
| 313 | 310 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DataModel\PersonDepartmentMaster.cs"> |
| 314 | 311 |
<Link>DataModel\PersonDepartmentMaster.cs</Link> |
| 315 | 312 |
</Compile> |
| 313 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DataModel\PersonExpensesCost.cs"> |
|
| 314 |
<Link>DataModel\PersonExpensesCost.cs</Link> |
|
| 315 |
</Compile> |
|
| 316 | 316 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DataModel\PersonInChargeMaster.cs"> |
| 317 | 317 |
<Link>DataModel\PersonInChargeMaster.cs</Link> |
| 318 | 318 |
</Compile> |
| ... | ... | |
| 361 | 361 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DataModel\RequestHead.cs"> |
| 362 | 362 |
<Link>DataModel\RequestHead.cs</Link> |
| 363 | 363 |
</Compile> |
| 364 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DataModel\SalaryClass.cs"> |
|
| 365 |
<Link>DataModel\SalaryClass.cs</Link> |
|
| 366 |
</Compile> |
|
| 364 | 367 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DataModel\SalesGraphData.cs"> |
| 365 | 368 |
<Link>DataModel\SalesGraphData.cs</Link> |
| 366 | 369 |
</Compile> |
| ... | ... | |
| 583 | 586 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DB\IOAccess\IOMComponentLink.cs"> |
| 584 | 587 |
<Link>DB\IOAccess\IOMComponentLink.cs</Link> |
| 585 | 588 |
</Compile> |
| 586 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DB\IOAccess\IOMComponentToTypeMaster.cs"> |
|
| 587 |
<Link>DB\IOAccess\IOMComponentToTypeMaster.cs</Link> |
|
| 588 |
</Compile> |
|
| 589 | 589 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\DB\IOAccess\IOMConstructionItem.cs"> |
| 590 | 590 |
<Link>DB\IOAccess\IOMConstructionItem.cs</Link> |
| 591 | 591 |
</Compile> |
| ... | ... | |
| 774 | 774 |
<Link>Forms\CustomControls\TextBoxEX.cs</Link> |
| 775 | 775 |
<SubType>Component</SubType> |
| 776 | 776 |
</Compile> |
| 777 |
<Compile Include="..\..\ProcessManagement\ProcessManagement\Forms\DataEntry\ConstructionLedgerList\CommonLedgerData.cs"> |
|
| 778 |
<Link>Forms\DataEntry\ConstructionLedger\CommonLedgerData.cs</Link> |
|
| 779 |
</Compile> |
|
| 777 | 780 |
<Compile Include="Common\CommonVersion.cs" /> |
| 778 | 781 |
<Compile Include="Common\Process\ClsChangeLedgerData.cs" /> |
| 779 | 782 |
<Compile Include="Common\Process\ClsSystemOnceExecute.cs" /> |
他の形式にエクスポート: Unified diff