/// <summary> /// 打开维护计划表 /// </summary> private void LoadData(MyType myType) { if (tsbExit.Visible) { tsbExit_Click(null, null); } if (tsbExitPrint.Visible) { tsbExitPrint_Click(null, null); } this._myType = myType; BLL.BaseBll bll = new BLL.BaseBll(); DataTable dtbl = bll.GetViewInfo(myType.ToString()); DataView dvw = new DataView(dtbl); SetDataView(ref dvw, "", GetSort(myType)); //给dgv重新指定数据源 dgvInfo.Columns.Clear(); dgvInfo.DataSource = dvw; //展示查询到的记录数 lblNumber.Text = dgvInfo.RowCount.ToString(); //给字段名加载信息 cbxColumnName.Items.Clear(); for (int i = 0; i < dgvInfo.Columns.Count; i++) { cbxColumnName.Items.Add(dgvInfo.Columns[i].Name); } SetGridView(myType); }
private void btnSelect_Click(object sender, EventArgs e) { if (cbxColumnName.Text.Trim().Length == 0 || cbxOperator.Text.Length == 0 || txtSelect.Text.Trim().Length == 0) { return; } if (cbxColumnName.Text.Contains("时间")) { DateTime dt; if (!DateTime.TryParse(txtSelect.Text.Trim(), out dt)) { return; } } StringBuilder sb = new StringBuilder(cbxColumnName.Text); switch (cbxOperator.Text) { case "等于": sb.AppendFormat(" = '{0}'", txtSelect.Text.Trim()); break; case "不等于": sb.AppendFormat(" <> '{0}'", txtSelect.Text.Trim()); break; case "大于": sb.AppendFormat(" > '{0}'", txtSelect.Text.Trim()); break; case "小于": sb.AppendFormat(" < '{0}'", txtSelect.Text.Trim()); break; case "大于等于": sb.AppendFormat(" >= '{0}'", txtSelect.Text.Trim()); break; case "小于等于": sb.AppendFormat(" <= '{0}'", txtSelect.Text.Trim()); break; case "模糊查询": sb.AppendFormat(" LIKE '%{0}%'", txtSelect.Text.Trim()); break; default: return; } BLL.BaseBll bll = new BLL.BaseBll(); DataTable dtbl = bll.GetViewInfo(this._myType.ToString()); DataView dvw = new DataView(dtbl); SetDataView(ref dvw, "", GetSort(this._myType)); //判断是否选中过滤当前 if (chbxNow.Checked) { this._sbSelect.AppendFormat(" AND {0}", sb.ToString()); SetDataView(ref dvw, this._sbSelect.ToString(), GetSort(this._myType)); } else { SetDataView(ref dvw, sb.ToString(), GetSort(this._myType)); this._sbSelect = sb; } //给dgv重新指定数据源 dgvInfo.Columns.Clear(); dgvInfo.DataSource = dvw; lblNumber.Text = dgvInfo.RowCount.ToString(); SetGridView(this._myType); this.cbxOperator.Text = ""; this.txtSelect.Text = ""; }
private void btnSelect_Click(object sender, EventArgs e) { if (cbxColumnName.Text.Trim().Length == 0 || cbxOperator.Text.Length == 0 || txtSelect.Text.Trim().Length == 0) { return; } if (cbxColumnName.Text.Contains("时间")) { DateTime dt; if (!DateTime.TryParse(txtSelect.Text.Trim(), out dt)) { return; } } StringBuilder sb = new StringBuilder(cbxColumnName.Text); switch (cbxOperator.Text) { case "等于" : sb.AppendFormat(" = '{0}'", txtSelect.Text.Trim()); break; case "不等于": sb.AppendFormat(" <> '{0}'", txtSelect.Text.Trim()); break; case "大于": sb.AppendFormat(" > '{0}'", txtSelect.Text.Trim()); break; case "小于": sb.AppendFormat(" < '{0}'", txtSelect.Text.Trim()); break; case "大于等于": sb.AppendFormat(" >= '{0}'", txtSelect.Text.Trim()); break; case "小于等于": sb.AppendFormat(" <= '{0}'", txtSelect.Text.Trim()); break; case "模糊查询": sb.AppendFormat(" LIKE '%{0}%'", txtSelect.Text.Trim()); break; default: return; } BLL.BaseBll bll = new BLL.BaseBll(); DataTable dtbl = bll.GetViewInfo(this._myType.ToString()); DataView dvw = new DataView(dtbl); SetDataView(ref dvw, "", GetSort(this._myType)); //判断是否选中过滤当前 if (chbxNow.Checked) { this._sbSelect.AppendFormat(" AND {0}", sb.ToString()); SetDataView(ref dvw, this._sbSelect.ToString(), GetSort(this._myType)); } else { SetDataView(ref dvw, sb.ToString(), GetSort(this._myType)); this._sbSelect = sb; } //给dgv重新指定数据源 dgvInfo.Columns.Clear(); dgvInfo.DataSource = dvw; lblNumber.Text = dgvInfo.RowCount.ToString(); SetGridView(this._myType); this.cbxOperator.Text = ""; this.txtSelect.Text = ""; }