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

                // 対象データが存在すれば更新する

                strSQL = string.Format("UPDATE CONSTRUCTIONBASEINFO SET CONSTRUCTIONSTATUSFLG = {0}", iCode1);

                strSQL += " WHERE CONSTRUCTIONCODE IN";

                strSQL += " (SELECT CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO WHERE DATE(ESTIMATESSUBMITTEDDATE) != DATE_FORMAT('0001/01/01','%Y/%m/%d')";

                strSQL += string.Format(" AND DATE(ESTIMATESSUBMITTEDDATE + {0})", s_NonOrderDay);

                strSQL += string.Format(" < DATE_FORMAT('{0}','%Y/%m/%d')", DateTime.Now.ToShortDateString());

                strSQL += string.Format(" AND CONSTRUCTIONSTATUSFLG IN({0}, {1})", iCode2, iCode3);

                strSQL += string.Format(" AND ESTIMATETYPE IN ({0}, {1}))", (int)CommonDefine.BaseInfoEstimateType.Normal, (int)CommonDefine.BaseInfoEstimateType.GetBudget);

                if (!BaseDB.ExecuteNonQuery(strSQL))

                {

                    logger.ErrorFormat("工事基本情報更新エラー　非受注案件移行処理失敗：{0}：{1}", CommonMotions.GetMethodName(), strSQL);

                wrk.CreatorCosts = double.Parse(objwrk[(int)ConstructionBudgetColumn.CreatorCosts].ToString());             // 作成者給与

                wrk.AssistantCode = int.Parse(objwrk[(int)ConstructionBudgetColumn.AssistantCode].ToString());              // 副担当者コード

                wrk.AssistantName = objwrk[(int)ConstructionBudgetColumn.AssistantName].ToString();                         // 副担当者名

                wrk.InstructorCode = int.Parse(objwrk[(int)ConstructionBudgetColumn.InstructorCode].ToString());            // 工事指導員コード

                wrk.InstructorName = objwrk[(int)ConstructionBudgetColumn.InstructorName].ToString();                       // 工事指導員名

                wrk.InstructorCosts = double.Parse(objwrk[(int)ConstructionBudgetColumn.InstructorCosts].ToString());       // 工事指導員給与

                wrk.PrePayments = int.Parse(objwrk[(int)PurchaseOrderColumn.PrePayments].ToString());                       // 前金払

                wrk.PrePaymentsDays = int.Parse(objwrk[(int)PurchaseOrderColumn.PrePaymentsDays].ToString());               // 前金払日数

                wrk.PartialPayment = int.Parse(objwrk[(int)PurchaseOrderColumn.PartialPayment].ToString());                 // 部分払

                wrk.PartialPaymentMounth = int.Parse(objwrk[(int)PurchaseOrderColumn.PartialPaymentMounth].ToString());     // 部分払締切月

                wrk.PartialPaymentDay1 = int.Parse(objwrk[(int)PurchaseOrderColumn.PartialPaymentDay1].ToString());         // 部分払締切日

                wrk.PartialPaymentDay2 = int.Parse(objwrk[(int)PurchaseOrderColumn.PartialPaymentDay2].ToString());         // 部分払支払日

                wrk.CompletionPayment = int.Parse(objwrk[(int)PurchaseOrderColumn.CompletionPayment].ToString());           // 引渡し時の支払

                wrk.CompletionPaymentDays = int.Parse(objwrk[(int)PurchaseOrderColumn.CompletionPaymentDays].ToString());   // 引渡し時の支払日数

                wrk.LeadEngineerCode = int.Parse(objwrk[(int)PurchaseOrderColumn.LeadEngineerCode].ToString());             // 主任技術者コード

                wrk.LeadEngineerName = objwrk[(int)PurchaseOrderColumn.LeadEngineerName].ToString();                        // 主任技術者名