/// <summary>
/// ヘッダ情報取得
/// </summary>
/// <remarks>
/// 作成者 ： sesaki
/// 作成日 ： 2019/09/24
/// </remarks>
private void GetHeader()
{
DataSet dtSet = null;
DataBase dataBase = null;
try
{
dataBase = new DataBase();
List <object> paraList = new List <object>();
string sqlStr = QueryBuild.GetSappanHeader(SPDPY_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_NM = 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();
COLOR_NM = row["COLOR_NM"].ToString();
dataBase.DisconnectDB();
}
catch (Exception ex)
{
}
finally
{
if (dataBase != null)
{
dataBase.DisconnectDB();
}
if (dtSet != null)
{
dtSet.Dispose();
}
}
}