プロジェクト

全般

プロフィール

リビジョン 210

山内 が8年以上前に追加

入金確認画面　表示データを請求日での取得に修正　データ取得用SQLの修正

差分を表示:

branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/SelectPayment/FrmSelectPayment.cs
1103 1103 
                sql.Append("   , NULL AS REQUESTNO ");
1104 1104 
                sql.Append("   , H.ORDERERSDIVISION ");
1105 1105 
                sql.Append("   , H.ORDERERSCODE ");
1106 
                sql.Append("   , NULL AS CRETATEDATE ");
1106 
                sql.Append("   , NULL AS REQUESTDATE ");
1107 1107 
                sql.Append("   , NULL AS REQCONSTRUCTIONCODE ");
1108 1108 
                sql.Append("   , NULL AS REQCONSTRUCTIONNAME ");
1109 1109 
                sql.Append("   , NULL AS REQUESTAMOUNT ");
......
1138 1138 
                sql.Append("   ON O.ORDERERSCODE = H.ORDERERSCODE ");
1139 1139 
                sql.Append("   AND O.ORDERCOTEGORY = H.ORDERERSDIVISION ");
1140 1140 
                sql.Append("  WHERE ");
1141 
                sql.Append("   H.REQUESTMONTH = 201706 ");
1141 
                sql.AppendFormat("   H.REQUESTMONTH = {0} ",m_Select_TargetDate);
1142 1142 
                sql.Append(" ) ");
1143 1143 
                sql.Append(" UNION ( ");
1144 1144 
                sql.Append("  SELECT ");
......
1147 1147 
                sql.Append("   , H.REQUESTNO ");
1148 1148 
                sql.Append("   , I.ORDERERSDIVISION ");
1149 1149 
                sql.Append("   , I.ORDERERSCODE ");
1150 
                sql.Append("   , DATE_FORMAT(I.CRETATEDATE, '%m/%d') AS CRETATEDATE ");
1150 
                sql.Append("   , DATE_FORMAT(I.REQUESTDATE, '%m/%d') AS REQUESTDATE ");
1151 1151 
                sql.Append("   , H.REQCONSTRUCTIONCODE ");
1152 1152 
                sql.Append("   , H.REQCONSTRUCTIONNAME ");
1153 1153 
                sql.Append("   , H.REQUESTAMOUNT ");
......
1192 1192 
                sql.Append("  LEFT OUTER JOIN PERSONINCHARGEMASTER PICM ");
1193 1193 
                sql.Append("   ON CBI.CONSTRUCTIONPERSONCODE = PICM.PERSONCODE ");
1194 1194 
                sql.Append("  WHERE ");
1195 
                sql.Append("   I.REQUESTMONTH = 201706 ");
1195 
                sql.AppendFormat("   I.REQUESTMONTH = {0} ", m_Select_TargetDate);
1196 1196 
                sql.Append(" ) ");
1197 1197 
                sql.Append(" ORDER BY ");
1198 1198 
                sql.Append("  ORDERERSCODE ");
1199 
                sql.Append("  , CRETATEDATE ");
1199 
                sql.Append("  , REQUESTDATE ");
1200 1200 
                sql.Append("  , REQCONSTRUCTIONCODE ");
1201 1201 
                sql.Append("  , KB; ");
1202 1202 

  		












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