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

            {

                int iCode1 = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("非 受 注")).Key;

                int iCode2 = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("施工完了")).Key;

                // 入力完了以外を対象にする

                StringBuilder strSQL = new StringBuilder();

                strSQL.AppendFormat(" A WHERE A.ComplateFlg <> {0}", (int)CommonDefine.ComplateTitleNo.Complated);

                strSQL.Append(" AND A.CONSTRUCTIONCODE IN (SELECT A1.CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO A1");

                strSQL.AppendFormat(" AND A1.CONSTRUCTIONSTATUSFLG < {0})", iCode2);

                strSQL.Append(" AND DATE(A.CONSTRUCTIONSTART) <= DATE(NOW())");

                strSQL.Append(" ORDER BY A.CONSTRUCTIONSTART ASC");