/// <summary> /// ヘッダ情報取得 /// </summary> /// <param name="customer">得意先コード</param> /// <remarks> /// 作成者 : sesaki /// 作成日 : 2019/11/21 /// </remarks> private void GetHeader(string customer) { DataSet dtSet = null; DataBase dataBase = null; try { dataBase = new DataBase(); List <object> paraList = new List <object>(); string sqlStr; if (GurabiaCustomer.IsTokan(customer)) { sqlStr = QueryBuild.GetGurabiaHeaderTokan(DPY_NO, ref paraList); } else { sqlStr = QueryBuild.GetGurabiaHeaderToyo(DPY_NO, ref paraList); } dataBase.ConnectDB(); dtSet = dataBase.GetDataSet(sqlStr, paraList.ToArray()); DataRow row = dtSet.Tables[0].Rows[0]; CUSTMER_RNM = row["CUSTMER_RNM"].ToString(); SUBNEGA_NO = row["SUBNEGA_NO"].ToString(); BURANDO_NM = row["BURANDO_NM"].ToString(); SYOHIN_NM = row["SYOHIN_NM"].ToString(); KAN_NM = row["KAN_NM"].ToString(); KSKBN_NM = row["KSKBN_NM"].ToString(); COLOR_NM = row["COLOR_NM"].ToString(); dataBase.DisconnectDB(); } catch (Exception ex) { } finally { if (dataBase != null) { dataBase.DisconnectDB(); } if (dtSet != null) { dtSet.Dispose(); } } }