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

                string strFilename = @strFilePath + s_WordExtension[m_WordVersion];

                int ParentCode = 0;

                int LinkCount = 0;

                else if (BaseRec.TyingFlg == (int)CommonDefine.BaseInfoTyingFlg.Tying)

                {

                    LinkCount = GetLinkageCode2(RemoveCode, DB03, ref ParentCode);

                }

                string strRemove2 = string.Empty;

                    if (BaseRec.JoinFlg == (int)CommonDefine.BaseInfoJoinFlg.JoinParent

                        || BaseRec.TyingFlg == (int)CommonDefine.BaseInfoTyingFlg.Parent)

                    {

                        DB03.DeleteAction(strRemove, false);

                    }

                    else if (BaseRec.TyingFlg == (int)CommonDefine.BaseInfoTyingFlg.Tying)

                    {

                        strRemove2 = string.Format(" Where FluctuationCode = {0}", RemoveList[i]);

                        strRemove2 += string.Format(" AND LINKTYPE = {0}", (int)CommonDefine.LinkDataType.FluctuationType);

                        DB03.DeleteAction(strRemove2, false);

                    }

                    else if (BaseRec.JoinFlg == (int)CommonDefine.BaseInfoJoinFlg.JoinChildren)

                    {

                        // 削除処理の未実装

                    }

                    // 増減工事子の場合（最後のリンク情報か、どうかの確認）

                    if (BaseRec.TyingFlg == (int)CommonDefine.BaseInfoTyingFlg.Tying)

                        if (LinkCount == 1)

                        {   // 最後のリンクは親を増減工事より外す

                            if (!DB01.UpdateFeild(ParentCode

        #region 増減工事リンク親コード取得

        /// <summary>

        /// 増減工事リンク親コード取得

        /// </summary>

        private static int GetLinkageCode2(int RemoveCode, IOConstructionLink LinkDB, ref int ParentCode)

        {

            try

            {

                string strSQL = "SELECT B.CONSTRUCTIONCODE, COUNT(*) FROM CONSTRUCTIONLINK A, CONSTRUCTIONLINK B";

                strSQL += string.Format(" WHERE A.FLUCTUATIONCODE = {0}", RemoveCode);

                strSQL += string.Format(" AND A.LINKTYPE = {0}", (int)CommonDefine.LinkDataType.FluctuationType);

                strSQL += " AND B.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE";

                strSQL += " GROUP BY B.CONSTRUCTIONCODE";

                ArrayList arList = new ArrayList();

                if (!LinkDB.ExecuteReader(strSQL, ref arList)) return 0;

                object[] CurRec = (object[])arList[0];

                ParentCode = CommonMotions.cnvInt(CurRec[0]);

                return CommonMotions.cnvInt(CurRec[1]);

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

                return 0;

            }

        }

        #endregion

                            ProcessExecuteNo_DRWork(m_ProcControlPara[NowPoint]);

        #region 出勤管理入力

        /// <summary>

        /// 出勤管理入力

        /// </summary>

        /// <returns></returns>

        public static void ProcessExecuteNo_DRWork(ProcessParameter CurrentPara)

        {

            // 出勤管理入力

            FrmDRWork frm = new FrmDRWork();

            try

            {

                // 自分のハンドルをリストへセットする

                int ProcessNo = (int)ClsExcute.ProcessExecuteNo.DRWork;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = ProcessNo;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = (Form)frm;

                // 起動・編集フラグ

                //int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference;

                //if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg))

                //{

                //    BackProcess();

                //    return;

                //}

                //if (EditFlg == (int)CommonDefine.ProcessDataEdit.Reference) frm.EditLock = true;

                // パラメータセット

                frm.PersonCode = CurrentPara.IntExecParameter[1];

                // フォーム表示

                frm.ShowDialog();

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

                BackProcess();

            }

            finally

            {

                frm.Dispose(); frm = null;

            }

        }

        #endregion

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Collections;

using log4net;

using Oracle.ManagedDataAccess.Client;

using ProcessManagement.DB.Oracle;

using ProcessManagement.DB.Core;

using ProcessManagement.DataModel;

using ProcessManagement.Common;

namespace ProcessManagement.DB.IOAccess

{

    /// <summary>

    /// 出勤日報データＤＢアクセス

    /// </summary>

    public class IOAttendanceData : OracleProcess

    {

        #region 定義部

        /// <summary>

        /// log4netログを使用する

        /// </summary>

        private static readonly ILog logger = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

        #endregion

        #region 定数

        /// <summary>

        /// データフィールド並び

        /// </summary>

        public enum DataColumn

        {

            /// <summary>

            /// 作成者コード

            /// </summary>

            PersonCode,

            /// <summary>

            /// 日報作成日

            /// </summary>

            AttendanceDate,

            /// <summary>

            /// 明細行番号

            /// </summary>

            SeqNo,

            /// <summary>

            /// 工事番号

            /// </summary>

            ConstructionCode,

            /// <summary>

            /// 残業時間

            /// </summary>

            OvertimeHours,

            /// <summary>

            /// コメント

            /// </summary>

            WorkingComment,

            /// <summary>

            /// 登録年月日

            /// </summary>

            EntryDate,

            /// <summary>

            /// 更新年月日

            /// </summary>

            UpdateDate,

        }

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

        /// <param name="ConnectionString"></param>

        public IOAttendanceData()

            : base(DBCommon.Instance.DBConnectString)

        {

        }

        #endregion

        #region SQL作成

        /// <summary>

        /// SQL作成

        /// </summary>

        private string CreateSelectSQL()

        {

            // SQL作成（oracleのDateTime型が変換できないのでCharに変換しておく）

            string strcmd = "SELECT";

            strcmd += "  PersonCode";                                       // 担当者コード

            strcmd += " ,TO_CHAR(AttendanceDate, 'YYYY/MM/DD')";            // 日報作成日

            strcmd += " ,SeqNo";                                            // 明細行番号

            strcmd += " ,ConstructionCode";                                 // 工事番号

            strcmd += " ,OvertimeHours";                                    // 残業時間

            strcmd += " ,WorkingComment";                                   // コメント

            strcmd += ", TO_CHAR(EntryDate, 'YYYY/MM/DD HH24:MI:ss')";      // 登録年月日

            strcmd += ", TO_CHAR(UpdateDate, 'YYYY/MM/DD HH24:MI:ss')";     // 更新年月日

            strcmd += " FROM AttendanceData";

            return strcmd;

        }

        #endregion

        #region 複数読込み処理

        public bool SelectAction(string AddSQLString, ref List<AttendanceData> data, bool bConnect = true)

        {

            //Oracle インターフェース

            string strcmd = "";

            ArrayList arData = new ArrayList();

            try

            {

                // SQL作成

                strcmd = CreateSelectSQL() + AddSQLString;

                // SQL実行

                if (!ExecuteReader(strcmd, ref arData, bConnect)) return false;

                // データセット

                foreach (object[] objwrk in arData)

                {

                    AttendanceData work = new AttendanceData();

                    Reader2Struct(objwrk, ref work);

                    data.Add(work);

                }

                return true;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);

                return false;

            }

        }

        #endregion

        #region 1件読込み処理

        public bool SelectAction(string AddSQLString, ref AttendanceData data, bool bConnect = true)

        {

            //Oracle インターフェース

            string strcmd = "";

            ArrayList arData = new ArrayList();

            try

            {

                strcmd = CreateSelectSQL() + AddSQLString;

                // SQL実行

                if (!ExecuteReader(strcmd, 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);

                return false;

            }

        }

        #endregion

        #region 1件追加処理

        /// <summary>

        /// 担当者毎経費データ追加

        /// </summary>

        /// <param name="data">担当者毎経費データデータ</param>

        /// <returns>true：成功 false：失敗</returns>

        public bool InsertAction(AttendanceData work, bool bConnect = true)

        {

            string strcmd = "";

            try

            {

                strcmd = "INSERT INTO AttendanceData";

                strcmd += "  (PersonCode";      // 担当者コード

                strcmd += " ,AttendanceDate";   // 日報作成日

                strcmd += " ,SeqNo";            // 明細行番号

                strcmd += " ,ConstructionCode"; // 工事番号

                strcmd += " ,OvertimeHours";    // 残業時間

                strcmd += " ,WorkingComment";   // コメント

                strcmd += " ,EntryDate";        // 登録年月日

                strcmd += " ,UpdateDate)";      // 更新年月日

                strcmd += " VALUES (";

                strcmd += string.Format("  {0}", work.PersonCode);                      // 担当者コード

                strcmd += string.Format(", TO_DATE('{0}','YYYY/MM/DD')"

                                            , work.AttendanceDate.ToShortDateString()); // 日報作成日

                strcmd += string.Format(", {0}", work.SeqNo);                           // 明細行番号

                strcmd += string.Format(", {0}", work.ConstructionCode);                // 工事番号

                strcmd += string.Format(", {0}", work.OvertimeHours);                   // 残業時間

                strcmd += string.Format(",'{0}'", work.WorkingComment);                 // コメント

                strcmd += ", TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

                strcmd += ", TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

                strcmd = strcmd + ")";

                if (!ExecuteNonQuery(strcmd, bConnect)) return false;

                return true;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);

                return false;

            }

        }

        #endregion

        #region 複数追加処理

        public bool InsertAction(List<AttendanceData> data, bool bConnect = true)

        {

            string strcmd = "";

            try

            {

                foreach (AttendanceData work in data)

                {

                    if (!InsertAction(work, bConnect)) return false;

                }

                return true;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);

                return false;

            }

        }

        #endregion

        #region 更新処理

        /// <summary>

        /// 担当者毎経費データ更新

        /// </summary>

        /// <param name="AddSQLString">更新条件SQL文字列</param>

        /// <param name="data">担当者毎経費データデータ</param>

        /// <returns>true：成功 false：失敗</returns>

        public bool UpdateAction(string AddSQLString, AttendanceData data, bool bConnect = true)

        {

            string strcmd = "";

            try

            {

                strcmd = "UPDATE AttendanceData";

                strcmd += " SET";

                strcmd += string.Format(" PersonCode = {0}", data.PersonCode);                  // 担当者コード

                strcmd += string.Format(",AttendanceDate = TO_DATE('{0}','YYYY/MM/DD')"

                                        , data.AttendanceDate.ToShortDateString());             // 日報作成日

                strcmd += string.Format(",SeqNo =  {0} ", data.SeqNo);                          // 明細行番号

                strcmd += string.Format(",ConstructionCode = {0}", data.ConstructionCode);      // 工事番号

                strcmd += string.Format(",OvertimeHours = {0}", data.OvertimeHours);            // 残業時間

                strcmd += string.Format(",WorkingComment = '{0}'", data.WorkingComment);        // コメント

                strcmd += ", UpdateDate = TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

                strcmd += AddSQLString;

                if (!ExecuteNonQuery(strcmd, bConnect)) return false;

                return true;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);

                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)

        {

            //Oracle インターフェース

            string strcmd = "";

            try

            {

                strcmd = string.Format("{0}{1}", "DELETE FROM AttendanceData", AddSQLString);

                if (!ExecuteNonQuery(strcmd, bConnect)) return false;

                return true;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);

                return false;

            }

        }

        #endregion

        #region 1項目更新処理

        /// <summary>

        /// 1項目の更新を行う

        /// </summary>

        /// <param name="ConstructionCode"></param>

        /// <param name="FeildNo"></param>

        /// <param name="value"></param>

        /// <param name="bConnect"></param>

        /// <returns></returns>

        public bool UpdateFeild(int PersonCode, DateTime AttendanceDate, int SeqNo, int FeildNo, object value, bool bConnect = true)

        {

            string strcmd = "";

            try

            {

                strcmd = "UPDATE AttendanceData";

                strcmd += " SET";

                switch (FeildNo)

                {

                    case (int)DataColumn.PersonCode:

                        strcmd += string.Format(" PersonCode = {0}", (int)value);

                        break;

                    case (int)DataColumn.AttendanceDate:

                        strcmd += string.Format(" AttendanceDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());

                        break;

                    case (int)DataColumn.SeqNo:

                        strcmd += string.Format(" SeqNo = {0}", (int)value);

                        break;

                    case (int)DataColumn.ConstructionCode:

                        strcmd += string.Format(" ConstructionCode = {0}", (int)value);

                        break;

                    case (int)DataColumn.OvertimeHours:

                        strcmd += string.Format(" OvertimeHours = {0}", (double)value);

                        break;

                    case (int)DataColumn.WorkingComment:

                        strcmd += string.Format(" WorkingComment = '{0}'", CommonMotions.cnvString(value));

                        break;

                }

                strcmd += ", UpdateDate = TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

                strcmd += CreatePrimarykeyString(PersonCode, AttendanceDate, SeqNo);

                if (!ExecuteNonQuery(strcmd, bConnect)) return false;

                return true;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);

                return false;

            }

        }

        #endregion

        #region データセット処理

        /// <summary>

        /// OracleDataReaderより構造体へセットする

        /// </summary>

        /// <param name="reader">OracleDataReader</param>

        /// <param name="wrk">構造体</param>

        public void Reader2Struct(object[] objwrk, ref AttendanceData wrk)

        {

            try

            {

                // データ取得

                wrk.PersonCode = int.Parse(objwrk[(int)DataColumn.PersonCode].ToString());                  // 担当者コード

                wrk.AttendanceDate = DateTime.Parse(objwrk[(int)DataColumn.AttendanceDate].ToString());     // 日報作成日

                wrk.SeqNo = int.Parse(objwrk[(int)DataColumn.SeqNo].ToString());                            // 明細行番号

                wrk.ConstructionCode = int.Parse(objwrk[(int)DataColumn.ConstructionCode].ToString());      // 工事番号

                wrk.OvertimeHours = double.Parse(objwrk[(int)DataColumn.OvertimeHours].ToString());         // 残業時間

                wrk.WorkingComment = objwrk[(int)DataColumn.WorkingComment].ToString();                     // 当日作業内容

                wrk.EntryDate = DateTime.Parse(objwrk[(int)DataColumn.EntryDate].ToString());

                wrk.UpdateDate = DateTime.Parse(objwrk[(int)DataColumn.UpdateDate].ToString());

            }

            catch (OracleException oraex)

            {

                logger.ErrorFormat("オラクルエラー：{0}：{1}", CommonMotions.GetMethodName(2), oraex.Message);

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(2), ex.Message);

            }

        }

        #endregion

        #region 検索文字列作成処理

        /// <summary>

        /// 主キー検索の文字列を返す

        /// </summary>

        /// <param name="PersonCode"></param>

        /// <param name="ActionDate"></param>

        /// <param name="DataType"></param>

        /// <param name="DataAddCount"></param>

        /// <returns></returns>

        public string CreatePrimarykeyString(int PersonCode, DateTime AttendanceDate, int SeqNo = 0)

        {

            string strWork = "";

            try

            {

                strWork = string.Format(" WHERE PersonCode = {0}", PersonCode);

                if (AttendanceDate != DateTime.MinValue)

                    strWork += string.Format(" AND AttendanceDate = TO_DATE('{0}','YYYY/MM/DD')", AttendanceDate.ToShortDateString());

                if (SeqNo != 0)

                    strWork += string.Format(" AND SeqNo = {0}", SeqNo);

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strWork);

            }

            return strWork;

        }

        #endregion

        #region 追加番号の最大値を取得

        /// <summary>

        /// 追加番号の最大値を取得する

        /// </summary>

        /// <param name="AddSQLString"></param>

        /// <param name="bConnect"></param>

        /// <returns></returns>

        public int SelectMaxAddDataCount(string AddSQLString, bool bConnect = true)

        {

            //Oracle インターフェース

            string strcmd = "";

            ArrayList arData = new ArrayList();

            int iRet = 0;

            try

            {

                // SQL作成

                strcmd = "SELECT NVL(MAX(SeqNo), 0) FROM AttendanceData" + AddSQLString;

                // SQL実行

                if (!ExecuteReader(strcmd, ref arData, bConnect)) return iRet;

                // データセット

                foreach (object[] objwrk in arData)

                {

                    if (objwrk[0].ToString().Equals("null"))

                        iRet = 0;

                    else

                        iRet = int.Parse(objwrk[0].ToString());

                }

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);

            }

            return iRet;

        }

        #endregion

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace ProcessManagement.DataModel

