Index: branches/src/ProcessManagement/ProcessManagement/Common/CommonMotions.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Common/CommonMotions.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Common/CommonMotions.cs	(revision 341)
@@ -3062,8 +3062,8 @@
 
                     strSQL.Append(" Union Select");
                     strSQL.Append(" A2.ConstrDepCode As DEPARTMENTCODE");
-                    strSQL.Append(" , B2.DetailString As DEPARTMENTSTRING");
-                    strSQL.Append(" , ifnull(C2.DisplayOrder, 10) As DISPLAYORDER");
+                    strSQL.Append(", B2.DetailString As DEPARTMENTSTRING");
+                    strSQL.Append(", ifnull(C2.DisplayOrder, 10) As DISPLAYORDER");
                     strSQL.Append(" From Constructionbaseinfo As A2");
                     strSQL.Append(" Inner Join constructionbaseinfodetail As B2");
                     strSQL.Append("       On B2.ConstructionCode = A2.ConstructionCode");
@@ -3241,8 +3241,73 @@
         }
         #endregion
 
+        #region 経費率リスト取得処理
+        /// <summary>
+        /// 経費率リストを取得する
+        /// </summary>
+        /// <returns></returns>
+        public static bool GetExpensesList(int Preiod, int DepartmentCode, ref ArrayList ExpensesList)
+        {
+            IOMDepartmentExpenses expDB = new IOMDepartmentExpenses();
+            try
+            {
+                // 部署経費率マスタ取得
+                StringBuilder strSQL = new StringBuilder();
+                if (CheckNowSeason(Preiod))
+                {   // 今期データ
+                    strSQL.Append("SELECT");
+                    strSQL.Append(" A.NAMESTRING");
+                    strSQL.Append(", IFNULL(B.EXPENSESRAITO, 0)");
+                    strSQL.Append(", A.NAMECODE");
+                    strSQL.Append(" FROM");
+                    strSQL.Append(" DIVISIONMASTER AS A");
+                    strSQL.Append(" LEFT JOIN (");
+                    strSQL.Append("SELECT");
+                    strSQL.Append(" NAMECODE");
+                    strSQL.Append(", DEPARTMENTCODE");
+                    strSQL.Append(", EXPENSESRAITO");
+                    strSQL.Append(", EXPENSESPERIOD");
+                    strSQL.Append(" FROM");
+                    strSQL.Append(" DEPARTMENTEXPENSESMASTER) AS B");
+                    strSQL.Append(" ON A.NAMECODE = B.NAMECODE");
+                    strSQL.AppendFormat(" AND B.EXPENSESPERIOD = {0}", Preiod);
+                    strSQL.AppendFormat(" AND B.DEPARTMENTCODE = {0}", DepartmentCode);
+                    strSQL.AppendFormat(" WHERE A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);
+                    strSQL.Append(" ORDER BY A.DISPLAYORDER");
+                }
+                else
+                {   // 以前のデータ
+                    strSQL.Append("SELECT");
+                    strSQL.Append(" NAMESTRING");
+                    strSQL.Append(", EXPENSESRAITO");
+                    strSQL.Append(", NAMECODE");
+                    strSQL.Append(" FROM");
+                    strSQL.Append(" DEPARTMENTEXPENSESMASTER AS B");
+                    strSQL.AppendFormat(" WHERE B.EXPENSESPERIOD = {0}", Preiod);
+                    strSQL.AppendFormat(" AND B.DEPARTMENTCODE = {0}", DepartmentCode);
+                    strSQL.Append(" ORDER BY B.DISPLAYORDER");
+                }
+
+                ExpensesList.Clear();
+                if (!expDB.ExecuteReader(strSQL.ToString(), ref ExpensesList)) return false;
+                if (ExpensesList.Count == 0) return false;
+
+                return true;
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
+                return false;
+            }
+            finally
+            {
+                expDB.close(); expDB = null;
+            }
+        }
         #endregion
 
+        #endregion
+
         #region ---------- Excel向け操作メソッド
         #region オブジェクト開放
         /// <summary>
Index: branches/src/ProcessManagement/ProcessManagement/Common/CommonVersion.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Common/CommonVersion.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Common/CommonVersion.cs	(revision 341)
@@ -14,7 +14,7 @@
         /// <summary>
         /// 本体バージョン
         /// </summary>
-        public static int s_SystemVersion = 178;
+        public static int s_SystemVersion = 180;
 
         /// <summary>
         /// コピー・環境バージョン
Index: branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsChangeBaseInfoData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsChangeBaseInfoData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsChangeBaseInfoData.cs	(revision 341)
@@ -362,7 +362,7 @@
                 strParent += " FROM CONSTRUCTIONLINK A";
                 strParent += " LEFT OUTER JOIN CONSTRUCTIONBASEINFODETAIL F ON F.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE";
                 strParent += string.Format(" AND F.DETAILNO = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
-                strParent += " , CONSTRUCTIONBASEINFO B";
+                strParent += ", CONSTRUCTIONBASEINFO B";
 
                 strParent += string.Format(" WHERE A.FLUCTUATIONCODE = {0}", SearchCode);
 
@@ -442,7 +442,7 @@
                 strSQL = "SELECT A.CONSTRUCTIONCODE, A.FLUCTUATIONCODE, D.JOINFLG, B.FLUCTUATIONCODE, C.JOINFLG FROM CONSTRUCTIONLINK A";
                 strSQL += " LEFT JOIN CONSTRUCTIONLINK B ON B.CONSTRUCTIONCODE = A.FLUCTUATIONCODE";
                 strSQL += " LEFT JOIN CONSTRUCTIONBASEINFO C ON C.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE";
-                strSQL += " , CONSTRUCTIONBASEINFO D";
+                strSQL += ", CONSTRUCTIONBASEINFO D";
                 strSQL += string.Format(" WHERE A.CONSTRUCTIONCODE = {0}", ParentCode);
                 strSQL += " AND D.CONSTRUCTIONCODE = A.FLUCTUATIONCODE";
                 strSQL += " ORDER BY D.JOINFLG ASC, C.JOINFLG ASC";
Index: branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsChangeLedgerData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsChangeLedgerData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsChangeLedgerData.cs	(revision 341)
@@ -339,9 +339,9 @@
                     strSQL.Clear();
                     strSQL.Append("UPDATE CONSTRUCTIONLEDGER SET");
                     strSQL.AppendFormat(" TOTALPAYMENT = {0}", Payment);
-                    strSQL.AppendFormat(" , GROSSPROFIT = {0}", (Billing - Payment));
-                    strSQL.AppendFormat(" , Allowance = {0}", Allowance);
-                    strSQL.AppendFormat(" , NETPROFIT = {0}", (Billing - (Payment + Allowance + PExpenses)));
+                    strSQL.AppendFormat(", GROSSPROFIT = {0}", (Billing - Payment));
+                    strSQL.AppendFormat(", Allowance = {0}", Allowance);
+                    strSQL.AppendFormat(", NETPROFIT = {0}", (Billing - (Payment + Allowance + PExpenses)));
                     strSQL.AppendFormat(" WHERE CONSTRUCTIONCODE = {0}", ConstrCode);
                     if (!LedgerExcuteDB.ExecuteNonQuery(strSQL.ToString(), false))
                     {
Index: branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsCommonCosts.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsCommonCosts.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsCommonCosts.cs	(revision 341)
@@ -49,9 +49,9 @@
         #region 積み上げ共通仮設費
         /// <summary>
         /// 積み上げ共通仮設費[工種キー]
-        /// 10	積み上げ共通仮設費　※公共工事
+        /// 11	積み上げ共通仮設費　※公共工事
         /// </summary>
-        public static int s_PileUpCommonTempory = 10;
+        public static int s_PileUpCommonTempory = 11;
         #endregion
 
         #region 共通仮設算定率
Index: branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsSystemOnceExecute.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsSystemOnceExecute.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsSystemOnceExecute.cs	(revision 341)
@@ -311,7 +311,7 @@
                 string strSQL = "SELECT A.DETAILSTRING, C.PERSONCODE CCODE, C.PERSONNAME CNAME";
                 strSQL += " FROM ConstructionBaseInfo P";
                 strSQL += string.Format(" LEFT JOIN PERSONINCHARGEMASTER C ON C.PERSONCODE = {0}", wrkRec.PersonCode);
-                strSQL += " , CONSTRUCTIONBASEINFODETAIL A";
+                strSQL += ", CONSTRUCTIONBASEINFODETAIL A";
                 strSQL += string.Format(" WHERE P.CONSTRUCTIONCODE = {0}", wrkRec.ConstructionCode);
                 strSQL += string.Format(" AND A.CONSTRUCTIONCODE = P.CONSTRUCTIONCODE AND A.DETAILNO = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
                 ArrayList arList = new ArrayList();
@@ -502,7 +502,7 @@
                 strSQL.Append(", t1.PERSONCODE");
                 strSQL.Append(" ORDER BY");
                 strSQL.Append(" t1.CONSTRUCTIONCODE");
-                strSQL.Append(" , t1.REPAYPLANDATE");
+                strSQL.Append(", t1.REPAYPLANDATE");
             }
             catch (Exception ex)
             {
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOActionScheduleData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOActionScheduleData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOActionScheduleData.cs	(revision 341)
@@ -74,13 +74,13 @@
                 // SQL作成（DateTime型が変換できないのでCharに変換しておく）
                 strcmd.Append("SELECT");
                 strcmd.Append(" DATE_FORMAT(TargetDate, '%Y/%m/%d')");
-                strcmd.Append(" ,PersonCode");
-                strcmd.Append(" ,ActionSchedule");
-                strcmd.Append(" ,TargetYear");
-                strcmd.Append(" ,TargetMonth");
-                strcmd.Append(" ,TargetDay");
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", PersonCode");
+                strcmd.Append(", ActionSchedule");
+                strcmd.Append(", TargetYear");
+                strcmd.Append(", TargetMonth");
+                strcmd.Append(", TargetDay");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM ActionScheduleData");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceDailyData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceDailyData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceDailyData.cs	(revision 341)
@@ -106,15 +106,15 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  PersonCode");                                      // 担当者コード
-            strcmd.Append(" ,DATE_FORMAT(AttendanceDate, '%Y/%m/%d')");         // 日報作成日
-            strcmd.Append(" ,SeqNo");                                           // 明細行番号
-            strcmd.Append(" ,ActionResult");                                    // 行動実績
-            strcmd.Append(" ,ConstructionCode");                                // 工事コード
-            strcmd.Append(" ,DATE_FORMAT(StartTime, '%Y/%m/%d %H:%i:%s')");     // 開始時間
-            strcmd.Append(" ,DATE_FORMAT(CompTime, '%Y/%m/%d %H:%i:%s')");      // 終了時間
-            strcmd.Append(" ,DayTimes");                                        // 日稼働合計時間
-            strcmd.Append(" ,WorkingComment");                                  // コメント
-            strcmd.Append(" ,WorkKindFlg");                                     // 作業区分フラグ
+            strcmd.Append(", DATE_FORMAT(AttendanceDate, '%Y/%m/%d')");         // 日報作成日
+            strcmd.Append(", SeqNo");                                           // 明細行番号
+            strcmd.Append(", ActionResult");                                    // 行動実績
+            strcmd.Append(", ConstructionCode");                                // 工事コード
+            strcmd.Append(", DATE_FORMAT(StartTime, '%Y/%m/%d %H:%i:%s')");     // 開始時間
+            strcmd.Append(", DATE_FORMAT(CompTime, '%Y/%m/%d %H:%i:%s')");      // 終了時間
+            strcmd.Append(", DayTimes");                                        // 日稼働合計時間
+            strcmd.Append(", WorkingComment");                                  // コメント
+            strcmd.Append(", WorkKindFlg");                                     // 作業区分フラグ
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");     // 登録年月日
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");    // 更新年月日
             strcmd.Append(" FROM AttendanceDailyData");
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceData.cs	(revision 341)
@@ -95,12 +95,12 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  PersonCode");                                      // 担当者コード
-            strcmd.Append(" ,DATE_FORMAT(AttendanceMonth, '%Y/%m/%d')");        // 出勤管理年月
-            strcmd.Append(" ,LastDays");                                        // 当月最終日
-            strcmd.Append(" ,AttendDayCount");                                  // 出勤日数
-            strcmd.Append(" ,TotalOverTimes");                                  // 残業時間数
-            strcmd.Append(" ,DATE_FORMAT(OrderDate, '%Y/%m/%d')");              // 申請日
-            strcmd.Append(" ,OrderNo");                                         // 申請受付番号
+            strcmd.Append(", DATE_FORMAT(AttendanceMonth, '%Y/%m/%d')");        // 出勤管理年月
+            strcmd.Append(", LastDays");                                        // 当月最終日
+            strcmd.Append(", AttendDayCount");                                  // 出勤日数
+            strcmd.Append(", TotalOverTimes");                                  // 残業時間数
+            strcmd.Append(", DATE_FORMAT(OrderDate, '%Y/%m/%d')");              // 申請日
+            strcmd.Append(", OrderNo");                                         // 申請受付番号
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");     // 更新年月日
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");    // 登録年月日
             strcmd.Append(" FROM AttendanceData");
@@ -193,7 +193,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
@@ -295,14 +295,14 @@
                 strcmd.Append(" SET");
 
                 strcmd.AppendFormat(" PersonCode = {0}", data.PersonCode);                  // 担当者コード
-                strcmd.AppendFormat(" ,AttendanceMonth = STR_TO_DATE('{0}','%Y/%m/%d')",
+                strcmd.AppendFormat(", AttendanceMonth = STR_TO_DATE('{0}','%Y/%m/%d')",
                                                     data.AttendanceMonth.ToShortDateString());  // 出勤管理年月
-                strcmd.AppendFormat(" ,LastDays =  {0} ", data.LastDays);                   // 当月最終日
-                strcmd.AppendFormat(" ,AttendDayCount =  {0} ", data.AttendDayCount);       // 出勤日数
-                strcmd.AppendFormat(" ,TotalOverTimes =  {0} ", data.TotalOverTimes);       // 残業時間数
-                strcmd.AppendFormat(" ,OrderDate = STR_TO_DATE('{0}','%Y/%m/%d')",
+                strcmd.AppendFormat(", LastDays =  {0} ", data.LastDays);                   // 当月最終日
+                strcmd.AppendFormat(", AttendDayCount =  {0} ", data.AttendDayCount);       // 出勤日数
+                strcmd.AppendFormat(", TotalOverTimes =  {0} ", data.TotalOverTimes);       // 残業時間数
+                strcmd.AppendFormat(", OrderDate = STR_TO_DATE('{0}','%Y/%m/%d')",
                                                     data.OrderDate.ToShortDateString());        // 申請日
-                strcmd.AppendFormat(" ,OrderNo =  {0} ", data.OrderNo);                     // 申請受付番号
+                strcmd.AppendFormat(", OrderNo =  {0} ", data.OrderNo);                     // 申請受付番号
 
                 strcmd.Append(", UpdateDate = NOW()");
                 strcmd.Append(AddSQLString);
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingData.cs	(revision 341)
@@ -123,7 +123,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(NameColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingDataDetail.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingDataDetail.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingDataDetail.cs	(revision 341)
@@ -95,8 +95,8 @@
                 strcmd.Append(", IndsWasteTax");
                 strcmd.Append(", Note");
 
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM BillingDataDetail");
                 strcmd.Append(AddSQLString);
 
@@ -142,7 +142,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(NameColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
@@ -198,7 +198,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(NameColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingPaymentSummary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingPaymentSummary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingPaymentSummary.cs	(revision 341)
@@ -95,8 +95,8 @@
                 strcmd.Append(", CnstrPriceStotal");
                 strcmd.Append(", BillingPriceTotal");
                 
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM BillingPaymentSummary");
                 strcmd.Append(AddSQLString);
 
@@ -141,7 +141,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(NameColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstrLedgerExpenses.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstrLedgerExpenses.cs	(nonexistent)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstrLedgerExpenses.cs	(revision 341)
@@ -0,0 +1,439 @@
+﻿using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Data;
+using System.Collections;
+
+using log4net;
+using MySql.Data.MySqlClient;           // Data Provider for MySql
+
+using ProcessManagement.DB.MySql;
+using ProcessManagement.DB.Core;
+using ProcessManagement.DataModel;
+using ProcessManagement.Common;
+
+namespace ProcessManagement.DB.IOAccess
+{
+    /// <summary>
+    /// 工事詳細台帳経費データ
+    /// </summary>
+    public class IOConstrLedgerExpenses : MySqlProcess
+    {
+        #region 定義部
+        /// <summary>
+        /// log4netログを使用する
+        /// </summary>
+        private static readonly ILog logger = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
+        #endregion
+
+        #region 定数
+        /// <summary>
+        /// 工事詳細台帳経費データフィールド並び
+        /// </summary>
+        public enum TableColumn
+        {
+            ConstructionCode = 0,       // 工事番号
+
+            SeqNo,                      // 枝番
+            NameCode,                   // 経費名称コード
+            ExpensesRaito,              // 経費率
+            ExpensesValue,              // 会社経費合計
+
+            EntryDate,
+            UpdateDate,
+        }
+        #endregion
+
+        #region コンストラクタ
+        /// <summary>
+        /// コンストラクタ
+        /// </summary>
+        /// <param name="ConnectionString"></param>
+        public IOConstrLedgerExpenses()
+            : base(DBCommon.Instance.DBConnectString)
+        {
+        }
+
+        #endregion
+
+        #region 工事詳細台帳経費データ検索SQL作成
+        /// <summary>
+        /// 工事詳細台帳経費データ検索SQL作成
+        /// </summary>
+        /// <returns></returns>
+        private string CreateSelectSQL()
+        {
+            StringBuilder strcmd = new StringBuilder();
+            strcmd.Append("SELECT");
+
+            strcmd.Append(" ConstructionCode");     // 工事番号
+
+            strcmd.Append(", SeqNo");                // 枝番
+            strcmd.Append(", NameCode");            // 経費名称コード
+            strcmd.Append(", ExpensesRaito");       // 経費率
+            strcmd.Append(", ExpensesValue");       // 会社経費合計
+
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(" FROM ConstrLedgerExpenses");
+
+            return strcmd.ToString();
+        }
+        #endregion
+
+        #region 工事詳細台帳経費データ複数検索
+        /// <summary>
+        /// 工事詳細台帳経費データ複数検索
+        /// </summary>
+        /// <param name="AddSQLString"></param>
+        /// <param name="data"></param>
+        /// <param name="bConnect"></param>
+        /// <returns></returns>
+        public bool SelectAction(string AddSQLString, ref List<ConstrLedgerExpenses> data, bool bConnect = true)
+        {
+            // インターフェース
+            StringBuilder strcmd = new StringBuilder();
+            ArrayList arData = new ArrayList();
+
+            try
+            {
+                // SQL作成（DateTime型が変換できないのでCharに変換しておく）
+                strcmd.Append(CreateSelectSQL());
+                strcmd.Append(AddSQLString);
+
+                // SQL実行
+                if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
+
+                // データセット
+                foreach (object[] objwrk in arData)
+                {
+                    ConstrLedgerExpenses work = new ConstrLedgerExpenses();
+                    Reader2Struct(objwrk, ref work);
+                    data.Add(work);
+                }
+
+                return true;
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
+                return false;
+            }
+        }
+        #endregion
+
+        #region 工事詳細台帳経費データ1件検索
+        /// <summary>
+        /// 工事詳細台帳経費データ1件検索
+        /// </summary>
+        /// <param name="AddSQLString"></param>
+        /// <param name="data"></param>
+        /// <param name="bConnect"></param>
+        /// <returns></returns>
+        public bool SelectAction(string AddSQLString, ref ConstrLedgerExpenses data, bool bConnect = true)
+        {
+            // インターフェース
+            StringBuilder strcmd = new StringBuilder();
+            ArrayList arData = new ArrayList();
+
+            try
+            {
+                // SQL作成（DateTime型が変換できないのでCharに変換しておく）
+                strcmd.Append(CreateSelectSQL());
+                strcmd.Append(AddSQLString);
+
+                // SQL実行
+                if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
+                if (arData.Count == 0) return false;
+
+                // データセット
+                foreach (object[] objwrk in arData)
+                {
+                    Reader2Struct(objwrk, ref data);
+                    break;
+                }
+
+                return true;
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
+                return false;
+            }
+        }
+        #endregion
+
+        #region 工事詳細台帳経費データ1件追加
+        /// <summary>
+        /// 工事詳細台帳経費データ1件追加
+        /// </summary>
+        /// <param name="data">工事詳細台帳経費データデータ</param>
+        /// <returns>true：成功 false：失敗</returns>
+        public bool InsertAction(ConstrLedgerExpenses work, bool bConnect = true)
+        {
+            StringBuilder strcmd = new StringBuilder();
+            try
+            {
+                bool bColFirst = true;
+                strcmd.Append("INSERT INTO ConstrLedgerExpenses");
+                strcmd.Append(" (");
+                foreach (var gender in Enum.GetValues(typeof(TableColumn)))
+                {
+                    if (!bColFirst) strcmd.Append(", ");
+                    strcmd.Append(gender.ToString());
+                    bColFirst = false;
+                }
+                strcmd.Append(") VALUES (");
+
+                strcmd.AppendFormat("  {0}", work.ConstructionCode);                // 工事番号
+
+                strcmd.AppendFormat(", {0}", work.SeqNo);                           // 枝番
+                strcmd.AppendFormat(", {0}", work.NameCode);                        // 経費名称コード
+                strcmd.AppendFormat(", {0}", work.ExpensesRaito);                   // 経費率
+                strcmd.AppendFormat(", {0}", work.ExpensesValue);                   // 会社経費合計
+
+                strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
+                strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
+                strcmd.Append(")");
+
+                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
+
+                return true;
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
+                return false;
+            }
+        }
+        #endregion
+
+        #region 工事詳細台帳経費データ複数追加
+        /// <summary>
+        /// 工事詳細台帳経費データ複数追加
+        /// </summary>
+        /// <param name="data">工事詳細台帳経費データデータ</param>
+        /// <returns>true：成功 false：失敗</returns>
+        public bool InsertAction(List<ConstrLedgerExpenses> data, bool bConnect = true)
+        {
+            StringBuilder strcmd = new StringBuilder();
+            try
+            {
+                bool bColFirst = true;
+                strcmd.Append("INSERT INTO ConstrLedgerExpenses");
+                strcmd.Append(" (");
+                foreach (var gender in Enum.GetValues(typeof(TableColumn)))
+                {
+                    if (!bColFirst) strcmd.Append(", ");
+                    strcmd.Append(gender.ToString());
+                    bColFirst = false;
+                }
+                strcmd.Append(") VALUES");
+
+                bool bDataFirst = true;
+                foreach (ConstrLedgerExpenses work in data)
+                {
+                    if (bDataFirst) strcmd.Append(" (");
+                    else strcmd.Append(", (");
+
+                    strcmd.AppendFormat("  {0}", work.ConstructionCode);                // 工事番号
+
+                    strcmd.AppendFormat(", {0}", work.SeqNo);                           // 枝番
+                    strcmd.AppendFormat(", {0}", work.NameCode);                        // 経費名称コード
+                    strcmd.AppendFormat(", {0}", work.ExpensesRaito);                   // 経費率
+                    strcmd.AppendFormat(", {0}", work.ExpensesValue);                   // 会社経費合計
+
+                    strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
+                    strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
+                    strcmd.Append(")");
+
+                    bDataFirst = false;
+                }
+
+                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
+
+                return true;
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
+                return false;
+            }
+        }
+        #endregion
+
+        #region 工事詳細台帳経費データ更新
+        /// <summary>
+        /// 工事詳細台帳経費データ更新
+        /// </summary>
+        /// <param name="AddSQLString">更新条件SQL文字列</param>
+        /// <param name="data">工事詳細台帳経費データデータ</param>
+        /// <returns>true：成功 false：失敗</returns>
+        public bool UpdateAction(string AddSQLString, ConstrLedgerExpenses data, bool bConnect = true)
+        {
+            StringBuilder strcmd = new StringBuilder();
+            try
+            {
+                strcmd.Append("UPDATE ConstrLedgerExpenses");
+
+                strcmd.Append(" SET");
+
+                strcmd.AppendFormat(" ConstructionCode = {0}", data.ConstructionCode);	        // 工事番号
+
+                strcmd.AppendFormat(", SeqNo = {0}", data.SeqNo);                               // 枝番
+                strcmd.AppendFormat(", NameCode = {0}", data.NameCode);                         // 経費名称コード
+                strcmd.AppendFormat(", ExpensesRaito = {0}", data.ExpensesRaito);               // 経費率
+                strcmd.AppendFormat(", ExpensesValue = {0}", data.ExpensesValue);               // 会社経費合計
+
+                strcmd.Append(", UpdateDate = NOW()");
+                strcmd.Append(AddSQLString);
+
+                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
+
+                return true;
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
+                return false;
+            }
+        }
+        #endregion
+
+        #region 工事詳細台帳経費データ削除
+        /// <summary>
+        /// 工事詳細台帳経費データ削除
+        /// </summary>
+        /// <param name="AddSQLString">削除条件SQL文字列</param>
+        /// <param name="data">工事詳細台帳経費データデータ</param>
+        /// <returns>true：成功 false：失敗</returns>
+        public bool DeleteAction(string AddSQLString, bool bConnect = true)
+        {
+            // インターフェース
+            StringBuilder strcmd = new StringBuilder();
+            try
+            {
+                strcmd.AppendFormat("{0}{1}", "DELETE FROM ConstrLedgerExpenses", AddSQLString);
+
+                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
+
+                return true;
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
+                return false;
+            }
+        }
+        #endregion
+
+        #region 1項目の更新を行う
+        /// <summary>
+        /// 1項目の更新を行う
+        /// </summary>
+        /// <returns></returns>
+        public bool UpdateFeild(int ConstructionCode, int SeqNo, int NameCode
+                                , int FeildNo, object value, bool bConnect = true)
+        {
+            StringBuilder strcmd = new StringBuilder();
+            try
+            {
+                strcmd.Append("UPDATE ConstrLedgerExpenses");
+
+                strcmd.Append(" SET");
+                switch (FeildNo)
+                {
+                    case (int)TableColumn.ConstructionCode:          // 工事番号
+                        strcmd.AppendFormat(" ConstructionCode = {0}", ((int)value).ToString());
+                        break;
+                    case (int)TableColumn.SeqNo:                    // 枝番
+                        strcmd.AppendFormat(" SeqNo = {0}", ((int)value).ToString());
+                        break;
+                    case (int)TableColumn.NameCode:                 // 経費名称コード
+                        strcmd.AppendFormat(" NameCode = {0}", ((int)value).ToString());
+                        break;
+                    case (int)TableColumn.ExpensesRaito:            // 経費率
+                        strcmd.AppendFormat(" ExpensesRaito = {0}", ((double)value).ToString());
+                        break;
+                    case (int)TableColumn.ExpensesValue:            // 会社経費合計
+                        strcmd.AppendFormat(" ExpensesValue = {0}", ((long)value).ToString());
+                        break;
+                    default:
+                        break;
+                }
+
+                strcmd.Append(", UpdateDate = NOW()");
+                strcmd.Append(CreatePrimarykeyString(ConstructionCode, SeqNo, NameCode));
+
+                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
+
+                return true;
+            }
+            catch (MySqlException myex)
+            {
+                logger.ErrorFormat("ＭｙＳＱＬエラー：{0}：{1}", CommonMotions.GetMethodName(2), myex.Message);
+                return false;
+            }
+        }
+        #endregion
+
+        #region MySQLDataReaderより構造体へセットする
+        /// <summary>
+        /// MySQLDataReaderより構造体へセットする
+        /// </summary>
+        /// <param name="reader">MySQLDataReader</param>
+        /// <param name="wrk">構造体</param>
+        public void Reader2Struct(object[] objwrk, ref ConstrLedgerExpenses wrk)
+        {
+            try
+            {
+                // データ取得
+
+                wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.ConstructionCode].ToString());             // 工事番号
+
+                wrk.SeqNo = int.Parse(objwrk[(int)TableColumn.SeqNo].ToString());                                   // 枝番
+                wrk.NameCode = int.Parse(objwrk[(int)TableColumn.NameCode].ToString());                             // 経費名称コード
+                wrk.ExpensesRaito = double.Parse(objwrk[(int)TableColumn.ExpensesRaito].ToString());                // 経費率
+                wrk.ExpensesValue = long.Parse(objwrk[(int)TableColumn.ExpensesValue].ToString());                  // 会社経費合計
+
+                wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
+                wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());
+            }
+            catch (MySqlException myex)
+            {
+                logger.ErrorFormat("ＭｙＳＱＬエラー：{0}：{1}", CommonMotions.GetMethodName(2), myex.Message);
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(2), ex.Message);
+            }
+        }
+        #endregion
+
+        #region 主キー検索の文字列を返す
+        /// <summary>
+        /// 主キー検索の文字列を返す
+        /// </summary>
+        /// <returns></returns>
+        public string CreatePrimarykeyString(int ConstructionCode, int SeqNo = 0, int NameCode = 0)
+        {
+            StringBuilder strWork = new StringBuilder();
+            try
+            {
+                strWork.AppendFormat(" Where ConstructionCode = {0}", ConstructionCode);
+                if (SeqNo > 0)
+                    strWork.AppendFormat(" And SeqNo = {0}", SeqNo);
+                if (NameCode > 0)
+                    strWork.AppendFormat(" And NameCode = {0}", NameCode);
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strWork.ToString());
+            }
+
+            return strWork.ToString();
+        }
+        #endregion
+    }
+}
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBaseInfo.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBaseInfo.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBaseInfo.cs	(revision 341)
@@ -53,8 +53,8 @@
             OrdersDecisionPriceInTax,
             SalesDepCode,
             SalesPersonCode,
-            SalesSubDepCode,
-            SalesSubPersonCode,
+            SalesSubDepCode,
+            SalesSubPersonCode,
             ConstrDepCode,
             ConstructionPersonCode,
             ConstrSubDepCode,
@@ -271,7 +271,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBaseInfoDetail.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBaseInfoDetail.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBaseInfoDetail.cs	(revision 341)
@@ -264,8 +264,8 @@
                 strcmd.Append(" SET");
 
                 strcmd.AppendFormat("  ConstructionCode = {0}", data.ConstructionCode);
-                strcmd.AppendFormat(" ,DetailNo = {0}", data.DetailNo);
-                strcmd.AppendFormat(" ,DetailString = '{0}'", data.DetailString);
+                strcmd.AppendFormat(", DetailNo = {0}", data.DetailNo);
+                strcmd.AppendFormat(", DetailString = '{0}'", data.DetailString);
 
                 strcmd.Append(", UpdateDate = NOW()");
                 strcmd.Append(AddSQLString);
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBudget.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBudget.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBudget.cs	(revision 341)
@@ -93,27 +93,27 @@
 
             strcmd.Append(" ConstructionCode");                             // 工事番号
 
-            strcmd.Append(" ,CreatorCode");                                 // 作成者コード
-            strcmd.Append(" ,CreatorName");    	                            // 作成者名
-            strcmd.Append(" ,CreatorCosts");	                            // 作成者給与
-            strcmd.Append(" ,AssistantCode");                               // 副担当者コード
-            strcmd.Append(" ,AssistantName");                               // 副担当者名
-            strcmd.Append(" ,AssistantCosts");                              // 副担当者給与
-            strcmd.Append(" ,InstructorCode");	                            // 工事指導員コード
-            strcmd.Append(" ,InstructorName");	                            // 工事指導員名
-            strcmd.Append(" ,InstructorCosts");                             // 工事指導員給与
-            strcmd.Append(" ,DATE_FORMAT(CreateDate, '%Y/%m/%d')");	        // 作成日
-            strcmd.Append(" ,ConstructionTimes");	                        // 工期（単位・月）
-            strcmd.Append(" ,DATE_FORMAT(ConstructionStart, '%Y/%m/%d')");  // 契約工期開始
-            strcmd.Append(" ,DATE_FORMAT(ConstructionEnd, '%Y/%m/%d')");    // 契約工期完了
-            strcmd.Append(" ,InstructorTimes");                             // 指導員稼働月数
-            strcmd.Append(" ,SalaryFlg");                                   // 給与振分区分
-            strcmd.Append(" ,SalaryDays");                                  // 振分日数
-            strcmd.Append(" ,A_SalaryFlg");                                 // 副担当者給与振分区分
-            strcmd.Append(" ,A_SalaryDays");                                // 副担当者振分日数
-            strcmd.Append(" ,I_SalaryFlg");                                 // 指導員給与振分区分
-            strcmd.Append(" ,I_SalaryDays");                                // 指導員振分日数
-            strcmd.Append(" ,OrdersDecisionPrice");                         // 税抜受注決定金額
+            strcmd.Append(", CreatorCode");                                 // 作成者コード
+            strcmd.Append(", CreatorName");    	                            // 作成者名
+            strcmd.Append(", CreatorCosts");	                            // 作成者給与
+            strcmd.Append(", AssistantCode");                               // 副担当者コード
+            strcmd.Append(", AssistantName");                               // 副担当者名
+            strcmd.Append(", AssistantCosts");                              // 副担当者給与
+            strcmd.Append(", InstructorCode");	                            // 工事指導員コード
+            strcmd.Append(", InstructorName");	                            // 工事指導員名
+            strcmd.Append(", InstructorCosts");                             // 工事指導員給与
+            strcmd.Append(", DATE_FORMAT(CreateDate, '%Y/%m/%d')");	        // 作成日
+            strcmd.Append(", ConstructionTimes");	                        // 工期（単位・月）
+            strcmd.Append(", DATE_FORMAT(ConstructionStart, '%Y/%m/%d')");  // 契約工期開始
+            strcmd.Append(", DATE_FORMAT(ConstructionEnd, '%Y/%m/%d')");    // 契約工期完了
+            strcmd.Append(", InstructorTimes");                             // 指導員稼働月数
+            strcmd.Append(", SalaryFlg");                                   // 給与振分区分
+            strcmd.Append(", SalaryDays");                                  // 振分日数
+            strcmd.Append(", A_SalaryFlg");                                 // 副担当者給与振分区分
+            strcmd.Append(", A_SalaryDays");                                // 副担当者振分日数
+            strcmd.Append(", I_SalaryFlg");                                 // 指導員給与振分区分
+            strcmd.Append(", I_SalaryDays");                                // 指導員振分日数
+            strcmd.Append(", OrdersDecisionPrice");                         // 税抜受注決定金額
 
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLedger.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLedger.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLedger.cs	(revision 341)
@@ -80,29 +80,25 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
 
-            strcmd.Append(" ConstructionCode");     // 工事番号
+            strcmd.Append(" ConstructionCode");                                 // 工事番号
+            strcmd.Append(", ConstructionPeriod");                              // 事業期
+            strcmd.Append(", CreatorCode");                                     // 作成者コード
+            strcmd.Append(", CreatorName");    	                                // 作成者名
+            strcmd.Append(", DATE_FORMAT(CreateDate, '%Y/%m/%d')");             // 作成日
+            strcmd.Append(", ConstructionTimes");                               // 工期（単位・月）
+            strcmd.Append(", DATE_FORMAT(ConstructionStart, '%Y/%m/%d')");      // 契約工期開始
+            strcmd.Append(", DATE_FORMAT(ConstructionEnd, '%Y/%m/%d')");        // 契約工期完了
+            strcmd.Append(", OrdersDecisionPrice");                             // 税抜受注決定金額
+            strcmd.Append(", CompanyExpenses");                                 // 会社経費合計
+            strcmd.Append(", DepartmentExpenses");                              // 部署経費合計
+            strcmd.Append(", SalesExpenses");                                   // 営業経費合計
+            strcmd.Append(", TotalPayment");                                    // 総支払額
+            strcmd.Append(", GrossProfit");                                     // 粗利
+            strcmd.Append(", Allowance");                                       // 給与
+            strcmd.Append(", NetProfit");                                       // 純利益
+            strcmd.Append(", ComplateFlg");                                     // 入力完了フラグ
+            strcmd.Append(", IntegrationFlg");                                  // 受注金額積算フラグ
 
-            strcmd.Append(" ,ConstructionPeriod");  // 事業期
-            strcmd.Append(" ,CreatorCode");         // 作成者コード
-            strcmd.Append(" ,CreatorName");    	    // 作成者名
-            strcmd.Append(" ,DATE_FORMAT(CreateDate, '%Y/%m/%d')");
-                                                    // 作成日
-            strcmd.Append(" ,ConstructionTimes");   // 工期（単位・月）
-            strcmd.Append(" ,DATE_FORMAT(ConstructionStart, '%Y/%m/%d')");
-                                                    // 契約工期開始
-            strcmd.Append(" ,DATE_FORMAT(ConstructionEnd, '%Y/%m/%d')");
-                                                    // 契約工期完了
-            strcmd.Append(" ,OrdersDecisionPrice");  // 税抜受注決定金額
-            strcmd.Append(" ,CompanyExpenses");      // 会社経費合計
-            strcmd.Append(" ,DepartmentExpenses");   // 部署経費合計
-            strcmd.Append(" ,SalesExpenses");        // 営業経費合計
-            strcmd.Append(" ,TotalPayment");         // 総支払額
-            strcmd.Append(" ,GrossProfit");          // 粗利
-            strcmd.Append(" ,Allowance");            // 給与
-            strcmd.Append(" ,NetProfit");            // 純利益
-            strcmd.Append(" ,ComplateFlg");          // 入力完了フラグ
-            strcmd.Append(" ,IntegrationFlg");       // 受注金額積算フラグ
-
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM ConstructionLedger");
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionProgressDate.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionProgressDate.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionProgressDate.cs	(revision 341)
@@ -281,7 +281,7 @@
         /// 1項目の更新を行う
         /// </summary>
         /// <returns></returns>
-        public bool UpdateFeild(int ConstructionCode, int FeildNo, object value, bool bConnect = true)
+        public bool UpdateFeild(int ConstructionCode, DateTime ChangeDate, int FeildNo, object value, bool bConnect = true)
         {
             StringBuilder strcmd = new StringBuilder();
             try
@@ -309,7 +309,7 @@
                 }
 
                 strcmd.Append(", UpdateDate = NOW()");
-                strcmd.Append(CreatePrimarykeyString(ConstructionCode));
+                strcmd.Append(CreatePrimarykeyString(ConstructionCode, ChangeDate));
 
                 if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
 
@@ -361,14 +361,12 @@
         /// </summary>
         /// <param name="BusinessTypeCode"></param>
         /// <returns>Where文字列</returns>
-        public string CreatePrimarykeyString(int ConstructionCode, int ConstructionStatusFlg = -1)
+        public string CreatePrimarykeyString(int ConstructionCode)
         {
             StringBuilder strWork = new StringBuilder();
             try
             {
                 strWork.AppendFormat(" Where ConstructionCode = {0}", ConstructionCode.ToString());
-                if (ConstructionStatusFlg != -1)
-                    strWork.AppendFormat(" And ConstructionStatusFlg = {0}", ConstructionStatusFlg.ToString());
 
                 return strWork.ToString();
             }
@@ -378,6 +376,22 @@
                 return string.Empty;
             }
         }
+        public string CreatePrimarykeyString(int ConstructionCode, DateTime ChangeDate)
+        {
+            StringBuilder strWork = new StringBuilder();
+            try
+            {
+                strWork.AppendFormat(" Where ConstructionCode = {0}", ConstructionCode.ToString());
+                strWork.AppendFormat(" And ChangeDate = STR_TO_DATE('{0}', '%Y/%m/%d %H:%i:%s')", ChangeDate.ToString());
+
+                return strWork.ToString();
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strWork.ToString());
+                return string.Empty;
+            }
+        }
         #endregion
     }
 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOCostDataOfPerson.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOCostDataOfPerson.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOCostDataOfPerson.cs	(revision 341)
@@ -77,22 +77,22 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
 
-            strcmd.Append("  PersonCode");                           // 担当者コード
-            strcmd.Append(" ,DATE_FORMAT(ActionDate, '%Y/%m/%d')");    // 対象日付
-            strcmd.Append(" ,DataType");                             // データ区分
-            strcmd.Append(" ,DataAddCount");                         // データ追加番号
-            strcmd.Append(" ,TargetMonth");                          // 対象年月
-            strcmd.Append(" ,ConstructionCode");                     // 工事番号
-            strcmd.Append(" ,SuppliersCode");                        // 支払先コード
-            strcmd.Append(" ,SuppliersName");                        // 支払先名称
-            strcmd.Append(" ,PaymentContent");                       // 支払内容
-            strcmd.Append(" ,PaymentType");                          // 支払方法フラグ
-            strcmd.Append(" ,EntryPrice");	                        // 金額（税抜）
-            strcmd.Append(" ,EntryPriceInTax");                      // 金額（税込）
-            strcmd.Append(" ,SlipNumber");                           // 伝票番号
+            strcmd.Append("  PersonCode");                              // 担当者コード
+            strcmd.Append(", DATE_FORMAT(ActionDate, '%Y/%m/%d')");     // 対象日付
+            strcmd.Append(", DataType");                                // データ区分
+            strcmd.Append(", DataAddCount");                            // データ追加番号
+            strcmd.Append(", TargetMonth");                             // 対象年月
+            strcmd.Append(", ConstructionCode");                        // 工事番号
+            strcmd.Append(", SuppliersCode");                           // 支払先コード
+            strcmd.Append(", SuppliersName");                           // 支払先名称
+            strcmd.Append(", PaymentContent");                          // 支払内容
+            strcmd.Append(", PaymentType");                             // 支払方法フラグ
+            strcmd.Append(", EntryPrice");	                            // 金額（税抜）
+            strcmd.Append(", EntryPriceInTax");                         // 金額（税込）
+            strcmd.Append(", SlipNumber");                              // 伝票番号
 
-            strcmd.Append(" ,ComplateFlg");                          // 引込済みフラグ
-            strcmd.Append(" ,ApprovalFlg");                          // 承認フラグ
+            strcmd.Append(", ComplateFlg");                             // 引込済みフラグ
+            strcmd.Append(", ApprovalFlg");                             // 承認フラグ
 
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOCostomerRegist.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOCostomerRegist.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOCostomerRegist.cs	(revision 341)
@@ -223,7 +223,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataConstruction.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataConstruction.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataConstruction.cs	(revision 341)
@@ -83,9 +83,9 @@
             strcmd.Append("SELECT");
 
             strcmd.Append("  PersonCode");                                       // 担当者コード
-            strcmd.Append(" ,DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");             // 日報作成日
-            strcmd.Append(" ,ConstructionCode");                                 // 工事番号
-            strcmd.Append(" ,Weather");                                          // 天気
+            strcmd.Append(", DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");             // 日報作成日
+            strcmd.Append(", ConstructionCode");                                 // 工事番号
+            strcmd.Append(", Weather");                                          // 天気
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");      // 登録年月日
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");     // 更新年月日
             strcmd.Append(" FROM DailyDataConstruction");
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataDetail.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataDetail.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataDetail.cs	(revision 341)
@@ -110,19 +110,19 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
 
-            strcmd.Append("  PersonCode");                                       // 担当者コード
-            strcmd.Append(" ,DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");             // 日報作成日
-            strcmd.Append(" ,ConstructionCode");                                 // 工事番号
-            strcmd.Append(" ,SeqNo");                                            // 明細行番号
-            strcmd.Append(" ,JobCategoryCode");                                  // 職種キー
-            strcmd.Append(" ,CompanyCode");                                      // 協力会社コード
-            strcmd.Append(" ,TodayHeadCount");                                   // 当日人員数
-            strcmd.Append(" ,TotalHeadCount");                                   // 累計人員数
-            strcmd.Append(" ,TodayWork");                                        // 当日作業内容
-            strcmd.Append(" ,NextdayWork");                                      // 翌日作業内容
-            strcmd.Append(" ,NextdayHeadCount");                                 // 翌日人員数
-            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");      // 登録年月日
-            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");     // 更新年月日
+            strcmd.Append("  PersonCode");                                      // 担当者コード
+            strcmd.Append(", DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");          // 日報作成日
+            strcmd.Append(", ConstructionCode");                                // 工事番号
+            strcmd.Append(", SeqNo");                                           // 明細行番号
+            strcmd.Append(", JobCategoryCode");                                 // 職種キー
+            strcmd.Append(", CompanyCode");                                     // 協力会社コード
+            strcmd.Append(", TodayHeadCount");                                  // 当日人員数
+            strcmd.Append(", TotalHeadCount");                                  // 累計人員数
+            strcmd.Append(", TodayWork");                                       // 当日作業内容
+            strcmd.Append(", NextdayWork");                                     // 翌日作業内容
+            strcmd.Append(", NextdayHeadCount");                                // 翌日人員数
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");     // 登録年月日
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");    // 更新年月日
             strcmd.Append(" FROM DailyDataDetail");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataField.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataField.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataField.cs	(revision 341)
@@ -90,16 +90,16 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
 
-            strcmd.Append("  PersonCode");                                       // 担当者コード
-            strcmd.Append(" ,DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");             // 日報作成日
-            strcmd.Append(" ,ConstructionCode");                                 // 工事番号
-            strcmd.Append(" ,SeqNo");                                            // 明細行番号
+            strcmd.Append("  PersonCode");                                      // 担当者コード
+            strcmd.Append(", DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");          // 日報作成日
+            strcmd.Append(", ConstructionCode");                                // 工事番号
+            strcmd.Append(", SeqNo");                                           // 明細行番号
 
-            strcmd.Append(" ,DATE_FORMAT(PatrolTime, '%Y/%m/%d %H:%i:%s')");     // 巡回時間
-            strcmd.Append(" ,ContentsText");                                     // 内容
+            strcmd.Append(", DATE_FORMAT(PatrolTime, '%Y/%m/%d %H:%i:%s')");    // 巡回時間
+            strcmd.Append(", ContentsText");                                    // 内容
 
-            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");      // 登録年月日
-            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");     // 更新年月日
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");     // 登録年月日
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");    // 更新年月日
             strcmd.Append(" FROM DailyDataField");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataMaterials.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataMaterials.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataMaterials.cs	(revision 341)
@@ -102,19 +102,19 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
 
-            strcmd.Append("  PersonCode");                                       // 担当者コード
-            strcmd.Append(" ,DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");             // 日報作成日
-            strcmd.Append(" ,ConstructionCode");                                 // 工事番号
-            strcmd.Append(" ,SeqNo");                                            // 明細行番号
+            strcmd.Append("  PersonCode");                                      // 担当者コード
+            strcmd.Append(", DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");          // 日報作成日
+            strcmd.Append(", ConstructionCode");                                // 工事番号
+            strcmd.Append(", SeqNo");                                           // 明細行番号
 
-            strcmd.Append(" ,Materials");                                        // 資材名
-            strcmd.Append(" ,Quantity");                                         // 数量
-            strcmd.Append(" ,Production");                                       // 制作会社
-            strcmd.Append(" ,Delivery");                                         // 納入業者
-            strcmd.Append(" ,QualityControl");                                   // 品質管理事項
+            strcmd.Append(", Materials");                                       // 資材名
+            strcmd.Append(", Quantity");                                        // 数量
+            strcmd.Append(", Production");                                      // 制作会社
+            strcmd.Append(", Delivery");                                        // 納入業者
+            strcmd.Append(", QualityControl");                                  // 品質管理事項
 
-            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");      // 登録年月日
-            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");     // 更新年月日
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");     // 登録年月日
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");    // 更新年月日
             strcmd.Append(" FROM DailyDataMaterials");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataSubcontractors.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataSubcontractors.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataSubcontractors.cs	(revision 341)
@@ -90,16 +90,16 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
 
-            strcmd.Append("  PersonCode");                                       // 担当者コード
-            strcmd.Append(" ,DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");             // 日報作成日
-            strcmd.Append(" ,ConstructionCode");                                 // 工事番号
-            strcmd.Append(" ,SeqNo");                                            // 明細行番号
+            strcmd.Append("  PersonCode");                                      // 担当者コード
+            strcmd.Append(", DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");          // 日報作成日
+            strcmd.Append(", ConstructionCode");                                // 工事番号
+            strcmd.Append(", SeqNo");                                           // 明細行番号
 
-            strcmd.Append(" ,Attendee");                                         // 出席者
-            strcmd.Append(" ,ContentsText");                                         // 内容
+            strcmd.Append(", Attendee");                                        // 出席者
+            strcmd.Append(", ContentsText");                                    // 内容
 
-            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");      // 登録年月日
-            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");     // 更新年月日
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");     // 登録年月日
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");    // 更新年月日
             strcmd.Append(" FROM DailyDataSubcontractors");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataVehicles.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataVehicles.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataVehicles.cs	(revision 341)
@@ -106,20 +106,20 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
 
-            strcmd.Append("  PersonCode");                                       // 担当者コード
-            strcmd.Append(" ,DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");             // 日報作成日
-            strcmd.Append(" ,ConstructionCode");                                 // 工事番号
-            strcmd.Append(" ,SeqNo");                                            // 明細行番号
+            strcmd.Append("  PersonCode");                                          // 担当者コード
+            strcmd.Append(", DATE_FORMAT(DailyDataDate, '%Y/%m/%d')");              // 日報作成日
+            strcmd.Append(", ConstructionCode");                                    // 工事番号
+            strcmd.Append(", SeqNo");                                               // 明細行番号
 
-            strcmd.Append(" ,Model");                                            // 機種
-            strcmd.Append(" ,Performance");                                      // 性能
-            strcmd.Append(" ,Owner");                                            // 所有会社
-            strcmd.Append(" ,Driver");                                           // 当日運転者
-            strcmd.Append(" ,DATE_FORMAT(StartWorkingTime, '%Y/%m/%d %H:%i:%s')");   // 作業時間開始
-            strcmd.Append(" ,DATE_FORMAT(EndWorkingTime, '%Y/%m/%d %H:%i:%s')");     // 作業時間終了
+            strcmd.Append(", Model");                                               // 機種
+            strcmd.Append(", Performance");                                         // 性能
+            strcmd.Append(", Owner");                                               // 所有会社
+            strcmd.Append(", Driver");                                              // 当日運転者
+            strcmd.Append(", DATE_FORMAT(StartWorkingTime, '%Y/%m/%d %H:%i:%s')");  // 作業時間開始
+            strcmd.Append(", DATE_FORMAT(EndWorkingTime, '%Y/%m/%d %H:%i:%s')");    // 作業時間終了
 
-            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");      // 登録年月日
-            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");     // 更新年月日
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");         // 登録年月日
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");        // 更新年月日
             strcmd.Append(" FROM DailyDataVehicles");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODepositDataDetail.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODepositDataDetail.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODepositDataDetail.cs	(revision 341)
@@ -85,22 +85,22 @@
                 // SQL作成（DateTime型が変換できないのでCharに変換しておく）
                 strcmd.Append("SELECT");
                 strcmd.Append(" OrderersDivision");
-                strcmd.Append(" ,OrderersCode");
-                strcmd.Append(" ,CAST(TargetDate As Char)");
-                strcmd.Append(" ,RequestNo");
-                strcmd.Append(" ,OrderNo");
-                strcmd.Append(" ,DepositAmount");
-                strcmd.Append(" ,DiscountAmount");
-                strcmd.Append(" ,CnstrPrice");
-                strcmd.Append(" ,Fees");
-                strcmd.Append(" ,OtherAdjustments");
-                strcmd.Append(" ,DifferenceAmount");
-                strcmd.Append(" ,ConfirmationPersonCode");
-                strcmd.Append(" ,DATE_FORMAT(ConfirmationDate, '%Y/%m/%d')");
-                strcmd.Append(" ,ConfirmationEndFlg");
-                strcmd.Append(" ,Note");
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", OrderersCode");
+                strcmd.Append(", CAST(TargetDate As Char)");
+                strcmd.Append(", RequestNo");
+                strcmd.Append(", OrderNo");
+                strcmd.Append(", DepositAmount");
+                strcmd.Append(", DiscountAmount");
+                strcmd.Append(", CnstrPrice");
+                strcmd.Append(", Fees");
+                strcmd.Append(", OtherAdjustments");
+                strcmd.Append(", DifferenceAmount");
+                strcmd.Append(", ConfirmationPersonCode");
+                strcmd.Append(", DATE_FORMAT(ConfirmationDate, '%Y/%m/%d')");
+                strcmd.Append(", ConfirmationEndFlg");
+                strcmd.Append(", Note");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM DepositDataDetail");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOEstimateBudget.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOEstimateBudget.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOEstimateBudget.cs	(revision 341)
@@ -68,15 +68,15 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
 
