Example #1
0
        /// <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);
        }
Example #2
0
        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   = "";
        }
Example #3
0
        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 = "";
        }
Example #4
0
        /// <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);
        }