{

    /// <summary>

    /// 出勤日報データ定義クラス

    /// </summary>

    public class AttendanceData

    {

        #region メンバ変数

        /// <summary>

        /// 作成者コード

        /// </summary>

        private int         m_PersonCode = 0;

        /// <summary>

        /// 日報作成日

        /// </summary>

        private DateTime    m_AttendanceDate = DateTime.Now;

        /// <summary>

        /// 明細行番号

        /// </summary>

        private int         m_SeqNo = 0;

        /// <summary>

        /// 工事番号

        /// </summary>

        private int         m_ConstructionCode = 0;

        /// <summary>

        /// 残業時間

        /// </summary>

        private double      m_OvertimeHours = 0;

        /// <summary>

        /// コメント

        /// </summary>

        private string      m_WorkingComment = string.Empty;

        /// <summary>

        /// 登録年月日

        /// </summary>

        private DateTime    m_EntryDate = DateTime.Now;

        /// <summary>

        /// 更新年月日

        /// </summary>

        private DateTime    m_UpdateDate = DateTime.Now;

        #endregion

        #region プロパティ

        /// <summary>

        /// 作成者コード

        /// </summary>

        public int PersonCode

        {

            get { return m_PersonCode; }

            set { m_PersonCode = value; }

        }

        /// <summary>

        /// 日報作成日

        /// </summary>

        public DateTime AttendanceDate

        {

            get { return m_AttendanceDate; }

            set { m_AttendanceDate = value; }

        }

        /// <summary>

        /// 明細行番号

        /// </summary>

        public int SeqNo

        {

            get { return m_SeqNo; }

            set { m_SeqNo = value; }

        }

        /// <summary>

        /// 工事番号

        /// </summary>

        public int ConstructionCode

        {

            get { return m_ConstructionCode; }

            set { m_ConstructionCode = value; }

        }

        /// <summary>

        /// 残業時間

        /// </summary>

        public double OvertimeHours

        {

            get { return m_OvertimeHours; }

            set { m_OvertimeHours = value; }

        }

        /// <summary>

        /// 作業コメント

        /// </summary>

        public string WorkingComment

        {

            get { return m_WorkingComment; }

            set { m_WorkingComment = value; }

        }

        /// <summary>

        /// 登録年月日

        /// </summary>

        public DateTime EntryDate

        {

            get { return m_EntryDate; }

            set { m_EntryDate = value; }

        }

        /// <summary>

        /// 更新年月日

        /// </summary>

        public DateTime UpdateDate

        {

            get { return m_UpdateDate; }

            set { m_UpdateDate = value; }

        }

        #endregion

    }

}

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle9 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle10 = new System.Windows.Forms.DataGridViewCellStyle();

            this.Column7 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column6 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.panel3 = new System.Windows.Forms.Panel();

            this.label2 = new System.Windows.Forms.Label();

            this.cmbDepartment = new ProcessManagement.Forms.CustomControls.ComboBoxEX();

            this.label14 = new System.Windows.Forms.Label();

            this.cmbConstructionPerson = new ProcessManagement.Forms.CustomControls.ComboBoxEX();

            this.label15 = new System.Windows.Forms.Label();

            this.label13 = new System.Windows.Forms.Label();

            this.label12 = new System.Windows.Forms.Label();

            this.label10 = new System.Windows.Forms.Label();

            this.label11 = new System.Windows.Forms.Label();

            this.label9 = new System.Windows.Forms.Label();

            this.label8 = new System.Windows.Forms.Label();

            this.label7 = new System.Windows.Forms.Label();

            this.label5 = new System.Windows.Forms.Label();

            this.comboBox1 = new ProcessManagement.Forms.CustomControls.ComboBoxEX();

            this.label4 = new System.Windows.Forms.Label();

            this.pnlApproval = new System.Windows.Forms.Panel();

            this.lblApprovalCount = new System.Windows.Forms.Label();

            this.btnPetition = new System.Windows.Forms.Button();

            this.btnApproval = new System.Windows.Forms.Button();

            this.pnlApprovalButton = new System.Windows.Forms.Panel();

            this.btnOnApproval = new System.Windows.Forms.Button();

            this.btnNotApproval = new System.Windows.Forms.Button();

            this.btnOnHold = new System.Windows.Forms.Button();

            this.panel3.SuspendLayout();

            this.pnlApproval.SuspendLayout();

            this.pnlApprovalButton.SuspendLayout();

            this.label1.Location = new System.Drawing.Point(422, 9);

            this.label1.Text = "出　勤　日　報";

            this.btnLineDel.Location = new System.Drawing.Point(815, 635);

            this.btnLineAdd.Location = new System.Drawing.Point(677, 635);

            this.btnDataDelete.Location = new System.Drawing.Point(1089, 635);

            this.btnDataEntry.Location = new System.Drawing.Point(963, 635);

            this.btnEnd.Location = new System.Drawing.Point(1215, 635);

            this.btnOtherProc.Location = new System.Drawing.Point(7, 635);

            this.pnlWork.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 

            this.pnlWork.Location = new System.Drawing.Point(5, 122);

            this.pnlWork.Size = new System.Drawing.Size(1334, 500);

            dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            dataGridViewCellStyle6.BackColor = System.Drawing.SystemColors.Control;

            dataGridViewCellStyle6.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            dataGridViewCellStyle6.ForeColor = System.Drawing.SystemColors.WindowText;

            dataGridViewCellStyle6.SelectionBackColor = System.Drawing.SystemColors.Highlight;

            dataGridViewCellStyle6.SelectionForeColor = System.Drawing.SystemColors.HighlightText;

            dataGridViewCellStyle6.WrapMode = System.Windows.Forms.DataGridViewTriState.True;

            this.dgvAllDisplay.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle6;

            this.dgvAllDisplay.ColumnHeadersHeight = 24;

            this.Column2,

            this.Column7,

            this.Column6});

            this.dgvAllDisplay.Location = new System.Drawing.Point(5, 8);

            this.dgvAllDisplay.RowTemplate.Height = 24;

            this.dgvAllDisplay.Size = new System.Drawing.Size(1320, 482);

            dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            this.Column1.DefaultCellStyle = dataGridViewCellStyle7;

            this.Column1.Width = 70;

            dataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            this.Column3.DefaultCellStyle = dataGridViewCellStyle8;

            this.Column3.Width = 80;

            dataGridViewCellStyle9.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;

            this.Column2.DefaultCellStyle = dataGridViewCellStyle9;

            this.Column2.Width = 650;

            // Column7

            // 

            dataGridViewCellStyle10.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;

            this.Column7.DefaultCellStyle = dataGridViewCellStyle10;

            this.Column7.Frozen = true;

            this.Column7.HeaderText = "残業時間";

            this.Column7.Name = "Column7";

            this.Column7.Resizable = System.Windows.Forms.DataGridViewTriState.False;

            this.Column7.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            // 

            // Column6

            // 

            this.Column6.Frozen = true;

            this.Column6.HeaderText = "備　考";

            this.Column6.Name = "Column6";

            this.Column6.Resizable = System.Windows.Forms.DataGridViewTriState.False;

            this.Column6.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.Column6.Width = 400;

            // 

            // panel3

            // 

            this.panel3.Anchor = System.Windows.Forms.AnchorStyles.Top;

            this.panel3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(128)))), ((int)(((byte)(255)))));

            this.panel3.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.panel3.Controls.Add(this.label2);

            this.panel3.Controls.Add(this.cmbDepartment);

            this.panel3.Controls.Add(this.label14);

            this.panel3.Controls.Add(this.cmbConstructionPerson);

            this.panel3.Controls.Add(this.label15);

            this.panel3.Controls.Add(this.label13);

            this.panel3.Controls.Add(this.label12);

            this.panel3.Controls.Add(this.label10);

            this.panel3.Controls.Add(this.label11);

            this.panel3.Controls.Add(this.label9);

            this.panel3.Controls.Add(this.label8);

            this.panel3.Controls.Add(this.label7);

            this.panel3.Controls.Add(this.label5);

            this.panel3.Controls.Add(this.comboBox1);

            this.panel3.Controls.Add(this.label6);

            this.panel3.Controls.Add(this.label4);

            this.panel3.Controls.Add(this.label3);

            this.panel3.Controls.Add(this.pnlApproval);

            this.panel3.Controls.Add(this.pnlApprovalButton);

            this.panel3.Location = new System.Drawing.Point(6, 40);

            this.panel3.Name = "panel3";

            this.panel3.Size = new System.Drawing.Size(1325, 74);

            this.panel3.TabIndex = 104;

            // 

            // label2

            // 

            this.label2.BackColor = System.Drawing.Color.LemonChiffon;

            this.label2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label2.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.label2.ForeColor = System.Drawing.Color.Black;

            this.label2.Location = new System.Drawing.Point(692, 39);

            this.label2.Name = "label2";

            this.label2.Size = new System.Drawing.Size(54, 27);

            this.label2.TabIndex = 127;

            this.label2.Text = "時間";

            this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // cmbDepartment

            // 

            this.cmbDepartment.BackColor = System.Drawing.Color.White;

            this.cmbDepartment.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

            this.cmbDepartment.FlatStyle = System.Windows.Forms.FlatStyle.Popup;

            this.cmbDepartment.Font = new System.Drawing.Font("ＭＳ 明朝", 15.75F, System.Drawing.FontStyle.Bold);

            this.cmbDepartment.FormattingEnabled = true;

            this.cmbDepartment.Location = new System.Drawing.Point(437, 4);

            this.cmbDepartment.Name = "cmbDepartment";

            this.cmbDepartment.Size = new System.Drawing.Size(260, 29);

            this.cmbDepartment.TabIndex = 123;

            this.cmbDepartment.TextChanged += new System.EventHandler(this.cmbDepartment_TextChanged);

            // 

            // label14

            // 

            this.label14.BackColor = System.Drawing.Color.SandyBrown;

            this.label14.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label14.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.label14.ForeColor = System.Drawing.Color.Black;

            this.label14.Location = new System.Drawing.Point(309, 5);

            this.label14.Name = "label14";

            this.label14.Size = new System.Drawing.Size(120, 27);

            this.label14.TabIndex = 126;

            this.label14.Text = "担当部署";

            this.label14.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // cmbConstructionPerson

            // 

            this.cmbConstructionPerson.BackColor = System.Drawing.Color.White;

            this.cmbConstructionPerson.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

            this.cmbConstructionPerson.FlatStyle = System.Windows.Forms.FlatStyle.Popup;

            this.cmbConstructionPerson.Font = new System.Drawing.Font("ＭＳ 明朝", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.cmbConstructionPerson.FormattingEnabled = true;

            this.cmbConstructionPerson.Location = new System.Drawing.Point(841, 4);

            this.cmbConstructionPerson.Name = "cmbConstructionPerson";

            this.cmbConstructionPerson.Size = new System.Drawing.Size(200, 29);

            this.cmbConstructionPerson.TabIndex = 124;

            this.cmbConstructionPerson.TextChanged += new System.EventHandler(this.cmbConstructionPerson_TextChanged);

            // 

            // label15

            // 

            this.label15.BackColor = System.Drawing.Color.SandyBrown;

            this.label15.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label15.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.label15.ForeColor = System.Drawing.Color.Black;

            this.label15.Location = new System.Drawing.Point(713, 5);

            this.label15.Name = "label15";

            this.label15.Size = new System.Drawing.Size(120, 27);

            this.label15.TabIndex = 125;

            this.label15.Text = "担　当　者";

            this.label15.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // label13

            // 

            this.label13.BackColor = System.Drawing.Color.White;

            this.label13.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label13.Font = new System.Drawing.Font("Century", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.label13.Location = new System.Drawing.Point(632, 39);

            this.label13.Name = "label13";

            this.label13.Size = new System.Drawing.Size(60, 27);

            this.label13.TabIndex = 122;

            this.label13.Text = "999";

            this.label13.TextAlign = System.Drawing.ContentAlignment.MiddleRight;

            // 

            // label12

            // 

            this.label12.BackColor = System.Drawing.Color.LemonChiffon;

            this.label12.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label12.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.label12.ForeColor = System.Drawing.Color.Black;

            this.label12.Location = new System.Drawing.Point(469, 39);

            this.label12.Name = "label12";

            this.label12.Size = new System.Drawing.Size(27, 27);

            this.label12.TabIndex = 121;

            this.label12.Text = "日";

            this.label12.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // label10

            // 

            this.label10.BackColor = System.Drawing.Color.LemonChiffon;

            this.label10.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label10.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.label10.ForeColor = System.Drawing.Color.Black;

            this.label10.Location = new System.Drawing.Point(272, 39);

            this.label10.Name = "label10";

            this.label10.Size = new System.Drawing.Size(27, 27);

            this.label10.TabIndex = 120;

            this.label10.Text = "日";

            this.label10.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // label11

            // 

            this.label11.BackColor = System.Drawing.Color.Transparent;

            this.label11.Font = new System.Drawing.Font("ＭＳ 明朝", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.label11.ForeColor = System.Drawing.Color.Black;

            this.label11.Location = new System.Drawing.Point(200, 39);

            this.label11.Name = "label11";

            this.label11.Size = new System.Drawing.Size(32, 27);

            this.label11.TabIndex = 120;

            this.label11.Text = "～";

            this.label11.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // label9

            // 

            this.label9.BackColor = System.Drawing.Color.LemonChiffon;

            this.label9.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label9.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.label9.ForeColor = System.Drawing.Color.Black;

            this.label9.Location = new System.Drawing.Point(173, 39);

            this.label9.Name = "label9";

            this.label9.Size = new System.Drawing.Size(27, 27);

            this.label9.TabIndex = 120;

            this.label9.Text = "日";

            this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // label8

            // 

            this.label8.BackColor = System.Drawing.Color.White;

            this.label8.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label8.Font = new System.Drawing.Font("Century", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.label8.Location = new System.Drawing.Point(232, 39);

            this.label8.Name = "label8";

            this.label8.Size = new System.Drawing.Size(40, 27);

            this.label8.TabIndex = 119;

            this.label8.Text = "99";

            this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // label7

            // 

            this.label7.BackColor = System.Drawing.Color.White;

            this.label7.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label7.Font = new System.Drawing.Font("Century", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.label7.Location = new System.Drawing.Point(133, 39);

            this.label7.Name = "label7";

            this.label7.Size = new System.Drawing.Size(40, 27);

            this.label7.TabIndex = 119;

            this.label7.Text = "99";

            this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // label5

            // 

            this.label5.BackColor = System.Drawing.Color.LemonChiffon;

            this.label5.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label5.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.label5.ForeColor = System.Drawing.Color.Black;

            this.label5.Location = new System.Drawing.Point(512, 39);

            this.label5.Name = "label5";

            this.label5.Size = new System.Drawing.Size(120, 27);

            this.label5.TabIndex = 117;

            this.label5.Text = "残業時間";

            this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // comboBox1

            // 

            this.comboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

            this.comboBox1.FlatStyle = System.Windows.Forms.FlatStyle.Popup;

            this.comboBox1.Font = new System.Drawing.Font("ＭＳ 明朝", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.comboBox1.FormattingEnabled = true;

            this.comboBox1.Location = new System.Drawing.Point(133, 4);

            this.comboBox1.Name = "comboBox1";

            this.comboBox1.Size = new System.Drawing.Size(160, 29);

            this.comboBox1.TabIndex = 114;

            // 

            this.label6.BackColor = System.Drawing.Color.SandyBrown;

            this.label6.Location = new System.Drawing.Point(5, 5);

            this.label6.TabIndex = 111;

            this.label6.Text = "対象年月";

            // label4

            this.label4.BackColor = System.Drawing.Color.White;

            this.label4.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label4.Font = new System.Drawing.Font("Century", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.label4.Location = new System.Drawing.Point(429, 39);

            this.label4.Name = "label4";

            this.label4.Size = new System.Drawing.Size(40, 27);

            this.label4.TabIndex = 113;

            this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            this.label3.Location = new System.Drawing.Point(309, 39);

            this.label3.TabIndex = 112;

            // pnlApproval

            this.pnlApproval.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));

            this.pnlApproval.BackColor = System.Drawing.Color.White;

            this.pnlApproval.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.pnlApproval.Controls.Add(this.lblApprovalCount);

            this.pnlApproval.Controls.Add(this.btnPetition);

            this.pnlApproval.Controls.Add(this.btnApproval);

            this.pnlApproval.Location = new System.Drawing.Point(1056, 0);

            this.pnlApproval.Name = "pnlApproval";

            this.pnlApproval.Size = new System.Drawing.Size(262, 34);

            this.pnlApproval.TabIndex = 109;

            this.pnlApproval.Visible = false;

            // lblApprovalCount

            this.lblApprovalCount.BackColor = System.Drawing.Color.Black;

            this.lblApprovalCount.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.lblApprovalCount.ForeColor = System.Drawing.Color.White;

            this.lblApprovalCount.Location = new System.Drawing.Point(205, 3);

            this.lblApprovalCount.Name = "lblApprovalCount";

            this.lblApprovalCount.Size = new System.Drawing.Size(50, 24);

            this.lblApprovalCount.TabIndex = 1;

            this.lblApprovalCount.Text = "4/5";

            this.lblApprovalCount.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // btnPetition

            this.btnPetition.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 

            | System.Windows.Forms.AnchorStyles.Right)));

            this.btnPetition.BackColor = System.Drawing.Color.White;

            this.btnPetition.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.btnPetition.ForeColor = System.Drawing.Color.Red;

            this.btnPetition.Location = new System.Drawing.Point(3, 3);

            this.btnPetition.Name = "btnPetition";

            this.btnPetition.Size = new System.Drawing.Size(100, 24);

            this.btnPetition.TabIndex = 12;

            this.btnPetition.Text = "未申請";

            this.btnPetition.UseVisualStyleBackColor = false;

            // btnApproval

            this.btnApproval.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));

            this.btnApproval.BackColor = System.Drawing.Color.White;

            this.btnApproval.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.btnApproval.ForeColor = System.Drawing.Color.Red;

            this.btnApproval.Location = new System.Drawing.Point(104, 3);

            this.btnApproval.Name = "btnApproval";

            this.btnApproval.Size = new System.Drawing.Size(100, 24);

            this.btnApproval.TabIndex = 12;

            this.btnApproval.Text = "未承認";

            this.btnApproval.UseVisualStyleBackColor = false;

            // pnlApprovalButton

            // 

            this.pnlApprovalButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));

            this.pnlApprovalButton.AutoSize = true;

            this.pnlApprovalButton.BackColor = System.Drawing.Color.White;

            this.pnlApprovalButton.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.pnlApprovalButton.Controls.Add(this.btnOnApproval);

            this.pnlApprovalButton.Controls.Add(this.btnNotApproval);

            this.pnlApprovalButton.Controls.Add(this.btnOnHold);

            this.pnlApprovalButton.Location = new System.Drawing.Point(1056, 0);

            this.pnlApprovalButton.Name = "pnlApprovalButton";

            this.pnlApprovalButton.Size = new System.Drawing.Size(262, 34);

            this.pnlApprovalButton.TabIndex = 110;

            this.pnlApprovalButton.Visible = false;

            // 

            // btnOnApproval

            // 

            this.btnOnApproval.BackColor = System.Drawing.Color.MediumSpringGreen;

            this.btnOnApproval.Location = new System.Drawing.Point(5, 3);

            this.btnOnApproval.Name = "btnOnApproval";

            this.btnOnApproval.Size = new System.Drawing.Size(83, 24);

            this.btnOnApproval.TabIndex = 34;

            this.btnOnApproval.TabStop = false;

            this.btnOnApproval.Text = "承認";

            this.btnOnApproval.UseVisualStyleBackColor = false;

            // 

            // btnNotApproval

            // 

            this.btnNotApproval.BackColor = System.Drawing.Color.Red;

            this.btnNotApproval.Location = new System.Drawing.Point(171, 3);

            this.btnNotApproval.Name = "btnNotApproval";

            this.btnNotApproval.Size = new System.Drawing.Size(83, 24);

            this.btnNotApproval.TabIndex = 35;

            this.btnNotApproval.TabStop = false;

            this.btnNotApproval.Text = "不承認";

            this.btnNotApproval.UseVisualStyleBackColor = false;

            // 

            // btnOnHold

            // 

            this.btnOnHold.BackColor = System.Drawing.Color.Yellow;

            this.btnOnHold.Location = new System.Drawing.Point(88, 3);

            this.btnOnHold.Name = "btnOnHold";

            this.btnOnHold.Size = new System.Drawing.Size(83, 24);

            this.btnOnHold.TabIndex = 36;

            this.btnOnHold.TabStop = false;

            this.btnOnHold.Text = "保留";

            this.btnOnHold.UseVisualStyleBackColor = false;

            // 

            this.ClientSize = new System.Drawing.Size(1344, 677);

            this.Controls.Add(this.panel3);

            this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.FrmDRWork_FormClosing);

            this.Load += new System.EventHandler(this.FrmDRWork_Load);

            this.panel3.ResumeLayout(false);

            this.panel3.PerformLayout();

            this.pnlApproval.ResumeLayout(false);

            this.pnlApprovalButton.ResumeLayout(false);

        private System.Windows.Forms.Panel panel3;

        private System.Windows.Forms.Panel pnlApproval;

        private System.Windows.Forms.Label lblApprovalCount;

        private System.Windows.Forms.Button btnPetition;

        private System.Windows.Forms.Button btnApproval;

        private System.Windows.Forms.Panel pnlApprovalButton;

        private System.Windows.Forms.Button btnOnApproval;

        private System.Windows.Forms.Button btnNotApproval;

        private System.Windows.Forms.Button btnOnHold;

        private System.Windows.Forms.Label label5;

        private CustomControls.ComboBoxEX comboBox1;