Example #1
0
        private void 查询ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            SelectForm selectForm = new SelectForm();

            if (selectForm.ShowDialog() == DialogResult.OK)
            {
                cItem         = selectForm.CItem;
                resermand     = selectForm.Resermand;
                startDateTime = selectForm.StartDateTime.ToString();
                endDateTime   = selectForm.EndDateTime.ToString();
                olddict.Clear();
                olddict.Add("项目编码", cItem);
                olddict.Add("请购人", resermand);
                this.Cursor = Cursors.WaitCursor;
                DataTable dt = sqlSelectTable.GetMainTable(cItemCode: cItem, resermand: resermand, starttime: startDateTime, endtime: endDateTime);
                this.Cursor = Cursors.Default;
                if (dt.Rows.Count > 0)
                {
                    dataTable = dt.Copy();
                    olddt     = dt.Copy();
                    dataAll   = dt.Copy();
                    scrDataGridView1.DataSource = dataTable;
                }
                else
                {
                    MessageBox.Show("没有查询到信息");
                }
            }
        }
Example #2
0
        public ProgressForm(SqlProcessor sqlProcessor) : this()
        {
            sqlSelectTable = new SQLSelectTable(sqlProcessor);
            DataTable data = sqlSelectTable.GetMainTable();

            scrDataGridView1.CellDoubleClickEvent += new CellDoubleClickHandler(CellDoubleClick);
            scrDataGridView1.SetBindingSource(data);
        }