リビジョン 151
SQLの日付変換誤り修正、日付（date項目はToShortDateStringで設定）
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionMaterialInfo.cs | ||
|---|---|---|
| 123 | 123 |
strcmd += string.Format(", {0}", work.RepayCount .ToString());
|
| 124 | 124 |
strcmd += string.Format(", {0}", work.CompleteFlg.ToString());
|
| 125 | 125 |
|
| 126 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 127 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 126 |
strcmd += ", NOW()";
|
|
| 127 |
strcmd += ", NOW()";
|
|
| 128 | 128 |
strcmd += ")"; |
| 129 | 129 |
|
| 130 | 130 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| ... | ... | |
| 158 | 158 |
strcmd += string.Format(",RepayCount = {0}", data.RepayCount.ToString());
|
| 159 | 159 |
strcmd += string.Format(",CompleteFlg = {0}", data.CompleteFlg.ToString());
|
| 160 | 160 |
|
| 161 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 161 |
strcmd += ", UpdateDate = NOW()";
|
|
| 162 | 162 |
strcmd += AddSQLString; |
| 163 | 163 |
|
| 164 | 164 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPaymentApprovalInfo.cs | ||
|---|---|---|
| 132 | 132 |
strcmd += string.Format(", {0}", work.ApprovalPerson.ToString());
|
| 133 | 133 |
strcmd += string.Format(", '{0}'", work.ApprovalPersonName);
|
| 134 | 134 |
strcmd += string.Format(", {0}", work.ApprovalAuthority.ToString());
|
| 135 |
strcmd += string.Format(", DATE_FORMAT(DATE_FORMAT('{0}','%Y/%m/%d'),'%Y/%m/%d')", work.ApprovalDate.ToString());
|
|
| 135 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.ApprovalDate.ToShortDateString());
|
|
| 136 | 136 |
|
| 137 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 138 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 137 |
strcmd += ", NOW()";
|
|
| 138 |
strcmd += ", NOW()";
|
|
| 139 | 139 |
strcmd += ")"; |
| 140 | 140 |
|
| 141 | 141 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| ... | ... | |
| 169 | 169 |
strcmd += string.Format(" ApprovalPerson = {0}", data.ApprovalPerson.ToString());
|
| 170 | 170 |
strcmd += string.Format(",ApprovalPersonName = '{0}'", data.ApprovalPersonName);
|
| 171 | 171 |
strcmd += string.Format(",ApprovalAuthority = {0}", data.ApprovalAuthority.ToString());
|
| 172 |
strcmd += string.Format(",ApprovalDate = DATE_FORMAT(DATE_FORMAT('{0}','%Y/%m/%d'),'%Y/%m/%d')", data.ApprovalDate.ToString());
|
|
| 172 |
strcmd += string.Format(",ApprovalDate = STR_TO_DATE('{0}','%Y/%m/%d')", data.ApprovalDate.ToShortDateString());
|
|
| 173 | 173 |
|
| 174 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 174 |
strcmd += ", UpdateDate = NOW()";
|
|
| 175 | 175 |
strcmd += AddSQLString; |
| 176 | 176 |
|
| 177 | 177 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPaymentDataDetail.cs | ||
|---|---|---|
| 151 | 151 |
strcmd += string.Format(", {0}", work.CnstrPriceExist.ToString());
|
| 152 | 152 |
} |
| 153 | 153 |
strcmd += string.Format(", {0}", work.ApprovalPersonCode.ToString());
|
| 154 |
strcmd += string.Format(", DATE_FORMAT(DATE_FORMAT('{0}','%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')", work.ApprovalDate.ToString());
|
|
| 154 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.ApprovalDate.ToShortDateString());
|
|
| 155 | 155 |
strcmd += string.Format(", {0}", work.ApprovalEndFlg.ToString());
|
| 156 | 156 |
|
| 157 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 158 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 157 |
strcmd += ", NOW()";
|
|
| 158 |
strcmd += ", NOW()";
|
|
| 159 | 159 |
strcmd += ")"; |
| 160 | 160 |
|
| 161 | 161 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| ... | ... | |
| 203 | 203 |
strcmd += string.Format(",CnstrPriceExist = {0}", data.CnstrPriceExist.ToString());
|
| 204 | 204 |
} |
| 205 | 205 |
strcmd += string.Format(",ApprovalPersonCode = {0}", data.ApprovalPersonCode.ToString());
|
| 206 |
strcmd += string.Format(",ApprovalDate = DATE_FORMAT(DATE_FORMAT('{0}','%Y/%m/%d'),'%Y/%m/%d')", data.ApprovalDate.ToString());
|
|
| 206 |
strcmd += string.Format(",ApprovalDate = STR_TO_DATE('{0}','%Y/%m/%d')", data.ApprovalDate.ToShortDateString());
|
|
| 207 | 207 |
strcmd += string.Format(",ApprovalEndFlg = {0}", data.ApprovalEndFlg.ToString());
|
| 208 | 208 |
|
| 209 |
strcmd += ", UpdateDate = DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 209 |
strcmd += ", UpdateDate = NOW()";
|
|
| 210 | 210 |
strcmd += AddSQLString; |
| 211 | 211 |
|
| 212 | 212 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
他の形式にエクスポート: Unified diff