/// <summary> /// 進捗データ登録 /// </summary> /// <param name="dpyno">伝票No</param> /// <param name="process">工程</param> /// <param name="uid">ユーザーID</param> /// <returns>処理成否</returns> /// <remarks> /// 作成者 : sesaki /// 作成日 : 2019/09/24 /// </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.RegistSappanMgmt(register, dpyno, process, Constants.PROCESS_SUB1, uid, ref paraList); dataBase.CommitData(sqlStr, paraList.ToArray()); // 編集はサブ2登録 if (process.Equals(Constants.PROCESS_HENSHU)) { paraList.Clear(); register = GetTargetRegister(process, Constants.PROCESS_SUB2); sqlStr = QueryBuild.RegistSappanMgmt(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); }