-            strcmd.Append("  ConstructionCode");                                 // 工事番号
-            strcmd.Append(" ,ConstructionTime");                                 // 工期
-            strcmd.Append(" ,IntegratedCode");	                                // 積算者
-            strcmd.Append(" ,DATE_FORMAT(DataCreateDate, '%Y/%m/%d %H:%i:%s')"); // データ引込日
-            strcmd.Append(" ,RetValue1");                                        // 予定価格
-            strcmd.Append(" ,RetValue2");                                        // 直接工事費
-            strcmd.Append(" ,RetValue3");                                        // 積み上げ共通仮設費
-            strcmd.Append(" ,RetValue4");                                        // 積み上げ現場管理費
-            strcmd.Append(" ,RetPercent");                                       // 一般管理費率
+            strcmd.Append("  ConstructionCode");                                    // 工事番号
+            strcmd.Append(", ConstructionTime");                                    // 工期
+            strcmd.Append(", IntegratedCode");	                                    // 積算者
+            strcmd.Append(", DATE_FORMAT(DataCreateDate, '%Y/%m/%d %H:%i:%s')");    // データ引込日
+            strcmd.Append(", RetValue1");                                           // 予定価格
+            strcmd.Append(", RetValue2");                                           // 直接工事費
+            strcmd.Append(", RetValue3");                                           // 積み上げ共通仮設費
+            strcmd.Append(", RetValue4");                                           // 積み上げ現場管理費
+            strcmd.Append(", RetPercent");                                          // 一般管理費率
 
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOEstimateData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOEstimateData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOEstimateData.cs	(revision 341)
@@ -174,7 +174,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOInvoiceData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOInvoiceData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOInvoiceData.cs	(revision 341)
@@ -533,23 +533,23 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append(" InvoiceNo");
-            strcmd.Append(" ,OrderersDivision");
-            strcmd.Append(" ,OrderersCode");
-            strcmd.Append(" ,RequestMonth");
-            strcmd.Append(" ,SeqNo");
-            strcmd.Append(" ,DATE_FORMAT(CretateDate, '%Y/%m/%d')");
-            strcmd.Append(" ,DATE_FORMAT(RequestDate, '%Y/%m/%d')");
-            strcmd.Append(" ,RequestName");
-            strcmd.Append(" ,TotalAmount");
-            strcmd.Append(" ,TaxAmount");
-            strcmd.Append(" ,Comment1");
-            strcmd.Append(" ,Comment2");
-            strcmd.Append(" ,Comment3");
-            strcmd.Append(" ,Comment4");
-            strcmd.Append(" ,Comment5");
-            strcmd.Append(" ,CompleteFlg");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", OrderersDivision");
+            strcmd.Append(", OrderersCode");
+            strcmd.Append(", RequestMonth");
+            strcmd.Append(", SeqNo");
+            strcmd.Append(", DATE_FORMAT(CretateDate, '%Y/%m/%d')");
+            strcmd.Append(", DATE_FORMAT(RequestDate, '%Y/%m/%d')");
+            strcmd.Append(", RequestName");
+            strcmd.Append(", TotalAmount");
+            strcmd.Append(", TaxAmount");
+            strcmd.Append(", Comment1");
+            strcmd.Append(", Comment2");
+            strcmd.Append(", Comment3");
+            strcmd.Append(", Comment4");
+            strcmd.Append(", Comment5");
+            strcmd.Append(", CompleteFlg");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM InvoiceData");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMApproval.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMApproval.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMApproval.cs	(revision 341)
@@ -338,7 +338,7 @@
             try
             {
                 // SQL作成
-                strcmd.AppendFormat("SELECT IFNULL(MAX(SeqNo), 0) FROM ApprovalMaster{0}" , AddSQLString);
+                strcmd.AppendFormat("SELECT IFNULL(MAX(SeqNo), 0) FROM ApprovalMaster{0}", AddSQLString);
 
                 // SQL実行
                 if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return iRet;
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMBizPeriodHistory.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMBizPeriodHistory.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMBizPeriodHistory.cs	(revision 341)
@@ -177,7 +177,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMBusinessType.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMBusinessType.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMBusinessType.cs	(revision 341)
@@ -71,8 +71,8 @@
                 // SQL作成（DateTime型が変換できないのでCharに変換しておく）
                 strcmd.Append("SELECT");
                 strcmd.Append(" BusinessTypeCode, DisplayOrder, BusinessTypeName");
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM BusinessTypeMaster");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCategoryName.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCategoryName.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCategoryName.cs	(revision 341)
@@ -74,13 +74,13 @@
                 strcmd.Append("SELECT");
 
                 strcmd.Append("  NameCode");
-                strcmd.Append(" ,CategoryCode");
-                strcmd.Append(" ,DisplayOrder");
-                strcmd.Append(" ,CategoryName");
-                strcmd.Append(" ,DeleteFlg");
+                strcmd.Append(", CategoryCode");
+                strcmd.Append(", DisplayOrder");
+                strcmd.Append(", CategoryName");
+                strcmd.Append(", DeleteFlg");
 
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM CategoryNameMaster");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMChgChargeDep.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMChgChargeDep.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMChgChargeDep.cs	(revision 341)
@@ -180,7 +180,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(ColumnCnt)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostLarge.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostLarge.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostLarge.cs	(revision 341)
@@ -68,12 +68,12 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  LargeCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,LargeName");
-            strcmd.Append(" ,CommentText");
-            strcmd.Append(" ,DeleteFlg");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", LargeName");
+            strcmd.Append(", CommentText");
+            strcmd.Append(", DeleteFlg");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM CommonCostLarge");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostLinkMS.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostLinkMS.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostLinkMS.cs	(revision 341)
@@ -66,10 +66,10 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  LargeCode");
-            strcmd.Append(" ,MiddleCode");
-            strcmd.Append(" ,ItemCode");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", MiddleCode");
+            strcmd.Append(", ItemCode");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM CommonCostLinkMS");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostMiddle.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostMiddle.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostMiddle.cs	(revision 341)
@@ -69,13 +69,13 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  LargeCode");
-            strcmd.Append(" ,MiddleCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,MiddleName");
-            strcmd.Append(" ,CommentText");
-            strcmd.Append(" ,DeleteFlg");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", MiddleCode");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", MiddleName");
+            strcmd.Append(", CommentText");
+            strcmd.Append(", DeleteFlg");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM CommonCostMiddle");
 
             return strcmd.ToString();
