/ - Diff - 工事管理システム製品化対応 - Redmine

リビジョン 212

入金確認画面　案件の並び替えの不備の修正、　請求金額合計を取得する際のロジックの修正

                     sql.AppendFormat("   I.REQUESTMONTH = {0} ", m_Select_TargetDate);
                     sql.Append(" ) ");
                     sql.Append(" ORDER BY ");
                     sql.Append("  ORDERERSCODE ");
                     sql.Append("  ORDERERSDIVISION ");
                     sql.Append("  , ORDERERSCODE ");
                     sql.Append("  , REQUESTDATE ");
                     sql.Append("  , REQCONSTRUCTIONCODE ");
                     sql.Append("  , KB; ");
-...
+                {
                     var sql = new StringBuilder();
                     sql.Append(" SELECT ");
                     sql.Append("     SUM(REQUESTAMOUNT) ");
                     sql.Append("     , SUM(TAXAMOUNT) ");
                     sql.Append("     SUM(H.REQUESTAMOUNT) ");
                     sql.Append("     , SUM(H.TAXAMOUNT) ");
                     sql.Append(" FROM ");
                     sql.Append("     REQUESTHEAD ");
                     sql.Append("     REQUESTHEAD AS H ");
                     sql.Append("     INNER JOIN INVOICEDATA AS I ");
                     sql.Append("     ON I.INVOICENO = H.INVOICENO ");
                     sql.Append(" WHERE ");
                     if (tgl == 1)
+                    {
                         sql.AppendFormat("     ORDERERSDIVISION = {0} ", orderersDiv);
                         sql.AppendFormat("     AND ORDERERSCODE = {0} ", orderersCd);
                         sql.AppendFormat("     AND REQUESTMONTH = {0} ", targetDate);
                         sql.AppendFormat("     H.ORDERERSDIVISION = {0} ", orderersDiv);
                         sql.AppendFormat("     AND H.ORDERERSCODE = {0} ", orderersCd);
                         sql.AppendFormat("     AND H.REQUESTMONTH = {0} ", targetDate);
+                    }
                     else if(tgl == 2)
+                    {
                         sql.AppendFormat("     REQUESTMONTH = {0} ", targetDate);
                         sql.AppendFormat("     H.REQUESTMONTH = {0} ", targetDate);
+                    }
                     var data = new ArrayList();
                     if (!ivD.ExecuteReader(sql.ToString(), ref data))
-...
                         SumRequestTax = CommonMotions.cnvInt(sum[1]);
+                    }
                     depositTotal = SumDepositAmountCash+SumDepositAmountBill;
                     depositTotal = SumDepositAmountCash + SumDepositAmountBill;
                     requestTotal = SumRequestBill + SumRequestTax;
                     lblDepositTotal.Text = depositTotal.ToString("#,0") + " 円";
                     lblRequestTotal.Text = requestTotal.ToString("#,0") + " 円";

他の形式にエクスポート: Unified diff

プロジェクト

全般

プロフィール

工事管理システム製品化対応

リビジョン 212