internal YoshiHanbaiHdrTblDataSet.TyumonShosaiDataTable GetDataByYoshiHanbaiChumonNo(string yoshiHanbaiChumonNo)
        {
            SqlCommand command = CreateSqlCommand(yoshiHanbaiChumonNo);

            SqlDataAdapter adpt = new SqlDataAdapter(command);
            adpt.SelectCommand.Connection = this.Connection;

            YoshiHanbaiHdrTblDataSet.TyumonShosaiDataTable dataTable = new YoshiHanbaiHdrTblDataSet.TyumonShosaiDataTable();
            adpt.Fill(dataTable);

            return dataTable;
        }
Esempio n. 2
0
        ////////////////////////////////////////////////////////////////////////////
        //  メソッド名 : DoFormLoad
        /// <summary>
        /// 
        /// </summary>
        /// <history>
        /// 日付    担当者   内容
        /// 2014/07/21  AnhNV      新規作成
        /// </history>
        ////////////////////////////////////////////////////////////////////////////
        private void DoFormLoad()
        {
            IFormLoadALInput alInput = new FormLoadALInput();
            alInput.YoshiHanbaiChumonNo = this._yoshiHanbaiChumonNo;
            IFormLoadALOutput alOutput = new FormLoadApplicationLogic().Execute(alInput);

            // 業者マスタ
            this._gyoshaMst = alOutput.GyoshaMstDataTable;

            // 支所(1)
            Utility.Utility.SetComboBoxList(shishoNmComboBox, alOutput.ShishoMstDataTable, "ShishoNm", "ShishoCd", true);

            // Display default value in Detail mode
            if (this._dispMode == DispMode.Detail)
            {
                this._hdrTable = alOutput.YoshiHanbaiHdrTblDataTable;

                // Default value
                DisplayDefault();
            }

            // 用紙一覧グリッドビュー(9)
            _dgvSource = alOutput.TyumonShosaiDataTable;
            yoshiListDataGridView.DataSource = _dgvSource;
        }