/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bnTop_btnSearch_Click(object sender, EventArgs e) { if (_Load) { //_Btn.DataPropertyName = "BTN"; //dgv1.Columns.Add(_Btn); _Chb.DataPropertyName = "CHB"; //_Chb.Name = "CHB"; dgv1.Columns.Add(_Chb); _Load = false; } _dtDataSource = DALCreator.PrdAllocation.GetNotice(_Date.Value, bnBottom_txtBillNo.Text); dgv1.DataSource = _dtDataSource; //_Btn = dgv1.Columns[0] as DataGridViewButtonColumn; //_Btn.HeaderText = ""; //_Btn.Name = "BTN"; //_Btn.Width = 60; _Ch = new datagridviewCheckboxHeaderCell(); _Chb = dgv1.Columns[0] as DataGridViewCheckBoxColumn; _Chb.Width = 35; _Chb.DataPropertyName = "CHB"; //_Chb.FalseValue = false; //_Chb.TrueValue = true; _Chb.HeaderCell = _Ch; _Chb.HeaderCell.Value = ""; _Ch.OnCheckBoxClicked += ch_OnCheckBoxClicked; }
public void InitDataGridViewMaster() { var list = DataHelper.GetProductItemList(); dataGridViewMaster.AutoGenerateColumns = false; dataGridViewMaster.DataSource = list; //创建复选框列 DataGridViewCheckBoxColumn checkboxCol = new DataGridViewCheckBoxColumn(); //创建复选框列头单元格 datagridviewCheckboxHeaderCell ch = new datagridviewCheckboxHeaderCell(); //设置复选框那列的单元格为复选框 checkboxCol.HeaderCell = ch; //将此复选框列添加到DataGridView中 this.dataGridViewMaster.Columns.Insert(0, checkboxCol); ch.OnCheckBoxClicked += new datagridviewcheckboxHeaderEventHander(ch_OnCheckBoxClicked);//关联单击事件 }
/// <summary> /// 获取数据 /// </summary> /// <param name="pType">Search,ChangePageSize OR Navi</param> private void DataSourceBinding(int pType) { if (_Load) { _Chb.DataPropertyName = "chb"; dgv1.Columns.Add(_Chb); _Load = false; } if (_ListFilter.Count == 0) { MessageBox.Show("请过滤单据"); return; } string strFilter = GetFilter(); if (strFilter.Equals(string.Empty)) { return; } if (pType == 1)//重新加载数据源 { _DataSource = DALCreator.PrdAllocation.GetTransForP(strFilter); if (_DataSource == null || _DataSource.Rows.Count == 0) { dgv1.DataSource = null; return; } _CurrentPage = 1; //当前页数从1开始 } else if (pType == 2) //改变_PageSize,重新计算 _CurrentPage { if (dgv1.DataSource == null || dgv1.Rows.Count == 0) { return; } _CurrentPage = _Start / _PageSize + 1; } _RecordCount = _DataSource.Rows.Count; _PageCount = (_RecordCount / _PageSize); if ((_RecordCount % _PageSize) > 0) { _PageCount++; } _Start = _PageSize * (_CurrentPage - 1); if (_CurrentPage == _PageCount) { _End = _RecordCount; } else { _End = _PageSize * _CurrentPage; } _DataTemp = _DataSource.Clone(); for (int i = _Start; i < _End; i++) { _DataTemp.ImportRow(_DataSource.Rows[i]); } bn_txtCurrentPage.Text = _CurrentPage.ToString(); bn_lblPageCount.Text = string.Format("{0}页", _PageCount.ToString()); bn_lblRecordCount.Text = string.Format("{0}行", _RecordCount.ToString()); bn_lblLockQty.Text = string.Format("锁库数汇总:{0}", SumQty("锁库数量")); bs1.DataSource = _DataTemp; bn1.BindingSource = bs1; dgv1.DataSource = bs1; _Ch = new datagridviewCheckboxHeaderCell(); _Chb = dgv1.Columns[0] as DataGridViewCheckBoxColumn; _Chb.Width = 35; _Chb.DataPropertyName = "chb"; _Chb.HeaderCell = _Ch; _Chb.HeaderCell.Value = ""; _Ch.OnCheckBoxClicked += ch_OnCheckBoxClicked; }
/// <summary> /// 获取数据 /// </summary> /// <param name="pType">Search,ChangePageSize OR Navi</param> private void DataSourceBinding(int pType) { if (_Load) { _Chb.DataPropertyName = "chb"; dgv1.Columns.Add(_Chb); _Load = false; } if (pType == 1)//重新加载数据源 { _DataSource = DALFactory.K3Cloud.DALCreator.SalOrder.NoPriceOrders(_FOrgIds); if (_DataSource == null || _DataSource.Rows.Count == 0) { dgv1.DataSource = null; return; } _CurrentPage = 1; //当前页数从1开始 } else if (pType == 2) //改变_PageSize,重新计算 _CurrentPage { if (dgv1.DataSource == null || dgv1.Rows.Count == 0) { return; } _CurrentPage = _Start / _PageSize + 1; } _RecordCount = _DataSource.Rows.Count; _PageCount = (_RecordCount / _PageSize); if ((_RecordCount % _PageSize) > 0) { _PageCount++; } _Start = _PageSize * (_CurrentPage - 1); if (_CurrentPage == _PageCount) { _End = _RecordCount; } else { _End = _PageSize * _CurrentPage; } _DataTemp = _DataSource.Clone(); for (int i = _Start; i < _End; i++) { _DataTemp.ImportRow(_DataSource.Rows[i]); } bn_txtCurrentPage.Text = _CurrentPage.ToString(); bn_lblPageCount.Text = string.Format("{0}页", _PageCount.ToString()); bn_lblRecordCount.Text = string.Format("{0}行", _RecordCount.ToString()); bs1.DataSource = _DataTemp; bn1.BindingSource = bs1; dgv1.DataSource = bs1; _Ch = new datagridviewCheckboxHeaderCell(); _Chb = dgv1.Columns[0] as DataGridViewCheckBoxColumn; _Chb.Width = 35; _Chb.DataPropertyName = "chb"; _Chb.HeaderCell = _Ch; _Chb.HeaderCell.Value = ""; _Ch.OnCheckBoxClicked += ch_OnCheckBoxClicked; }