リビジョン 389
FrmRequestPrintSelAux.csの請求ヘッダより請求金額を取得する処理のSQLを修正
strSQL.Append("Select INVOICENO, SUM, Sum(TAXAMOUNT) From RequestHead");
↓
strSQL.Append("Select INVOICENO, SUM, Sum(TAXAMOUNT) From RequestHead");
| trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestPrint/FrmRequestPrintSelAux.cs | ||
|---|---|---|
| 405 | 405 |
|
| 406 | 406 |
// 請求ヘッダより請求金額を取得する |
| 407 | 407 |
strSQL.Clear(); |
| 408 |
strSQL.Append("Select INVOICENO, SUM(REQUESTAMOUNT), Sum(TAXAMOUNT) From RequestHead");
|
|
| 408 |
strSQL.Append("Select INVOICENO, SUM(REQUESTTOTALAMOUNT), Sum(TAXAMOUNT) From RequestHead");
|
|
| 409 | 409 |
strSQL.AppendFormat(" Where INVOICENO = {0}", nInvoiceNo);
|
| 410 | 410 |
strSQL.Append(" Group By INVOICENO");
|
| 411 | 411 |
ArrayList GetList = new ArrayList(); |
他の形式にエクスポート: Unified diff