リビジョン 455
工事台帳一覧：振分経費取得SQLバグ修正
| trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedgerList/CommonLedgerData.cs | ||
|---|---|---|
| 397 | 397 |
strSQL.AppendFormat(" A.GroupCount = {0}", (int)FrmConstructionLedger.DataGroup.Payroll);
|
| 398 | 398 |
|
| 399 | 399 |
if (DepartmentCode > 0) |
| 400 |
strSQL.AppendFormat(" AND B.ComponentCode = {0}", DepartmentCode);
|
|
| 400 |
strSQL.AppendFormat(" AND B.ConstrDepCode = {0}", DepartmentCode);
|
|
| 401 | 401 |
if (PersonCode > 0) |
| 402 | 402 |
strSQL.AppendFormat(" AND B.CompanyCode = {0}", PersonCode);
|
| 403 | 403 |
} |
| ... | ... | |
| 420 | 420 |
strSQL.AppendFormat(" A.GroupCount = {0}", (int)FrmConstructionLedger.DataGroup.Payroll);
|
| 421 | 421 |
|
| 422 | 422 |
if (DepartmentCode > 0) |
| 423 |
strSQL.AppendFormat(" AND A.ComponentCode = {0}", DepartmentCode);
|
|
| 423 |
strSQL.AppendFormat(" AND B.ConstrDepCode = {0}", DepartmentCode);
|
|
| 424 | 424 |
if (PersonCode > 0) |
| 425 | 425 |
strSQL.AppendFormat(" AND A.CompanyCode = {0}", PersonCode);
|
| 426 | 426 |
} |
他の形式にエクスポート: Unified diff