Esempio n. 1
0
        /// <summary>
        /// 進捗データ登録
        /// </summary>
        /// <param name="dpyno">伝票No</param>
        /// <param name="process">工程コード</param>
        /// <param name="uid">ユーザーID</param>
        /// <returns>処理成否</returns>
        /// <remarks>
        /// 作成者    :  nakao
        /// 作成日    :  2019/09/01
        /// </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.RegistSeihanMgmt(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.RegistSeihanMgmt(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;
        }