/// <summary> /// 根据查询条件,获取品种_期货_交易费用 /// </summary> /// <returns></returns> private bool QueryQHFutureCosts() { try { string breedClassName = this.txtBreedClassID.Text; DataSet _dsQHFutureCosts = FuturesManageCommon.GetAllQHFutureCosts(breedClassName, m_pageNo, m_pageSize, out m_rowCount); DataTable _dtQHFutureCosts; if (_dsQHFutureCosts == null || _dsQHFutureCosts.Tables[0].Rows.Count == 0) { _dtQHFutureCosts = new DataTable(); } else { _dtQHFutureCosts = _dsQHFutureCosts.Tables[0]; } //绑定绑定品种类型是商品期货或股指期货的品种名称 this.ddlBreedClassID.DataSource = CommonParameterSetCommon.GetQHFutureCostsBreedClassName().Tables[0]; this.ddlBreedClassID.ValueMember = CommonParameterSetCommon.GetQHFutureCostsBreedClassName().Tables[0].Columns["BreedClassID"]. ToString(); this.ddlBreedClassID.DisplayMember = CommonParameterSetCommon.GetQHFutureCostsBreedClassName().Tables[0].Columns["BreedClassName"]. ToString(); //绑定货币类型 this.ddlCurrencyTypeID.DataSource = BindData.GetBindListCurrencyType(); this.ddlCurrencyTypeID.ValueMember = "ValueIndex"; this.ddlCurrencyTypeID.DisplayMember = "TextTitleValue"; //绑定手续费类型 this.ddlCostType.DataSource = BindData.GetBindListFutrueCostType(); this.ddlCostType.ValueMember = "ValueIndex"; this.ddlCostType.DisplayMember = "TextTitleValue"; this.gdFutureCostsResult.DataSource = _dtQHFutureCosts; } catch (Exception ex) { string errCode = "GL-6204"; string errMsg = "根据查询条件,获取品种_期货_交易费用失败!"; VTException exception = new VTException(errCode, errMsg, ex); LogHelper.WriteError(exception.ToString(), exception.InnerException); return(false); } return(true); }
//================================ 事件 ================================ #region 期货交易费用管理窗体 FutureCostsManageUI_Load /// <summary> /// 期货交易费用管理窗体 FutureCostsManageUI_Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FutureCostsManageUI_Load(object sender, EventArgs e) { try { //绑定品种类型是商品期货或股指期货的品种名称 this.cmbBreedClassID.Properties.Items.Clear(); this.GetBindQHFutureCostsBreedClassName(); //从交易商品品种表中获取 this.cmbBreedClassID.SelectedIndex = 0; //绑定货币类型 this.cmbCurrencyTypeID.Properties.Items.Clear(); this.cmbCurrencyTypeID.Properties.Items.AddRange(BindData.GetBindListCurrencyType()); this.cmbCurrencyTypeID.SelectedIndex = 0; //初次加载时,更新按钮禁用 //btnModify.Enabled = false; //绑定期货手续费类型 this.cmbCostType.Properties.Items.Clear(); this.cmbCostType.Properties.Items.AddRange(BindData.GetBindListFutrueCostType()); this.cmbCostType.SelectedIndex = 0; //绑定查询结果 this.m_pageNo = 1; this.gdFutureCostsResult.DataSource = this.QueryQHFutureCosts(); this.ShowDataPage(); //窗体加载时禁用文本框和确定按钮 this.cmbBreedClassID.Enabled = false; this.cmbCurrencyTypeID.Enabled = false; this.cmbCostType.Enabled = false; this.txtCost.Enabled = false; this.btnOK.Enabled = false; } catch (Exception ex) { string errCode = "GL-6200"; string errMsg = "期货交易费用管理窗体加载失败!"; VTException exception = new VTException(errCode, errMsg, ex); LogHelper.WriteError(exception.ToString(), exception.InnerException); return; } }