@@ -99,7 +99,7 @@
             try
             {
                 // SQL作成（DateTime型が変換できないのでCharに変換しておく）
-                strcmd.AppendFormat("{0}{1}" , CreateSelectSQL() , AddSQLString);
+                strcmd.AppendFormat("{0}{1}", CreateSelectSQL() , AddSQLString);
 
                 // SQL実行
                 if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostMiddleSearchWord.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostMiddleSearchWord.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCommonCostMiddleSearchWord.cs	(revision 341)
@@ -67,11 +67,11 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  LargeCode");
-            strcmd.Append(" ,MiddleCode");
-            strcmd.Append(" ,SeqNo");
-            strcmd.Append(" ,SearchWord");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", MiddleCode");
+            strcmd.Append(", SeqNo");
+            strcmd.Append(", SearchWord");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM CommonCostMiddleSearchWord");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMComponent.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMComponent.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMComponent.cs	(revision 341)
@@ -70,14 +70,14 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  ComponentCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,ComponentName");
-            strcmd.Append(" ,SubitemsFlg");
-            strcmd.Append(" ,DirectInputFlg");
-            strcmd.Append(" ,MyExpensesFlg");
-            strcmd.Append(" ,DeleteFlg");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", ComponentName");
+            strcmd.Append(", SubitemsFlg");
+            strcmd.Append(", DirectInputFlg");
+            strcmd.Append(", MyExpensesFlg");
+            strcmd.Append(", DeleteFlg");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM ComponentMaster");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMComponentLink.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMComponentLink.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMComponentLink.cs	(revision 341)
@@ -66,10 +66,10 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  ComponentCode");
-            strcmd.Append(" ,ItemCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", ItemCode");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM ComponentLinkMaster");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMComponentToTypeMaster.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMComponentToTypeMaster.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMComponentToTypeMaster.cs	(revision 341)
@@ -66,10 +66,10 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  ComponentCode");
-            strcmd.Append(" ,ItemCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", ItemCode");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM ComponentToTypeMaster");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMConstructionItem.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMConstructionItem.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMConstructionItem.cs	(revision 341)
@@ -69,13 +69,13 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  ItemCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,ItemName");
-            strcmd.Append(" ,SubitemsFlg");
-            strcmd.Append(" ,MyExpensesFlg");
-            strcmd.Append(" ,DeleteFlg");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", ItemName");
+            strcmd.Append(", SubitemsFlg");
+            strcmd.Append(", MyExpensesFlg");
+            strcmd.Append(", DeleteFlg");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM ConstructionItemMaster");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMConstructionTypeMaster.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMConstructionTypeMaster.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMConstructionTypeMaster.cs	(revision 341)
@@ -78,8 +78,8 @@
 
             strcmd.Append(",DeleteFlg");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM ConstructionTypeMaster");
 
             return strcmd.ToString();
@@ -186,7 +186,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(NameColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDepartment.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDepartment.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDepartment.cs	(revision 341)
@@ -80,8 +80,8 @@
             strcmd.Append(",CompDate");
             strcmd.Append(",DeleteFlg");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM DepartmentMaster");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDepartmentExpenses.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDepartmentExpenses.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDepartmentExpenses.cs	(revision 341)
@@ -46,6 +46,10 @@
             /// </summary>
             NameCode,
             /// <summary>
+            /// 名称
+            /// </summary>
+            NameString,
+            /// <summary>
             /// 表示順
             /// </summary>
             DisplayOrder,
@@ -93,14 +97,15 @@
 
             strcmd.Append("SELECT");
             strcmd.Append(" DepartmentCode");
-            strcmd.Append(" ,ExpensesPeriod");
-            strcmd.Append(" ,NameCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,ExpensesRaito");
-            strcmd.Append(" ,DeleteFlg");
+            strcmd.Append(", ExpensesPeriod");
+            strcmd.Append(", NameCode");
+            strcmd.Append(", NameString");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", ExpensesRaito");
+            strcmd.Append(", DeleteFlg");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM DepartmentExpensesMaster");
 
             return strcmd.ToString();
@@ -215,6 +220,7 @@
                 strcmd.AppendFormat("  {0}", data.DepartmentCode.ToString());
                 strcmd.AppendFormat(", {0}", data.ExpensesPeriod.ToString());
                 strcmd.AppendFormat(", {0}", data.NameCode.ToString());
+                strcmd.AppendFormat(",'{0}'", data.NameString);
                 strcmd.AppendFormat(", {0}", data.DisplayOrder.ToString());
                 strcmd.AppendFormat(", {0}", data.ExpensesRaito.ToString());
                 strcmd.AppendFormat(", {0}", data.DeleteFlg.ToString());
@@ -266,6 +272,7 @@
                     strcmd.AppendFormat("  {0}", work.DepartmentCode.ToString());
                     strcmd.AppendFormat(", {0}", work.ExpensesPeriod.ToString());
                     strcmd.AppendFormat(", {0}", work.NameCode.ToString());
+                    strcmd.AppendFormat(",'{0}'", work.NameString);
                     strcmd.AppendFormat(", {0}", work.DisplayOrder.ToString());
                     strcmd.AppendFormat(", {0}", work.ExpensesRaito.ToString());
                     strcmd.AppendFormat(", {0}", work.DeleteFlg.ToString());
@@ -307,11 +314,12 @@
                 strcmd.Append(" SET");
 
                 strcmd.AppendFormat(" DepartmentCode = {0}", data.DepartmentCode.ToString());
-                strcmd.AppendFormat(",ExpensesPeriod = {0}", data.ExpensesPeriod.ToString());
-                strcmd.AppendFormat(",NameCode = {0}", data.NameCode.ToString());
-                strcmd.AppendFormat(",DisplayOrder = {0}", data.DisplayOrder.ToString());
-                strcmd.AppendFormat(",EXPENSESRAITO = {0}", data.ExpensesRaito.ToString());
-                strcmd.AppendFormat(",DeleteFlg = {0}", data.DeleteFlg.ToString());
+                strcmd.AppendFormat(", ExpensesPeriod = {0}", data.ExpensesPeriod.ToString());
+                strcmd.AppendFormat(", NameCode = {0}", data.NameCode.ToString());
+                strcmd.AppendFormat(", NameString = '{0}'", data.NameString);
+                strcmd.AppendFormat(", DisplayOrder = {0}", data.DisplayOrder.ToString());
+                strcmd.AppendFormat(", EXPENSESRAITO = {0}", data.ExpensesRaito.ToString());
+                strcmd.AppendFormat(", DeleteFlg = {0}", data.DeleteFlg.ToString());
 
                 strcmd.Append(", UpdateDate = NOW()");
                 strcmd.Append(AddSQLString);
@@ -405,6 +413,7 @@
                 // データ取得
                 wrk.DepartmentCode = int.Parse(objwrk[(int)NameColumn.DepartmentCode].ToString());
                 wrk.NameCode = int.Parse(objwrk[(int)NameColumn.NameCode].ToString());
+                wrk.NameString = objwrk[(int)NameColumn.NameString].ToString();
                 wrk.ExpensesPeriod = int.Parse(objwrk[(int)NameColumn.ExpensesPeriod].ToString());
                 wrk.DisplayOrder = int.Parse(objwrk[(int)NameColumn.DisplayOrder].ToString());
                 wrk.ExpensesRaito = CommonMotions.cnvDouble(objwrk[(int)NameColumn.ExpensesRaito]);
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDivision.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDivision.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDivision.cs	(revision 341)
@@ -73,8 +73,8 @@
             strcmd.Append(",NameString");
             strcmd.Append(",DeleteFlg");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM DivisionMaster");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMExpenses.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMExpenses.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMExpenses.cs	(revision 341)
@@ -68,13 +68,13 @@
             strcmd.Append("SELECT");
 
             strcmd.Append(" DivisionCode");
-            strcmd.Append(" ,NameCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,ExpensesRaito");
-            strcmd.Append(" ,DeleteFlg");
+            strcmd.Append(", NameCode");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", ExpensesRaito");
+            strcmd.Append(", DeleteFlg");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM ExpensesMaster");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMHolidayCalender.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMHolidayCalender.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMHolidayCalender.cs	(revision 341)
@@ -175,9 +175,9 @@
                     else strcmd.Append(", (");
 
                     strcmd.AppendFormat(" STR_TO_DATE('{0}','%Y/%m/%d')", work.Holiday.ToShortDateString());
-                    strcmd.AppendFormat(" ,{0}", work.BusinessYear.ToString());
-                    strcmd.AppendFormat(" ,{0}", work.TargetMonth.ToString());
-                    strcmd.AppendFormat(" ,{0}", work.TargetDay.ToString());
+                    strcmd.AppendFormat(", {0}", work.BusinessYear.ToString());
+                    strcmd.AppendFormat(", {0}", work.TargetMonth.ToString());
+                    strcmd.AppendFormat(", {0}", work.TargetDay.ToString());
 
                     strcmd.Append(")");
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMOrderers.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMOrderers.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMOrderers.cs	(revision 341)
@@ -82,27 +82,27 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  OrderCotegory");
-            strcmd.Append(" ,OrderersCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,OrderFlg");
-            strcmd.Append(" ,CorporateStatusName");
-            strcmd.Append(" ,CorporateStatusPoint");
-            strcmd.Append(" ,OrderersName1");
-            strcmd.Append(" ,OrderersName2");
-            strcmd.Append(" ,DepartmentName");
-            strcmd.Append(" ,ChargePersonName");
-            strcmd.Append(" ,ZipCode");
-            strcmd.Append(" ,Address1");
-            strcmd.Append(" ,Address2");
-            strcmd.Append(" ,Address3");
-            strcmd.Append(" ,PhoneNumber");
-            strcmd.Append(" ,FaxNumber");
-            strcmd.Append(" ,MailAddress");
-            strcmd.Append(" ,Note");
-            strcmd.Append(" ,DeleteFlg");
+            strcmd.Append(", OrderersCode");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", OrderFlg");
+            strcmd.Append(", CorporateStatusName");
+            strcmd.Append(", CorporateStatusPoint");
+            strcmd.Append(", OrderersName1");
+            strcmd.Append(", OrderersName2");
+            strcmd.Append(", DepartmentName");
+            strcmd.Append(", ChargePersonName");
+            strcmd.Append(", ZipCode");
+            strcmd.Append(", Address1");
+            strcmd.Append(", Address2");
+            strcmd.Append(", Address3");
+            strcmd.Append(", PhoneNumber");
+            strcmd.Append(", FaxNumber");
+            strcmd.Append(", MailAddress");
+            strcmd.Append(", Note");
+            strcmd.Append(", DeleteFlg");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM OrderersMaster");
 
             return strcmd.ToString();
@@ -270,7 +270,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(OrderersColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMPersonInCharge.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMPersonInCharge.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMPersonInCharge.cs	(revision 341)
@@ -208,7 +208,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(ColumnCnt)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMProcessExcute.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMProcessExcute.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMProcessExcute.cs	(revision 341)
@@ -67,10 +67,10 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  SecCode");
-            strcmd.Append(" ,ExecCode");
-            strcmd.Append(" ,EditFlg");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", ExecCode");
+            strcmd.Append(", EditFlg");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM ProcessExcuteMaster");
 
             return strcmd.ToString();
@@ -276,7 +276,7 @@
 
                 strcmd.AppendFormat(",EditFlg = {0}", data.EditFlg.ToString());
 
-                strcmd.Append(" ,UpdateDate = NOW()");
+                strcmd.Append(", UpdateDate = NOW()");
 
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSecurity.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSecurity.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSecurity.cs	(revision 341)
@@ -68,15 +68,15 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  SecCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,SecName");
-            strcmd.Append(" ,SecRank");
-            strcmd.Append(" ,SecRange");
-            strcmd.Append(" ,GeneralAffairs");
-            strcmd.Append(" ,SelectBackColor");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", SecName");
+            strcmd.Append(", SecRank");
+            strcmd.Append(", SecRange");
+            strcmd.Append(", GeneralAffairs");
+            strcmd.Append(", SelectBackColor");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM SecurityMaster");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractor.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractor.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractor.cs	(revision 341)
@@ -106,8 +106,8 @@
             strcmd.Append(", labourKind");
             strcmd.Append(", DeleteFlg");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM SubContractorMaster");
 
             return strcmd.ToString();
@@ -223,18 +223,18 @@
                 strcmd.AppendFormat(",'{0}'", data.CorporateStatusName);
                 strcmd.AppendFormat(", {0}", data.CorporateStatusPoint);
                 strcmd.AppendFormat(",'{0}'", data.CompanyName);
-                strcmd.AppendFormat(",'{0}'" ,data.CEOPositionName);
-                strcmd.AppendFormat(",'{0}'" ,data.CEOName);
-                strcmd.AppendFormat(",'{0}'" ,data.ContactPersonName);
-                strcmd.AppendFormat(",'{0}'" ,data.ZipCode);
-                strcmd.AppendFormat(",'{0}'" ,data.Address1);
-                strcmd.AppendFormat(",'{0}'" ,data.Address2);
-                strcmd.AppendFormat(",'{0}'" ,data.Address3);
-                strcmd.AppendFormat(",'{0}'" ,data.CellPhoneNumber);
-                strcmd.AppendFormat(",'{0}'" ,data.MailAddress);
-                strcmd.AppendFormat(",'{0}'" ,data.PhoneNumber);
-                strcmd.AppendFormat(",'{0}'" ,data.FaxNumber );
-                strcmd.AppendFormat(",'{0}'" ,data.JapaneseSyllabary);
+                strcmd.AppendFormat(",'{0}'", data.CEOPositionName);
+                strcmd.AppendFormat(",'{0}'", data.CEOName);
+                strcmd.AppendFormat(",'{0}'", data.ContactPersonName);
+                strcmd.AppendFormat(",'{0}'", data.ZipCode);
+                strcmd.AppendFormat(",'{0}'", data.Address1);
+                strcmd.AppendFormat(",'{0}'", data.Address2);
+                strcmd.AppendFormat(",'{0}'", data.Address3);
+                strcmd.AppendFormat(",'{0}'", data.CellPhoneNumber);
+                strcmd.AppendFormat(",'{0}'", data.MailAddress);
+                strcmd.AppendFormat(",'{0}'", data.PhoneNumber);
+                strcmd.AppendFormat(",'{0}'", data.FaxNumber );
+                strcmd.AppendFormat(",'{0}'", data.JapaneseSyllabary);
                 strcmd.AppendFormat(",STR_TO_DATE('{0}','%Y/%m/%d')", data.StartDate.ToShortDateString());
                 strcmd.AppendFormat(",'{0}'", data.Note);
                 strcmd.AppendFormat(", {0} ", data.labourKind.ToString());
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorItem.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorItem.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorItem.cs	(revision 341)
@@ -67,11 +67,11 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  ItemCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,ItemName");
-            strcmd.Append(" ,DeleteFlg");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", ItemName");
+            strcmd.Append(", DeleteFlg");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM SubContractorItemMaster");
 
             return strcmd.ToString();
@@ -192,9 +192,9 @@
                     else strcmd.Append(", (");
 
                     strcmd.AppendFormat(" {0}", work.ItemCode.ToString());
-                    strcmd.AppendFormat(" ,{0}", work.DisplayOrder.ToString());
-                    strcmd.AppendFormat(" ,'{0}'", work.ItemName);
-                    strcmd.AppendFormat(" ,{0}", work.DeleteFlg.ToString());
+                    strcmd.AppendFormat(", {0}", work.DisplayOrder.ToString());
+                    strcmd.AppendFormat(", '{0}'", work.ItemName);
+                    strcmd.AppendFormat(", {0}", work.DeleteFlg.ToString());
 
                     strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
                     strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobCategory.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobCategory.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobCategory.cs	(revision 341)
@@ -67,11 +67,11 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  JobCategoryCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,JobCategoryName");
-            strcmd.Append(" ,DeleteFlg");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", JobCategoryName");
+            strcmd.Append(", DeleteFlg");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM SubContractorJobCategory");
 
             return strcmd.ToString();
@@ -186,9 +186,9 @@
                 strcmd.Append(") VALUES (");
 
                 strcmd.AppendFormat(" {0}", data.JobCategoryCode.ToString());
-                strcmd.AppendFormat(" ,{0}", data.DisplayOrder.ToString());
-                strcmd.AppendFormat(" ,'{0}'", data.JobCategoryName);
-                strcmd.AppendFormat(" ,{0}", data.DeleteFlg.ToString());
+                strcmd.AppendFormat(", {0}", data.DisplayOrder.ToString());
+                strcmd.AppendFormat(", '{0}'", data.JobCategoryName);
+                strcmd.AppendFormat(", {0}", data.DeleteFlg.ToString());
 
                 strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.EntryDate);
                 strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.UpdateDate);
@@ -235,9 +235,9 @@
                     else strcmd.Append(", (");
 
                     strcmd.AppendFormat(" {0}", work.JobCategoryCode.ToString());
-                    strcmd.AppendFormat(" ,{0}", work.DisplayOrder.ToString());
-                    strcmd.AppendFormat(" ,'{0}'", work.JobCategoryName);
-                    strcmd.AppendFormat(" ,{0}", work.DeleteFlg.ToString());
+                    strcmd.AppendFormat(", {0}", work.DisplayOrder.ToString());
+                    strcmd.AppendFormat(", '{0}'", work.JobCategoryName);
+                    strcmd.AppendFormat(", {0}", work.DeleteFlg.ToString());
 
                     strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
                     strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobItem.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobItem.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobItem.cs	(revision 341)
@@ -66,10 +66,10 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  CompanyCode");
-            strcmd.Append(" ,ItemCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", ItemCode");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM SubContractorJobItem");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobLink.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobLink.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSubContractorJobLink.cs	(revision 341)
@@ -64,10 +64,10 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  CompanyCode");
-            strcmd.Append(" ,JobCategoryCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", JobCategoryCode");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM SubContractorJobLink");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSuppliers.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSuppliers.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSuppliers.cs	(revision 341)
@@ -75,20 +75,20 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  SuppliersCode");
-            strcmd.Append(" ,DisplayOrder");
-            strcmd.Append(" ,SuppliersName1");
-            strcmd.Append(" ,SuppliersName2");
-            strcmd.Append(" ,ZipCode");
-            strcmd.Append(" ,Address1");
-            strcmd.Append(" ,Address2");
-            strcmd.Append(" ,Address3");
-            strcmd.Append(" ,PhoneNumber");
-            strcmd.Append(" ,FaxNumber");
-            strcmd.Append(" ,Note");
-            strcmd.Append(" ,DeleteFlg");
+            strcmd.Append(", DisplayOrder");
+            strcmd.Append(", SuppliersName1");
+            strcmd.Append(", SuppliersName2");
+            strcmd.Append(", ZipCode");
+            strcmd.Append(", Address1");
+            strcmd.Append(", Address2");
+            strcmd.Append(", Address3");
+            strcmd.Append(", PhoneNumber");
+            strcmd.Append(", FaxNumber");
+            strcmd.Append(", Note");
+            strcmd.Append(", DeleteFlg");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM SuppliersMaster");
 
             return strcmd.ToString();
@@ -309,8 +309,8 @@
 
                 strcmd.AppendFormat(" SuppliersCode = {0}", data.SuppliersCode);
                 strcmd.AppendFormat(", DisplayOrder = {0}", data.DisplayOrder);
-                strcmd.AppendFormat(", SuppliersName1 = '{0}'" , data.SuppliersName1);
-                strcmd.AppendFormat(", SuppliersName2 = '{0}'" , data.SuppliersName2);
+                strcmd.AppendFormat(", SuppliersName1 = '{0}'", data.SuppliersName1);
+                strcmd.AppendFormat(", SuppliersName2 = '{0}'", data.SuppliersName2);
                 strcmd.AppendFormat(", ZipCode = '{0}'", data.ZipCode);
                 strcmd.AppendFormat(", Address1 = '{0}'", data.Address1);
                 strcmd.AppendFormat(", Address2 = '{0}'", data.Address2);
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSystem.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSystem.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMSystem.cs	(revision 341)
@@ -119,8 +119,8 @@
             strcmd.Append(",SloganString1");
             strcmd.Append(",SloganString2");
             strcmd.Append(",SloganString3");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM SystemMaster");
 
             return strcmd.ToString();
