リビジョン 96
不具合修正
| branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsExcute.cs | ||
|---|---|---|
| 2264 | 2264 |
FrmCostomerRegistList frm = new FrmCostomerRegistList(); |
| 2265 | 2265 |
try |
| 2266 | 2266 |
{
|
| 2267 |
// 起動・編集フラグ |
|
| 2268 |
int ProcessNo = (int)ClsExcute.ProcessExecuteNo.CostomerRegist; |
|
| 2269 |
int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference; |
|
| 2270 |
if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg)) |
|
| 2271 |
{
|
|
| 2272 |
BackProcess(); |
|
| 2273 |
return; |
|
| 2274 |
} |
|
| 2267 | 2275 |
// フォーム表示 |
| 2268 | 2276 |
frm.ShowDialog(); |
| 2269 | 2277 |
} |
| ... | ... | |
| 2279 | 2287 |
} |
| 2280 | 2288 |
#endregion |
| 2281 | 2289 |
|
| 2282 |
#region 発注者登録申請一覧
|
|
| 2290 |
#region 発注者登録申請入力
|
|
| 2283 | 2291 |
/// <summary> |
| 2284 |
/// 発注者登録申請一覧
|
|
| 2292 |
/// 発注者登録申請入力
|
|
| 2285 | 2293 |
/// </summary> |
| 2286 | 2294 |
/// <param name="CurrentPara"></param> |
| 2287 | 2295 |
public static void ProcessExecuteNo_CostomerRegist(ProcessParameter CurrentPara) |
| ... | ... | |
| 2335 | 2343 |
FrmSubConstrRegistList frm = new FrmSubConstrRegistList(); |
| 2336 | 2344 |
try |
| 2337 | 2345 |
{
|
| 2346 |
// 起動・編集フラグ |
|
| 2347 |
int ProcessNo = (int)ClsExcute.ProcessExecuteNo.SubConstrRegist; |
|
| 2348 |
int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference; |
|
| 2349 |
if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg)) |
|
| 2350 |
{
|
|
| 2351 |
BackProcess(); |
|
| 2352 |
return; |
|
| 2353 |
} |
|
| 2338 | 2354 |
// フォーム表示 |
| 2339 | 2355 |
frm.ShowDialog(); |
| 2340 | 2356 |
} |
| ... | ... | |
| 2350 | 2366 |
} |
| 2351 | 2367 |
#endregion |
| 2352 | 2368 |
|
| 2353 |
#region 協力会社登録申請一覧
|
|
| 2369 |
#region 協力会社登録申請入力
|
|
| 2354 | 2370 |
/// <summary> |
| 2355 |
/// 協力会社登録申請一覧
|
|
| 2371 |
/// 協力会社登録申請入力
|
|
| 2356 | 2372 |
/// </summary> |
| 2357 | 2373 |
/// <param name="CurrentPara"></param> |
| 2358 | 2374 |
public static void ProcessExecuteNo_SubConstrRegist(ProcessParameter CurrentPara) |
| ... | ... | |
| 2362 | 2378 |
try |
| 2363 | 2379 |
{
|
| 2364 | 2380 |
// 自分のハンドルをリストへセットする |
| 2365 |
int ProcessNo = (int)ClsExcute.ProcessExecuteNo.CostomerRegist;
|
|
| 2381 |
int ProcessNo = (int)ClsExcute.ProcessExecuteNo.SubConstrRegist;
|
|
| 2366 | 2382 |
ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = ProcessNo; |
| 2367 | 2383 |
ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = (Form)frm; |
| 2368 | 2384 |
|
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOActionScheduleData.cs | ||
|---|---|---|
| 118 | 118 |
try |
| 119 | 119 |
{
|
| 120 | 120 |
|
| 121 |
bool bColFirst = true; |
|
| 122 |
strcmd = "INSERT INTO ActionScheduleData"; |
|
| 123 |
strcmd += " (";
|
|
| 124 |
foreach (var gender in Enum.GetValues(typeof(NameColumn))) |
|
| 125 |
{
|
|
| 126 |
if (!bColFirst) strcmd += ", "; |
|
| 127 |
strcmd += gender.ToString(); |
|
| 128 |
bColFirst = false; |
|
| 129 |
} |
|
| 130 |
strcmd += ") VALUES"; |
|
| 131 |
|
|
| 132 |
bool bDataFirst = true; |
|
| 121 | 133 |
foreach (ActionScheduleData work in data) |
| 122 | 134 |
{
|
| 123 |
if (!InsertAction(work, bConnect)) return false; |
|
| 135 |
if (bDataFirst) strcmd += " (";
|
|
| 136 |
else strcmd += ", (";
|
|
| 137 |
|
|
| 138 |
strcmd += string.Format(" STR_TO_DATE('{0}','%Y/%m/%d')", work.TargetDate.ToShortDateString());
|
|
| 139 |
strcmd += string.Format(", {0}", work.PersonCode.ToString());
|
|
| 140 |
strcmd += string.Format(", '{0}'", work.ActionSchedule);
|
|
| 141 |
strcmd += string.Format(", {0}", work.TargetYear.ToString());
|
|
| 142 |
strcmd += string.Format(", {0}", work.TargetMonth.ToString());
|
|
| 143 |
strcmd += string.Format(", {0}", work.TargetDay.ToString());
|
|
| 144 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 145 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 146 |
strcmd += ")"; |
|
| 147 |
|
|
| 148 |
bDataFirst = false; |
|
| 124 | 149 |
} |
| 150 |
|
|
| 151 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 152 |
|
|
| 125 | 153 |
return true; |
| 126 | 154 |
} |
| 127 | 155 |
catch (Exception ex) |
| ... | ... | |
| 145 | 173 |
try |
| 146 | 174 |
{
|
| 147 | 175 |
|
| 148 |
strcmd = "INSERT INTO ActionScheduleData"; |
|
| 176 |
bool bColFirst = true; |
|
| 177 |
strcmd = "INSERT INTO ActionScheduleData"; |
|
| 178 |
strcmd += " (";
|
|
| 179 |
foreach (var gender in Enum.GetValues(typeof(NameColumn))) |
|
| 180 |
{
|
|
| 181 |
if (!bColFirst) strcmd += ", "; |
|
| 182 |
strcmd += gender.ToString(); |
|
| 183 |
bColFirst = false; |
|
| 184 |
} |
|
| 185 |
strcmd += ") VALUES (";
|
|
| 149 | 186 |
|
| 150 |
strcmd += " VALUES (";
|
|
| 187 |
strcmd += string.Format(" STR_TO_DATE('{0}','%Y/%m/%d')", data.TargetDate.ToShortDateString());
|
|
| 188 |
strcmd += string.Format(", {0}", data.PersonCode.ToString());
|
|
| 189 |
strcmd += string.Format(", '{0}'", data.ActionSchedule);
|
|
| 190 |
strcmd += string.Format(", {0}", data.TargetYear.ToString());
|
|
| 191 |
strcmd += string.Format(", {0}", data.TargetMonth.ToString());
|
|
| 192 |
strcmd += string.Format(", {0}", data.TargetDay.ToString());
|
|
| 151 | 193 |
|
| 152 |
strcmd += string.Format(" STR_TO_DATE('{0}','%Y/%m/%d')", data.TargetDate.ToShortDateString());
|
|
| 153 |
strcmd += string.Format(", {0}", data.PersonCode.ToString());
|
|
| 154 |
strcmd += string.Format(", '{0}'", data.ActionSchedule);
|
|
| 155 |
strcmd += string.Format(", {0}", data.TargetYear.ToString());
|
|
| 156 |
strcmd += string.Format(", {0}", data.TargetMonth.ToString());
|
|
| 157 |
strcmd += string.Format(", {0}", data.TargetDay.ToString());
|
|
| 194 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.EntryDate);
|
|
| 195 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.UpdateDate);
|
|
| 196 |
strcmd += ")"; |
|
| 158 | 197 |
|
| 159 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
|
| 160 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
|
| 161 |
strcmd = strcmd + ")"; |
|
| 198 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 162 | 199 |
|
| 163 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 164 |
|
|
| 165 | 200 |
return true; |
| 166 | 201 |
} |
| 167 | 202 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceDailyData.cs | ||
|---|---|---|
| 179 | 179 |
string strcmd = ""; |
| 180 | 180 |
try |
| 181 | 181 |
{
|
| 182 |
bool bColFirst = true; |
|
| 182 | 183 |
strcmd = "INSERT INTO AttendanceDailyData"; |
| 183 |
strcmd += " (PersonCode"; // 担当者コード
|
|
| 184 |
strcmd += " ,AttendanceDate"; // 日報作成日
|
|
| 185 |
strcmd += " ,SeqNo"; // 明細行番号
|
|
| 186 |
strcmd += " ,ActionResult"; // 行動実績
|
|
| 187 |
strcmd += " ,OvertimeHours"; // 残業時間
|
|
| 188 |
strcmd += " ,WorkingComment"; // コメント
|
|
| 189 |
strcmd += " ,EntryDate"; // 登録年月日
|
|
| 190 |
strcmd += " ,UpdateDate)"; // 更新年月日
|
|
| 184 |
strcmd += " (";
|
|
| 185 |
foreach (var gender in Enum.GetValues(typeof(TableColumn)))
|
|
| 186 |
{
|
|
| 187 |
if (!bColFirst) strcmd += ", ";
|
|
| 188 |
strcmd += gender.ToString();
|
|
| 189 |
bColFirst = false;
|
|
| 190 |
}
|
|
| 191 |
strcmd += ") VALUES (";
|
|
| 191 | 192 |
|
| 192 |
strcmd += " VALUES (";
|
|
| 193 |
|
|
| 194 | 193 |
strcmd += string.Format(" {0}", work.PersonCode); // 担当者コード
|
| 195 | 194 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"
|
| 196 | 195 |
, work.AttendanceDate.ToShortDateString()); // 日報作成日 |
| ... | ... | |
| 199 | 198 |
strcmd += string.Format(", {0}", work.OvertimeHours); // 残業時間
|
| 200 | 199 |
strcmd += string.Format(",'{0}'", work.WorkingComment); // コメント
|
| 201 | 200 |
|
| 202 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 203 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 204 |
strcmd = strcmd + ")";
|
|
| 201 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 202 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 203 |
strcmd += ")";
|
|
| 205 | 204 |
|
| 206 | 205 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 207 | 206 |
|
| ... | ... | |
| 221 | 220 |
string strcmd = ""; |
| 222 | 221 |
try |
| 223 | 222 |
{
|
| 223 |
bool bColFirst = true; |
|
| 224 |
strcmd = "INSERT INTO AttendanceDailyData"; |
|
| 225 |
strcmd += " (";
|
|
| 226 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 227 |
{
|
|
| 228 |
if (!bColFirst) strcmd += ", "; |
|
| 229 |
strcmd += gender.ToString(); |
|
| 230 |
bColFirst = false; |
|
| 231 |
} |
|
| 232 |
strcmd += ") VALUES"; |
|
| 233 |
|
|
| 234 |
bool bDataFirst = true; |
|
| 224 | 235 |
foreach (AttendanceDailyData work in data) |
| 225 | 236 |
{
|
| 226 |
if (!InsertAction(work, bConnect)) return false; |
|
| 237 |
if (bDataFirst) strcmd += " (";
|
|
| 238 |
else strcmd += ", (";
|
|
| 239 |
|
|
| 240 |
strcmd += string.Format(" {0}", work.PersonCode); // 担当者コード
|
|
| 241 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"
|
|
| 242 |
, work.AttendanceDate.ToShortDateString()); // 日報作成日 |
|
| 243 |
strcmd += string.Format(", {0}", work.SeqNo); // 明細行番号
|
|
| 244 |
strcmd += string.Format(",'{0}'", work.ActionResult); // 行動実績
|
|
| 245 |
strcmd += string.Format(", {0}", work.OvertimeHours); // 残業時間
|
|
| 246 |
strcmd += string.Format(",'{0}'", work.WorkingComment); // コメント
|
|
| 247 |
|
|
| 248 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 249 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 250 |
strcmd += ")"; |
|
| 251 |
|
|
| 252 |
bDataFirst = false; |
|
| 227 | 253 |
} |
| 254 |
|
|
| 255 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 256 |
|
|
| 228 | 257 |
return true; |
| 229 | 258 |
} |
| 230 | 259 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceData.cs | ||
|---|---|---|
| 207 | 207 |
, work.OrderDate.ToShortDateString()); // 申請日 |
| 208 | 208 |
strcmd += string.Format(", {0}", work.OrderNo); // 申請受付番号
|
| 209 | 209 |
|
| 210 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 211 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 212 |
strcmd = strcmd + ")";
|
|
| 210 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 211 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 212 |
strcmd += ")";
|
|
| 213 | 213 |
|
| 214 | 214 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 215 | 215 |
|
| ... | ... | |
| 229 | 229 |
string strcmd = ""; |
| 230 | 230 |
try |
| 231 | 231 |
{
|
| 232 |
bool bColFirst = true; |
|
| 233 |
strcmd = "INSERT INTO AttendanceData"; |
|
| 234 |
strcmd += " (";
|
|
| 235 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 236 |
{
|
|
| 237 |
if (!bColFirst) strcmd += ", "; |
|
| 238 |
strcmd += gender.ToString(); |
|
| 239 |
bColFirst = false; |
|
| 240 |
} |
|
| 241 |
strcmd += ") VALUES"; |
|
| 242 |
|
|
| 243 |
bool bDataFirst = true; |
|
| 232 | 244 |
foreach (AttendanceData work in data) |
| 233 | 245 |
{
|
| 234 |
if (!InsertAction(work, bConnect)) return false; |
|
| 246 |
if (bDataFirst) strcmd += " (";
|
|
| 247 |
else strcmd += ", (";
|
|
| 248 |
|
|
| 249 |
strcmd += string.Format(" {0}", work.PersonCode); // 担当者コード
|
|
| 250 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"
|
|
| 251 |
, work.AttendanceMonth.ToShortDateString());// 日報作成日 |
|
| 252 |
strcmd += string.Format(", {0}", work.LastDays); // 当月最終日
|
|
| 253 |
strcmd += string.Format(", {0}", work.AttendDayCount); // 出勤日数
|
|
| 254 |
strcmd += string.Format(", {0}", work.TotalOverTimes); // 残業時間数
|
|
| 255 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"
|
|
| 256 |
, work.OrderDate.ToShortDateString()); // 申請日 |
|
| 257 |
strcmd += string.Format(", {0}", work.OrderNo); // 申請受付番号
|
|
| 258 |
|
|
| 259 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 260 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 261 |
strcmd += ")"; |
|
| 262 |
|
|
| 263 |
bDataFirst = false; |
|
| 235 | 264 |
} |
| 265 |
|
|
| 266 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 267 |
|
|
| 236 | 268 |
return true; |
| 237 | 269 |
} |
| 238 | 270 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBankBusinessDayMaster.cs | ||
|---|---|---|
| 124 | 124 |
|
| 125 | 125 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 126 | 126 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 127 |
strcmd = strcmd + ")";
|
|
| 127 |
strcmd += ")";
|
|
| 128 | 128 |
|
| 129 | 129 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 130 | 130 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingData.cs | ||
|---|---|---|
| 125 | 125 |
|
| 126 | 126 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 127 | 127 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 128 |
strcmd = strcmd + ")";
|
|
| 128 |
strcmd += ")";
|
|
| 129 | 129 |
|
| 130 | 130 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 131 | 131 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingDataDetail.cs | ||
|---|---|---|
| 138 | 138 |
|
| 139 | 139 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 140 | 140 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 141 |
strcmd = strcmd + ")";
|
|
| 141 |
strcmd += ")";
|
|
| 142 | 142 |
|
| 143 | 143 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 144 | 144 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingPaymentSummary.cs | ||
|---|---|---|
| 142 | 142 |
|
| 143 | 143 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 144 | 144 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 145 |
strcmd = strcmd + ")";
|
|
| 145 |
strcmd += ")";
|
|
| 146 | 146 |
|
| 147 | 147 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 148 | 148 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBaseInfo.cs | ||
|---|---|---|
| 306 | 306 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", data.BillingSendDate.ToShortDateString());
|
| 307 | 307 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", data.LedgerComplateDate.ToShortDateString());
|
| 308 | 308 |
|
| 309 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 310 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 311 |
strcmd = strcmd + ")";
|
|
| 309 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.EntryDate);
|
|
| 310 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.UpdateDate);
|
|
| 311 |
strcmd += ")";
|
|
| 312 | 312 |
|
| 313 | 313 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 314 | 314 |
|
| ... | ... | |
| 333 | 333 |
string strcmd = ""; |
| 334 | 334 |
try |
| 335 | 335 |
{
|
| 336 |
bool bColFirst = true; |
|
| 337 |
strcmd = "INSERT INTO ConstructionBaseInfo"; |
|
| 338 |
strcmd += " (";
|
|
| 339 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 340 |
{
|
|
| 341 |
if (!bColFirst) strcmd += ", "; |
|
| 342 |
strcmd += gender.ToString(); |
|
| 343 |
bColFirst = false; |
|
| 344 |
} |
|
| 345 |
strcmd += ") VALUES"; |
|
| 346 |
|
|
| 347 |
bool bDataFirst = true; |
|
| 336 | 348 |
foreach (ConstructionBaseInfo work in data) |
| 337 | 349 |
{
|
| 338 |
if (!InsertAction(work, bConnect)) return false; |
|
| 350 |
if (bDataFirst) strcmd += " (";
|
|
| 351 |
else strcmd += ", (";
|
|
| 352 |
|
|
| 353 |
strcmd += string.Format(" {0}", work.ConstructionCode);
|
|
| 354 |
strcmd += string.Format(", {0}", work.TyingFlg);
|
|
| 355 |
strcmd += string.Format(", {0}", work.JoinFlg);
|
|
| 356 |
strcmd += string.Format(", {0}", work.ConstructionYear);
|
|
| 357 |
strcmd += string.Format(", {0}", work.ConstructionPeriod);
|
|
| 358 |
|
|
| 359 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.RequestedDate.ToShortDateString());
|
|
| 360 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.EstimatesSubmitDeadline.ToShortDateString());
|
|
| 361 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.EstimatesSubmittedDate.ToShortDateString());
|
|
| 362 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.ProvisionalOrderDate.ToShortDateString());
|
|
| 363 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.OrderDate.ToShortDateString());
|
|
| 364 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.OrderStartingDate.ToShortDateString());
|
|
| 365 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.OrderCompletionDate.ToShortDateString());
|
|
| 366 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.PreparationStartDate.ToShortDateString());
|
|
| 367 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.ConstructionStartingDate.ToShortDateString());
|
|
| 368 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.ConstructionCompletionDate.ToShortDateString());
|
|
| 369 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.NonOrderDate.ToShortDateString());
|
|
| 370 |
|
|
| 371 |
strcmd += string.Format(", {0}", work.OrdersDecisionPrice);
|
|
| 372 |
strcmd += string.Format(", {0}", work.OrdersDecisionPriceInTax);
|
|
| 373 |
|
|
| 374 |
strcmd += string.Format(", {0}", work.SalesPersonCode);
|
|
| 375 |
strcmd += string.Format(", {0}", work.ConstructionPersonCode);
|
|
| 376 |
strcmd += string.Format(", {0}", work.ConstrSubPersonCode);
|
|
| 377 |
strcmd += string.Format(", {0}", work.ConstructionInstructor);
|
|
| 378 |
|
|
| 379 |
strcmd += string.Format(", {0}", work.TransferConstruction);
|
|
| 380 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.TransferConstructionDate.ToShortDateString());
|
|
| 381 |
|
|
| 382 |
strcmd += string.Format(", {0}", work.OrderersDivision);
|
|
| 383 |
strcmd += string.Format(", {0}", work.OrderersCode);
|
|
| 384 |
|
|
| 385 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.EstimatesExpirationDate.ToShortDateString());
|
|
| 386 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.ConstructionPeriodStart.ToShortDateString());
|
|
| 387 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.ConstructionPeriodEnd.ToShortDateString());
|
|
| 388 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.ConstructionPeriodStart2.ToShortDateString());
|
|
| 389 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.ConstructionPeriodEnd2.ToShortDateString());
|
|
| 390 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.StartDate.ToShortDateString());
|
|
| 391 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.EndDate.ToShortDateString());
|
|
| 392 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.PurchaseOrderMailingDate.ToShortDateString());
|
|
| 393 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.PurchaseOrderReturnDate.ToShortDateString());
|
|
| 394 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.PurchaseOrderReturnCheckDate.ToShortDateString());
|
|
| 395 |
|
|
| 396 |
strcmd += string.Format(", {0}", work.ConsumptionTaxFlg);
|
|
| 397 |
strcmd += string.Format(", {0}", work.PrimeContractorFlg);
|
|
| 398 |
strcmd += string.Format(", {0}", work.SalesCostFlg);
|
|
| 399 |
strcmd += string.Format(", {0}", work.ConstructionStatusFlg);
|
|
| 400 |
|
|
| 401 |
strcmd += string.Format(", {0}", work.ConstructionType);
|
|
| 402 |
strcmd += string.Format(", {0}", work.EstimateType);
|
|
| 403 |
|
|
| 404 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.BillingStartDate.ToShortDateString());
|
|
| 405 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.BillingDate.ToShortDateString());
|
|
| 406 |
strcmd += string.Format(", {0}", work.BillingSplitFlg);
|
|
| 407 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.BillingSendDate.ToShortDateString());
|
|
| 408 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.LedgerComplateDate.ToShortDateString());
|
|
| 409 |
|
|
| 410 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 411 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 412 |
strcmd += ")"; |
|
| 413 |
|
|
| 414 |
bDataFirst = false; |
|
| 339 | 415 |
} |
| 416 |
|
|
| 417 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 418 |
|
|
| 340 | 419 |
return true; |
| 341 | 420 |
} |
| 342 | 421 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBaseInfoDetail.cs | ||
|---|---|---|
| 161 | 161 |
string strcmd = ""; |
| 162 | 162 |
try |
| 163 | 163 |
{
|
| 164 |
|
|
| 164 |
bool bColFirst = true; |
|
| 165 | 165 |
strcmd = "INSERT INTO ConstructionBaseInfoDetail"; |
| 166 |
strcmd += " (";
|
|
| 167 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 168 |
{
|
|
| 169 |
if (!bColFirst) strcmd += ", "; |
|
| 170 |
strcmd += gender.ToString(); |
|
| 171 |
bColFirst = false; |
|
| 172 |
} |
|
| 173 |
strcmd += ") VALUES (";
|
|
| 166 | 174 |
|
| 167 |
strcmd += " VALUES (";
|
|
| 168 |
|
|
| 169 | 175 |
strcmd += string.Format(" {0}", data.ConstructionCode);
|
| 170 | 176 |
strcmd += string.Format(", {0}", data.DetailNo);
|
| 171 | 177 |
strcmd += string.Format(",'{0}'", data.DetailString);
|
| 172 | 178 |
|
| 173 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 174 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 175 |
strcmd = strcmd + ")";
|
|
| 179 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.EntryDate);
|
|
| 180 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.UpdateDate);
|
|
| 181 |
strcmd += ")";
|
|
| 176 | 182 |
|
| 177 | 183 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 178 | 184 |
|
| ... | ... | |
| 194 | 200 |
string strcmd = ""; |
| 195 | 201 |
try |
| 196 | 202 |
{
|
| 203 |
bool bColFirst = true; |
|
| 204 |
strcmd = "INSERT INTO ConstructionBaseInfoDetail"; |
|
| 205 |
strcmd += " (";
|
|
| 206 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 207 |
{
|
|
| 208 |
if (!bColFirst) strcmd += ", "; |
|
| 209 |
strcmd += gender.ToString(); |
|
| 210 |
bColFirst = false; |
|
| 211 |
} |
|
| 212 |
strcmd += ") VALUES"; |
|
| 197 | 213 |
|
| 214 |
bool bDataFirst = true; |
|
| 198 | 215 |
foreach (ConstructionBaseInfoDetail work in data) |
| 199 | 216 |
{
|
| 200 |
if (!InsertAction(work, bConnect)) return false; |
|
| 217 |
if (bDataFirst) strcmd += " (";
|
|
| 218 |
else strcmd += ", (";
|
|
| 219 |
|
|
| 220 |
strcmd += string.Format(" {0}", work.ConstructionCode);
|
|
| 221 |
strcmd += string.Format(", {0}", work.DetailNo);
|
|
| 222 |
strcmd += string.Format(",'{0}'", work.DetailString);
|
|
| 223 |
|
|
| 224 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 225 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 226 |
strcmd += ")"; |
|
| 227 |
|
|
| 228 |
bDataFirst = false; |
|
| 201 | 229 |
} |
| 230 |
|
|
| 231 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 232 |
|
|
| 202 | 233 |
return true; |
| 203 | 234 |
} |
| 204 | 235 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBudget.cs | ||
|---|---|---|
| 212 | 212 |
try |
| 213 | 213 |
{
|
| 214 | 214 |
|
| 215 |
bool bColFirst = true; |
|
| 215 | 216 |
strcmd = "INSERT INTO ConstructionBudget"; |
| 216 |
strcmd += "(ConstructionCode"; // 工事番号 |
|
| 217 |
strcmd += " ,CreatorCode"; // 作成者コード |
|
| 218 |
strcmd += " ,CreatorName"; // 作成者名 |
|
| 219 |
strcmd += " ,CreatorCosts"; // 作成者給与 |
|
| 220 |
strcmd += " ,AssistantCode"; // 副担当者コード |
|
| 221 |
strcmd += " ,AssistantName"; // 副担当者名 |
|
| 222 |
strcmd += " ,AssistantCosts"; // 副担当者給与 |
|
| 223 |
strcmd += " ,InstructorCode"; // 工事指導員コード |
|
| 224 |
strcmd += " ,InstructorName"; // 工事指導員名 |
|
| 225 |
strcmd += " ,InstructorCosts"; // 工事指導員給与 |
|
| 226 |
strcmd += " ,CreateDate"; // 作成日 |
|
| 227 |
strcmd += " ,ConstructionTimes"; // 工期（単位・月） |
|
| 228 |
strcmd += " ,ConstructionStart"; // 契約工期開始 |
|
| 229 |
strcmd += " ,ConstructionEnd"; // 契約工期完了 |
|
| 230 |
strcmd += " ,InstructorTimes"; // 指導員稼働月数 |
|
| 231 |
strcmd += " ,SalaryFlg"; // 給与振分区分 |
|
| 232 |
strcmd += " ,SalaryDays"; // 振分日数 |
|
| 233 |
strcmd += " ,A_SalaryFlg"; // 副担当者給与振分区分 |
|
| 234 |
strcmd += " ,A_SalaryDays"; // 副担当者振分日数 |
|
| 235 |
strcmd += " ,I_SalaryFlg"; // 指導員給与振分区分 |
|
| 236 |
strcmd += " ,I_SalaryDays"; // 指導員振分日数 |
|
| 237 |
strcmd += " ,EntryDate"; |
|
| 238 |
strcmd += " ,UpdateDate)"; |
|
| 217 |
strcmd += " (";
|
|
| 218 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 219 |
{
|
|
| 220 |
if (!bColFirst) strcmd += ", "; |
|
| 221 |
strcmd += gender.ToString(); |
|
| 222 |
bColFirst = false; |
|
| 223 |
} |
|
| 224 |
strcmd += ") VALUES (";
|
|
| 239 | 225 |
|
| 240 |
strcmd += " VALUES (";
|
|
| 241 |
|
|
| 242 | 226 |
strcmd += string.Format(" {0}", work.ConstructionCode); // 工事番号
|
| 243 | 227 |
|
| 244 | 228 |
strcmd += string.Format(", {0}", work.CreatorCode); // 作成者コード
|
| ... | ... | |
| 269 | 253 |
strcmd += string.Format(", {0}", work.I_SalaryFlg); // 指導員給与振分区分
|
| 270 | 254 |
strcmd += string.Format(", {0}", work.I_SalaryDays); // 指導員振分日数
|
| 271 | 255 |
|
| 272 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 273 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 274 |
strcmd = strcmd + ")";
|
|
| 256 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 257 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 258 |
strcmd += ")";
|
|
| 275 | 259 |
|
| 276 | 260 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 277 | 261 |
|
| ... | ... | |
| 296 | 280 |
string strcmd = ""; |
| 297 | 281 |
try |
| 298 | 282 |
{
|
| 283 |
bool bColFirst = true; |
|
| 284 |
strcmd = "INSERT INTO ConstructionBudget"; |
|
| 285 |
strcmd += " (";
|
|
| 286 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 287 |
{
|
|
| 288 |
if (!bColFirst) strcmd += ", "; |
|
| 289 |
strcmd += gender.ToString(); |
|
| 290 |
bColFirst = false; |
|
| 291 |
} |
|
| 292 |
strcmd += ") VALUES"; |
|
| 299 | 293 |
|
| 294 |
bool bDataFirst = true; |
|
| 300 | 295 |
foreach (ConstructionBudget work in data) |
| 301 | 296 |
{
|
| 302 |
if (!InsertAction(work, bConnect)) return false; |
|
| 297 |
if (bDataFirst) strcmd += " (";
|
|
| 298 |
else strcmd += ", (";
|
|
| 299 |
|
|
| 300 |
strcmd += string.Format(" {0}", work.ConstructionCode); // 工事番号
|
|
| 301 |
|
|
| 302 |
strcmd += string.Format(", {0}", work.CreatorCode); // 作成者コード
|
|
| 303 |
strcmd += string.Format(",'{0}'", work.CreatorName); // 作成者名
|
|
| 304 |
strcmd += string.Format(", {0}", work.CreatorCosts); // 作成者給与
|
|
| 305 |
|
|
| 306 |
strcmd += string.Format(", {0}", work.AssistantCode); // 副担当者コード
|
|
| 307 |
strcmd += string.Format(",'{0}'", work.AssistantName); // 副担当者名
|
|
| 308 |
strcmd += string.Format(", {0}", work.AssistantCosts); // 副担当者給与
|
|
| 309 |
|
|
| 310 |
strcmd += string.Format(", {0}", work.InstructorCode); // 工事指導員コード
|
|
| 311 |
strcmd += string.Format(",'{0}'", work.InstructorName); // 工事指導員名
|
|
| 312 |
strcmd += string.Format(", {0}", work.InstructorCosts); // 工事指導員給与
|
|
| 313 |
|
|
| 314 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')",
|
|
| 315 |
work.CreateDate.ToShortDateString()); // 作成日 |
|
| 316 |
strcmd += string.Format(", {0}", work.ConstructionTimes); // 工期（単位・月）
|
|
| 317 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')",
|
|
| 318 |
work.ConstructionStart.ToShortDateString()); // 契約工期開始 |
|
| 319 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')",
|
|
| 320 |
work.ConstructionEnd.ToShortDateString()); // 契約工期完了 |
|
| 321 |
|
|
| 322 |
strcmd += string.Format(", {0}", work.InstructorTimes); // 指導員稼働月数
|
|
| 323 |
strcmd += string.Format(", {0}", work.SalaryFlg); // 給与振分区分
|
|
| 324 |
strcmd += string.Format(", {0}", work.SalaryDays); // 振分日数
|
|
| 325 |
strcmd += string.Format(", {0}", work.A_SalaryFlg); // 副担当者給与振分区分
|
|
| 326 |
strcmd += string.Format(", {0}", work.A_SalaryDays); // 副担当者振分日数
|
|
| 327 |
strcmd += string.Format(", {0}", work.I_SalaryFlg); // 指導員給与振分区分
|
|
| 328 |
strcmd += string.Format(", {0}", work.I_SalaryDays); // 指導員振分日数
|
|
| 329 |
|
|
| 330 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 331 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 332 |
strcmd += ")"; |
|
| 333 |
|
|
| 334 |
bDataFirst = false; |
|
| 303 | 335 |
} |
| 336 |
|
|
| 337 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 338 |
|
|
| 304 | 339 |
return true; |
| 305 | 340 |
} |
| 306 | 341 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBudgetDetail.cs | ||
|---|---|---|
| 185 | 185 |
try |
| 186 | 186 |
{
|
| 187 | 187 |
|
| 188 |
bool bColFirst = true; |
|
| 188 | 189 |
strcmd = "INSERT INTO ConstructionBudgetDetail"; |
| 190 |
strcmd += " (";
|
|
| 191 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 192 |
{
|
|
| 193 |
if (!bColFirst) strcmd += ", "; |
|
| 194 |
strcmd += gender.ToString(); |
|
| 195 |
bColFirst = false; |
|
| 196 |
} |
|
| 197 |
strcmd += ") VALUES (";
|
|
| 189 | 198 |
|
| 190 |
strcmd += " VALUES (";
|
|
| 191 |
|
|
| 192 | 199 |
strcmd += string.Format(" {0}", work.ConstructionCode); // 工事番号
|
| 193 | 200 |
|
| 194 | 201 |
strcmd += string.Format(", {0}", work.GroupCount); // グループ番号
|
| ... | ... | |
| 207 | 214 |
strcmd += string.Format(", {0}", work.AmountConfigRate); // 金額構成率
|
| 208 | 215 |
strcmd += string.Format(", {0}", work.NegotiateFlg); // 協力業者交渉フラグ
|
| 209 | 216 |
|
| 217 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 218 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 219 |
strcmd += ")"; |
|
| 210 | 220 |
|
| 211 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
|
| 212 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
|
| 213 |
strcmd = strcmd + ")"; |
|
| 214 |
|
|
| 215 | 221 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 216 | 222 |
|
| 217 | 223 |
return true; |
| ... | ... | |
| 235 | 241 |
string strcmd = ""; |
| 236 | 242 |
try |
| 237 | 243 |
{
|
| 244 |
bool bColFirst = true; |
|
| 245 |
strcmd = "INSERT INTO ConstructionBudgetDetail"; |
|
| 246 |
strcmd += " (";
|
|
| 247 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 248 |
{
|
|
| 249 |
if (!bColFirst) strcmd += ", "; |
|
| 250 |
strcmd += gender.ToString(); |
|
| 251 |
bColFirst = false; |
|
| 252 |
} |
|
| 253 |
strcmd += ") VALUES"; |
|
| 254 |
|
|
| 255 |
bool bDataFirst = true; |
|
| 238 | 256 |
foreach (ConstructionBudgetDetail work in data) |
| 239 | 257 |
{
|
| 240 |
if (!InsertAction(work, bConnect)) return false; |
|
| 258 |
if (bDataFirst) strcmd += " (";
|
|
| 259 |
else strcmd += ", (";
|
|
| 260 |
|
|
| 261 |
strcmd += string.Format(" {0}", work.ConstructionCode); // 工事番号
|
|
| 262 |
|
|
| 263 |
strcmd += string.Format(", {0}", work.GroupCount); // グループ番号
|
|
| 264 |
strcmd += string.Format(", {0}", work.LineCount); // 行番号
|
|
| 265 |
strcmd += string.Format(", {0}", work.ComponentCode); // 構成キー
|
|
| 266 |
strcmd += string.Format(", {0}", work.ItemCode); // 工種キー
|
|
| 267 |
strcmd += string.Format(",'{0}'", work.FirstString); // 項目名称
|
|
| 268 |
strcmd += string.Format(",'{0}'", work.SecondString); // 工事内容
|
|
| 269 |
strcmd += string.Format(", {0}", work.CompanyType); // 協力会社コードタイプ
|
|
| 270 |
strcmd += string.Format(", {0}", work.CompanyCode); // 協力会社コード
|
|
| 271 |
strcmd += string.Format(",'{0}'", work.CompanyName); // 協力会社名称
|
|
| 272 |
strcmd += string.Format(", {0}", work.EstimatePrice); // 見積時金額
|
|
| 273 |
strcmd += string.Format(", {0}", work.NegotiationPrice); // 交渉時金額
|
|
| 274 |
strcmd += string.Format(", {0}", work.OrderDesiredAmount); // 発注希望金額
|
|
| 275 |
strcmd += string.Format(", {0}", work.ExecutionAmount); // 実行金額
|
|
| 276 |
strcmd += string.Format(", {0}", work.AmountConfigRate); // 金額構成率
|
|
| 277 |
strcmd += string.Format(", {0}", work.NegotiateFlg); // 協力業者交渉フラグ
|
|
| 278 |
|
|
| 279 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 280 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 281 |
strcmd += ")"; |
|
| 282 |
|
|
| 283 |
bDataFirst = false; |
|
| 241 | 284 |
} |
| 285 |
|
|
| 286 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 287 |
|
|
| 242 | 288 |
return true; |
| 243 | 289 |
} |
| 244 | 290 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLedger.cs | ||
|---|---|---|
| 201 | 201 |
string strcmd = ""; |
| 202 | 202 |
try |
| 203 | 203 |
{
|
| 204 |
|
|
| 204 |
bool bColFirst = true; |
|
| 205 | 205 |
strcmd = "INSERT INTO ConstructionLedger"; |
| 206 |
strcmd += " (ConstructionCode"; // 工事番号 |
|
| 207 |
strcmd += " ,ConstructionPeriod"; // 事業期 |
|
| 208 |
strcmd += " ,CreatorCode"; // 作成者コード |
|
| 209 |
strcmd += " ,CreatorName"; // 作成者名 |
|
| 210 |
strcmd += " ,CreateDate"; // 作成日 |
|
| 211 |
strcmd += " ,ConstructionTimes"; // 工期（単位・月） |
|
| 212 |
strcmd += " ,ConstructionStart"; // 契約工期開始 |
|
| 213 |
strcmd += " ,ConstructionEnd"; // 契約工期完了 |
|
| 214 |
strcmd += " ,OrdersDecisionPrice"; // 税抜受注決定金額 |
|
| 215 |
strcmd += " ,CompanyExpenses"; // 会社経費合計 |
|
| 216 |
strcmd += " ,DepartmentExpenses"; // 部署経費合計 |
|
| 217 |
strcmd += " ,SalesExpenses"; // 営業経費合計 |
|
| 218 |
strcmd += " ,TotalPayment"; // 総支払額 |
|
| 219 |
strcmd += " ,GrossProfit"; // 粗利 |
|
| 220 |
strcmd += " ,Allowance"; // 給与 |
|
| 221 |
strcmd += " ,NetProfit"; // 純利益 |
|
| 222 |
strcmd += " ,ComplateFlg"; // 入力完了フラグ |
|
| 223 |
strcmd += " ,IntegrationFlg"; // 受注金額積算フラグ |
|
| 224 |
strcmd += " ,EntryDate"; |
|
| 225 |
strcmd += " ,UpdateDate)"; |
|
| 206 |
strcmd += " (";
|
|
| 207 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 208 |
{
|
|
| 209 |
if (!bColFirst) strcmd += ", "; |
|
| 210 |
strcmd += gender.ToString(); |
|
| 211 |
bColFirst = false; |
|
| 212 |
} |
|
| 213 |
strcmd += ") VALUES (";
|
|
| 226 | 214 |
|
| 227 |
strcmd += " VALUES (";
|
|
| 228 |
|
|
| 229 | 215 |
strcmd += string.Format(" {0}", work.ConstructionCode); // 工事番号
|
| 230 | 216 |
|
| 231 | 217 |
strcmd += string.Format(", {0}", work.ConstructionPeriod); // 事業期
|
| ... | ... | |
| 251 | 237 |
strcmd += string.Format(",{0}", work.IntegrationFlg); // 受注金額積算フラグ
|
| 252 | 238 |
|
| 253 | 239 |
|
| 254 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 255 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 256 |
strcmd = strcmd + ")";
|
|
| 240 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 241 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 242 |
strcmd += ")";
|
|
| 257 | 243 |
|
| 258 | 244 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 259 | 245 |
|
| ... | ... | |
| 278 | 264 |
string strcmd = ""; |
| 279 | 265 |
try |
| 280 | 266 |
{
|
| 267 |
bool bColFirst = true; |
|
| 268 |
strcmd = "INSERT INTO ConstructionLedger"; |
|
| 269 |
strcmd += " (";
|
|
| 270 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 271 |
{
|
|
| 272 |
if (!bColFirst) strcmd += ", "; |
|
| 273 |
strcmd += gender.ToString(); |
|
| 274 |
bColFirst = false; |
|
| 275 |
} |
|
| 276 |
strcmd += ") VALUES"; |
|
| 281 | 277 |
|
| 278 |
bool bDataFirst = true; |
|
| 282 | 279 |
foreach (ConstructionLedger work in data) |
| 283 | 280 |
{
|
| 284 |
if (!InsertAction(work, bConnect)) return false; |
|
| 281 |
if (bDataFirst) strcmd += " (";
|
|
| 282 |
else strcmd += ", (";
|
|
| 283 |
|
|
| 284 |
strcmd += string.Format(" {0}", work.ConstructionCode); // 工事番号
|
|
| 285 |
|
|
| 286 |
strcmd += string.Format(", {0}", work.ConstructionPeriod); // 事業期
|
|
| 287 |
strcmd += string.Format(", {0}", work.CreatorCode); // 作成者コード
|
|
| 288 |
strcmd += string.Format(",'{0}'", work.CreatorName); // 作成者名
|
|
| 289 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')",
|
|
| 290 |
work.CreateDate.ToShortDateString()); // 作成日 |
|
| 291 |
strcmd += string.Format(", {0}", work.ConstructionTimes); // 工期（単位・月）
|
|
| 292 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')",
|
|
| 293 |
work.ConstructionStart.ToShortDateString()); // 契約工期開始 |
|
| 294 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')",
|
|
| 295 |
work.ConstructionEnd.ToShortDateString()); // 契約工期完了 |
|
| 296 |
|
|
| 297 |
strcmd += string.Format(",{0}", work.OrdersDecisionPrice); // 税抜受注決定金額
|
|
| 298 |
strcmd += string.Format(",{0}", work.CompanyExpenses); // 会社経費合計
|
|
| 299 |
strcmd += string.Format(",{0}", work.DepartmentExpenses); // 部署経費合計
|
|
| 300 |
strcmd += string.Format(",{0}", work.SalesExpenses); // 営業経費合計
|
|
| 301 |
strcmd += string.Format(",{0}", work.TotalPayment); // 総支払額
|
|
| 302 |
strcmd += string.Format(",{0}", work.GrossProfit); // 粗利
|
|
| 303 |
strcmd += string.Format(",{0}", work.Allowance); // 給与
|
|
| 304 |
strcmd += string.Format(",{0}", work.NetProfit); // 純利益
|
|
| 305 |
strcmd += string.Format(",{0}", work.ComplateFlg); // 入力完了フラグ
|
|
| 306 |
strcmd += string.Format(",{0}", work.IntegrationFlg); // 受注金額積算フラグ
|
|
| 307 |
|
|
| 308 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 309 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 310 |
strcmd += ")"; |
|
| 311 |
|
|
| 312 |
bDataFirst = false; |
|
| 285 | 313 |
} |
| 314 |
|
|
| 315 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 316 |
|
|
| 286 | 317 |
return true; |
| 287 | 318 |
} |
| 288 | 319 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLedgerDetail.cs | ||
|---|---|---|
| 201 | 201 |
try |
| 202 | 202 |
{
|
| 203 | 203 |
|
| 204 |
bool bColFirst = true; |
|
| 204 | 205 |
strcmd = "INSERT INTO ConstructionLedgerDetail"; |
| 206 |
strcmd += " (";
|
|
| 207 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 208 |
{
|
|
| 209 |
if (!bColFirst) strcmd += ", "; |
|
| 210 |
strcmd += gender.ToString(); |
|
| 211 |
bColFirst = false; |
|
| 212 |
} |
|
| 213 |
strcmd += ") VALUES (";
|
|
| 205 | 214 |
|
| 206 |
strcmd += " (ConstructionCode"; // 工事コード |
|
| 207 |
strcmd += ", GroupCount"; // グループ番号 |
|
| 208 |
strcmd += ", LineCount"; // 行番号 |
|
| 209 |
strcmd += ", ComponentCode"; // 構成キー |
|
| 210 |
strcmd += ", ItemCode"; // 工種キー |
|
| 211 |
strcmd += ", FirstString"; // 項目名称 |
|
| 212 |
strcmd += ", SecondString"; // 工事内容 |
|
| 213 |
strcmd += ", CompanyType"; // 協力会社コードタイプ |
|
| 214 |
strcmd += ", CompanyCode"; // 協力会社コード |
|
| 215 |
strcmd += ", CompanyName"; // 協力会社名称 |
|
| 216 |
strcmd += ", EstimatePrice"; // 予算（見積）金額 |
|
| 217 |
strcmd += ", ExecutionAmount"; // 実行金額 |
|
| 218 |
strcmd += ", AmountConfigRate"; // 金額構成率 |
|
| 219 |
strcmd += ", PaymentBurden"; // 支払補填額 |
|
| 220 |
strcmd += ", FixDataFlg"; // 固定データフラグ |
|
| 221 |
strcmd += ", IndependentFlg"; // 独立データフラグ |
|
| 222 |
strcmd += ", FluctuationFlg"; // 増減データフラグ |
|
| 223 |
strcmd += ", SalaryFlg"; // 給与振分区分 |
|
| 224 |
strcmd += ", SalaryDays"; // 給与振分日数 |
|
| 225 |
strcmd += ", OperatingFlg"; // 担当中フラグ |
|
| 226 |
strcmd += ", SourceCode"; // 元工事番号 |
|
| 227 |
strcmd += ", JoinTitleFlg"; // 工事名称タイトル |
|
| 228 |
strcmd += ", SalaryOnRegist"; // 登録時月額給与 |
|
| 229 |
strcmd += ", PurchaseOrderFlg"; // 注文書発行フラグ |
|
| 230 |
|
|
| 231 |
strcmd += ", EntryDate"; |
|
| 232 |
strcmd += ", UpdateDate)"; |
|
| 233 |
|
|
| 234 |
strcmd += " VALUES (";
|
|
| 235 |
|
|
| 236 | 215 |
strcmd += string.Format(" {0}", work.ConstructionCode); // 工事番号
|
| 237 | 216 |
|
| 238 | 217 |
strcmd += string.Format(", {0}", work.GroupCount); // グループ番号
|
| ... | ... | |
| 261 | 240 |
strcmd += string.Format(", {0}", work.SalaryOnRegist); // 登録時月額給与
|
| 262 | 241 |
strcmd += string.Format(", {0}", work.PurchaseOrderFlg); // 注文書発行フラグ
|
| 263 | 242 |
|
| 264 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 265 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 266 |
strcmd = strcmd + ")";
|
|
| 243 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 244 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 245 |
strcmd += ")";
|
|
| 267 | 246 |
|
| 268 | 247 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 269 | 248 |
|
| ... | ... | |
| 288 | 267 |
string strcmd = ""; |
| 289 | 268 |
try |
| 290 | 269 |
{
|
| 270 |
bool bColFirst = true; |
|
| 271 |
strcmd = "INSERT INTO ConstructionLedgerDetail"; |
|
| 272 |
strcmd += " (";
|
|
| 273 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 274 |
{
|
|
| 275 |
if (!bColFirst) strcmd += ", "; |
|
| 276 |
strcmd += gender.ToString(); |
|
| 277 |
bColFirst = false; |
|
| 278 |
} |
|
| 279 |
strcmd += ") VALUES"; |
|
| 280 |
|
|
| 281 |
bool bDataFirst = true; |
|
| 291 | 282 |
foreach (ConstructionLedgerDetail work in data) |
| 292 | 283 |
{
|
| 293 |
if (!InsertAction(work, bConnect)) return false; |
|
| 284 |
if (bDataFirst) strcmd += " (";
|
|
| 285 |
else strcmd += ", (";
|
|
| 286 |
|
|
| 287 |
strcmd += string.Format(" {0}", work.ConstructionCode); // 工事番号
|
|
| 288 |
|
|
| 289 |
strcmd += string.Format(", {0}", work.GroupCount); // グループ番号
|
|
| 290 |
strcmd += string.Format(", {0}", work.LineCount); // 行番号
|
|
| 291 |
strcmd += string.Format(", {0}", work.ComponentCode); // 構成キー
|
|
| 292 |
strcmd += string.Format(", {0}", work.ItemCode); // 工種キー
|
|
| 293 |
strcmd += string.Format(",'{0}'", work.FirstString); // 項目名称
|
|
| 294 |
strcmd += string.Format(",'{0}'", work.SecondString); // 工事内容
|
|
| 295 |
strcmd += string.Format(", {0}", work.CompanyType); // 協力会社コードタイプ
|
|
| 296 |
strcmd += string.Format(", {0}", work.CompanyCode); // 協力会社コード
|
|
| 297 |
strcmd += string.Format(",'{0}'", work.CompanyName); // 協力会社名称
|
|
| 298 |
strcmd += string.Format(", {0}", work.EstimatePrice); // 予算（見積）金額
|
|
| 299 |
strcmd += string.Format(", {0}", work.ExecutionAmount); // 実行金額
|
|
| 300 |
strcmd += string.Format(", {0}", work.AmountConfigRate); // 金額構成率
|
|
| 301 |
strcmd += string.Format(", {0}", work.PaymentBurden); // 支払補填額
|
|
| 302 |
|
|
| 303 |
strcmd += string.Format(", {0}", work.FixDataFlg); // 固定データフラグ
|
|
| 304 |
strcmd += string.Format(", {0}", work.IndependentFlg); // 独立データフラグ
|
|
| 305 |
strcmd += string.Format(", {0}", work.FluctuationFlg); // 増減データフラグ
|
|
| 306 |
|
|
| 307 |
strcmd += string.Format(", {0}", work.SalaryFlg); // 給与振分区分
|
|
| 308 |
strcmd += string.Format(", {0}", work.SalaryDays); // 給与振分日数
|
|
| 309 |
strcmd += string.Format(", {0}", work.OperatingFlg); // 担当中フラグ
|
|
| 310 |
strcmd += string.Format(", {0}", work.SourceCode); // 元工事番号
|
|
| 311 |
strcmd += string.Format(", {0}", work.JoinTitleFlg); // 工事名称タイトル
|
|
| 312 |
strcmd += string.Format(", {0}", work.SalaryOnRegist); // 登録時月額給与
|
|
| 313 |
strcmd += string.Format(", {0}", work.PurchaseOrderFlg); // 注文書発行フラグ
|
|
| 314 |
|
|
| 315 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 316 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 317 |
strcmd += ")"; |
|
| 318 |
|
|
| 319 |
bDataFirst = false; |
|
| 294 | 320 |
} |
| 321 |
|
|
| 322 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 295 | 323 |
return true; |
| 296 | 324 |
} |
| 297 | 325 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLedgerExcute.cs | ||
|---|---|---|
| 189 | 189 |
try |
| 190 | 190 |
{
|
| 191 | 191 |
|
| 192 |
bool bColFirst = true; |
|
| 192 | 193 |
strcmd = "INSERT INTO ConstructionLedgerExcute"; |
| 193 |
strcmd += "(ConstructionCode"; // 工事コード
|
|
| 194 |
strcmd += ", GroupCount"; // グループ番号
|
|
| 195 |
strcmd += ", LineCount"; // 行番号
|
|
| 196 |
strcmd += ", ColumnCount"; // 列番号
|
|
| 197 |
strcmd += ", PaymentAmount"; // 支払金額
|
|
| 198 |
strcmd += ", TargetMonth"; // 対象年月
|
|
| 199 |
strcmd += ", EntryDate";
|
|
| 200 |
strcmd += ", UpdateDate)";
|
|
| 194 |
strcmd += " (";
|
|
| 195 |
foreach (var gender in Enum.GetValues(typeof(TableColumn)))
|
|
| 196 |
{
|
|
| 197 |
if (!bColFirst) strcmd += ", ";
|
|
| 198 |
strcmd += gender.ToString();
|
|
| 199 |
bColFirst = false;
|
|
| 200 |
}
|
|
| 201 |
strcmd += ") VALUES (";
|
|
| 201 | 202 |
|
| 202 |
strcmd += " VALUES (";
|
|
| 203 |
|
|
| 204 | 203 |
strcmd += string.Format(" {0}", work.ConstructionCode); // 工事番号
|
| 205 | 204 |
|
| 206 | 205 |
strcmd += string.Format(", {0}", work.GroupCount); // グループ番号
|
| ... | ... | |
| 210 | 209 |
strcmd += string.Format(", {0}", work.PaymentAmount); // 支払金額
|
| 211 | 210 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')",work.TargetMonth.ToShortDateString()); // 対象年月
|
| 212 | 211 |
|
| 213 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 214 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 215 |
strcmd = strcmd + ")";
|
|
| 212 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 213 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 214 |
strcmd += ")";
|
|
| 216 | 215 |
|
| 217 | 216 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 218 | 217 |
|
| ... | ... | |
| 237 | 236 |
string strcmd = ""; |
| 238 | 237 |
try |
| 239 | 238 |
{
|
| 239 |
bool bColFirst = true; |
|
| 240 |
strcmd = "INSERT INTO ConstructionLedgerExcute"; |
|
| 241 |
strcmd += " (";
|
|
| 242 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 243 |
{
|
|
| 244 |
if (!bColFirst) strcmd += ", "; |
|
| 245 |
strcmd += gender.ToString(); |
|
| 246 |
bColFirst = false; |
|
| 247 |
} |
|
| 248 |
strcmd += ") VALUES"; |
|
| 249 |
|
|
| 250 |
bool bDataFirst = true; |
|
| 240 | 251 |
foreach (ConstructionLedgerExcute work in data) |
| 241 | 252 |
{
|
| 242 |
if (!InsertAction(work, bConnect)) return false; |
|
| 253 |
if (bDataFirst) strcmd += " (";
|
|
| 254 |
else strcmd += ", (";
|
|
| 255 |
|
|
| 256 |
strcmd += string.Format(" {0}", work.ConstructionCode); // 工事番号
|
|
| 257 |
strcmd += string.Format(", {0}", work.GroupCount); // グループ番号
|
|
| 258 |
strcmd += string.Format(", {0}", work.LineCount); // 行番号
|
|
| 259 |
strcmd += string.Format(", {0}", work.ColumnCount); // 列番号
|
|
| 260 |
strcmd += string.Format(", {0}", work.PaymentAmount); // 支払金額
|
|
| 261 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.TargetMonth.ToShortDateString()); // 対象年月
|
|
| 262 |
|
|
| 263 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 264 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 265 |
strcmd += ")"; |
|
| 266 |
|
|
| 267 |
bDataFirst = false; |
|
| 243 | 268 |
} |
| 269 |
|
|
| 270 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 244 | 271 |
return true; |
| 245 | 272 |
} |
| 246 | 273 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLink.cs | ||
|---|---|---|
| 162 | 162 |
try |
| 163 | 163 |
{
|
| 164 | 164 |
|
| 165 |
bool bColFirst = true; |
|
| 165 | 166 |
strcmd = "INSERT INTO ConstructionLink"; |
| 166 |
strcmd += " (ConstructionCode,"; |
|
| 167 |
strcmd += " FluctuationCode,"; |
|
| 168 |
strcmd += " LinkType,"; |
|
| 169 |
strcmd += " EntryDate,"; |
|
| 170 |
strcmd += " UpdateDate)"; |
|
| 171 |
strcmd += " VALUES (";
|
|
| 167 |
strcmd += " (";
|
|
| 168 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 169 |
{
|
|
| 170 |
if (!bColFirst) strcmd += ", "; |
|
| 171 |
strcmd += gender.ToString(); |
|
| 172 |
bColFirst = false; |
|
| 173 |
} |
|
| 174 |
strcmd += ") VALUES (";
|
|
| 172 | 175 |
|
| 173 | 176 |
strcmd += string.Format(" {0}", data.ConstructionCode);
|
| 174 | 177 |
strcmd += string.Format(", {0}", data.FluctuationCode);
|
| 175 | 178 |
strcmd += string.Format(", {0}", data.LinkType);
|
| 176 | 179 |
|
| 177 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 178 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 179 |
strcmd = strcmd + ")";
|
|
| 180 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.EntryDate);
|
|
| 181 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.UpdateDate);
|
|
| 182 |
strcmd += ")";
|
|
| 180 | 183 |
|
| 181 | 184 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 182 | 185 |
|
| ... | ... | |
| 206 | 209 |
string strcmd = ""; |
| 207 | 210 |
try |
| 208 | 211 |
{
|
| 212 |
bool bColFirst = true; |
|
| 213 |
strcmd = "INSERT INTO ConstructionLink"; |
|
| 214 |
strcmd += " (";
|
|
| 215 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 216 |
{
|
|
| 217 |
if (!bColFirst) strcmd += ", "; |
|
| 218 |
strcmd += gender.ToString(); |
|
| 219 |
bColFirst = false; |
|
| 220 |
} |
|
| 221 |
strcmd += ") VALUES"; |
|
| 209 | 222 |
|
| 223 |
bool bDataFirst = true; |
|
| 210 | 224 |
foreach (ConstructionLink work in data) |
| 211 | 225 |
{
|
| 212 |
if (!InsertAction(work, bConnect)) return false; |
|
| 226 |
if (bDataFirst) strcmd += " (";
|
|
| 227 |
else strcmd += ", (";
|
|
| 228 |
|
|
| 229 |
strcmd += string.Format(" {0}", work.ConstructionCode);
|
|
| 230 |
strcmd += string.Format(", {0}", work.FluctuationCode);
|
|
| 231 |
strcmd += string.Format(", {0}", work.LinkType);
|
|
| 232 |
|
|
| 233 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 234 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 235 |
strcmd += ")"; |
|
| 236 |
|
|
| 237 |
bDataFirst = false; |
|
| 213 | 238 |
} |
| 214 |
return true; |
|
| 239 |
|
|
| 240 |
if (!ExecuteNonQuery(strcmd, false)) return false; return true; |
|
| 215 | 241 |
} |
| 216 | 242 |
catch (Exception ex) |
| 217 | 243 |
{
|
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionMaterialInfo.cs | ||
|---|---|---|
| 125 | 125 |
|
| 126 | 126 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 127 | 127 |
strcmd += ", DATE_FORMAT(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 128 |
strcmd = strcmd + ")";
|
|
| 128 |
strcmd += ")";
|
|
| 129 | 129 |
|
| 130 | 130 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 131 | 131 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionProgressDate.cs | ||
|---|---|---|
| 128 | 128 |
string strcmd = ""; |
| 129 | 129 |
try |
| 130 | 130 |
{
|
| 131 |
bool bColFirst = true; |
|
| 132 |
strcmd = "INSERT INTO ConstructionProgressDate"; |
|
| 133 |
strcmd += " (";
|
|
| 134 |
foreach (var gender in Enum.GetValues(typeof(ColumnName))) |
|
| 135 |
{
|
|
| 136 |
if (!bColFirst) strcmd += ", "; |
|
| 137 |
strcmd += gender.ToString(); |
|
| 138 |
bColFirst = false; |
|
| 139 |
} |
|
| 140 |
strcmd += ") VALUES"; |
|
| 141 |
|
|
| 142 |
bool bDataFirst = true; |
|
| 131 | 143 |
foreach (ConstructionProgressDate work in data) |
| 132 | 144 |
{
|
| 133 |
if (!InsertAction(work, bConnect)) return false; |
|
| 145 |
if (bDataFirst) strcmd += " (";
|
|
| 146 |
else strcmd += ", (";
|
|
| 147 |
|
|
| 148 |
strcmd += string.Format(" {0}", work.ConstructionCode.ToString());
|
|
| 149 |
strcmd += string.Format(", {0}", work.ConstructionStatusFlg.ToString());
|
|
| 150 |
strcmd += string.Format(", {0}", work.PreviousStatusFlg.ToString());
|
|
| 151 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.ChangeDate.ToString());
|
|
| 152 |
strcmd += string.Format(", {0}", work.ChangePersonCode.ToString());
|
|
| 153 |
|
|
| 154 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 155 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 156 |
strcmd += ")"; |
|
| 157 |
|
|
| 158 |
bDataFirst = false; |
|
| 134 | 159 |
} |
| 160 |
|
|
| 161 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 162 |
|
|
| 135 | 163 |
return true; |
| 136 | 164 |
} |
| 137 | 165 |
catch (Exception ex) |
| ... | ... | |
| 148 | 176 |
string strcmd = ""; |
| 149 | 177 |
try |
| 150 | 178 |
{
|
| 179 |
bool bColFirst = true; |
|
| 180 |
strcmd = "INSERT INTO ConstructionProgressDate"; |
|
| 181 |
strcmd += " (";
|
|
| 182 |
foreach (var gender in Enum.GetValues(typeof(ColumnName))) |
|
| 183 |
{
|
|
| 184 |
if (!bColFirst) strcmd += ", "; |
|
| 185 |
strcmd += gender.ToString(); |
|
| 186 |
bColFirst = false; |
|
| 187 |
} |
|
| 188 |
strcmd += ") VALUES (";
|
|
| 151 | 189 |
|
| 152 |
strcmd = "INSERT INTO ConstructionProgressDate"; |
|
| 190 |
strcmd += string.Format(" {0}", data.ConstructionCode.ToString());
|
|
| 191 |
strcmd += string.Format(", {0}", data.ConstructionStatusFlg.ToString());
|
|
| 192 |
strcmd += string.Format(", {0}", data.PreviousStatusFlg.ToString());
|
|
| 193 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.ChangeDate.ToString());
|
|
| 194 |
strcmd += string.Format(", {0}", data.ChangePersonCode.ToString());
|
|
| 153 | 195 |
|
| 154 |
strcmd += " VALUES (";
|
|
| 196 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.EntryDate);
|
|
| 197 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.UpdateDate);
|
|
| 198 |
strcmd += ")"; |
|
| 155 | 199 |
|
| 156 |
strcmd += string.Format(" {0}", data.ConstructionCode.ToString());
|
|
| 157 |
strcmd += string.Format(", {0}", data.ConstructionStatusFlg.ToString());
|
|
| 158 |
strcmd += string.Format(", {0}", data.PreviousStatusFlg.ToString());
|
|
| 159 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.ChangeDate.ToString());
|
|
| 160 |
strcmd += string.Format(", {0}", data.ChangePersonCode.ToString());
|
|
| 200 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 161 | 201 |
|
| 162 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
|
| 163 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
|
| 164 |
strcmd = strcmd + ")"; |
|
| 165 |
|
|
| 166 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 167 |
|
|
| 168 | 202 |
return true; |
| 169 | 203 |
} |
| 170 | 204 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOCostDataOfPerson.cs | ||
|---|---|---|
| 177 | 177 |
string strcmd = ""; |
| 178 | 178 |
try |
| 179 | 179 |
{
|
| 180 |
bool bColFirst = true; |
|
| 180 | 181 |
strcmd = "INSERT INTO CostDataOfPerson"; |
| 181 |
strcmd += " (PersonCode"; // 担当者コード |
|
| 182 |
strcmd += " ,ActionDate"; // 対象日付 |
|
| 183 |
strcmd += " ,DataType"; // データ区分 |
|
| 184 |
strcmd += " ,DataAddCount"; // データ追加番号 |
|
| 185 |
strcmd += " ,TargetMonth"; // 対象年月 |
|
| 186 |
strcmd += " ,ConstructionCode"; // 工事番号 |
|
| 187 |
strcmd += " ,SuppliersCode"; // 支払先コード |
|
| 188 |
strcmd += " ,SuppliersName"; // 支払先名称 |
|
| 189 |
strcmd += " ,PaymentContent"; // 支払内容 |
|
| 190 |
strcmd += " ,PaymentType"; // 支払方法フラグ |
|
| 191 |
strcmd += " ,EntryPrice"; // 金額（税抜） |
|
| 192 |
strcmd += " ,EntryPriceInTax"; // 金額（税込） |
|
| 193 |
strcmd += " ,SlipNumber"; // 伝票番号 |
|
| 194 |
strcmd += " ,ComplateFlg"; // 引込済みフラグ |
|
| 195 |
strcmd += " ,ApprovalFlg"; // 承認フラグ |
|
| 196 |
strcmd += " ,EntryDate"; |
|
| 197 |
strcmd += " ,UpdateDate)"; |
|
| 182 |
strcmd += " (";
|
|
| 183 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 184 |
{
|
|
| 185 |
if (!bColFirst) strcmd += ", "; |
|
| 186 |
strcmd += gender.ToString(); |
|
| 187 |
bColFirst = false; |
|
| 188 |
} |
|
| 189 |
strcmd += ") VALUES (";
|
|
| 198 | 190 |
|
| 199 |
strcmd += " VALUES (";
|
|
| 200 |
|
|
| 201 | 191 |
strcmd += string.Format(" {0}", work.PersonCode); // 担当者コード
|
| 202 | 192 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"
|
| 203 | 193 |
, work.ActionDate.ToShortDateString()); // 対象日付 |
| ... | ... | |
| 216 | 206 |
strcmd += string.Format(", {0}", work.ComplateFlg); // 引込済みフラグ
|
| 217 | 207 |
strcmd += string.Format(", {0}", work.ApprovalFlg); // 承認フラグ
|
| 218 | 208 |
|
| 219 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 220 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 221 |
strcmd = strcmd + ")";
|
|
| 209 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 210 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 211 |
strcmd += ")";
|
|
| 222 | 212 |
|
| 223 | 213 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 224 | 214 |
|
| ... | ... | |
| 238 | 228 |
string strcmd = ""; |
| 239 | 229 |
try |
| 240 | 230 |
{
|
| 231 |
bool bColFirst = true; |
|
| 232 |
strcmd = "INSERT INTO CostDataOfPerson"; |
|
| 233 |
strcmd += " (";
|
|
| 234 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 235 |
{
|
|
| 236 |
if (!bColFirst) strcmd += ", "; |
|
| 237 |
strcmd += gender.ToString(); |
|
| 238 |
bColFirst = false; |
|
| 239 |
} |
|
| 240 |
strcmd += ") VALUES"; |
|
| 241 | 241 |
|
| 242 |
bool bDataFirst = true; |
|
| 242 | 243 |
foreach (CostDataOfPerson work in data) |
| 243 | 244 |
{
|
| 244 |
if (!InsertAction(work, bConnect)) return false; |
|
| 245 |
if (bDataFirst) strcmd += " (";
|
|
| 246 |
else strcmd += ", (";
|
|
| 247 |
|
|
| 248 |
strcmd += string.Format(" {0}", work.PersonCode); // 担当者コード
|
|
| 249 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"
|
|
| 250 |
, work.ActionDate.ToShortDateString()); // 対象日付 |
|
| 251 |
strcmd += string.Format(", {0}", work.DataType); // データ区分
|
|
| 252 |
strcmd += string.Format(", {0}", work.DataAddCount); // データ追加番号
|
|
| 253 |
strcmd += string.Format(",'{0}'", work.TargetMonth); // 対象年月
|
|
| 254 |
strcmd += string.Format(", {0}", work.ConstructionCode); // 工事番号
|
|
| 255 |
strcmd += string.Format(", {0}", work.SuppliersCode); // 支払先コード
|
|
| 256 |
strcmd += string.Format(",'{0}'", work.SuppliersName); // 支払先名称
|
|
| 257 |
strcmd += string.Format(",'{0}'", work.PaymentContent); // 支払内容
|
|
| 258 |
strcmd += string.Format(", {0}", work.PaymentType); // 支払方法フラグ
|
|
| 259 |
strcmd += string.Format(", {0}", work.EntryPrice); // 金額（税抜）
|
|
| 260 |
strcmd += string.Format(", {0}", work.EntryPriceInTax); // 金額（税込）
|
|
| 261 |
strcmd += string.Format(",'{0}'", work.SlipNumber); // 伝票番号
|
|
| 262 |
|
|
| 263 |
strcmd += string.Format(", {0}", work.ComplateFlg); // 引込済みフラグ
|
|
| 264 |
strcmd += string.Format(", {0}", work.ApprovalFlg); // 承認フラグ
|
|
| 265 |
|
|
| 266 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 267 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 268 |
strcmd += ")"; |
|
| 269 |
|
|
| 270 |
bDataFirst = false; |
|
| 245 | 271 |
} |
| 272 |
|
|
| 273 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 246 | 274 |
return true; |
| 247 | 275 |
} |
| 248 | 276 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOCostomerRegist.cs | ||
|---|---|---|
| 210 | 210 |
string strcmd = ""; |
| 211 | 211 |
try |
| 212 | 212 |
{
|
| 213 |
|
|
| 214 | 213 |
strcmd = "INSERT INTO CostomerRegist"; |
| 215 | 214 |
strcmd += " (";
|
| 216 | 215 |
|
| ... | ... | |
| 250 | 249 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.OrderDate.ToShortDateString());
|
| 251 | 250 |
strcmd += string.Format(", {0}", work.OrderNo);
|
| 252 | 251 |
|
| 253 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 254 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 255 |
strcmd = strcmd + ")";
|
|
| 252 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 253 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 254 |
strcmd += ")";
|
|
| 256 | 255 |
|
| 257 | 256 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 258 | 257 |
|
| ... | ... | |
| 277 | 276 |
string strcmd = ""; |
| 278 | 277 |
try |
| 279 | 278 |
{
|
| 279 |
bool bColFirst = true; |
|
| 280 |
strcmd = "INSERT INTO CostomerRegist"; |
|
| 281 |
strcmd += " (";
|
|
| 282 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 283 |
{
|
|
| 284 |
if (!bColFirst) strcmd += ", "; |
|
| 285 |
strcmd += gender.ToString(); |
|
| 286 |
bColFirst = false; |
|
| 287 |
} |
|
| 288 |
strcmd += ") VALUES"; |
|
| 289 |
|
|
| 290 |
bool bDataFirst = true; |
|
| 280 | 291 |
foreach (CostomerRegist work in data) |
| 281 | 292 |
{
|
| 282 |
if (!InsertAction(work, bConnect)) return false; |
|
| 293 |
if (bDataFirst) strcmd += " (";
|
|
| 294 |
else strcmd += ", (";
|
|
| 295 |
|
|
| 296 |
strcmd += string.Format(" {0}", work.PersonCode);
|
|
| 297 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.CreateDate.ToShortDateString());
|
|
| 298 |
strcmd += string.Format(", {0}", work.SeqNo);
|
|
| 299 |
strcmd += string.Format(", {0}", work.DataMode);
|
|
| 300 |
strcmd += string.Format(", {0}", work.SourceCotegory);
|
|
| 301 |
strcmd += string.Format(", {0}", work.SourceCode);
|
|
| 302 |
strcmd += string.Format(", {0}", work.PetitionPeriod);
|
|
| 303 |
strcmd += string.Format(", {0}", work.OrderFlg);
|
|
| 304 |
strcmd += string.Format(", '{0}'", work.CorporateStatusName);
|
|
| 305 |
strcmd += string.Format(", {0}", work.CorporateStatusPoint);
|
|
| 306 |
strcmd += string.Format(", '{0}'", work.OrderersName1);
|
|
| 307 |
strcmd += string.Format(", '{0}'", work.OrderersName2);
|
|
| 308 |
strcmd += string.Format(", '{0}'", work.DepartmentName);
|
|
| 309 |
strcmd += string.Format(", '{0}'", work.ChargePersonName);
|
|
| 310 |
strcmd += string.Format(", '{0}'", work.ZipCode);
|
|
| 311 |
strcmd += string.Format(", '{0}'", work.Address1);
|
|
| 312 |
strcmd += string.Format(", '{0}'", work.Address2);
|
|
| 313 |
strcmd += string.Format(", '{0}'", work.Address3);
|
|
| 314 |
strcmd += string.Format(", '{0}'", work.PhoneNumber);
|
|
| 315 |
strcmd += string.Format(", '{0}'", work.FaxNumber);
|
|
| 316 |
strcmd += string.Format(", '{0}'", work.MailAddress);
|
|
| 317 |
strcmd += string.Format(", '{0}'", work.Note);
|
|
| 318 |
strcmd += string.Format(", {0}", work.OrderCotegory);
|
|
| 319 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.OrderDate.ToShortDateString());
|
|
| 320 |
strcmd += string.Format(", {0}", work.OrderNo);
|
|
| 321 |
|
|
| 322 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 323 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 324 |
strcmd += ")"; |
|
| 325 |
|
|
| 326 |
bDataFirst = false; |
|
| 283 | 327 |
} |
| 328 |
|
|
| 329 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 330 |
|
|
| 284 | 331 |
return true; |
| 285 | 332 |
} |
| 286 | 333 |
catch (Exception ex) |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyData.cs | ||
|---|---|---|
| 187 | 187 |
|
| 188 | 188 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 189 | 189 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')"; |
| 190 |
strcmd = strcmd + ")";
|
|
| 190 |
strcmd += ")";
|
|
| 191 | 191 |
|
| 192 | 192 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 193 | 193 |
|
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataConstruction.cs | ||
|---|---|---|
| 169 | 169 |
string strcmd = ""; |
| 170 | 170 |
try |
| 171 | 171 |
{
|
| 172 |
bool bColFirst = true; |
|
| 172 | 173 |
strcmd = "INSERT INTO DailyDataConstruction"; |
| 174 |
strcmd += " (";
|
|
| 175 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 176 |
{
|
|
| 177 |
if (!bColFirst) strcmd += ", "; |
|
| 178 |
strcmd += gender.ToString(); |
|
| 179 |
bColFirst = false; |
|
| 180 |
} |
|
| 181 |
strcmd += ") VALUES (";
|
|
| 173 | 182 |
|
| 174 |
strcmd += " VALUES (";
|
|
| 175 |
|
|
| 176 | 183 |
strcmd += string.Format(" {0}", work.PersonCode); // 担当者コード
|
| 177 | 184 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"
|
| 178 | 185 |
, work.DailyDataDate.ToShortDateString()); // 日報作成日 |
| 179 | 186 |
strcmd += string.Format(", {0}", work.ConstructionCode); // 工事番号
|
| 180 | 187 |
strcmd += string.Format(",'{0}'", work.Weather); // 天気
|
| 181 | 188 |
|
| 182 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 183 |
strcmd += ", STR_TO_DATE(DATE_FORMAT(NOW(),'%Y/%m/%d %H:%i:%s'),'%Y/%m/%d %H:%i:%s')";
|
|
| 184 |
strcmd = strcmd + ")";
|
|
| 189 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 190 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 191 |
strcmd += ")";
|
|
| 185 | 192 |
|
| 186 | 193 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
| 187 | 194 |
|
| ... | ... | |
| 201 | 208 |
string strcmd = ""; |
| 202 | 209 |
try |
| 203 | 210 |
{
|
| 211 |
bool bColFirst = true; |
|
| 212 |
strcmd = "INSERT INTO DailyDataConstruction"; |
|
| 213 |
strcmd += " (";
|
|
他の形式にエクスポート: Unified diff