示例#1
0
        /// <summary>
        /// ヘッダ情報取得
        /// </summary>
        /// <remarks>
        /// 作成者    :  nakao
        /// 作成日    :  2019/09/01
        /// </remarks>
        private void GetHeader()
        {
            DataSet  dtSet    = null;
            DataBase dataBase = null;

            try
            {
                dataBase = new DataBase();
                List <object> paraList = new List <object>();
                string        sqlStr   = QueryBuild.GetSeihanHeader(DPY_NO, ref paraList);

                dataBase.ConnectDB();
                dtSet = dataBase.GetDataSet(sqlStr, paraList.ToArray());

                DataRow row = dtSet.Tables[0].Rows[0];

                SUBNEGA_NO = row["SUBNEGA_NO"].ToString();
                CMNY       = row["CMNY_NM"].ToString();
                CMKBN      = row["CMKBN_NM"].ToString();
                BURANDO_NM = row["BURANDO_NM"].ToString();
                SYOHIN_NM  = row["SYOHIN_NM"].ToString();
                KAN_NM     = row["KAN_NM"].ToString();
                ZUMEN_NO   = row["ZUMEN_NO"].ToString();
                HAN_KBN    = row["HAN_KBN"].ToString();
                COLOR_NM   = row["COLOR_NM"].ToString();
                KSKBN      = row["KSKBN_NM"].ToString();
                KSZAI      = row["KOSEIZAI"].ToString();
                KSBUSU     = row["GOKEI_CT"].ToString();

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