@@ -223,7 +223,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(SystemColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMTerm.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMTerm.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMTerm.cs	(revision 341)
@@ -78,17 +78,17 @@
                 // SQL作成
                 strcmd.Append("SELECT");
                 strcmd.Append("  ConstructionStatusFlg");
-                strcmd.Append(" ,FieldNo");
-                strcmd.Append(" ,SeqNo");
-                strcmd.Append(" ,DisplayOrder");
-                strcmd.Append(" ,CheckSchdule");
-                strcmd.Append(" ,TermDays");
-                strcmd.Append(" ,SendTitile");
-                strcmd.Append(" ,SendMessage");
-                strcmd.Append(" ,BackColor");
-                strcmd.Append(" ,ForeColor");
-                strcmd.Append(" ,DATE_FORMAT(EntryDate,'%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate,'%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", FieldNo");
+                strcmd.Append(", SeqNo");
+                strcmd.Append(", DisplayOrder");
+                strcmd.Append(", CheckSchdule");
+                strcmd.Append(", TermDays");
+                strcmd.Append(", SendTitile");
+                strcmd.Append(", SendMessage");
+                strcmd.Append(", BackColor");
+                strcmd.Append(", ForeColor");
+                strcmd.Append(", DATE_FORMAT(EntryDate,'%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate,'%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM TermMaster");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMTypeExpenses.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMTypeExpenses.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMTypeExpenses.cs	(revision 341)
@@ -68,10 +68,10 @@
             strcmd.Append("SELECT");
 
             strcmd.Append(" TypeCode");
-            strcmd.Append(" ,ExpensesPeriod");
-            strcmd.Append(" ,NameCode");
-            strcmd.Append(" ,ExpensesRaito");
-            strcmd.Append(" ,DeleteFlg");
+            strcmd.Append(", ExpensesPeriod");
+            strcmd.Append(", NameCode");
+            strcmd.Append(", ExpensesRaito");
+            strcmd.Append(", DeleteFlg");
 
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
@@ -182,7 +182,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(NameColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMUnit.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMUnit.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMUnit.cs	(revision 341)
@@ -71,8 +71,8 @@
                 // SQL作成
                 strcmd.Append("SELECT");
                 strcmd.Append(" UnitKey, DisplayOrder, UnitName");
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM UnitMaster");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMVehicle.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMVehicle.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMVehicle.cs	(revision 341)
@@ -109,8 +109,8 @@
                 strcmd.Append(",InsurancePhone");
                 strcmd.Append(",Note");
 
-                strcmd.Append(" ,DATE_FORMAT(EntryDate,'%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate,'%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(EntryDate,'%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate,'%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM VehicleMaster");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMVehicleRecordData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMVehicleRecordData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMVehicleRecordData.cs	(revision 341)
@@ -83,8 +83,8 @@
                 strcmd.Append(",Content");
                 strcmd.Append(",PaymentCost");
 
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM VehicleRecordData");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialInfo.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialInfo.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialInfo.cs	(revision 341)
@@ -71,8 +71,8 @@
                 // SQL作成（DateTime型が変換できないのでCharに変換しておく）
                 strcmd.Append("SELECT");
                 strcmd.Append(" MaterialItemCode, MaterialCount, RentCount, DeleteFlg");
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM MaterialInfo");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialItem.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialItem.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialItem.cs	(revision 341)
@@ -78,9 +78,9 @@
                 // SQL作成（DateTime型が変換できないのでCharに変換しておく）
                 strcmd.Append("SELECT");
                 strcmd.Append(" MaterialItemCode, MaterialKindCode, MaterialItemName, DisplayOrder, DeleteFlg");
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,VersionNo");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", VersionNo");
                 strcmd.Append(" FROM MaterialItemMaster");
                 strcmd.Append(AddSQLString);
 
@@ -367,7 +367,7 @@
             try
             {
                 // SQL作成
-                strcmd.AppendFormat("SELECT COUNT(*) FROM MaterialItemMaster where MaterialKindCode = {0} and Deleteflg = 0" , MaterialKindCode);
+                strcmd.AppendFormat("SELECT COUNT(*) FROM MaterialItemMaster where MaterialKindCode = {0} and Deleteflg = 0", MaterialKindCode);
 
                 // SQL実行
                 if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return iRet;
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBoardData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBoardData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBoardData.cs	(revision 341)
@@ -92,8 +92,8 @@
             strcmd.Append(",BackColor");
             strcmd.Append(",MessageFlag");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM MessageBoardData");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBoardDataTerget.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBoardDataTerget.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBoardDataTerget.cs	(revision 341)
@@ -72,8 +72,8 @@
             strcmd.Append(",ToCode");
             strcmd.Append(",ToName");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM MessageBoardTerget");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBrowsingHistory.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBrowsingHistory.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBrowsingHistory.cs	(revision 341)
@@ -72,8 +72,8 @@
             strcmd.Append(",BrowsingCode");
             strcmd.Append(",DATE_FORMAT(BrowsingDate, '%Y/%m/%d %H:%i:%s')");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM MessageBrowsingHistory");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOOrdersPriceData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOOrdersPriceData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOOrdersPriceData.cs	(revision 341)
@@ -72,15 +72,15 @@
             strcmd.Append("SELECT");
 
             strcmd.Append("  ConstructionCode");             // 工事コード
-            strcmd.Append(" ,ChangeNo");	                    // 変更番号
-            strcmd.Append(" ,DATE_FORMAT(ChangeDate, '%Y/%m/%d')");	// 変更日
-            strcmd.Append(" ,ChangePersonCode");             // 変更者コード
-            strcmd.Append(" ,ChangePersonName");             // 変更者名
-            strcmd.Append(" ,BeforeValue");                  // 変更前税抜受注金額
-            strcmd.Append(" ,BeforeValueInTax");             // 　〃　税込受注金額
-            strcmd.Append(" ,AfterValue");                   // 変更後税抜受注金額
-            strcmd.Append(" ,AfterValueInTax");              // 　〃　税込受注金額
-            strcmd.Append(" ,ChangeComment");                // 変更理由
+            strcmd.Append(", ChangeNo");	                    // 変更番号
+            strcmd.Append(", DATE_FORMAT(ChangeDate, '%Y/%m/%d')");	// 変更日
+            strcmd.Append(", ChangePersonCode");             // 変更者コード
+            strcmd.Append(", ChangePersonName");             // 変更者名
+            strcmd.Append(", BeforeValue");                  // 変更前税抜受注金額
+            strcmd.Append(", BeforeValueInTax");             // 　〃　税込受注金額
+            strcmd.Append(", AfterValue");                   // 変更後税抜受注金額
+            strcmd.Append(", AfterValueInTax");              // 　〃　税込受注金額
+            strcmd.Append(", ChangeComment");                // 変更理由
 
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPaymentApprovalInfo.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPaymentApprovalInfo.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPaymentApprovalInfo.cs	(revision 341)
@@ -250,7 +250,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(NameColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPaymentDataDetail.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPaymentDataDetail.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPaymentDataDetail.cs	(revision 341)
@@ -101,8 +101,8 @@
                 strcmd.Append(" ApprovalDate,");
                 strcmd.Append(" ApprovalEndFlg");
 
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM PaymentDataDetail");
                 strcmd.Append(AddSQLString);
 
@@ -148,7 +148,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(NameColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
@@ -208,7 +208,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(NameColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApproval.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApproval.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApproval.cs	(revision 341)
@@ -246,7 +246,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(ColumnName)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApprovalCommnet.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApprovalCommnet.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApprovalCommnet.cs	(revision 341)
@@ -238,7 +238,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(ColumnName)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApprovalDetail.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApprovalDetail.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPersonApprovalDetail.cs	(revision 341)
@@ -244,7 +244,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(ColumnName)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsData.cs	(revision 341)
@@ -95,12 +95,12 @@
 
             strcmd.Append("SELECT");
             strcmd.Append("  ConstructionCode");                                 // 工事番号
-            strcmd.Append(" ,DATE_FORMAT(ProceedingsDataDate, '%Y/%m/%d')");     // 議事録作成日
-            strcmd.Append(" ,StartMeetingTime");                                 // 会議時間開始
-            strcmd.Append(" ,EndMeetingTime");                                   // 会議時間終了
-            strcmd.Append(" ,CreatorCode");                                      // 作成者コード
-            strcmd.Append(" ,PalceFlag");                                        // 現地フラグ
-            strcmd.Append(" ,MeetingPalce");                                     // 打合せ場所
+            strcmd.Append(", DATE_FORMAT(ProceedingsDataDate, '%Y/%m/%d')");     // 議事録作成日
+            strcmd.Append(", StartMeetingTime");                                 // 会議時間開始
+            strcmd.Append(", EndMeetingTime");                                   // 会議時間終了
+            strcmd.Append(", CreatorCode");                                      // 作成者コード
+            strcmd.Append(", PalceFlag");                                        // 現地フラグ
+            strcmd.Append(", MeetingPalce");                                     // 打合せ場所
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");      // 登録年月日
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");     // 更新年月日
             strcmd.Append(" FROM ProceedingsData");
@@ -194,7 +194,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsDataAttend.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsDataAttend.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsDataAttend.cs	(revision 341)
@@ -91,11 +91,11 @@
             strcmd.Append("SELECT");
 
             strcmd.Append(" ConstructionCode");                                  // 工事番号
-            strcmd.Append(" ,DATE_FORMAT(ProceedingsDataDate, '%Y/%m/%d')");     // 議事録作成日
-            strcmd.Append(" ,StartMeetingTime");                                 // 会議時間開始
-            strcmd.Append(" ,SeqNo");                                            // データ行番号
-            strcmd.Append(" ,Department");                                       // 出席者所属
-            strcmd.Append(" ,AttendName");                                       // 出席者氏名
+            strcmd.Append(", DATE_FORMAT(ProceedingsDataDate, '%Y/%m/%d')");     // 議事録作成日
+            strcmd.Append(", StartMeetingTime");                                 // 会議時間開始
+            strcmd.Append(", SeqNo");                                            // データ行番号
+            strcmd.Append(", Department");                                       // 出席者所属
+            strcmd.Append(", AttendName");                                       // 出席者氏名
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");      // 更新年月日
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");     // 登録年月日
             strcmd.Append(" FROM ProceedingsDataAttend");
@@ -188,7 +188,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsDataDetail.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsDataDetail.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsDataDetail.cs	(revision 341)
@@ -95,12 +95,12 @@
 
             strcmd.Append("SELECT");
             strcmd.Append(" ConstructionCode");                                  // 工事番号
-            strcmd.Append(" ,DATE_FORMAT(ProceedingsDataDate, '%Y/%m/%d')");     // 議事録作成日
-            strcmd.Append(" ,StartMeetingTime");                                 // 会議時間開始
-            strcmd.Append(" ,SeqNo");                                            // データ行番号
-            strcmd.Append(" ,TitleNo");                                          // 議題番号
-            strcmd.Append(" ,Title");                                            // 議題
-            strcmd.Append(" ,ContentsText");                                     // 内容
+            strcmd.Append(", DATE_FORMAT(ProceedingsDataDate, '%Y/%m/%d')");     // 議事録作成日
+            strcmd.Append(", StartMeetingTime");                                 // 会議時間開始
+            strcmd.Append(", SeqNo");                                            // データ行番号
+            strcmd.Append(", TitleNo");                                          // 議題番号
+            strcmd.Append(", Title");                                            // 議題
+            strcmd.Append(", ContentsText");                                     // 内容
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");      // 更新年月日
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");     // 登録年月日
             strcmd.Append(" FROM ProceedingsDataDetail");
@@ -193,7 +193,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProcessApproval.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProcessApproval.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProcessApproval.cs	(revision 341)
@@ -246,7 +246,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(ColumnName)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
@@ -485,7 +485,7 @@
             try
             {
                 // SQL作成
-                strcmd.AppendFormat("SELECT IFNULL(MAX(OrderNo), 0) FROM ProcessApproval {0}" , AddSQLString);
+                strcmd.AppendFormat("SELECT IFNULL(MAX(OrderNo), 0) FROM ProcessApproval {0}", AddSQLString);
 
                 // SQL実行
                 if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return iRet;
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProcessApprovalCommnet.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProcessApprovalCommnet.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProcessApprovalCommnet.cs	(revision 341)
@@ -236,7 +236,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(ColumnName)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPurchaseOrderDetail.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPurchaseOrderDetail.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPurchaseOrderDetail.cs	(revision 341)
@@ -197,7 +197,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestData.cs	(revision 341)
@@ -86,24 +86,24 @@
                 // SQL作成（DateTime型が変換できないのでCharに変換しておく）
                 strcmd.Append("SELECT");
                 strcmd.Append(" RequestNo");
-                strcmd.Append(" ,MainConstructionCode");
+                strcmd.Append(", MainConstructionCode");
 
-                strcmd.Append(" ,ConstructionName");
-                strcmd.Append(" ,ContractAmount");
-                strcmd.Append(" ,PaidAmount");
-                strcmd.Append(" ,RequestAmount0");
-                strcmd.Append(" ,RequestAmount1");
-                strcmd.Append(" ,RequestAmount2");
-                strcmd.Append(" ,RequestAmount3");
-                strcmd.Append(" ,RequestAmount4");
-                strcmd.Append(" ,RequestAmount5");
-                strcmd.Append(" ,RequestAmount6");
-                strcmd.Append(" ,UnclaimedAmount");
-                strcmd.Append(" ,UnpaidAmount");
-                strcmd.Append(" ,TaxAmount");
-                strcmd.Append(" ,Note");
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", ConstructionName");
+                strcmd.Append(", ContractAmount");
+                strcmd.Append(", PaidAmount");
+                strcmd.Append(", RequestAmount0");
+                strcmd.Append(", RequestAmount1");
+                strcmd.Append(", RequestAmount2");
+                strcmd.Append(", RequestAmount3");
+                strcmd.Append(", RequestAmount4");
+                strcmd.Append(", RequestAmount5");
+                strcmd.Append(", RequestAmount6");
+                strcmd.Append(", UnclaimedAmount");
+                strcmd.Append(", UnpaidAmount");
+                strcmd.Append(", TaxAmount");
+                strcmd.Append(", Note");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM RequestData");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestDataDetail.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestDataDetail.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestDataDetail.cs	(revision 341)
@@ -76,14 +76,14 @@
                 // SQL作成（DateTime型が変換できないのでCharに変換しておく）
                 strcmd.Append("SELECT");
                 strcmd.Append(" RequestNo");
-                strcmd.Append(" ,MainConstructionCode");
-                strcmd.Append(" ,ConstructionCode");
+                strcmd.Append(", MainConstructionCode");
+                strcmd.Append(", ConstructionCode");
 
-                strcmd.Append(" ,ConstructionKind");
-                strcmd.Append(" ,RequestAmount");
-                strcmd.Append(" ,TaxAmount");
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", ConstructionKind");
+                strcmd.Append(", RequestAmount");
+                strcmd.Append(", TaxAmount");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM RequestDataDetail");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestHead.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestHead.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IORequestHead.cs	(revision 341)
@@ -85,22 +85,22 @@
                 // SQL作成（DateTime型が変換できないのでCharに変換しておく）
                 strcmd.Append("SELECT");
                 strcmd.Append(" RequestNo");
-                strcmd.Append(" ,ReqConstructionCode");
-                strcmd.Append(" ,OrderNo");
-                strcmd.Append(" ,RequestMonth");
-                strcmd.Append(" ,OrderersDivision");
-                strcmd.Append(" ,OrderersCode");
-                strcmd.Append(" ,OrderersName");
-                strcmd.Append(" ,ReqConstructionName");
-                strcmd.Append(" ,RequestTotalAmount");
-                strcmd.Append(" ,RequestAmount");
-                strcmd.Append(" ,TaxAmount");
-                strcmd.Append(" ,UnpaidAmount");
-                strcmd.Append(" ,Note");
-                strcmd.Append(" ,AssignedFlg");
-                strcmd.Append(" ,InvoiceNo");
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", ReqConstructionCode");
+                strcmd.Append(", OrderNo");
+                strcmd.Append(", RequestMonth");
+                strcmd.Append(", OrderersDivision");
+                strcmd.Append(", OrderersCode");
+                strcmd.Append(", OrderersName");
+                strcmd.Append(", ReqConstructionName");
+                strcmd.Append(", RequestTotalAmount");
+                strcmd.Append(", RequestAmount");
+                strcmd.Append(", TaxAmount");
+                strcmd.Append(", UnpaidAmount");
+                strcmd.Append(", Note");
+                strcmd.Append(", AssignedFlg");
+                strcmd.Append(", InvoiceNo");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM RequestHead");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSFPData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSFPData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSFPData.cs	(revision 341)
@@ -241,7 +241,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSFPDataDetail.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSFPDataDetail.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSFPDataDetail.cs	(revision 341)
@@ -73,8 +73,8 @@
             strcmd.Append(", SeqNo");
             strcmd.Append(", CompanyCode");
 
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM SFPDataDetail");
 
             return strcmd.ToString();
@@ -227,7 +227,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrJobItemRegist.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrJobItemRegist.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrJobItemRegist.cs	(revision 341)
@@ -182,7 +182,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrJobLinkRegist.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrJobLinkRegist.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrJobLinkRegist.cs	(revision 341)
@@ -180,7 +180,7 @@
                     bool bFirst = true;
                     foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                     {
-                        if (!bFirst) strcmd.Append(" ,");
+                        if (!bFirst) strcmd.Append(", ");
                         strcmd.Append(gender.ToString());
                         bFirst = false;
                     }
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrRegist.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrRegist.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSubConstrRegist.cs	(revision 341)
@@ -114,8 +114,8 @@
             strcmd.Append(", DATE_FORMAT(StartDate, '%Y/%m/%d')");
             strcmd.Append(", Note");
             strcmd.Append(", labourKind");
-            strcmd.Append(" ,DATE_FORMAT(OrderDate, '%Y/%m/%d')");
-            strcmd.Append(" ,OrderNo");
+            strcmd.Append(", DATE_FORMAT(OrderDate, '%Y/%m/%d')");
+            strcmd.Append(", OrderNo");
 
             strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
@@ -224,7 +224,7 @@
                 bool bFirst = true;
                 foreach (var gender in Enum.GetValues(typeof(TableColumn)))
                 {
-                    if (!bFirst) strcmd.Append(" ,");
+                    if (!bFirst) strcmd.Append(", ");
                     strcmd.Append(gender.ToString());
                     bFirst = false;
                 }
@@ -231,7 +231,7 @@
                 strcmd.Append(") VALUES (");
 
                 strcmd.AppendFormat("  {0}", data.PersonCode);
-                strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d')" ,data.CreateDate.ToShortDateString());
+                strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d')", data.CreateDate.ToShortDateString());
                 strcmd.AppendFormat(", {0}", data.SeqNo);
                 strcmd.AppendFormat(", {0}", data.DataMode);
                 strcmd.AppendFormat(", {0}", data.SourceCode);
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSystemExecute.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSystemExecute.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSystemExecute.cs	(revision 341)
@@ -68,11 +68,11 @@
             StringBuilder strcmd = new StringBuilder();
             strcmd.Append("SELECT");
             strcmd.Append("  PrimaryCode");
-            strcmd.Append(" ,DATE_FORMAT(TargetDate, '%Y/%m/%d')");
-            strcmd.Append(" ,SystemVersion");
-            strcmd.Append(" ,UpDateCopyVersion");
-            strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-            strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(TargetDate, '%Y/%m/%d')");
+            strcmd.Append(", SystemVersion");
+            strcmd.Append(", UpDateCopyVersion");
+            strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+            strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
             strcmd.Append(" FROM SystemExecute");
 
             return strcmd.ToString();
Index: branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOVehicleScheduleData.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOVehicleScheduleData.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOVehicleScheduleData.cs	(revision 341)
@@ -75,14 +75,14 @@
                 // SQL作成（DateTime型が変換できないのでCharに変換しておく）
                 strcmd.Append("SELECT");
                 strcmd.Append(" DATE_FORMAT(TargetDate, '%Y/%m/%d')");
-                strcmd.Append(" ,VehicleCode");
-                strcmd.Append(" ,MorningAfternoon");
-                strcmd.Append(" ,PersonCode");
-                strcmd.Append(" ,TargetYear");
-                strcmd.Append(" ,TargetMonth");
-                strcmd.Append(" ,TargetDay");
-                strcmd.Append(" ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-                strcmd.Append(" ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", VehicleCode");
+                strcmd.Append(", MorningAfternoon");
+                strcmd.Append(", PersonCode");
+                strcmd.Append(", TargetYear");
+                strcmd.Append(", TargetMonth");
+                strcmd.Append(", TargetDay");
+                strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
+                strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(" FROM VehicleScheduleData");
                 strcmd.Append(AddSQLString);
 
Index: branches/src/ProcessManagement/ProcessManagement/DataModel/ConstrLedgerExpenses.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DataModel/ConstrLedgerExpenses.cs	(nonexistent)
+++ branches/src/ProcessManagement/ProcessManagement/DataModel/ConstrLedgerExpenses.cs	(revision 341)
@@ -0,0 +1,91 @@
+﻿using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+
+namespace ProcessManagement.DataModel
+{
+    /// <summary>
+    /// 工事詳細台帳経費データ
+    /// </summary>
+    public class ConstrLedgerExpenses
+    {
+        #region 定数
+        #endregion
+
+        #region メンバ変数
+
+        private int         m_ConstructionCode = 0;                     // 工事コード
+        private int         m_SeqNo = 0;                                // 枝番
+        private int         m_NameCode = 0;                             // 経費名称コード
+        private double      m_ExpensesRaito = 0;                        // 経費率
+        private long        m_ExpensesValue = 0;                        // 会社経費合計
+
+        private DateTime    m_EntryDate = DateTime.Now;                 // 登録日付
+        private DateTime    m_UpdateDate = DateTime.Now;                // 更新日付
+        #endregion
+
+        #region コンストラクタ
+        #endregion
+
+        #region プロパティ
+        /// <summary>
+        /// 工事コード
+        /// </summary>
+        public int ConstructionCode
+        {
+            get { return m_ConstructionCode; }
+            set { m_ConstructionCode = value; }
+        }
+        /// <summary>
+        /// 枝番
+        /// </summary>
+        public int SeqNo
+        {
+            get { return m_SeqNo; }
+            set { m_SeqNo = value; }
+        }
+        /// <summary>
+        /// 経費名称コード
+        /// </summary>
+        public int NameCode
+        {
+            get { return m_NameCode; }
+            set { m_NameCode = value; }
+        }
+        /// <summary>
+        /// 経費率
+        /// </summary>
+        public double ExpensesRaito
+        {
+            get { return m_ExpensesRaito; }
+            set { m_ExpensesRaito = value; }
+        }
+        /// <summary>
+        /// 会社経費合計
+        /// </summary>
+        public long ExpensesValue
+        {
+            get { return m_ExpensesValue; }
+            set { m_ExpensesValue = value; }
+        }
+
+        /// <summary>
+        /// 登録日付
+        /// </summary>
+        public DateTime EntryDate
+        {
+            set { m_EntryDate = value; }
+            get { return m_EntryDate; }
+        }
+        /// <summary>
+        /// 更新日付
+        /// </summary>
+        public DateTime UpdateDate
+        {
+            set { m_UpdateDate = value; }
+            get { return m_UpdateDate; }
+        }
+        #endregion
+    }
+}
Index: branches/src/ProcessManagement/ProcessManagement/DataModel/DepartmentExpenses.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/DataModel/DepartmentExpenses.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/DataModel/DepartmentExpenses.cs	(revision 341)
@@ -14,6 +14,7 @@
         private int         m_DepartmentCode = 0;	            // 工事種別コード
         private int         m_ExpensesPeriod = 0;               // 事業期
         private int         m_NameCode = 0;	                    // 経費区分コード
+        private string      m_NameString = string.Empty;        // 経費名称
 
         private int         m_DisplayOrder = 0;	                // 表示順
         private double      m_ExpensesRaito = 0;	            // 経費率
@@ -51,6 +52,14 @@
             set { m_NameCode = value; }
         }
         /// <summary>
+        /// 経費名称
+        /// </summary>
+        public string NameString
+        {
+            get { return m_NameString; }
+            set { m_NameString = value; }
+        }
+        /// <summary>
         /// 表示順
         /// </summary>
         public int DisplayOrder
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalList/FrmApprovalListAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalList/FrmApprovalListAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalList/FrmApprovalListAuxiliary.cs	(revision 341)
@@ -960,12 +960,12 @@
             strSQL.Append(" ifnull(DEP.DISPLAYORDER, 99999),");
             strSQL.Append(" PERSON.DISPLAYORDER");
             strSQL.Append(" FROM PROCESSAPPROVAL A");
-            strSQL.Append(" , CONSTRUCTIONBASEINFO B");
+            strSQL.Append(", CONSTRUCTIONBASEINFO B");
             strSQL.Append(" LEFT JOIN DEPARTMENTMASTER DEP On DEP.DepartmentCode = B.ConstrDepCode");
             strSQL.Append(" Left Join CONSTRUCTIONBASEINFODETAIL DepName On DepName.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE");
             strSQL.AppendFormat(" And DepName.DetailNo = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstrDepartmentName);
-            strSQL.Append(" , CONSTRUCTIONBASEINFODETAIL C");
-            strSQL.Append(" , PERSONINCHARGEMASTER PERSON");
+            strSQL.Append(", CONSTRUCTIONBASEINFODETAIL C");
+            strSQL.Append(", PERSONINCHARGEMASTER PERSON");
 
             strSQL.AppendFormat(" WHERE A.APPROVALCODE = {0} AND A.SEQNO = 1", m_ApprovalCode);
             strSQL.Append(" AND A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/DataChange.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/DataChange.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/DataChange.cs	(revision 341)
@@ -412,7 +412,7 @@
                 strSQL.Append(" FROM CONSTRUCTIONBASEINFO A");
                 strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER C ON C.PERSONCODE = A.CONSTRSUBPERSONCODE");
                 strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER D ON D.PERSONCODE = A.CONSTRUCTIONINSTRUCTOR");
-                strSQL.Append(" , PERSONINCHARGEMASTER B");
+                strSQL.Append(", PERSONINCHARGEMASTER B");
                 strSQL.AppendFormat(" LEFT JOIN DEPARTMENTEXPENSESMASTER E ON E.DEPARTMENTCODE = B.DEPARTMENTCODE AND E.EXPENSESPERIOD = {0} AND E.NAMECODE = 3", ConstrPeriod);
                 strSQL.AppendFormat(" LEFT JOIN DIVISIONMASTER E1 ON E1.DIVISIONCODE = {0} AND E1.NAMECODE = E.NAMECODE", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);
                 strSQL.AppendFormat(" LEFT JOIN DEPARTMENTEXPENSESMASTER F ON F.DEPARTMENTCODE = B.DEPARTMENTCODE AND F.EXPENSESPERIOD = {0} AND F.NAMECODE = 1", ConstrPeriod);
@@ -643,42 +643,6 @@
         }
         #endregion
 
-        #region �o����X�g�擾����
-        /// <summary>
-        /// �o����X�g���擾����
-        /// </summary>
-        /// <returns></returns>
-        private bool GetExpensesList(int DepartmentCode, ref ArrayList ExpensesList)
-        {
-            IOMDepartmentExpenses expDB = new IOMDepartmentExpenses();
-            try
-            {
-                // �����o��}�X�^�擾
-                StringBuilder strSQL = new StringBuilder();
-                strSQL.Append("SELECT A.NAMESTRING, IFNULL(B.EXPENSESRAITO, 0), B.NAMECODE");
-                strSQL.Append(" FROM DIVISIONMASTER A");
-                strSQL.Append(" LEFT OUTER JOIN");
-                strSQL.AppendFormat(" (SELECT NAMECODE, DEPARTMENTCODE, EXPENSESRAITO FROM DEPARTMENTEXPENSESMASTER WHERE DEPARTMENTCODE = {0}) B", DepartmentCode);
-                strSQL.Append(" ON A.NAMECODE = B.NAMECODE");
-                strSQL.AppendFormat(" WHERE A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);
-                strSQL.Append(" ORDER BY A.DISPLAYORDER");
-                if (!expDB.ExecuteReader(strSQL.ToString(), ref ExpensesList)) return false;
-                if (ExpensesList.Count == 0) return false;
-
-                return true;
-            }
-            catch (Exception ex)
-            {
-                logger.ErrorFormat("�V�X�e���G���[�F{0}�F{1}", CommonMotions.GetMethodName(), ex.Message);
-                return false;
-            }
-            finally
-            {
-                expDB.close(); expDB = null;
-            }
-        }
-        #endregion
-
         #region �H���\�Z���F�f�[�^�ύX
         /// <summary>
         /// �H���\�Z���F�f�[�^�ύX
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/FrmConstructionBaseInfo.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/FrmConstructionBaseInfo.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/FrmConstructionBaseInfo.cs	(revision 341)
@@ -1424,9 +1424,12 @@
                     SeeModeLock();
                 }
 
-                // ���������{�^���\��
-                DispbtnRestore();
+                // �����m�F�����W�I�{�^���̃��b�N
+                RadioButtonLockProc();
 
+                // �ŏI�{�^���\������
+                DspSpecialProc();
+
                 // �����\���̂��̑�����
                 InitOtherProcess();
 
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/FrmConstructionBaseInfoAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/FrmConstructionBaseInfoAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/FrmConstructionBaseInfoAuxiliary.cs	(revision 341)
@@ -744,10 +744,10 @@
                 strSQL.Append(" AND A.SeqNo = 1");
                 strSQL.Append(" GROUP BY");
                 strSQL.Append(" A.ApprovalCode");
-                strSQL.Append(" , A.OrderNo");
+                strSQL.Append(", A.OrderNo");
                 strSQL.Append(" ORDER BY");
                 strSQL.Append(" A.ApprovalCode");
-                strSQL.Append(" , A.OrderNo");
+                strSQL.Append(", A.OrderNo");
             }
             catch (Exception ex)
             {
@@ -1764,7 +1764,7 @@
 
                 strSQL += " LEFT OUTER JOIN CONSTRUCTIONBASEINFODETAIL F ON (F.CONSTRUCTIONCODE = A.FLUCTUATIONCODE";
                 strSQL += string.Format(" AND F.DETAILNO = {0})", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
-                strSQL += " , CONSTRUCTIONBASEINFO B";
+                strSQL += ", CONSTRUCTIONBASEINFO B";
                 strSQL += string.Format(" WHERE A.CONSTRUCTIONCODE = {0}", SearchCode);
 
                 if (bJoin)
@@ -3339,7 +3339,7 @@
                 Rec.ChangePersonCode = CommonMotions.LoginUserData.PersonCode;
 
                 // ����������쐬
-                string strWhere = cpdDB.CreatePrimarykeyString(Rec.ConstructionCode, Rec.ConstructionStatusFlg);
+                string strWhere = cpdDB.CreatePrimarykeyString(Rec.ConstructionCode, Rec.ChangeDate);
 
                 List<ConstructionProgressDate> workList = new List<ConstructionProgressDate>();
                 if (!cpdDB.SelectAction(strWhere, ref workList, false))
@@ -3446,9 +3446,9 @@
                     work.DetailString = ((TextBox)m_DspCtrl[nCrtlCnt]).Text;
 
                     // �f�[�^�̗L���𔻒�
-                    ConstructionBaseInfoDetail CurRec = oldDetail.Find(x => x.DetailNo == work.DetailNo);
-
-                    if (CurRec == null)
+                    ConstructionBaseInfoDetail[] CurRec = oldDetail.Cast<ConstructionBaseInfoDetail>()
+                                                                    .Where(x => x.DetailNo == work.DetailNo).ToArray();
+                    if (CurRec.Count() < 1 && work.DetailString.Length > 0)
                     {
                         // �f�[�^���Ȃ��ꍇ�F�f�[�^�V�K�o�^
                         if (!cbidDB.InsertAction(work, false))
@@ -3459,8 +3459,11 @@
                         continue;
                     }
 
+                    // ���̃f�[�^�������ꍇ�͏������Ȃ�
+                    if(CurRec.Count() < 1) continue;
+
                     // �f�[�^������ꍇ�F���e���Ⴆ�΍X�V�o�^
-                    if (CurRec.DetailString == work.DetailString) continue;
+                    if (CurRec[0].DetailString == work.DetailString) continue;
 
                     if (!cbidDB.UpdateFeild(work.ConstructionCode
                                             , (int)IOConstructionBaseInfoDetail.TableColumn.DETAILSTRING
@@ -5287,14 +5290,40 @@
         }
         #endregion
 
-        #region ���������{�^���\��
+        #region �����m�F�����W�I�{�^���̃��b�N
         /// <summary>
-        /// ���������{�^���\��
+        /// �����m�F�����W�I�{�^���̃��b�N
         /// </summary>
-        private void DispbtnRestore()
+        private void RadioButtonLockProc()
         {
             try
             {
+                // �����m�F���͈ȊO�͏������Ȃ�
+                if (!rdbStatus10.Checked) return;
+
+                // �i�����W�I�{�^����S�ă��b�N����
+                foreach (Control CurCtrl in panel5.Controls)
+                {
+                    // ���W�I�{�^���ȊO�͏������Ȃ�
+                    if (!CurCtrl.GetType().Equals(typeof(RadioButton))) continue;
+                    CurCtrl.Enabled = false;
+                }
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("�V�X�e���G���[�F{0}�F{1}", CommonMotions.GetMethodName(), ex.Message);
+            }
+        }
+        #endregion
+
+        #region �ŏI�{�^���\������
+        /// <summary>
+        /// �ŏI�{�^���\������
+        /// </summary>
+        private void DspSpecialProc()
+        {
+            try
+            {
                 // �ō��ӔC�҈ȊO�͏������Ȃ�
                 int SRank = (int)CommonDefine.SecurityRankPos.SpecialAuthority;
                 if (CommonMotions.LoginUserSecurity.SecRank != CommonDefine.SecurityRankList[SRank].Key) return;
@@ -5362,10 +5391,40 @@
         private void BillingStatusChage()
         {
             IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();
+            IOConstructionProgressDate cpdDB = new IOConstructionProgressDate();
             try
             {
+                BaseDB.connect(); BaseDB.beginTran();
+                cpdDB.connect(); cpdDB.beginTran();
+
+                // �H������ԕύX
                 int nCode = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("��������")).Key;
-                BaseDB.UpdateFeild(m_ConstructionCode, (int)IOConstructionBaseInfo.TableColumn.ConstructionStatusFlg, nCode);
+                int BeforeStatus = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("�����m�F")).Key;
+                if (!BaseDB.UpdateFeild(m_ConstructionCode, (int)IOConstructionBaseInfo.TableColumn.ConstructionStatusFlg, nCode, false))
+                {
+                    MessageBox.Show("�H������ԁF��ԕύX�Ɏ��s���܂����B", "�X�V�G���[", MessageBoxButtons.OK, MessageBoxIcon.Error);
+                    BaseDB.rollback();
+                    cpdDB.rollback();
+                    return;
+                }
+
+                // �H���i����Ԓǉ�
+                ConstructionProgressDate Rec = new ConstructionProgressDate();
+                Rec.ConstructionCode = CommonMotions.cnvIntFromStringCode(m_DspCtrl[(int)DspCnt.ConstructionCode].Text, "-");
+                Rec.ConstructionStatusFlg = nCode;
+                Rec.PreviousStatusFlg = BeforeStatus;
+                Rec.ChangeDate = DateTime.Now;
+                Rec.ChangePersonCode = CommonMotions.LoginUserData.PersonCode;
+                if (!cpdDB.InsertAction(Rec, false))
+                {
+                    MessageBox.Show("�Č��i�����t�f�[�^�F�ǉ��o�^�Ɏ��s���܂����B", "�o�^�G���[", MessageBoxButtons.OK, MessageBoxIcon.Error);
+                    BaseDB.rollback();
+                    cpdDB.rollback();
+                    return;
+                }
+
+                BaseDB.commit();
+                cpdDB.commit();
             }
             catch (Exception ex)
             {
@@ -5374,6 +5433,7 @@
             finally
             {
                 BaseDB.close(); BaseDB = null;
+                cpdDB.close(); cpdDB = null;
             }
         }
         #endregion
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBudget/FrmConstructionBudgetAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBudget/FrmConstructionBudgetAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBudget/FrmConstructionBudgetAuxiliary.cs	(revision 341)
@@ -237,30 +237,14 @@
         /// <returns></returns>
         private bool GetExpensesList()
         {
-            IOMDepartmentExpenses expDB = new IOMDepartmentExpenses();
-            IOMPersonInCharge picDB = new IOMPersonInCharge();
             try
             {
-                // 工事担当者マスタ取得
-                string strPerson = picDB.CreatePrimarykeyString(m_Constructor);
-                PersonInChargeMaster picRec = new PersonInChargeMaster();
-                if(!picDB.SelectAction(strPerson,ref picRec)) return false;
+                int nPreiod = m_ConstructionBaseInfo.ConstructionPeriod;
+                int nDepartmentCode = m_ConstructionBaseInfo.ConstrDepCode;
 
-                m_ExpensesList.Clear();
                 // 部署経費率マスタ取得
-                string strSQL = "SELECT A.NAMESTRING, IFNULL(B.EXPENSESRAITO, 0), B.NAMECODE";
-                strSQL += " FROM DIVISIONMASTER A";
-                strSQL += " LEFT OUTER JOIN";
-                strSQL += " (SELECT NAMECODE, DEPARTMENTCODE, EXPENSESRAITO, EXPENSESPERIOD";
-                strSQL += string.Format(" FROM DEPARTMENTEXPENSESMASTER WHERE DEPARTMENTCODE = {0}) B", picRec.DepartmentCode);
-                strSQL += " ON A.NAMECODE = B.NAMECODE";
-                strSQL += string.Format(" AND B.EXPENSESPERIOD = {0}", m_ConstructionBaseInfo.ConstructionPeriod);
-                strSQL += string.Format(" WHERE A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);
-                strSQL += " ORDER BY A.DISPLAYORDER";
-                if (!expDB.ExecuteReader(strSQL, ref m_ExpensesList)) return false;
-                if (m_ExpensesList.Count == 0) return false;
+                return CommonMotions.GetExpensesList(nPreiod, nDepartmentCode, ref m_ExpensesList);
 
-                return true;
             }
             catch (Exception ex)
             {
@@ -267,11 +251,6 @@
                 logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
                 return false;
             }
-            finally
-            {
-                expDB.close(); expDB = null;
-                picDB.close(); picDB = null;
-            }
         }
         #endregion
 
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionJoin/FrmConstructionJoinAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionJoin/FrmConstructionJoinAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionJoin/FrmConstructionJoinAuxiliary.cs	(revision 341)
@@ -632,7 +632,7 @@
                 strSQL += " FROM CONSTRUCTIONLINK A";
                 strSQL += " LEFT JOIN CONSTRUCTIONBASEINFODETAIL B ON B.CONSTRUCTIONCODE = A.FLUCTUATIONCODE";
                 strSQL += string.Format(" AND B.DETAILNO = {0}", (int)IOConstructionBaseInfoDetail.TableColumn.DETAILSTRING);
-                strSQL += " , CONSTRUCTIONBASEINFODETAIL C";
+                strSQL += ", CONSTRUCTIONBASEINFODETAIL C";
 
                 if (JoinFlg)
                 {
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedger/FrmConstructionLedgerAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedger/FrmConstructionLedgerAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedger/FrmConstructionLedgerAuxiliary.cs	(revision 341)
@@ -112,29 +112,13 @@
         /// <returns></returns>
         private bool GetExpensesList()
         {
-            IOMDepartmentExpenses expDB = new IOMDepartmentExpenses();
-            IOMPersonInCharge picDB = new IOMPersonInCharge();
             try
             {
-                // 工事担当者マスタ取得
-                string strPerson = picDB.CreatePrimarykeyString(m_ConstructionBaseInfo.ConstructionPersonCode);
-                PersonInChargeMaster picRec = new PersonInChargeMaster();
-                if (!picDB.SelectAction(strPerson, ref picRec)) return false;
+                int nPreiod = m_ConstructionBaseInfo.ConstructionPeriod;
+                int nDepartmentCode = m_ConstructionBaseInfo.ConstrDepCode;
 
                 // 部署経費率マスタ取得
-                string strSQL = "SELECT A.NAMESTRING, IFNULL(B.EXPENSESRAITO, 0), B.NAMECODE";
-                strSQL += " FROM DIVISIONMASTER A";
-                strSQL += " LEFT OUTER JOIN";
-                strSQL += " (SELECT NAMECODE, DEPARTMENTCODE, EXPENSESRAITO, EXPENSESPERIOD";
-                strSQL += string.Format(" FROM DEPARTMENTEXPENSESMASTER WHERE DEPARTMENTCODE = {0}) B", picRec.DepartmentCode);
-                strSQL += " ON A.NAMECODE = B.NAMECODE";
-                strSQL += string.Format(" AND B.EXPENSESPERIOD = {0}", m_ConstructionBaseInfo.ConstructionPeriod);
-                strSQL += string.Format(" WHERE A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);
-                strSQL += " ORDER BY A.DISPLAYORDER";
-                if (!expDB.ExecuteReader(strSQL, ref m_ExpensesList)) return false;
-                if (m_ExpensesList.Count == 0) return false;
-
-                return true;
+                return CommonMotions.GetExpensesList(nPreiod, nDepartmentCode, ref m_ExpensesList);
             }
             catch (Exception ex)
             {
@@ -141,11 +125,6 @@
                 logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
                 return false;
             }
-            finally
-            {
-                expDB.close(); expDB = null;
-                picDB.close(); picDB = null;
-            }
         }
         #endregion
 
@@ -4166,6 +4145,7 @@
             IOConstructionLedger LedgerDB = new IOConstructionLedger();
             IOConstructionLedgerDetail DetailDB = new IOConstructionLedgerDetail();
             IOConstructionLedgerExcute ExcuteDB = new IOConstructionLedgerExcute();
+            IOConstrLedgerExpenses ExpDB = new IOConstrLedgerExpenses();
             IOPurchaseOrderDetail PDetailDB = new IOPurchaseOrderDetail();
             IOBillingDataDetail BDetailDB = new IOBillingDataDetail();
             try
@@ -4185,6 +4165,7 @@
                 ExcuteDB.connect(); ExcuteDB.beginTran();
                 PDetailDB.connect(); PDetailDB.beginTran();
                 BDetailDB.connect(); BDetailDB.beginTran();
+                ExpDB.connect(); ExpDB.beginTran();
 
                 // 詳細台帳データ
                 if (!ConstructionLedgerDataEntry(LedgerDB))
@@ -4214,10 +4195,23 @@
                     return false;
                 }
 
+                // 工事詳細台帳経費データ登録
+                if (!ConstrLedgerExpensesEntry(ExpDB))
+                {
+                    LedgerDB.rollback();
+                    DetailDB.rollback();
+                    ExcuteDB.rollback();
+                    ExpDB.rollback();
+                    PDetailDB.rollback();
+                    BDetailDB.rollback();
+                    return false;
+                }
+
                 // データ更新
                 LedgerDB.commit();
                 DetailDB.commit();
                 ExcuteDB.commit();
+                ExpDB.commit();
                 PDetailDB.commit();
                 BDetailDB.commit();
 
@@ -4236,6 +4230,7 @@
                 LedgerDB.close(); LedgerDB = null;
                 DetailDB.close(); DetailDB = null;
                 ExcuteDB.close(); ExcuteDB = null;
+                ExpDB.close(); ExpDB = null;
                 PDetailDB.close(); PDetailDB = null;
                 BDetailDB.close(); BDetailDB = null;
             }
@@ -4242,38 +4237,6 @@
         }
         #endregion
 
-        #region 経費を探す
-        /// <summary>
-        /// 経費を名称から探す
-        /// </summary>
-        /// <param name="Terget"></param>
-        /// <returns></returns>
-        private int GetExpenss(string Terget,int ExpensesCode)
-        {
-            try
-            {
-                int LineRet = 0;
-
-                DataGridView dgv = dgvAllDisplay;
-                for (int i = 0; i < m_CostsRowCount[(int)CostsRowLine.PurchaseCostsRowLine]; i++)
-                {
-                    if (CommonMotions.cnvString(dgv.Rows[i].Cells[(int)GridColumn.ItemName].Value).IndexOf(Terget) >= 0 ||
-                        CommonMotions.cnvInt(dgv.Rows[i].Cells[(int)GridColumn.ComponentCode].Value) == ExpensesCode)
-                    {
-                        LineRet = i;
-                        break;
-                    }
-                }
-                return LineRet;
-            }
-            catch (System.Exception ex)
-            {
-                logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
-                return 0;
-            }
-        }
-        #endregion
-
         // ---------- データ登録↓↓
         #region 工事詳細台帳データ登録
         /// <summary>
@@ -4318,33 +4281,33 @@
                 // 契約工期完了
                 work.ConstructionEnd = CommonMotions.cnvDate(m_DspLabelCtrl[(int)DspLblCtrlName.CompleteDate].Text);
                 // 税抜受注決定金額
-                string strwork = m_DspLabelCtrl[(int)DspLblCtrlName.OrdersPrice].Text;
-                work.OrdersDecisionPrice = CommonMotions.cnvDouble(strwork);
-                int Rowcnt1 = GetExpenss("会社", 3);
-                int Rowcnt2 = GetExpenss("部署", 2);
-                int Rowcnt3 = GetExpenss("営業", 1);
-                for (int i = (int)GridColumn.Payment; i < TotalPoint; i++)
-                {
-                    // 会社経費合計
-                    work.CompanyExpenses += CommonMotions.cnvDouble(dgv.Rows[Rowcnt1].Cells[i].Value);
-                    // 部署経費合計
-                    work.DepartmentExpenses += CommonMotions.cnvDouble(dgv.Rows[Rowcnt2].Cells[i].Value);
-                    // 営業経費合計
-                    work.SalesExpenses += CommonMotions.cnvDouble(dgv.Rows[Rowcnt3].Cells[i].Value);
-                }
+                work.OrdersDecisionPrice = CommonMotions.cnvDouble(m_DspLabelCtrl[(int)DspLblCtrlName.OrdersPrice].Text);
 
+                //int Rowcnt1 = GetExpenss("会社", 3);
+                //int Rowcnt2 = GetExpenss("部署", 2);
+                //int Rowcnt3 = GetExpenss("営業", 1);
+                //for (int i = (int)GridColumn.Payment; i < TotalPoint; i++)
+                //{
+                //    // 会社経費合計
+                //    work.CompanyExpenses += CommonMotions.cnvDouble(dgv.Rows[Rowcnt1].Cells[i].Value);
+                //    // 部署経費合計
+                //    work.DepartmentExpenses += CommonMotions.cnvDouble(dgv.Rows[Rowcnt2].Cells[i].Value);
+                //    // 営業経費合計
+                //    work.SalesExpenses += CommonMotions.cnvDouble(dgv.Rows[Rowcnt3].Cells[i].Value);
+                //}
+
                 // 受注金額積算フラグ
                 if (CommonMotions.CheckCreateLedgerData(m_ConstructionBaseInfo.ConstructionStatusFlg, m_ConstructionBaseInfo.ConstructionType))
                     work.IntegrationFlg = (int)CommonDefine.LedgerIntegration.Integration;
 
-                // 経費を取得する
-                int endRow = m_CostsRowCount[(int)CostsRowLine.ConstructionCostLine];
-                double bworkExpenses = 0;
-                for (int i = 0; i < endRow; i++)
-                {
-                    // 集計する
-                    bworkExpenses += CommonMotions.cnvDouble(dgv.Rows[i].Cells[(int)GridColumn.ExecPrice].Value);
-                }
+                //// 経費を取得する
+                //int endRow = m_CostsRowCount[(int)CostsRowLine.ConstructionCostLine];
+                //double bworkExpenses = 0;
+                //for (int i = 0; i < endRow; i++)
+                //{
+                //    // 集計する
+                //    bworkExpenses += CommonMotions.cnvDouble(dgv.Rows[i].Cells[(int)GridColumn.ExecPrice].Value);
+                //}
 
                 // 担当者給与
                 int PayrollRow = m_CostsRowCount[(int)CostsRowLine.PayrollRowLine];
@@ -4463,6 +4426,82 @@
         }
         #endregion
 
+        #region 工事詳細台帳経費データ登録
+        /// <summary>
+        /// 工事詳細台帳経費データ登録
+        /// </summary>
+        private bool ConstrLedgerExpensesEntry(IOConstrLedgerExpenses ExpDB)
+        {
+            try
+            {
+                DataGridView dgv = dgvAllDisplay;
+
+                // 経費データを取得する
+                int nGroupCount = (int)GridColumn.GroupCount;
+                int nLineCnt = (int)GridColumn.DataLineCount;
+                int nFixFlg = (int)GridColumn.FixFlg;
+                DataGridViewRow[] RowList = dgv.Rows.Cast<DataGridViewRow>()
+                                                    .Where(x => CommonMotions.cnvInt(x.Cells[nGroupCount].Value) == (int)DataGroup.Expenses
+                                                            && CommonMotions.cnvString(x.Cells[nFixFlg].Value) == string.Empty)
+                                                    .OrderBy(y => CommonMotions.cnvInt(y.Cells[nLineCnt].Value))
+                                                    .ToArray();
+                int nCnt = 1;
+                StringBuilder strSQL = new StringBuilder();
+                List<ConstrLedgerExpenses> workList = new List<ConstrLedgerExpenses>();
+                foreach (DataGridViewRow CurRow in RowList)
+                {
+                    ConstrLedgerExpenses CurRec = new ConstrLedgerExpenses();
+                    CurRec.ConstructionCode = m_ConstructionCode;                       // 工事コード
+                    CurRec.SeqNo = (nCnt++);                                            // 枝番
+                    int RCnt = (int)GridColumn.ComponentCode;                           // 経費コード
+                    CurRec.NameCode = CommonMotions.cnvInt(CurRow.Cells[RCnt].Value);
+                    RCnt = (int)GridColumn.Percent;                                     // 経費率
+                    CurRec.ExpensesRaito = CommonMotions.cnvDouble(CurRow.Cells[RCnt].Value); 
+                    RCnt = dgv.ColumnCount + (int)ColPayTotal.Totals;                   // 経費金額
+                    CurRec.ExpensesValue = CommonMotions.cnvLong(CurRow.Cells[RCnt].Value);
+
+                    strSQL.Clear();
+                    strSQL.Append(ExpDB.CreatePrimarykeyString(CurRec.ConstructionCode, 0, CurRec.NameCode));
+                    workList.Clear();
+                    if (!ExpDB.SelectAction(strSQL.ToString(), ref workList, false))
+                    {
+                        MessageBox.Show("工事詳細台帳経費データ：登録確認に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
+                        return false;
+                    }
+
+                    // 積算予算書データデータ登録
+                    if (workList.Count == 0)
+                    {
+                        // データがない場合・データ登録
+                        if (!ExpDB.InsertAction(CurRec, false))
+                        {
+                            MessageBox.Show("工事詳細台帳経費データ：追加登録に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
+                            return false;
+                        }
+                    }
+                    else
+                    {
+                        // データがある場合
+                        // データ更新
+                        if (!ExpDB.UpdateAction(strSQL.ToString(), CurRec, false))
+                        {
+                            MessageBox.Show("工事詳細台帳経費データ：更新登録に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
+                            return false;
+                        }
+                    }
+
+                }
+
+                return true;
+            }
+            catch (System.Exception ex)
+            {
+                logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
+                return false;
+            }
+        }
+        #endregion
+
         #region 工事詳細台帳データ明細登録
         /// <summary>
         /// 工事詳細台帳データ明細登録
@@ -7647,10 +7686,10 @@
                 // 検索キー追加
                 for (int i = 0; i < m_JoiningCodeList.Count; i++)
                 {
-                    if (i != 0) strCopy += " ,";
+                    if (i != 0) strCopy += ", ";
                     strCopy += string.Format("{0}", m_JoiningCodeList[i]);
 
-                    if (i != 0) strRemove += " ,";
+                    if (i != 0) strRemove += ", ";
                     strRemove += string.Format("{0}", m_JoiningCodeList[i]);
                 }
                 strCopy += ")";
@@ -8432,26 +8471,26 @@
         //    {
         //        // ------ 通常分
         //        string strSQL = "SELECT A.CONSTRUCTIONCODE";
-        //        strSQL += " , B.CreatorCode B1";
-        //        strSQL += " , B.SalaryFlg B2";
-        //        strSQL += " , B.SalaryDays B3";
-        //        strSQL += " , B.AssistantCode B4";
-        //        strSQL += " , B.A_SalaryFlg B5";
-        //        strSQL += " , B.A_SalaryDays B6";
-        //        strSQL += " , B.InstructorCode B7";
-        //        strSQL += " , B.I_SalaryFlg B8";
-        //        strSQL += " , B.I_SalaryDays B9";
-        //        strSQL += " , C.CONSTRUCTIONPERSONCODE C10";
-        //        strSQL += " , C.CONSTRSUBPERSONCODE C11";
-        //        strSQL += " , C.CONSTRUCTIONINSTRUCTOR C12";
-        //        strSQL += " , C.CONSTRUCTIONPERIODSTART C13";
-        //        strSQL += " , C.CONSTRUCTIONPERIODSTART2 C14";
-        //        strSQL += " , C.CONSTRUCTIONPERIODEND C15";
-        //        strSQL += " , C.CONSTRUCTIONPERIODEND2 C16";
-        //        strSQL += " , C.CONSTRUCTIONPERIOD C17";
-        //        strSQL += " , count(*)";
+        //        strSQL += ", B.CreatorCode B1";
+        //        strSQL += ", B.SalaryFlg B2";
+        //        strSQL += ", B.SalaryDays B3";
+        //        strSQL += ", B.AssistantCode B4";
+        //        strSQL += ", B.A_SalaryFlg B5";
+        //        strSQL += ", B.A_SalaryDays B6";
+        //        strSQL += ", B.InstructorCode B7";
+        //        strSQL += ", B.I_SalaryFlg B8";
+        //        strSQL += ", B.I_SalaryDays B9";
+        //        strSQL += ", C.CONSTRUCTIONPERSONCODE C10";
+        //        strSQL += ", C.CONSTRSUBPERSONCODE C11";
+        //        strSQL += ", C.CONSTRUCTIONINSTRUCTOR C12";
+        //        strSQL += ", C.CONSTRUCTIONPERIODSTART C13";
+        //        strSQL += ", C.CONSTRUCTIONPERIODSTART2 C14";
+        //        strSQL += ", C.CONSTRUCTIONPERIODEND C15";
+        //        strSQL += ", C.CONSTRUCTIONPERIODEND2 C16";
+        //        strSQL += ", C.CONSTRUCTIONPERIOD C17";
+        //        strSQL += ", count(*)";
         //        strSQL += " FROM CONSTRUCTIONLEDGER A LEFT JOIN CONSTRUCTIONBUDGET B ON A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE";
-        //        strSQL += " , CONSTRUCTIONBASEINFO C";
+        //        strSQL += ", CONSTRUCTIONBASEINFO C";
         //        strSQL += " WHERE A.CONSTRUCTIONCODE = C.CONSTRUCTIONCODE";
         //        strSQL += " GROUP BY A.CONSTRUCTIONCODE, B.CreatorCode, B.AssistantCode, B.InstructorCode, B.SalaryFlg, ";
         //        strSQL += " B.SalaryDays, B.A_SalaryFlg, B.A_SalaryDays, B.I_SalaryFlg, B.I_SalaryDays, ";
@@ -8505,28 +8544,28 @@
 
         //        // ------ 工事増減分
         //        strSQL = "SELECT A.CONSTRUCTIONCODE";
-        //        strSQL += " , B.CreatorCode B1";
-        //        strSQL += " , B.SalaryFlg B2";
-        //        strSQL += " , B.SalaryDays B3";
-        //        strSQL += " , B.AssistantCode B4";
-        //        strSQL += " , B.A_SalaryFlg B5";
-        //        strSQL += " , B.A_SalaryDays B6";
-        //        strSQL += " , B.InstructorCode B7";
-        //        strSQL += " , B.I_SalaryFlg B8";
-        //        strSQL += " , B.I_SalaryDays B9";
-        //        strSQL += " , A.CONSTRUCTIONPERSONCODE C10";
-        //        strSQL += " , A.CONSTRSUBPERSONCODE C11";
-        //        strSQL += " , A.CONSTRUCTIONINSTRUCTOR C12";
-        //        strSQL += " , A.CONSTRUCTIONPERIODSTART C13";
-        //        strSQL += " , A.CONSTRUCTIONPERIODSTART2 C14";
-        //        strSQL += " , A.CONSTRUCTIONPERIODEND C15";
-        //        strSQL += " , A.CONSTRUCTIONPERIODEND2 C16";
-        //        strSQL += " , A.CONSTRUCTIONPERIOD C17";
-        //        strSQL += " , C.CONSTRUCTIONCODE C18";
-        //        strSQL += " , D.COMPANYCODE D19";
-        //        strSQL += " , E.COMPANYCODE E20";
-        //        strSQL += " , F.COMPANYCODE F21";
-        //        strSQL += " , count(*)";
+        //        strSQL += ", B.CreatorCode B1";
+        //        strSQL += ", B.SalaryFlg B2";
+        //        strSQL += ", B.SalaryDays B3";
+        //        strSQL += ", B.AssistantCode B4";
+        //        strSQL += ", B.A_SalaryFlg B5";
+        //        strSQL += ", B.A_SalaryDays B6";
+        //        strSQL += ", B.InstructorCode B7";
+        //        strSQL += ", B.I_SalaryFlg B8";
+        //        strSQL += ", B.I_SalaryDays B9";
+        //        strSQL += ", A.CONSTRUCTIONPERSONCODE C10";
+        //        strSQL += ", A.CONSTRSUBPERSONCODE C11";
+        //        strSQL += ", A.CONSTRUCTIONINSTRUCTOR C12";
+        //        strSQL += ", A.CONSTRUCTIONPERIODSTART C13";
+        //        strSQL += ", A.CONSTRUCTIONPERIODSTART2 C14";
+        //        strSQL += ", A.CONSTRUCTIONPERIODEND C15";
+        //        strSQL += ", A.CONSTRUCTIONPERIODEND2 C16";
+        //        strSQL += ", A.CONSTRUCTIONPERIOD C17";
+        //        strSQL += ", C.CONSTRUCTIONCODE C18";
+        //        strSQL += ", D.COMPANYCODE D19";
+        //        strSQL += ", E.COMPANYCODE E20";
+        //        strSQL += ", F.COMPANYCODE F21";
+        //        strSQL += ", count(*)";
         //        strSQL += " FROM CONSTRUCTIONBASEINFO A, CONSTRUCTIONBUDGET B, CONSTRUCTIONLINK C";
         //        strSQL += " LEFT JOIN CONSTRUCTIONLEDGERDETAIL D ON C.CONSTRUCTIONCODE = D.CONSTRUCTIONCODE AND D.GROUPCOUNT = 11";
         //        strSQL += " LEFT JOIN CONSTRUCTIONLEDGERDETAIL E ON C.CONSTRUCTIONCODE = E.CONSTRUCTIONCODE AND E.GROUPCOUNT = 10";
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedgerList/FrmConstructionLedgerListAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedgerList/FrmConstructionLedgerListAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedgerList/FrmConstructionLedgerListAuxiliary.cs	(revision 341)
@@ -756,7 +756,7 @@
                 strSQL.Append("SELECT A.CONSTRUCTIONPERIOD, P.GROUPCOUNT, SUM(B.PAYMENTAMOUNT)");
                 strSQL.Append(" FROM CONSTRUCTIONLEDGERDETAIL P LEFT JOIN CONSTRUCTIONLEDGEREXCUTE B");
                 strSQL.Append(" ON B.CONSTRUCTIONCODE = P.CONSTRUCTIONCODE AND B.GROUPCOUNT = P.GROUPCOUNT AND B.LINECOUNT = P.LINECOUNT");
-                strSQL.Append(" , CONSTRUCTIONBASEINFO A");
+                strSQL.Append(", CONSTRUCTIONBASEINFO A");
                 strSQL.AppendFormat(" WHERE P.GROUPCOUNT IN ({0}, {1})"
                                     , (int)FrmConstructionLedger.DataGroup.Instructor
                                     , (int)FrmConstructionLedger.DataGroup.Assistant);
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/CopyTargetList/FrmCopyTargetListAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/CopyTargetList/FrmCopyTargetListAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/CopyTargetList/FrmCopyTargetListAuxiliary.cs	(revision 341)
@@ -344,8 +344,8 @@
                 strSQL += " FROM ConstructionBaseInfo A";
                 strSQL += " LEFT JOIN PERSONINCHARGEMASTER E ON A.SalesPersonCode = E.PersonCode";
                 strSQL += " LEFT JOIN PERSONINCHARGEMASTER F ON A.ConstructionPersonCode = F.PersonCode";
-                strSQL += " , ConstructionBaseInfoDetail B";
-                strSQL += " , PERSONINCHARGEMASTER D";
+                strSQL += ", ConstructionBaseInfoDetail B";
+                strSQL += ", PERSONINCHARGEMASTER D";
                 strSQL += " WHERE (A.ConstructionCode = B.ConstructionCode";
                 strSQL += string.Format(" AND B.DETAILNO = {0})", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
                 strSQL += " AND (A.SalesPersonCode = D.PersonCode OR A.ConstructionPersonCode = D.PersonCode";
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/CopyTargetList/FrmNewOrContinueCopy.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/CopyTargetList/FrmNewOrContinueCopy.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/CopyTargetList/FrmNewOrContinueCopy.cs	(revision 341)
@@ -1272,9 +1272,6 @@
                 Rec.ChangeDate = DateTime.Now;
                 Rec.ChangePersonCode = CommonMotions.LoginUserData.PersonCode;
 
-                // 検索文字列作成
-                strWhere = cpdDB.CreatePrimarykeyString(Rec.ConstructionCode, Rec.ConstructionStatusFlg);
-
                 List<ConstructionProgressDate> workList = new List<ConstructionProgressDate>();
                 // データ登録
                 if (!cpdDB.InsertAction(Rec, false))
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/CostomerRegist/FrmCostomerRegistListAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/CostomerRegist/FrmCostomerRegistListAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/CostomerRegist/FrmCostomerRegistListAuxiliary.cs	(revision 341)
@@ -236,16 +236,16 @@
             {
                 strSQL = "SELECT";
                 strSQL += " A.PersonName";
-                strSQL += " ,A.CORPORATESTATUSNAME";
-                strSQL += " ,A.CORPORATESTATUSPOINT";
-                strSQL += " ,A.ORDERERSNAME1";
-                strSQL += " ,A.ORDERERSNAME2";
-                strSQL += " ,C.NAMESTRING";
-                strSQL += " ,DATE_FORMAT(A.CREATEDATE,'%Y/%m/%d')";
-                strSQL += " ,A.CreatePersonCode";
-                strSQL += " ,A.SEQNO";
-                strSQL += " ,A.DepartmentName";
-                strSQL += " ,A.DATAMODE";
+                strSQL += ", A.CORPORATESTATUSNAME";
+                strSQL += ", A.CORPORATESTATUSPOINT";
+                strSQL += ", A.ORDERERSNAME1";
+                strSQL += ", A.ORDERERSNAME2";
+                strSQL += ", C.NAMESTRING";
+                strSQL += ", DATE_FORMAT(A.CREATEDATE,'%Y/%m/%d')";
+                strSQL += ", A.CreatePersonCode";
+                strSQL += ", A.SEQNO";
+                strSQL += ", A.DepartmentName";
+                strSQL += ", A.DATAMODE";
                 strSQL += " FROM COSTOMERREGIST A";
                 strSQL += " LEFT JOIN DIVISIONMASTER C ON C.DIVISIONCODE = 1 AND C.NAMECODE = A.ORDERCOTEGORY";
                 strSQL += string.Format(" WHERE A.PETITIONPERIOD = {0}", numUDConstPro.Value);
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/DRList/FrmDRListAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/DRList/FrmDRListAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/DRList/FrmDRListAuxiliary.cs	(revision 341)
@@ -452,13 +452,13 @@
                 strSQL.Append(strSecurity.ToString());
                 strSQL.Append(" GROUP BY A.CONSTRUCTIONCODE");
                 strSQL.Append(", B.DETAILSTRING");
-                strSQL.Append(" , D.PERSONCODE");
-                strSQL.Append(" , D.PERSONNAME");
-                strSQL.Append(" , E.DEPARTMENTCODE");
-                strSQL.Append(" , E.DEPARTMENTSTRING");
-                strSQL.Append(" , E.DISPLAYORDER");
-                strSQL.Append(" , D.DISPLAYORDER");
-                strSQL.Append(" , F.COMPLATEFLG)");
+                strSQL.Append(", D.PERSONCODE");
+                strSQL.Append(", D.PERSONNAME");
+                strSQL.Append(", E.DEPARTMENTCODE");
+                strSQL.Append(", E.DEPARTMENTSTRING");
+                strSQL.Append(", E.DISPLAYORDER");
+                strSQL.Append(", D.DISPLAYORDER");
+                strSQL.Append(", F.COMPLATEFLG)");
                 // Order by �t��
                 strSQL.Append(" ORDER BY ifnull(COMPLATEFLG, 0) ASC, 8 ASC, 9 ASC, 6 ASC, 7 ASC, 3 ASC");
 
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/DepExpenssList/FrmDepExpenssListAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/DepExpenssList/FrmDepExpenssListAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/DepExpenssList/FrmDepExpenssListAuxiliary.cs	(revision 341)
@@ -716,7 +716,7 @@
                 strSQL.Append("SELECT A.CONSTRUCTIONPERIOD, P.GROUPCOUNT, SUM(B.PAYMENTAMOUNT)");
                 strSQL.Append(" FROM CONSTRUCTIONLEDGERDETAIL P LEFT JOIN CONSTRUCTIONLEDGEREXCUTE B");
                 strSQL.Append(" ON B.CONSTRUCTIONCODE = P.CONSTRUCTIONCODE AND B.GROUPCOUNT = P.GROUPCOUNT AND B.LINECOUNT = P.LINECOUNT");
-                strSQL.Append(" , CONSTRUCTIONBASEINFO A");
+                strSQL.Append(", CONSTRUCTIONBASEINFO A");
                 strSQL.AppendFormat(" WHERE P.GROUPCOUNT IN ({0}, {1})"
                                                 , (int)FrmConstructionLedger.DataGroup.Instructor
                                                 , (int)FrmConstructionLedger.DataGroup.Assistant);
@@ -1118,16 +1118,16 @@
                 strSQL.Append("SELECT");
 
                 strSQL.Append(" C.PERSONCODE");
-                strSQL.Append(" ,C.PERSONNAME");
-                strSQL.Append(" ,C.DISPLAYORDER AS DISPLAYORDER");
-                strSQL.Append(" ,SUM(A.ORDERSDECISIONPRICE)");
-                strSQL.Append(" ,SUM(A.COMPANYEXPENSES)");
-                strSQL.Append(" ,SUM(A.DEPARTMENTEXPENSES)");
-                strSQL.Append(" ,SUM(A.SALESEXPENSES)");
-                strSQL.Append(" ,SUM(A.TOTALPAYMENT)");
-                strSQL.Append(" ,SUM(A.GROSSPROFIT)");
-                strSQL.Append(" ,SUM(A.NETPROFIT)");
-                strSQL.Append(" ,C.EMPLOYEECLASSFLG AS EMPLOYEECLASSFLG");
+                strSQL.Append(", C.PERSONNAME");
+                strSQL.Append(", C.DISPLAYORDER AS DISPLAYORDER");
+                strSQL.Append(", SUM(A.ORDERSDECISIONPRICE)");
+                strSQL.Append(", SUM(A.COMPANYEXPENSES)");
+                strSQL.Append(", SUM(A.DEPARTMENTEXPENSES)");
+                strSQL.Append(", SUM(A.SALESEXPENSES)");
+                strSQL.Append(", SUM(A.TOTALPAYMENT)");
+                strSQL.Append(", SUM(A.GROSSPROFIT)");
+                strSQL.Append(", SUM(A.NETPROFIT)");
+                strSQL.Append(", C.EMPLOYEECLASSFLG AS EMPLOYEECLASSFLG");
 
                 strSQL.Append(" FROM PERSONINCHARGEMASTER AS C");
 
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/DepartmentCost/FrmDepartmentCostListAux.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/DepartmentCost/FrmDepartmentCostListAux.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/DepartmentCost/FrmDepartmentCostListAux.cs	(revision 341)
@@ -679,8 +679,8 @@
 
                     strSQL.Append(" Union Select");
                     strSQL.Append(" A2.ConstrDepCode As DEPARTMENTCODE");
-                    strSQL.Append(" , B2.DetailString As DEPARTMENTSTRING");
-                    strSQL.Append(" , ifnull(C2.DisplayOrder, 10) As DISPLAYORDER");
+                    strSQL.Append(", B2.DetailString As DEPARTMENTSTRING");
+                    strSQL.Append(", ifnull(C2.DisplayOrder, 10) As DISPLAYORDER");
                     strSQL.Append(" From Constructionbaseinfo As A2");
                     strSQL.Append(" Inner Join constructionbaseinfodetail As B2");
                     strSQL.Append("       On B2.ConstructionCode = A2.ConstructionCode");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/EstimateBudget/FrmEstimateBudgetAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/EstimateBudget/FrmEstimateBudgetAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/EstimateBudget/FrmEstimateBudgetAuxiliary.cs	(revision 341)
@@ -1243,7 +1243,7 @@
                 strSQL.AppendFormat(" WHERE CONSTRUCTIONCODE = {0}", m_ConstructionCode);
                 strSQL.AppendFormat(" AND COMPONENTCODE = {0}", ClsCommonCosts.s_CommunityCompCode);    // 共通仮設費を対象にする
                 strSQL.Append(" AND COMPANYCODE != 0");                                                 // 会社割当のあるものを対象
-                strSQL.Append(" ORDER BY PageCount, LineCount");
+                strSQL.Append(" ORDER BY GroupCount, LineCount");
 
                 List<EstimateDataDetail> DetailList = new List<EstimateDataDetail>();
                 if (!DetailDB.SelectAction(strSQL.ToString(), ref DetailList)) return;
@@ -1433,7 +1433,7 @@
                 strSQL.Append(" LEFT JOIN (SELECT E.COMPONENTCODE, E.ITEMCODE, SUM(E.LINETOTAL) TOTAL FROM ESTIMATEDATADETAIL E");
                 strSQL.AppendFormat(" WHERE E.CONSTRUCTIONCODE = {0} GROUP BY E.COMPONENTCODE, E.ITEMCODE) D ON A.ITEMCODE = D.ITEMCODE", m_ConstructionCode);
 
-                strSQL.Append(" , COMMONCOSTLARGE B, COMMONCOSTMIDDLE C");
+                strSQL.Append(", COMMONCOSTLARGE B, COMMONCOSTMIDDLE C");
                 
                 strSQL.AppendFormat(" WHERE A.LARGECODE = {0}", ClsCommonCosts.s_CommunityCompCode);
                 strSQL.Append(" AND A.LARGECODE = B.LARGECODE");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Material/ConstrMATLList/FrmConstrMATLListAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Material/ConstrMATLList/FrmConstrMATLListAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Material/ConstrMATLList/FrmConstrMATLListAuxiliary.cs	(revision 341)
@@ -306,9 +306,9 @@
                     strSQL.Append("     , CA.SALESPERSONCODE As PERSONCODE");
                     strSQL.Append("     , CB.PERSONNAME As PERSONNAME");
                     strSQL.Append("     , ifnull(CA.SalesDepCode, 0) As DEPARTMENTCODE");
-                    strSQL.Append(" , ifnull(CD.DetailString, '') As DEPARTMENTNAME");
-                    strSQL.Append(" , ifnull(CB.DISPLAYORDER, 99999) As MANDISPORDER");
-                    strSQL.Append(" , ifnull(CC.DISPLAYORDER, 99999) As DEPDISPORDER");
+                    strSQL.Append(", ifnull(CD.DetailString, '') As DEPARTMENTNAME");
+                    strSQL.Append(", ifnull(CB.DISPLAYORDER, 99999) As MANDISPORDER");
+                    strSQL.Append(", ifnull(CC.DISPLAYORDER, 99999) As DEPDISPORDER");
                     strSQL.Append(" FROM");
                     strSQL.Append(" CONSTRUCTIONBASEINFO CA");
                     strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER CB");
@@ -325,25 +325,25 @@
                     strSQL.Append(" LEFT JOIN(");
                     strSQL.Append(" SELECT");
                     strSQL.Append(" DA.CONSTRUCTIONCODE");
-                    strSQL.Append(" , DA.CONSTRUCTIONPERSONCODE PERSONCODE");
-                    strSQL.Append(" , DB.PERSONNAME PERSONNAME");
-                    strSQL.Append(" , ifnull(DA.ConstrDepCode, 0) As DEPARTMENTCODE");
-                    strSQL.Append(" , ifnull(DD.DetailString, '') As DEPARTMENTNAME");
-                    strSQL.Append(" , ifnull(DB.DISPLAYORDER, 99999) As MANDISPORDER");
-                    strSQL.Append(" , ifnull(DC.DISPLAYORDER, 99999) As DEPDISPORDER");
+                    strSQL.Append(", DA.CONSTRUCTIONPERSONCODE PERSONCODE");
+                    strSQL.Append(", DB.PERSONNAME PERSONNAME");
+                    strSQL.Append(", ifnull(DA.ConstrDepCode, 0) As DEPARTMENTCODE");
+                    strSQL.Append(", ifnull(DD.DetailString, '') As DEPARTMENTNAME");
+                    strSQL.Append(", ifnull(DB.DISPLAYORDER, 99999) As MANDISPORDER");
+                    strSQL.Append(", ifnull(DC.DISPLAYORDER, 99999) As DEPDISPORDER");
                     strSQL.Append(" FROM");
                     strSQL.Append(" CONSTRUCTIONBASEINFO DA");
                     strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER DB");
                     strSQL.Append(" ON DB.PERSONCODE IN(");
                     strSQL.Append(" DA.CONSTRUCTIONPERSONCODE");
-                    strSQL.Append(" , DA.ConstrSubPersonCode");
-                    strSQL.Append(" , DA.ConstructionInstructor");
+                    strSQL.Append(", DA.ConstrSubPersonCode");
+                    strSQL.Append(", DA.ConstructionInstructor");
                     strSQL.Append(" )");
                     strSQL.Append(" LEFT JOIN DEPARTMENTMASTER DC");
                     strSQL.Append(" ON DC.DEPARTMENTCODE IN(");
                     strSQL.Append(" DA.ConstrDepCode");
-                    strSQL.Append(" , DA.ConstrSubDepCode");
-                    strSQL.Append(" , DA.ConstrInstrDepCode");
+                    strSQL.Append(", DA.ConstrSubDepCode");
+                    strSQL.Append(", DA.ConstrInstrDepCode");
                     strSQL.Append(" )");
                     strSQL.Append(" LEFT JOIN constructionbaseinfodetail As DD");
                     strSQL.Append(" ON DD.ConstructionCode = DA.ConstructionCode");
@@ -440,9 +440,9 @@
                 strSQL.Append("     , CA.SALESPERSONCODE As PERSONCODE");
                 strSQL.Append("     , CB.PERSONNAME As PERSONNAME");
                 strSQL.Append("     , ifnull(CA.SalesDepCode, 0) As DEPARTMENTCODE");
-                strSQL.Append(" , ifnull(CD.DetailString, '') As DEPARTMENTNAME");
-                strSQL.Append(" , ifnull(CB.DISPLAYORDER, 99999) As MANDISPORDER");
-                strSQL.Append(" , ifnull(CC.DISPLAYORDER, 99999) As DEPDISPORDER");
+                strSQL.Append(", ifnull(CD.DetailString, '') As DEPARTMENTNAME");
+                strSQL.Append(", ifnull(CB.DISPLAYORDER, 99999) As MANDISPORDER");
+                strSQL.Append(", ifnull(CC.DISPLAYORDER, 99999) As DEPDISPORDER");
                 strSQL.Append(" FROM");
                 strSQL.Append(" CONSTRUCTIONBASEINFO CA");
                 strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER CB");
@@ -459,25 +459,25 @@
                 strSQL.Append(" LEFT JOIN(");
                 strSQL.Append(" SELECT");
                 strSQL.Append(" DA.CONSTRUCTIONCODE");
-                strSQL.Append(" , DA.CONSTRUCTIONPERSONCODE PERSONCODE");
-                strSQL.Append(" , DB.PERSONNAME PERSONNAME");
-                strSQL.Append(" , ifnull(DA.ConstrDepCode, 0) As DEPARTMENTCODE");
-                strSQL.Append(" , ifnull(DD.DetailString, '') As DEPARTMENTNAME");
-                strSQL.Append(" , ifnull(DB.DISPLAYORDER, 99999) As MANDISPORDER");
-                strSQL.Append(" , ifnull(DC.DISPLAYORDER, 99999) As DEPDISPORDER");
+                strSQL.Append(", DA.CONSTRUCTIONPERSONCODE PERSONCODE");
+                strSQL.Append(", DB.PERSONNAME PERSONNAME");
+                strSQL.Append(", ifnull(DA.ConstrDepCode, 0) As DEPARTMENTCODE");
+                strSQL.Append(", ifnull(DD.DetailString, '') As DEPARTMENTNAME");
+                strSQL.Append(", ifnull(DB.DISPLAYORDER, 99999) As MANDISPORDER");
+                strSQL.Append(", ifnull(DC.DISPLAYORDER, 99999) As DEPDISPORDER");
                 strSQL.Append(" FROM");
                 strSQL.Append(" CONSTRUCTIONBASEINFO DA");
                 strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER DB");
                 strSQL.Append(" ON DB.PERSONCODE IN(");
                 strSQL.Append(" DA.CONSTRUCTIONPERSONCODE");
-                strSQL.Append(" , DA.ConstrSubPersonCode");
-                strSQL.Append(" , DA.ConstructionInstructor");
+                strSQL.Append(", DA.ConstrSubPersonCode");
+                strSQL.Append(", DA.ConstructionInstructor");
                 strSQL.Append(" )");
                 strSQL.Append(" LEFT JOIN DEPARTMENTMASTER DC");
                 strSQL.Append(" ON DC.DEPARTMENTCODE IN(");
                 strSQL.Append(" DA.ConstrDepCode");
-                strSQL.Append(" , DA.ConstrSubDepCode");
-                strSQL.Append(" , DA.ConstrInstrDepCode");
+                strSQL.Append(", DA.ConstrSubDepCode");
+                strSQL.Append(", DA.ConstrInstrDepCode");
                 strSQL.Append(" )");
                 strSQL.Append(" LEFT JOIN constructionbaseinfodetail As DD");
                 strSQL.Append(" ON DD.ConstructionCode = DA.ConstructionCode");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Material/MaterialReserveEntry/FrmMateResEntAux.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Material/MaterialReserveEntry/FrmMateResEntAux.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Material/MaterialReserveEntry/FrmMateResEntAux.cs	(revision 341)
@@ -639,19 +639,19 @@
                 sql.Append("Select");
 
                 sql.AppendLine(" Mkm.MaterialKindCode");
-                sql.AppendLine(" , Mkm.MaterialKindName");
-                sql.AppendLine(" , Mkm.DisplayOrder");
-                sql.AppendLine(" , Mim.MaterialItemCode");
-                sql.AppendLine(" , Mim.MaterialItemName");
-                sql.AppendLine(" , Mim.DisplayOrder");
-                sql.AppendLine(" , ifnull(Mi.RentCount, 0) as RentCount");
-                sql.AppendLine(" , Cmi.RENTCOUNT");
-                sql.AppendLine(" , ifnull(DATE_FORMAT(Mri.RepayPlanDate, '%Y/%m/%d'), '') as RepayPlanDate");
-                sql.AppendLine(" , ifnull(Mri.CommentText, '') as CommentText");
-                sql.AppendLine(" , ifnull(DATE_FORMAT(Cmi.PROCESSDATE, '%Y/%m/%d'), '') as ProcessDate");
-                sql.AppendLine(" , Cmi.REPAYCOUNT");
-                sql.AppendLine(" , Cmi.JUNKCOUNT");
-                sql.AppendLine(" , Cmi.COMPLETEFLG ");
+                sql.AppendLine(", Mkm.MaterialKindName");
+                sql.AppendLine(", Mkm.DisplayOrder");
+                sql.AppendLine(", Mim.MaterialItemCode");
+                sql.AppendLine(", Mim.MaterialItemName");
+                sql.AppendLine(", Mim.DisplayOrder");
+                sql.AppendLine(", ifnull(Mi.RentCount, 0) as RentCount");
+                sql.AppendLine(", Cmi.RENTCOUNT");
+                sql.AppendLine(", ifnull(DATE_FORMAT(Mri.RepayPlanDate, '%Y/%m/%d'), '') as RepayPlanDate");
+                sql.AppendLine(", ifnull(Mri.CommentText, '') as CommentText");
+                sql.AppendLine(", ifnull(DATE_FORMAT(Cmi.PROCESSDATE, '%Y/%m/%d'), '') as ProcessDate");
+                sql.AppendLine(", Cmi.REPAYCOUNT");
+                sql.AppendLine(", Cmi.JUNKCOUNT");
+                sql.AppendLine(", Cmi.COMPLETEFLG ");
                 sql.AppendLine(" From");
                 sql.AppendLine(" ConstructionMaterialInfo as Cmi");
                 sql.AppendLine(" left join MaterialInfo as Mi");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Material/MaterialReturnEntry/FrmMateRetEntAux.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Material/MaterialReturnEntry/FrmMateRetEntAux.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Material/MaterialReturnEntry/FrmMateRetEntAux.cs	(revision 341)
@@ -493,19 +493,19 @@
                 StringBuilder sql = new StringBuilder();
                 sql.AppendLine("select");
                 sql.AppendLine(" Mkm.MaterialKindCode");
-                sql.AppendLine(" , Mkm.MaterialKindName");
-                sql.AppendLine(" , Mkm.DisplayOrder as KindDisp");
-                sql.AppendLine(" , Mim.MaterialItemCode");
-                sql.AppendLine(" , Mim.MaterialItemName");
-                sql.AppendLine(" , Mim.DisplayOrder as ItemDisp");
-                sql.AppendLine(" , Cmi.RENTCOUNT");
-                sql.AppendLine(" , Cmi.REPAYCOUNT");
-                sql.AppendLine(" , Cmi.JUNKCOUNT");
-                sql.AppendLine(" , ifnull(Mri.CommentText, '') as CommentText");
-                sql.AppendLine(" , Cmi.CompleteFlg");
-                sql.AppendLine(" , DATE_FORMAT(Mri.RepayPlanDate, '%Y/%m/%d') as RepayPlanDate");
-                sql.AppendLine(" , DATE_FORMAT(Cmi.ProcessDate, '%Y/%m/%d') as ProcessDate");
-                sql.AppendLine(" , Mri.RECKIND");
+                sql.AppendLine(", Mkm.MaterialKindName");
+                sql.AppendLine(", Mkm.DisplayOrder as KindDisp");
+                sql.AppendLine(", Mim.MaterialItemCode");
+                sql.AppendLine(", Mim.MaterialItemName");
+                sql.AppendLine(", Mim.DisplayOrder as ItemDisp");
+                sql.AppendLine(", Cmi.RENTCOUNT");
+                sql.AppendLine(", Cmi.REPAYCOUNT");
+                sql.AppendLine(", Cmi.JUNKCOUNT");
+                sql.AppendLine(", ifnull(Mri.CommentText, '') as CommentText");
+                sql.AppendLine(", Cmi.CompleteFlg");
+                sql.AppendLine(", DATE_FORMAT(Mri.RepayPlanDate, '%Y/%m/%d') as RepayPlanDate");
+                sql.AppendLine(", DATE_FORMAT(Cmi.ProcessDate, '%Y/%m/%d') as ProcessDate");
+                sql.AppendLine(", Mri.RECKIND");
 
                 sql.AppendLine(" from");
                 sql.AppendLine("   ConstructionMaterialInfo as Cmi");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudget.Designer.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudget.Designer.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudget.Designer.cs	(revision 341)
@@ -52,6 +52,7 @@
             this.label3 = new System.Windows.Forms.Label();
             this.label5 = new System.Windows.Forms.Label();
             this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
+            this.Column9 = new System.Windows.Forms.DataGridViewTextBoxColumn();
             this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
             this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
             this.Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn();
@@ -113,6 +114,7 @@
             this.dgvMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
             this.dgvMain.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
             this.Column1,
+            this.Column9,
             this.Column2,
             this.Column3,
             this.Column4,
@@ -274,6 +276,14 @@
             this.Column1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
             this.Column1.Width = 50;
             // 
+            // Column9
+            // 
+            this.Column9.Frozen = true;
+            this.Column9.HeaderText = "部署コード";
+            this.Column9.Name = "Column9";
+            this.Column9.ReadOnly = true;
+            this.Column9.Visible = false;
+            // 
             // Column2
             // 
             dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
@@ -401,6 +411,7 @@
         private ProcessManagement.Forms.CustomControls.DataGridViewEX dgvMain;
         private System.Windows.Forms.Label lblCellTotal;
         private System.Windows.Forms.DataGridViewTextBoxColumn Column1;
+        private System.Windows.Forms.DataGridViewTextBoxColumn Column9;
         private System.Windows.Forms.DataGridViewTextBoxColumn Column2;
         private System.Windows.Forms.DataGridViewTextBoxColumn Column3;
         private System.Windows.Forms.DataGridViewTextBoxColumn Column4;
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudget.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudget.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudget.cs	(revision 341)
@@ -33,6 +33,7 @@
         private enum GridColumn
         {
             No = 0,
+            DepartmentCode,
             DepartmentName,
             PersonName,
             ConstrCode,
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudget.resx
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudget.resx	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudget.resx	(revision 341)
@@ -120,6 +120,9 @@
   <metadata name="Column1.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
     <value>True</value>
   </metadata>
+  <metadata name="Column9.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
+    <value>True</value>
+  </metadata>
   <metadata name="Column2.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
     <value>True</value>
   </metadata>
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudgetAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudgetAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PriceOfBudget/FrmPriceOfBudgetAuxiliary.cs	(revision 341)
@@ -45,15 +45,24 @@
 
                 // �����H���ԍ����X�g
                 List<int> nConstrCodeList = new List<int>();
-                List<KeyValuePair<int, string>> ExpList = new List<KeyValuePair<int, string>>();
+                List<KeyValuePair<int, string>> ExpNameList = new List<KeyValuePair<int, string>>();
+                List<DepartmentExpenses> DepExpList = new List<DepartmentExpenses>();
+
+                // �o����X�g���擾����
+                GetExpensesList((int)numUDConstPro.Value, ref ExpNameList, ref DepExpList);
+
+                // �O���b�h�Ɍo����쐬����
+                CreateExpensesColumn(ExpNameList);
+
                 // ���v�G���A
-                long[] TotalArea = null;
+                int TotalColCnt = ExpNameList.Count + 1;
+                long[] TotalArea = new long[TotalColCnt];
 
                 // �䒠���쐬�f�[�^�\������
-                SetNotCreateRowData(ref nConstrCodeList, ref ExpList, ref TotalArea);
+                SetNotCreateRowData(DepExpList, ref nConstrCodeList, ref ExpNameList, ref TotalArea);
 
                 // �䒠�f�[�^�\��
-                SetCreateRowData(ExpList, ref TotalArea);
+                SetCreateRowData(ExpNameList, ref TotalArea);
 
                 // �����v��\������
                 DisplayTotalRow((int)RowTitleNum.AllTotal, TotalArea);
@@ -150,7 +159,10 @@
         /// <summary>
         /// �䒠���쐬�f�[�^�\������
         /// </summary>
-        private void SetNotCreateRowData(ref List<int> nConstrCodeList, ref List<KeyValuePair<int, string>> ExpList, ref long[] TotalArea)
+        private void SetNotCreateRowData(List<DepartmentExpenses> DepExpList
+                                        , ref List<int> nConstrCodeList
+                                        , ref List<KeyValuePair<int, string>> ExpList
+                                        , ref long[] TotalArea)
         {
             IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();
             long[] CurTotalArea = null;
@@ -248,26 +260,22 @@
 
                 ArrayList DataArList = new ArrayList();
                 if (!BaseDB.ExecuteReader(strSQL.ToString(), ref DataArList)) return;
-                if (DataArList.Count == 0) return;
+                if (DataArList.Count == 0)
+                {
+                    CurTotalArea = new long[ExpList.Count + 1];
+                    return;
+                }
 
-                
-
                 // �����Ώۃ��X�g�쐬
-                GetProcList(DataArList, ref nConstrCodeList, ref ExpList);
+                GetProcList(DataArList, ref nConstrCodeList);
 
                 DataGridView dgv = dgvMain;
                 dgv.Rows.Clear();
 
-                // �O���b�h�Ɍo����쐬����
-                CreateExpensesColumn(ExpList);
-
                 // ���쐬���v�G���A������
                 int TotalColCnt = ExpList.Count + 1;
                 CurTotalArea = new long[TotalColCnt];
 
-                // �����v�G���A������
-                TotalArea = new long[TotalColCnt];
-
                 int ino = 1;
                 long[] ExpensesVal = new long[TotalColCnt];
 
@@ -286,24 +294,44 @@
 
                     int RowIndex = dgv.Rows.Add(1);
                     DataGridViewRow dgvRow = dgv.Rows[RowIndex];
-                    foreach(DataGridViewCell CurCell in dgvRow.Cells)
+
+                    foreach (DataGridViewCell CurCell in dgvRow.Cells)
                     {
                         switch (CurCell.ColumnIndex)
                         {
-                            case 0:
+                            case (int)GridColumn.No:
                                 CurCell.Value = (ino++);
                                 break;
-                            case 1:                 // ������
-                            case 2:                 // �S���Җ�
-                            case 3:                 // �H���ԍ�
-                            case 4:                 // �H������                 
-                            case 5:                 // �󒍓�
-                            case 6:                 // �{�H���
+                            case (int)GridColumn.DepartmentCode:            // �����R�[�h
+                            case (int)GridColumn.DepartmentName:            // ������
+                            case (int)GridColumn.PersonName:                // �S���Җ�
+                            case (int)GridColumn.ConstrCode:                // �H���ԍ�
+                            case (int)GridColumn.ConstrName:                // �H������                 
+                            case (int)GridColumn.OrderDate:                 // �󒍓�
+                            case (int)GridColumn.ConstrStatus:              // �{�H���
                                 CurCell.Value = DspData[CurCell.ColumnIndex];
                                 break;
-                            default:                // �󒍋��z->�o��S��
+                            case (int)GridColumn.OrdersPrice:               // �󒍋��z
                                 CurCell.Value = CommonMotions.cnvLong(DspData[CurCell.ColumnIndex]).ToString("#,0");
                                 break;
+                            default:                                        // �o��S��
+                                long workCal = CommonMotions.cnvLong(DspData[CurCell.ColumnIndex]);
+                                int tarCode = CommonMotions.cnvInt(DspData[(int)GridColumn.DepartmentCode]);
+
+                                int nKey = ExpList[(CurCell.ColumnIndex - ((int)GridColumn.OrdersPrice + 1))].Key;
+                                DepartmentExpenses[] wrkExpList = DepExpList.Cast<DepartmentExpenses>()
+                                                                            .Where(x => x.DepartmentCode == tarCode
+                                                                                        && x.NameCode == nKey)
+                                                                            .ToArray();
+                                // �o����z�������ĕ����R�[�h������ꍇ
+                                if (wrkExpList != null && workCal < 1 && tarCode > 0)
+                                {
+                                    double workPar = (wrkExpList[0].ExpensesRaito / 100.0);
+                                    workCal = CommonMotions.cnvLong(DspData[(int)GridColumn.OrdersPrice]);
+                                    workCal = (long)CommonMotions.cnvRoundUp((double)workCal * workPar);
+                                }
+                                CurCell.Value = workCal.ToString("#,0");
+                                break;
                         }
                     }
                     // ���쐬���v���Z
@@ -312,6 +340,7 @@
                         CurTotalArea[i] += ExpensesVal[(i)];
                     }
                 }
+
                 // ���v���Z
                 for (int i = 0; i < TotalArea.Length; i++)
                 {
@@ -372,9 +401,7 @@
         /// <summary>
         /// �����Ώۃ��X�g�쐬
         /// </summary>
-        private void GetProcList(ArrayList DatArList
-                                , ref List<int> nConstrCodeList
-                                , ref List<KeyValuePair<int, string>> ExpList)
+        private void GetProcList(ArrayList DatArList, ref List<int> nConstrCodeList)
         {
             try
             {
@@ -388,14 +415,6 @@
                         nConstrCodeList.Add(nCode);
                         BKey1 = nCode;
                     }
-                    // �o��ꗗ�����X�g������
-                    int nExpCode = CommonMotions.cnvInt(objRec[(int)GetDataEnum.ExpCode]);
-                    if (nExpCode < 1) continue;
-                    if (!ExpList.Exists(x => x.Key == nExpCode))
-                    {
-                        string strName = CommonMotions.cnvString(objRec[(int)GetDataEnum.ExpName]);
-                        ExpList.Add(new KeyValuePair<int, string>(nExpCode, strName));
-                    }
                 }
             }
             catch (Exception ex)
@@ -488,6 +507,7 @@
                     }
 
                     // �f�[�^���Z�b�g����
+                    DspData[(int)GridColumn.DepartmentCode] = ObjRec[(int)GetDataEnum.DepCode];         // 0:�����R�[�h
                     DspData[(int)GridColumn.DepartmentName] = ObjRec[(int)GetDataEnum.DepName];         // 1:������
                     DspData[(int)GridColumn.PersonName] = ObjRec[(int)GetDataEnum.ManName];             // 2:�S���Җ�
                     DspData[(int)GridColumn.ConstrCode] = ObjRec[(int)GetDataEnum.ConstrCode];          // 3:�H���ԍ�
@@ -577,13 +597,11 @@
                 strSQL.Append(" FROM");
                 strSQL.Append(" CONSTRUCTIONLEDGER A");
                 strSQL.Append(", CONSTRUCTIONBASEINFO B");
-                strSQL.Append(", PERSONINCHARGEMASTER C");
                 strSQL.Append(" WHERE A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE"); ;
                 strSQL.AppendFormat(" AND B.CONSTRUCTIONPERIOD = {0}", SelectPeriod);
                 strSQL.AppendFormat(" AND B.CONSTRUCTIONSTATUSFLG != {0}", iCode1);
-                strSQL.Append(" AND C.PERSONCODE = B.CONSTRUCTIONPERSONCODE");
-                if (DepartmantCode != 0) strSQL.AppendFormat(" AND C.DEPARTMENTCODE = {0}", DepartmantCode);
-                if (PersonCode != 0) strSQL.AppendFormat(" AND C.PERSONCODE = {0}", PersonCode);
+                if (DepartmantCode != 0) strSQL.AppendFormat(" AND B.ConstrDepCode = {0}", DepartmantCode);
+                if (PersonCode != 0) strSQL.AppendFormat(" AND B.ConstructionPersonCode = {0}", PersonCode);
                 strSQL.Append(" GROUP BY A.COMPLATEFLG");
                 strSQL.Append(" ORDER BY 1");
 
@@ -1059,5 +1077,85 @@
             }
         }
         #endregion
+
+        #region �o����X�g�擾����
+        /// <summary>
+        /// �o����X�g���擾����
+        /// </summary>
+        /// <returns></returns>
+        private bool GetExpensesList(int Preiod
+                                    , ref List<KeyValuePair<int, string>> ExpList
+                                    , ref List<DepartmentExpenses> DepExpList)
+        {
+            IOMDepartmentExpenses expDB = new IOMDepartmentExpenses();
+            try
+            {
+                // �o����̎擾
+                StringBuilder strSQL = new StringBuilder();
+                ArrayList arList = new ArrayList();
+                for(int i = 0; i < 2; i++)
+                {
+                    strSQL.Clear();
+                    switch (i)
+                    {
+                        case 0:
+                            strSQL.Append("Select");
+                            strSQL.Append(" C.*");
+                            strSQL.Append(" From");
+                            strSQL.Append(" constructionbaseinfo AS A");
+                            strSQL.Append(" Inner Join constrledgerexpenses As B");
+                            strSQL.Append(" On B.ConstructionCode = A.ConstructionCode");
+                            strSQL.Append(" Inner join departmentexpensesmaster As C");
+                            strSQL.Append(" On C.DepartmentCode = A.ConstrDepCode");
+                            strSQL.Append(" And C.ExpensesPeriod = A.ConstructionPeriod");
+                            strSQL.Append(" And C.NameCode = B.NameCode");
+                            strSQL.Append(" Where");
+                            strSQL.AppendFormat(" A.ConstructionPeriod = {0}", Preiod);
+                            strSQL.Append(" Group By C.DepartmentCode, C.NameCode");
+                            strSQL.Append(" Order by C.DepartmentCode, C.DisplayOrder");
+                            break;
+                        case 1:
+                            strSQL.Append("Select");
+                            strSQL.Append(" B.*");
+                            strSQL.Append(" From divisionmaster AS A");
+                            strSQL.Append(" Left Join departmentexpensesmaster AS B");
+                            strSQL.Append(" On B.NameCode = A.NameCode");
+                            strSQL.AppendFormat(" Where A.DivisionCode = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);
+                            strSQL.Append(" Group By B.DepartmentCode, B.NameCode");
+                            strSQL.Append(" Order by B.DepartmentCode, A.DisplayOrder");
+                            break;
+                    }
+
+                    arList.Clear();
+                    if (!expDB.ExecuteReader(strSQL.ToString(), ref arList)) return false;
+                    if (arList.Count > 0) break;
+                }
+
+                // �f�[�^�S�Ă��擾����
+                foreach (object[] objRec in arList)
+                {
+                    DepartmentExpenses DepExpRec = new DepartmentExpenses();
+                    expDB.Reader2Struct(objRec, ref DepExpRec);
+                    DepExpList.Add(DepExpRec);
+                }
+
+                foreach(DepartmentExpenses CurRec in DepExpList)
+                {
+                    if (!ExpList.Exists(x => x.Key == CurRec.NameCode))
+                        ExpList.Add(new KeyValuePair<int, string>(CurRec.NameCode, CurRec.NameString));
+                }
+                return true;
+            }
+            catch (Exception ex)
+            {
+                logger.ErrorFormat("�V�X�e���G���[�F{0}�F{1}", CommonMotions.GetMethodName(), ex.Message);
+                return false;
+            }
+            finally
+            {
+                expDB.close(); expDB = null;
+            }
+        }
+        #endregion
     }
 }
\ No newline at end of file
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PurchaseOrderEntry/FrmOrderEntryListAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PurchaseOrderEntry/FrmOrderEntryListAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PurchaseOrderEntry/FrmOrderEntryListAuxiliary.cs	(revision 341)
@@ -181,20 +181,20 @@
             {
                 strSQL.Append(" (SELECT");
                 strSQL.Append(" A.CONSTRUCTIONCODE");
-                strSQL.Append(" , A.FIRSTSTRING");
-                strSQL.Append(" , A.SECONDSTRING");
-                strSQL.Append(" , A.COMPANYCODE AS COMPANYCODE");
-                strSQL.Append(" , A.COMPANYNAME");
-                strSQL.Append(" , SUM(A.EXECUTIONAMOUNT)");
-                strSQL.Append(" , A.SOURCECODE");
-                strSQL.Append(" , A.PURCHASEORDERFLG");
-                strSQL.Append(" , B.DETAILSTRING");
-                strSQL.Append(" , -1 AS APPVAL");
-                strSQL.Append(" , 0 AS SEQNO");
-                strSQL.Append(" , A.DetailCount AS LINECOUNT");
-                strSQL.Append(" , 0 AS ORDERNO");
-                strSQL.AppendFormat(" , DATE ('{0}') AS PRINTOUTDATE", DateTime.MinValue.ToShortDateString());
-                strSQL.Append(" , ConstrType.PublicFlg");
+                strSQL.Append(", A.FIRSTSTRING");
+                strSQL.Append(", A.SECONDSTRING");
+                strSQL.Append(", A.COMPANYCODE AS COMPANYCODE");
+                strSQL.Append(", A.COMPANYNAME");
+                strSQL.Append(", SUM(A.EXECUTIONAMOUNT)");
+                strSQL.Append(", A.SOURCECODE");
+                strSQL.Append(", A.PURCHASEORDERFLG");
+                strSQL.Append(", B.DETAILSTRING");
+                strSQL.Append(", -1 AS APPVAL");
+                strSQL.Append(", 0 AS SEQNO");
+                strSQL.Append(", A.DetailCount AS LINECOUNT");
+                strSQL.Append(", 0 AS ORDERNO");
+                strSQL.AppendFormat(", DATE ('{0}') AS PRINTOUTDATE", DateTime.MinValue.ToShortDateString());
+                strSQL.Append(", ConstrType.PublicFlg");
                 strSQL.Append(" FROM CONSTRUCTIONLEDGERDETAIL A");
                 strSQL.Append(" LEFT JOIN CONSTRUCTIONBASEINFODETAIL B");
                 strSQL.Append("       ON B.CONSTRUCTIONCODE = A.SOURCECODE");
@@ -219,9 +219,9 @@
 
                 strSQL.Append(" Group by");
                 strSQL.Append(" A.CONSTRUCTIONCODE");
-                strSQL.Append(" , A.GROUPCOUNT");
-                strSQL.Append(" , A.COMPANYCODE");
-                strSQL.Append(" , A.PurchaseOrderFlg)");
+                strSQL.Append(", A.GROUPCOUNT");
+                strSQL.Append(", A.COMPANYCODE");
+                strSQL.Append(", A.PurchaseOrderFlg)");
 
                 strSQL.Append(" UNION (SELECT");
                 strSQL.Append(" A.CONSTRUCTIONCODE");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PurchaseOrderStatus/FrmPurchaseOrderStatusAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PurchaseOrderStatus/FrmPurchaseOrderStatusAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/PurchaseOrderStatus/FrmPurchaseOrderStatusAuxiliary.cs	(revision 341)
@@ -397,7 +397,7 @@
                 // GROUP BY �ǉ�
                 strSQL += " GROUP BY";
                 strSQL += " A.CONSTRUCTIONCODE";
-                strSQL += " , A1.ORDERNO";
+                strSQL += ", A1.ORDERNO";
                 // ORDER BY �ǉ�
                 strSQL += string.Format(" ORDER BY {0} ASC, {1} ASC, {2} ASC, {3} DESC, {4} DESC",
                                                     (int)GetData.CONSTRUCTIONSTATUSFLG + 1,
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ReqbillingStatus/FrmReqBillingStatusAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ReqbillingStatus/FrmReqBillingStatusAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ReqbillingStatus/FrmReqBillingStatusAuxiliary.cs	(revision 341)
@@ -405,11 +405,11 @@
 
                 // ORDER BY �ǉ�
                 strSQL.Append(" ORDER BY C.OrderCotegory ASC");
-                strSQL.Append(" , C.OrderersCode ASC");
-                strSQL.Append(" , H.INVOICENO DESC");
-                strSQL.Append(" , A.REQUESTNO DESC");
-                strSQL.Append(" , ApprovalDate DESC");
-                strSQL.Append(" , SendDate DESC");
+                strSQL.Append(", C.OrderersCode ASC");
+                strSQL.Append(", H.INVOICENO DESC");
+                strSQL.Append(", A.REQUESTNO DESC");
+                strSQL.Append(", ApprovalDate DESC");
+                strSQL.Append(", SendDate DESC");
             }
             catch (Exception ex)
             {
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/ReqSumTotalList/FrmReqSumTotalList.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/ReqSumTotalList/FrmReqSumTotalList.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/ReqSumTotalList/FrmReqSumTotalList.cs	(revision 341)
@@ -366,12 +366,12 @@
                 strSQL.Append(" On SubConstr.CompanyCode = InData.COMPANYCODE");
                 strSQL.Append(" Left Join (select");
                 strSQL.Append(" Pay.COMPANYCODE AS COMPANYCODE");
-                strSQL.Append(" , Pay.TARGETDATE AS TARGETDATE");
-                strSQL.Append(" , SUM(Pay.BILLPRICE) AS BILLPRICE");
-                strSQL.Append(" , SUM(Pay.HIGHWPRICE) AS HIGHWPRICE");
-                strSQL.Append(" , SUM(Pay.HARDWPRICE) AS HARDWPRICE");
-                strSQL.Append(" , SUM(Pay.INDSWASTETAX) AS INDSWASTETAX");
-                strSQL.Append(" , SUM(Pay.CNSTRPRICE) AS CNSTRPRICE");
+                strSQL.Append(", Pay.TARGETDATE AS TARGETDATE");
+                strSQL.Append(", SUM(Pay.BILLPRICE) AS BILLPRICE");
+                strSQL.Append(", SUM(Pay.HIGHWPRICE) AS HIGHWPRICE");
+                strSQL.Append(", SUM(Pay.HARDWPRICE) AS HARDWPRICE");
+                strSQL.Append(", SUM(Pay.INDSWASTETAX) AS INDSWASTETAX");
+                strSQL.Append(", SUM(Pay.CNSTRPRICE) AS CNSTRPRICE");
                 strSQL.Append(" From paymentdatadetail AS Pay");
                 strSQL.AppendFormat(" where Pay.TARGETDATE = '{0}'", m_TargetMonth.ToString());
                 strSQL.Append(" Group by Pay.COMPANYCODE, Pay.TARGETDATE) AS OutData");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestEntry/FrmEntryReqSelRequest.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestEntry/FrmEntryReqSelRequest.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestEntry/FrmEntryReqSelRequest.cs	(revision 341)
@@ -468,23 +468,23 @@
             {
                 string sql = "SELECT";
                 sql += " InvData.InvoiceNo";
-                sql += " ,InvData.OrderersDivision";
-                sql += " ,InvData.OrderersCode";
-                sql += " ,InvData.RequestMonth";
-                sql += " ,InvData.SeqNo";
-                sql += " ,DATE_FORMAT(InvData.CretateDate, '%Y/%m/%d')";
-                sql += " ,DATE_FORMAT(InvData.RequestDate, '%Y/%m/%d')";
-                sql += " ,InvData.RequestName";
-                sql += " ,InvData.TotalAmount";
-                sql += " ,InvData.TaxAmount";
-                sql += " ,InvData.Comment1";
-                sql += " ,InvData.Comment2";
-                sql += " ,InvData.Comment3";
-                sql += " ,InvData.Comment4";
-                sql += " ,InvData.Comment5";
-                sql += " ,InvData.CompleteFlg";
-                sql += " ,DATE_FORMAT(InvData.EntryDate, '%Y/%m/%d %H:%i:%s')";
-                sql += " ,DATE_FORMAT(InvData.UpdateDate, '%Y/%m/%d %H:%i:%s')";
+                sql += ", InvData.OrderersDivision";
+                sql += ", InvData.OrderersCode";
+                sql += ", InvData.RequestMonth";
+                sql += ", InvData.SeqNo";
+                sql += ", DATE_FORMAT(InvData.CretateDate, '%Y/%m/%d')";
+                sql += ", DATE_FORMAT(InvData.RequestDate, '%Y/%m/%d')";
+                sql += ", InvData.RequestName";
+                sql += ", InvData.TotalAmount";
+                sql += ", InvData.TaxAmount";
+                sql += ", InvData.Comment1";
+                sql += ", InvData.Comment2";
+                sql += ", InvData.Comment3";
+                sql += ", InvData.Comment4";
+                sql += ", InvData.Comment5";
+                sql += ", InvData.CompleteFlg";
+                sql += ", DATE_FORMAT(InvData.EntryDate, '%Y/%m/%d %H:%i:%s')";
+                sql += ", DATE_FORMAT(InvData.UpdateDate, '%Y/%m/%d %H:%i:%s')";
                 sql += " FROM";
                 sql += " InvoiceData InvData";
                 sql += string.Format(" WHERE InvData.OrderersDivision = {0}", m_nOrderersDivision);
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestEntry/FrmRequestPrintSelAux.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestEntry/FrmRequestPrintSelAux.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestEntry/FrmRequestPrintSelAux.cs	(revision 341)
@@ -186,23 +186,23 @@
                 StringBuilder sql = new StringBuilder();
                 sql.Append("SELECT");
                 sql.Append(" InvData.InvoiceNo");
-                sql.Append(" ,InvData.OrderersDivision");
-                sql.Append(" ,InvData.OrderersCode");
-                sql.Append(" ,InvData.RequestMonth");
-                sql.Append(" ,InvData.SeqNo");
-                sql.Append(" ,DATE_FORMAT(InvData.CretateDate, '%Y/%m/%d')");
-                sql.Append(" ,DATE_FORMAT(InvData.RequestDate, '%Y/%m/%d')");
-                sql.Append(" ,InvData.RequestName");
-                sql.Append(" ,InvData.TotalAmount");
-                sql.Append(" ,InvData.TaxAmount");
-                sql.Append(" ,InvData.Comment1");
-                sql.Append(" ,InvData.Comment2");
-                sql.Append(" ,InvData.Comment3");
-                sql.Append(" ,InvData.Comment4");
-                sql.Append(" ,InvData.Comment5");
-                sql.Append(" ,InvData.CompleteFlg");
-                sql.Append(" ,DATE_FORMAT(InvData.EntryDate, '%Y/%m/%d %H:%i:%s')");
-                sql.Append(" ,DATE_FORMAT(InvData.UpdateDate, '%Y/%m/%d %H:%i:%s')");
+                sql.Append(", InvData.OrderersDivision");
+                sql.Append(", InvData.OrderersCode");
+                sql.Append(", InvData.RequestMonth");
+                sql.Append(", InvData.SeqNo");
+                sql.Append(", DATE_FORMAT(InvData.CretateDate, '%Y/%m/%d')");
+                sql.Append(", DATE_FORMAT(InvData.RequestDate, '%Y/%m/%d')");
+                sql.Append(", InvData.RequestName");
+                sql.Append(", InvData.TotalAmount");
+                sql.Append(", InvData.TaxAmount");
+                sql.Append(", InvData.Comment1");
+                sql.Append(", InvData.Comment2");
+                sql.Append(", InvData.Comment3");
+                sql.Append(", InvData.Comment4");
+                sql.Append(", InvData.Comment5");
+                sql.Append(", InvData.CompleteFlg");
+                sql.Append(", DATE_FORMAT(InvData.EntryDate, '%Y/%m/%d %H:%i:%s')");
+                sql.Append(", DATE_FORMAT(InvData.UpdateDate, '%Y/%m/%d %H:%i:%s')");
                 sql.Append(" FROM");
                 sql.Append(" InvoiceData InvData");
                 sql.AppendFormat(" WHERE InvData.OrderersDivision = {0}", m_nOrderersDivision);
@@ -1191,7 +1191,8 @@
 
                     // 既にデータが存在しないか一度検索しておく
                     sql.Clear();
-                    sql.Append(ioPrgDate.CreatePrimarykeyString(nConstructionCode, Info.ConstructionStatusFlg));
+                    sql.Append(ioPrgDate.CreatePrimarykeyString(nConstructionCode));
+                    sql.AppendFormat(" And ConstructionStatusFlg = {0}", Info.ConstructionStatusFlg);
                     List<ConstructionProgressDate> lstPrgDate = new List<ConstructionProgressDate>();
                     if (!ioPrgDate.SelectAction(sql.ToString(), ref lstPrgDate, false)) return false;
 
@@ -1200,7 +1201,8 @@
                     {
                         // 該当データを削除
                         sql.Clear();
-                        sql.Append(ioPrgDate.CreatePrimarykeyString(nConstructionCode, Info.ConstructionStatusFlg));
+                        sql.Append(ioPrgDate.CreatePrimarykeyString(nConstructionCode));
+                        sql.AppendFormat(" And ConstructionStatusFlg = {0}", Info.ConstructionStatusFlg);
                         if (!ioPrgDate.DeleteAction(sql.ToString(), false)) return false;
                     }
 
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestInput/FrmRequestInputAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestInput/FrmRequestInputAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestInput/FrmRequestInputAuxiliary.cs	(revision 341)
@@ -860,6 +860,7 @@
 
                     List<int> lstKey = new List<int>(dicReqData.Keys);
 
+                    StringBuilder sql = new StringBuilder();
                     foreach (int nMainConstructionCode in lstKey)
                     {
                         ConstructionBaseInfo Info = null;
@@ -871,9 +872,11 @@
                                 continue;
                             }
                         }
-                        string sql = ioProg.CreatePrimarykeyString(nMainConstructionCode, (int)CommonDefine.StatNumArray.Status9);
+                        sql.Clear();
+                        sql.Append(ioProg.CreatePrimarykeyString(nMainConstructionCode));
+                        sql.AppendFormat(" And ConstructionStatusFlg = {0}", (int)CommonDefine.StatNumArray.Status9);
                         List<ConstructionProgressDate> lstProg = new List<ConstructionProgressDate>();
-                        if (ioProg.SelectAction(sql, ref lstProg) == false)
+                        if (ioProg.SelectAction(sql.ToString(), ref lstProg) == false)
                         {
                             return (int)CheckResult.UnknownError;
                         }
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestSummaryList/FrmRequestSummaryListAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestSummaryList/FrmRequestSummaryListAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/RequestSummaryList/FrmRequestSummaryListAuxiliary.cs	(revision 341)
@@ -3092,12 +3092,12 @@
                 sql.AppendLine("select  ");
                 sql.AppendLine(" case ifnull(");
                 sql.AppendLine("     DATE_FORMAT(Cbi.PurchaseOrderMailingDate, '%Y/%m/%d')");
-                sql.AppendFormat(" , '{0}')", DateTime.MinValue.ToShortDateString());
+                sql.AppendFormat(", '{0}')", DateTime.MinValue.ToShortDateString());
                 sql.AppendFormat("     when '{0}' then '�~' else '��'  ", DateTime.MinValue.ToShortDateString());
                 sql.AppendLine(" end as PurchaseOrderMailingDate, /*�������X����*/ ");
                 sql.AppendLine(" case ifnull(");
                 sql.AppendLine("     DATE_FORMAT(Cbi.PurchaseOrderReturnDate, '%Y/%m/%d')");
-                sql.AppendFormat(" , '{0}')", DateTime.MinValue.ToShortDateString());
+                sql.AppendFormat(", '{0}')", DateTime.MinValue.ToShortDateString());
                 sql.AppendFormat("     when '{0}' then '�~' else '��'  ", DateTime.MinValue.ToShortDateString());
                 sql.AppendLine(" end as PurchaseOrderReturnDate,  /*�������ԑ���*/ ");
                 sql.AppendLine(" case ifnull(Pa.PERSONCODE,0) when 0 then '�~' /* �\�Z�� */ ");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/SelectPayment/FrmEntryDeposit.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/SelectPayment/FrmEntryDeposit.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/SelectPayment/FrmEntryDeposit.cs	(revision 341)
@@ -262,7 +262,7 @@
                 sql.Append(" ) ");
                 sql.Append(" ORDER BY ");
                 sql.Append(" ORDERERSNAME ");
-                sql.Append(" ,SEQNO ");
+                sql.Append(", SEQNO ");
                 sql.Append(" ; ");
 
                 var data = new ArrayList();
@@ -912,7 +912,7 @@
                     strSQL += string.Format(" AND H.REQUESTMONTH = {0}", deposit.TargetDate);
                     strSQL += " LEFT JOIN PERSONINCHARGEMASTER B ON B.PERSONCODE = P.SALESPERSONCODE";
                     strSQL += " LEFT JOIN PERSONINCHARGEMASTER C ON C.PERSONCODE = P.CONSTRUCTIONPERSONCODE";
-                    strSQL += " , CONSTRUCTIONBASEINFODETAIL A";
+                    strSQL += ", CONSTRUCTIONBASEINFODETAIL A";
                     strSQL += " WHERE P.CONSTRUCTIONCODE = H.REQCONSTRUCTIONCODE";
                     strSQL += string.Format(" AND A.CONSTRUCTIONCODE = P.CONSTRUCTIONCODE AND A.DETAILNO = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
                     ArrayList arList = new ArrayList();
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/SubConstrRegist/FrmSubConstrRegistListAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/SubConstrRegist/FrmSubConstrRegistListAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/SubConstrRegist/FrmSubConstrRegistListAuxiliary.cs	(revision 341)
@@ -237,17 +237,17 @@
             {
                 strSQL = "SELECT";
                 strSQL += " B.PERSONNAME";
-                strSQL += " ,A.CORPORATESTATUSNAME";
-                strSQL += " ,A.CORPORATESTATUSPOINT";
-                strSQL += " ,A.COMPANYNAME";
-                strSQL += " ,DATE_FORMAT(A.CREATEDATE,'%Y/%m/%d')";
-                strSQL += " ,A.PERSONCODE";
-                strSQL += " ,A.SEQNO";
-                strSQL += " ,D.DEPARTMENTSTRING";
-                strSQL += " ,A.DATAMODE";
-                strSQL += " ,A.CEOPOSITIONNAME";
-                strSQL += " ,A.CEONAME";
-                strSQL += " ,A.CONTACTPERSONNAME";
+                strSQL += ", A.CORPORATESTATUSNAME";
+                strSQL += ", A.CORPORATESTATUSPOINT";
+                strSQL += ", A.COMPANYNAME";
+                strSQL += ", DATE_FORMAT(A.CREATEDATE,'%Y/%m/%d')";
+                strSQL += ", A.PERSONCODE";
+                strSQL += ", A.SEQNO";
+                strSQL += ", D.DEPARTMENTSTRING";
+                strSQL += ", A.DATAMODE";
+                strSQL += ", A.CEOPOSITIONNAME";
+                strSQL += ", A.CEONAME";
+                strSQL += ", A.CONTACTPERSONNAME";
 
                 strSQL += " FROM SUBCONSTRREGIST A";
                 strSQL += " LEFT JOIN PERSONINCHARGEMASTER B ON B.PERSONCODE = A.PERSONCODE";
Index: branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/TAndPCosts/FrmTAndPCostsAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/TAndPCosts/FrmTAndPCostsAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/TAndPCosts/FrmTAndPCostsAuxiliary.cs	(revision 341)
@@ -782,18 +782,18 @@
                 StringBuilder strSQL = new StringBuilder();
                 strSQL.Append("SELECT");
                 strSQL.Append(" DATE_FORMAT(Cost.ACTIONDATE, '%d') AS ACTIONDATE");
-                strSQL.Append(" , Cost.DATATYPE");
-                strSQL.Append(" , Cost.CONSTRUCTIONCODE");
-                strSQL.Append(" , Cost.PAYMENTCONTENT");
-                strSQL.Append(" , Cost.ENTRYPRICE");
-                strSQL.Append(" , Cost.ENTRYPRICEINTAX");
-                strSQL.Append(" , Cost.SUPPLIERSCODE");
-                strSQL.Append(" , Cost.SUPPLIERSNAME");
-                strSQL.Append(" , Cost.COMPLATEFLG");
-                strSQL.Append(" , Cost.APPROVALFLG");
-                strSQL.Append(" , Cost.SlipNumber");
-                strSQL.Append(" , Cost.PaymentType");
-                strSQL.Append(" , BaseDetail.DetailString");
+                strSQL.Append(", Cost.DATATYPE");
+                strSQL.Append(", Cost.CONSTRUCTIONCODE");
+                strSQL.Append(", Cost.PAYMENTCONTENT");
+                strSQL.Append(", Cost.ENTRYPRICE");
+                strSQL.Append(", Cost.ENTRYPRICEINTAX");
+                strSQL.Append(", Cost.SUPPLIERSCODE");
+                strSQL.Append(", Cost.SUPPLIERSNAME");
+                strSQL.Append(", Cost.COMPLATEFLG");
+                strSQL.Append(", Cost.APPROVALFLG");
+                strSQL.Append(", Cost.SlipNumber");
+                strSQL.Append(", Cost.PaymentType");
+                strSQL.Append(", BaseDetail.DetailString");
                 strSQL.Append(" FROM CostDataOfPerson AS Cost");
 
                 strSQL.Append(" LEFT JOIN ConstructionBaseInfoDetail AS BaseDetail");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/Master/Department/FrmDepartmentAux.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/Master/Department/FrmDepartmentAux.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/Master/Department/FrmDepartmentAux.cs	(revision 341)
@@ -373,6 +373,7 @@
                     exList.DepartmentCode = m_DepartmentCode;
                     exList.ExpensesPeriod = ExpensesPeriod;
                     exList.NameCode = CommonMotions.cnvInt(wrkRow.Cells[(int)ExpGridColumn.ExpensesCode].Value);
+                    exList.NameString = CommonMotions.cnvString(wrkRow.Cells[(int)ExpGridColumn.ExpensesName].Value);
                     exList.DisplayOrder = ++idisp;
                     exList.ExpensesRaito = CommonMotions.cnvDouble(wrkRow.Cells[(int)ExpGridColumn.Ratio].Value);
                     exList.DeleteFlg = 0;
@@ -656,7 +657,6 @@
         }
         #endregion
 
-
         #region 工事情報明細対象部署名変更
         /// <summary>
         /// 工事情報明細対象部署名変更
@@ -790,31 +790,23 @@
         /// </summary>
         private void DispExpExpenses()
         {
-            IOMDepartmentExpenses expDB = new IOMDepartmentExpenses();
             try
             {
                 dgvExpenses.Rows.Clear();
 
                 int preiod = CommonMotions.cnvInt(numUDPeriod.Value);
-                // 部署経費率マスタ取得
-                string strSQL = "SELECT A.DIVISIONCODE, A.NAMECODE, A.NAMESTRING,A.DISPLAYORDER, IFNULL(B.EXPENSESRAITO, 0)";
-                strSQL += " FROM DIVISIONMASTER A LEFT OUTER JOIN";
-                strSQL += " (SELECT NAMECODE, DEPARTMENTCODE, EXPENSESRAITO, EXPENSESPERIOD FROM DEPARTMENTEXPENSESMASTER";
-                strSQL += string.Format(" WHERE DEPARTMENTCODE = {0}) B", m_DepartmentCode);
-                strSQL += " ON A.NAMECODE = B.NAMECODE";
-                strSQL += string.Format(" AND B.EXPENSESPERIOD = {0}", CommonMotions.cnvInt(numUDPeriod.Value));
-                strSQL += string.Format(" WHERE A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);
-                strSQL += " ORDER BY A.DISPLAYORDER";
                 ArrayList arData = new ArrayList();
-                expDB.ExecuteReader(strSQL, ref arData);
 
+                // 部署経費率マスタ取得
+                CommonMotions.GetExpensesList(preiod, m_DepartmentCode, ref arData);
+
                 // データ表示
                 foreach (object[] objwrk in arData)
                 {
                     // データ表示
-                    int icnt = dgvExpenses.Rows.Add(CommonMotions.cnvInt(objwrk[1]),                // 経費率コード
-                                            CommonMotions.cnvString(objwrk[2]),                     // 経費率名称
-                                            CommonMotions.cnvDouble(objwrk[4]).ToString("0.00"));   // 経費率
+                    int icnt = dgvExpenses.Rows.Add(CommonMotions.cnvInt(objwrk[2]),                // 経費率コード
+                                            CommonMotions.cnvString(objwrk[0]),                     // 経費率名称
+                                            CommonMotions.cnvDouble(objwrk[1]).ToString("0.00"));   // 経費率
                     dgvExpenses.Rows[icnt].Cells[(int)ExpGridColumn.Ratio].ReadOnly = false;
                 }
                 int RowCnt = 4 - dgvExpenses.RowCount;
@@ -821,7 +813,6 @@
                 if (RowCnt > 0)
                 {
                     dgvExpenses.Rows.Add(RowCnt);
-                    //dgvExpenses.Columns[(int)ExpGridColumn.ExpensesName].Width = s_CellSize[(int)ExpGridColumn.ExpensesName] + dgvExpenses.RowHeadersWidth;
                 }
 
                 m_bChengeAns = false;
@@ -830,10 +821,6 @@
             {
                 logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
             }
-            finally
-            {
-                expDB.close(); expDB = null;
-            }
         }
         #endregion
 
Index: branches/src/ProcessManagement/ProcessManagement/Forms/Master/Security/FrmSecurityAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/Master/Security/FrmSecurityAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/Master/Security/FrmSecurityAuxiliary.cs	(revision 341)
@@ -561,15 +561,15 @@
                 StringBuilder strcmd = new StringBuilder();
 
                 strcmd.AppendFormat("  {0}SecCode", Alias);
-                strcmd.AppendFormat(" ,{0}DisplayOrder", Alias);
-                strcmd.AppendFormat(" ,{0}SecName", Alias);
-                strcmd.AppendFormat(" ,{0}SecRank", Alias);
-                strcmd.AppendFormat(" ,{0}SecRange", Alias);
-                strcmd.AppendFormat(" ,{0}GeneralAffairs", Alias);
-                strcmd.AppendFormat(" ,{0}SelectBackColor", Alias);
+                strcmd.AppendFormat(", {0}DisplayOrder", Alias);
+                strcmd.AppendFormat(", {0}SecName", Alias);
+                strcmd.AppendFormat(", {0}SecRank", Alias);
+                strcmd.AppendFormat(", {0}SecRange", Alias);
+                strcmd.AppendFormat(", {0}GeneralAffairs", Alias);
+                strcmd.AppendFormat(", {0}SelectBackColor", Alias);
 
-                strcmd.AppendFormat(" ,DATE_FORMAT({0}EntryDate, '%Y/%m/%d %H:%i:%s')", Alias);
-                strcmd.AppendFormat(" ,DATE_FORMAT({0}UpdateDate, '%Y/%m/%d %H:%i:%s')", Alias);
+                strcmd.AppendFormat(", DATE_FORMAT({0}EntryDate, '%Y/%m/%d %H:%i:%s')", Alias);
+                strcmd.AppendFormat(", DATE_FORMAT({0}UpdateDate, '%Y/%m/%d %H:%i:%s')", Alias);
 
                 return strcmd.ToString();
             }
Index: branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmConstructionDiag.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmConstructionDiag.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmConstructionDiag.cs	(revision 341)
@@ -586,14 +586,14 @@
                 // 進行中＋一括請求を検索する
                 strSQL.Append("SELECT");
                 strSQL.Append(" UNI.CONSTRUCTIONCODE");
-                strSQL.Append(" , UNI.DETAILSTRING");
-                strSQL.Append(" , '', '', UNI.PERSONNAME");
+                strSQL.Append(", UNI.DETAILSTRING");
+                strSQL.Append(", '', '', UNI.PERSONNAME");
                 strSQL.Append(" FROM (");
                 strSQL.Append(" SELECT");
                 strSQL.Append(" A1.CONSTRUCTIONCODE AS CONSTRUCTIONCODE");
-                strSQL.Append(" , B1.DETAILSTRING AS DETAILSTRING");
-                strSQL.Append(" , A1.CONSTRUCTIONPERIODSTART AS CONSTRUCTIONPERIODSTART");
-                strSQL.Append(" , P1.PERSONNAME AS PERSONNAME");
+                strSQL.Append(", B1.DETAILSTRING AS DETAILSTRING");
+                strSQL.Append(", A1.CONSTRUCTIONPERIODSTART AS CONSTRUCTIONPERIODSTART");
+                strSQL.Append(", P1.PERSONNAME AS PERSONNAME");
                 strSQL.Append(" FROM");
                 strSQL.Append(" CONSTRUCTIONBASEINFO A1");
                 strSQL.Append(" INNER JOIN CONSTRUCTIONBASEINFODETAIL B1 ON ");
@@ -622,9 +622,9 @@
                 strSQL.Append(" UNION ALL");
                 strSQL.Append(" SELECT");
                 strSQL.Append(" A2.CONSTRUCTIONCODE AS CONSTRUCTIONCODE");
-                strSQL.Append(" , B2.DETAILSTRING AS DETAILSTRING");
-                strSQL.Append(" , A2.CONSTRUCTIONPERIODSTART AS CONSTRUCTIONPERIODSTART");
-                strSQL.Append(" , P2.PERSONNAME AS PERSONNAME");
+                strSQL.Append(", B2.DETAILSTRING AS DETAILSTRING");
+                strSQL.Append(", A2.CONSTRUCTIONPERIODSTART AS CONSTRUCTIONPERIODSTART");
+                strSQL.Append(", P2.PERSONNAME AS PERSONNAME");
                 strSQL.Append(" FROM");
                 strSQL.Append(" CONSTRUCTIONBASEINFO A2");
                 strSQL.Append(" INNER JOIN CONSTRUCTIONBASEINFODETAIL B2 ON ");
@@ -673,14 +673,14 @@
                 // 進行中＋分割請求を検索する
                 strSQL.Append("SELECT");
                 strSQL.Append(" UNI.CONSTRUCTIONCODE");
-                strSQL.Append(" , UNI.DETAILSTRING");
-                strSQL.Append(" , '', '', UNI.PERSONNAME");
+                strSQL.Append(", UNI.DETAILSTRING");
+                strSQL.Append(", '', '', UNI.PERSONNAME");
                 strSQL.Append(" FROM (");
                 strSQL.Append(" SELECT");
                 strSQL.Append(" A1.CONSTRUCTIONCODE AS CONSTRUCTIONCODE");
-                strSQL.Append(" , B1.DETAILSTRING AS DETAILSTRING");
-                strSQL.Append(" , A1.CONSTRUCTIONPERIODSTART AS CONSTRUCTIONPERIODSTART");
-                strSQL.Append(" , P1.PersonName AS PERSONNAME");
+                strSQL.Append(", B1.DETAILSTRING AS DETAILSTRING");
+                strSQL.Append(", A1.CONSTRUCTIONPERIODSTART AS CONSTRUCTIONPERIODSTART");
+                strSQL.Append(", P1.PersonName AS PERSONNAME");
                 strSQL.Append(" FROM");
                 strSQL.Append(" CONSTRUCTIONBASEINFO A1");
                 strSQL.Append(" INNER JOIN CONSTRUCTIONBASEINFODETAIL B1 ON ");
@@ -709,9 +709,9 @@
                 strSQL.Append(" UNION ALL");
                 strSQL.Append(" SELECT");
                 strSQL.Append(" A2.CONSTRUCTIONCODE AS CONSTRUCTIONCODE");
-                strSQL.Append(" , B2.DETAILSTRING AS DETAILSTRING");
-                strSQL.Append(" , A2.CONSTRUCTIONPERIODSTART AS CONSTRUCTIONPERIODSTART");
-                strSQL.Append(" , P2.PERSONNAME AS PERSONNAME");
+                strSQL.Append(", B2.DETAILSTRING AS DETAILSTRING");
+                strSQL.Append(", A2.CONSTRUCTIONPERIODSTART AS CONSTRUCTIONPERIODSTART");
+                strSQL.Append(", P2.PERSONNAME AS PERSONNAME");
                 strSQL.Append(" FROM");
                 strSQL.Append(" CONSTRUCTIONBASEINFO A2");
                 strSQL.Append(" INNER JOIN CONSTRUCTIONBASEINFODETAIL B2 ON ");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmConstructionItemDiag.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmConstructionItemDiag.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmConstructionItemDiag.cs	(revision 341)
@@ -345,13 +345,13 @@
                     // SQL作成
                     strSQL = "SELECT";
                     strSQL += "  B.ItemCode";
-                    strSQL += " ,B.DisplayOrder";
-                    strSQL += " ,B.ItemName";
-                    strSQL += " ,B.SubitemsFlg";
-                    strSQL += " ,B.MyExpensesFlg";
-                    strSQL += " ,B.DeleteFlg";
-                    strSQL += " ,DATE_FORMAT(B.EntryDate, '%Y/%m/%d %H:%i:%s')";
-                    strSQL += " ,DATE_FORMAT(B.UpdateDate, '%Y/%m/%d %H:%i:%s')";
+                    strSQL += ", B.DisplayOrder";
+                    strSQL += ", B.ItemName";
+                    strSQL += ", B.SubitemsFlg";
+                    strSQL += ", B.MyExpensesFlg";
+                    strSQL += ", B.DeleteFlg";
+                    strSQL += ", DATE_FORMAT(B.EntryDate, '%Y/%m/%d %H:%i:%s')";
+                    strSQL += ", DATE_FORMAT(B.UpdateDate, '%Y/%m/%d %H:%i:%s')";
                     strSQL += " FROM ComponentLinkMaster A, ConstructionItemMaster B";
                     strSQL += " Where B.DeleteFlg = 0";
                     strSQL += string.Format(" And A.ComponentCode = {0}", m_ComponentCode);
Index: branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmConstructionSpecDiag.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmConstructionSpecDiag.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmConstructionSpecDiag.cs	(revision 341)
@@ -341,13 +341,13 @@
                     // SQL作成
                     strSQL = "SELECT";
                     strSQL += "  B.ItemCode";
-                    strSQL += " ,B.DisplayOrder";
-                    strSQL += " ,B.ItemName";
-                    strSQL += " ,B.SubitemsFlg";
-                    strSQL += " ,B.MyExpensesFlg";
-                    strSQL += " ,B.DeleteFlg";  
-                    strSQL += " ,DATE_FORMAT(B.EntryDate, '%Y/%m/%d %H:%i:%s')";
-                    strSQL += " ,DATE_FORMAT(B.UpdateDate, '%Y/%m/%d %H:%i:%s')";
+                    strSQL += ", B.DisplayOrder";
+                    strSQL += ", B.ItemName";
+                    strSQL += ", B.SubitemsFlg";
+                    strSQL += ", B.MyExpensesFlg";
+                    strSQL += ", B.DeleteFlg";  
+                    strSQL += ", DATE_FORMAT(B.EntryDate, '%Y/%m/%d %H:%i:%s')";
+                    strSQL += ", DATE_FORMAT(B.UpdateDate, '%Y/%m/%d %H:%i:%s')";
                     strSQL += " FROM ComponentLinkMaster A, ConstructionItemMaster B";
                     strSQL += " Where B.DeleteFlg = 0";
                     strSQL += string.Format(" And A.ComponentCode = {0}", m_ComponentCode);
Index: branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmPeriodAvoidance.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmPeriodAvoidance.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmPeriodAvoidance.cs	(revision 341)
@@ -379,15 +379,15 @@
 
                 strSQL.Append(" Select");
                 strSQL.Append(" Base.ConstructionCode");            // 0
-                strSQL.Append(" , Detil.DetailString");             // 1
-                strSQL.Append(" , Base.SalesPersonCode");           // 2
-                strSQL.Append(" , SalesName.PersonName");           // 3
-                strSQL.Append(" , Base.ConstructionPersonCode");    // 4
-                strSQL.Append(" , ConstrName.PersonName");          // 5
-                strSQL.Append(" , Base.ConstrSubPersonCode");       // 6
-                strSQL.Append(" , SubName.PersonName");             // 7
-                strSQL.Append(" , Base.ConstructionInstructor");    // 8
-                strSQL.Append(" , InstrName.PersonName");           // 9
+                strSQL.Append(", Detil.DetailString");             // 1
+                strSQL.Append(", Base.SalesPersonCode");           // 2
+                strSQL.Append(", SalesName.PersonName");           // 3
+                strSQL.Append(", Base.ConstructionPersonCode");    // 4
+                strSQL.Append(", ConstrName.PersonName");          // 5
+                strSQL.Append(", Base.ConstrSubPersonCode");       // 6
+                strSQL.Append(", SubName.PersonName");             // 7
+                strSQL.Append(", Base.ConstructionInstructor");    // 8
+                strSQL.Append(", InstrName.PersonName");           // 9
                 strSQL.Append(" From");
                 strSQL.Append(" constructionbaseinfo As Base");
                 strSQL.Append(" Left Join personinchargemaster As SalesName");
Index: branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmTyingConstrDiag.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmTyingConstrDiag.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmTyingConstrDiag.cs	(revision 341)
@@ -249,7 +249,7 @@
                 bool binit = true;
                 foreach (int CurCode in CodeList)
                 {
-                    if (!binit) strInWher += " ,";
+                    if (!binit) strInWher += ", ";
                     strInWher += string.Format("{0}", CurCode);
                     binit = false;
                 }
Index: branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/Material/FrmMaterialSelect.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/Material/FrmMaterialSelect.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/SubForms/Material/FrmMaterialSelect.cs	(revision 341)
@@ -313,17 +313,17 @@
                 StringBuilder strSQL = new StringBuilder();
                 strSQL.Append("select");
                 strSQL.AppendLine(" A.DisplayOrder");
-                strSQL.AppendLine(" , A.MaterialItemCode");
-                strSQL.AppendLine(" , A.MaterialItemName");
-                strSQL.AppendLine(" , B.RENTCOUNT");
-                strSQL.AppendLine(" , C.MATERIALKINDCODE");
-                strSQL.AppendLine(" , C.MATERIALKINDNAME");
-                strSQL.AppendLine(" , C.DISPLAYORDER");
+                strSQL.AppendLine(", A.MaterialItemCode");
+                strSQL.AppendLine(", A.MaterialItemName");
+                strSQL.AppendLine(", B.RENTCOUNT");
+                strSQL.AppendLine(", C.MATERIALKINDCODE");
+                strSQL.AppendLine(", C.MATERIALKINDNAME");
+                strSQL.AppendLine(", C.DISPLAYORDER");
 
                 strSQL.AppendLine(" from");
                 strSQL.AppendLine(" materialitemmaster AS A");
-                strSQL.AppendLine(" , materialinfo AS B");
-                strSQL.AppendLine(" , materialkindmaster AS C");
+                strSQL.AppendLine(", materialinfo AS B");
+                strSQL.AppendLine(", materialkindmaster AS C");
 
                 strSQL.AppendLine(" Where");
                 strSQL.AppendFormat(" A.MaterialKindCode = {0}", strMaterialKindCode);
@@ -334,7 +334,7 @@
 
                 strSQL.AppendLine(" Order By");
                 strSQL.AppendLine(" C.DISPLAYORDER ASC");
-                strSQL.AppendLine(" , A.DisplayOrder ASC");
+                strSQL.AppendLine(", A.DisplayOrder ASC");
 
                 ArrayList mim = new ArrayList();
                 if (!IoMi.ExecuteReader(strSQL.ToString(), ref mim)) return;
Index: branches/src/ProcessManagement/ProcessManagement/Forms/ZMenu/FrmMenuAuxiliary.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Forms/ZMenu/FrmMenuAuxiliary.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Forms/ZMenu/FrmMenuAuxiliary.cs	(revision 341)
@@ -5006,7 +5006,7 @@
                 strSQL.Append(" LEFT JOIN (SELECT SG.CONSTRUCTIONCODE, SG.SEQNO, SG.APPROVALSTATUS, MAX(SG.APPROVALCODE) APPROVALCODE");
                 strSQL.Append(" FROM PROCESSAPPROVAL SG GROUP BY SG.CONSTRUCTIONCODE, SG.SEQNO, SG.APPROVALSTATUS) G");
                 strSQL.Append(" ON A.ConstructionCode = G.CONSTRUCTIONCODE AND G.SEQNO = 1");
-                strSQL.Append(" , CONSTRUCTIONBASEINFODETAIL B, PERSONINCHARGEMASTER C");
+                strSQL.Append(", CONSTRUCTIONBASEINFODETAIL B, PERSONINCHARGEMASTER C");
 
                 strSQL.AppendFormat(" WHERE A.TYINGFLG = {0}", (int)ConstructionBaseInfo.TyingFlgDef.Tying);
                 strSQL.AppendFormat(" AND (DATE(A.BILLINGDATE) = STR_TO_DATE('{0}', '%Y/%m/%d')", DateTime.MinValue.ToShortDateString());
@@ -6068,15 +6068,15 @@
                 if (SelDepartment == 0)
                 {
                     strSubSQL.Append(" F.DepartmentCode AS DepartmentCode");
-                    strSubSQL.Append(" , F.DepartmentString AS DepName");
+                    strSubSQL.Append(", F.DepartmentString AS DepName");
                 }
                 else
                 {
                     strSubSQL.Append(" A.PersonCode AS PersonCode");
-                    strSubSQL.Append(" , A.PersonName AS PerName");
+                    strSubSQL.Append(", A.PersonName AS PerName");
                 }
-                strSubSQL.Append(" , Sum(C.REQUESTAMOUNT) As Amount");
-                strSubSQL.Append(" , DATE_FORMAT(MAX(C.UPDATEDATE), '%Y/%m/%d') AS UPDATEDATE");
+                strSubSQL.Append(", Sum(C.REQUESTAMOUNT) As Amount");
+                strSubSQL.Append(", DATE_FORMAT(MAX(C.UPDATEDATE), '%Y/%m/%d') AS UPDATEDATE");
                 strSubSQL.Append(" From");
                 strSubSQL.Append(" personinchargemaster AS A");
                 strSubSQL.Append(" LEFT JOIN constructionbaseinfo AS B ON B.ConstructionPersonCode = A.PersonCode");
@@ -6148,8 +6148,8 @@
 
                 strSQL.Append(" Union Select");
                 strSQL.Append(" A2.ConstrDepCode As DEPARTMENTCODE");
-                strSQL.Append(" , B2.DetailString As DEPARTMENTSTRING");
-                strSQL.Append(" , ifnull(C2.DisplayOrder, 10) As DISPLAYORDER");
+                strSQL.Append(", B2.DetailString As DEPARTMENTSTRING");
+                strSQL.Append(", ifnull(C2.DisplayOrder, 10) As DISPLAYORDER");
                 strSQL.Append(" From Constructionbaseinfo As A2");
                 strSQL.Append(" Inner Join constructionbaseinfodetail As B2");
                 strSQL.Append("       On B2.ConstructionCode = A2.ConstructionCode");
Index: branches/src/ProcessManagement/ProcessManagement/ProcessManagement.csproj
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/ProcessManagement.csproj	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/ProcessManagement.csproj	(revision 341)
@@ -145,6 +145,7 @@
     <Compile Include="Common\Process\ClsExcute.cs" />
     <Compile Include="Common\CommonDefine.cs" />
     <Compile Include="Common\Office\UsedWord.cs" />
+    <Compile Include="DataModel\ConstrLedgerExpenses.cs" />
     <Compile Include="DataModel\DepartmentCostData.cs" />
     <Compile Include="DataModel\PersonExpensesCost.cs" />
     <Compile Include="DataModel\SalaryClass.cs" />
@@ -225,6 +226,7 @@
     <Compile Include="DB\IOAccess\IOAttendanceDailyData.cs" />
     <Compile Include="DB\IOAccess\IOAttendanceData.cs" />
     <Compile Include="DB\IOAccess\IOBankBusinessDayMaster.cs" />
+    <Compile Include="DB\IOAccess\IOConstrLedgerExpenses.cs" />
     <Compile Include="DB\IOAccess\IODepartmentCostData.cs" />
     <Compile Include="DB\IOAccess\IODirectAccess.cs" />
     <Compile Include="DB\IOAccess\IOBillingData.cs" />
Index: branches/src/ProcessManagement/ProcessManagement/Properties/AssemblyInfo.cs
===================================================================
--- branches/src/ProcessManagement/ProcessManagement/Properties/AssemblyInfo.cs	(revision 340)
+++ branches/src/ProcessManagement/ProcessManagement/Properties/AssemblyInfo.cs	(revision 341)
@@ -32,7 +32,7 @@
 // すべての値を指定するか、下のように '*' を使ってビルドおよびリビジョン番号を 
 // 既定値にすることができます:
 // [assembly: AssemblyVersion("1.0.*")]
-[assembly: AssemblyVersion("1.0.1.178")]
-[assembly: AssemblyFileVersion("1.0.1.178")]
+[assembly: AssemblyVersion("1.0.1.180")]
+[assembly: AssemblyFileVersion("1.0.1.180")]
 // Log4netを使用する
 [assembly: log4net.Config.XmlConfigurator(ConfigFile = @"log4net.config", Watch = true)]
\ No newline at end of file
