示例#1
0
        /// <summary>
        /// 進捗データ登録
        /// </summary>
        /// <param name="dpyno">伝票No</param>
        /// <param name="process">工程</param>
        /// <param name="uid">ユーザーID</param>
        /// <returns>処理成否</returns>
        /// <remarks>
        /// 作成者    :  sesaki
        /// 作成日    :  2019/11/21
        /// </remarks>

        public bool RegistMgmt(string dpyno, string process, string uid)
        {
            DataSet  dtSet    = null;
            DataBase dataBase = null;

            try
            {
                string        sqlStr;
                Register      register;
                List <object> paraList = new List <object>();

                dataBase = new DataBase();
                dataBase.ConnectDB();

                // サブ1登録
                register = GetTargetRegister(process, Constants.PROCESS_SUB1);
                sqlStr   = QueryBuild.RegistGurabiaMgmt(register, dpyno, process, Constants.PROCESS_SUB1, uid, ref paraList);
                dataBase.CommitData(sqlStr, paraList.ToArray());

                // 編集と検査はサブ2登録
                if (process.Equals(Constants.PROCESS_HENSHU) || process.Equals(Constants.PROCESS_KENSA))
                {
                    paraList.Clear();
                    register = GetTargetRegister(process, Constants.PROCESS_SUB2);
                    sqlStr   = QueryBuild.RegistGurabiaMgmt(register, dpyno, process, Constants.PROCESS_SUB2, uid, ref paraList);
                    dataBase.CommitData(sqlStr, paraList.ToArray());
                }

                dataBase.DisconnectDB();
            }
            catch
            {
                return(false);
            }
            finally
            {
                if (dataBase != null)
                {
                    dataBase.DisconnectDB();
                }
                if (dtSet != null)
                {
                    dtSet.Dispose();
                }
            }

            return(true);
        }