コード例 #1
0
        /// <summary>
        /// ヘッダ情報取得
        /// </summary>
        /// <remarks>
        /// 作成者    :  kawana
        /// 作成日    :  2019/10/24
        /// </remarks>
        private void GetHeader()
        {
            DataSet  dtSet    = null;
            DataBase dataBase = null;

            try
            {
                dataBase = new DataBase();
                List <object> paraList = new List <object>();
                string        sqlStr   = QueryBuild.GetJushihanHeader(JSBDPY_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();
                LOTSU       = row["LOTSU"].ToString();
                HANSU       = row["HANSU"].ToString();
                BURANDO_NM  = row["BURANDO_NM"].ToString();
                CUSTMER_RNM = row["CUSTMER_RNM"].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();

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