Example #1
0
        private void LoadCustomerInPage(int page)
        {
            if (page < 1)
            {
                this.PageNumber = 1;
            }
            else if (page > this.TotalPageNumber)
            {
                this.PageNumber = this.TotalPageNumber;
            }
            else
            {
                this.PageNumber = page;
            }

            DataGridViewCustomerInfo.ClearSelection();

            DataTable dataTable = new DataTable();

            if (this.UserName.Equals(AllUsers))
            {
                dataTable = TableCustomerManage.QueryCustomerByPage(this.PageNumber, PageSize);
            }
            else
            {
                dataTable = TableCustomerManage.QueryCustomerByUserNameAndPage(this.UserName, this.PageNumber, PageSize);
            }

            DataGridViewCustomerInfo.DataSource = dataTable;
            FormatDataGridView(DataGridViewCustomerInfo);

            LblCurPage.Text = this.PageNumber + "/" + this.TotalPageNumber;
        }
Example #2
0
        private void DataGridViewCustomerInfo_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            try
            {
                int rowIndex = e.RowIndex;
                int count    = DataGridViewCustomerInfo.SelectedRows.Count;

                contextMenuStrip1.Items.Clear();

                ToolStripMenuItem tsmiAdd = CreateAddCustomerInfoMenuItem();
                contextMenuStrip1.Items.Add(tsmiAdd);

                if (count > 0)
                {
                    bool contains = DataGridViewCustomerInfo.SelectedRows.Contains(DataGridViewCustomerInfo.Rows[rowIndex]);
                    if (contains)
                    {
                        if (1 == count)
                        {
                            ToolStripMenuItem tsmiEdit = CreateEditCustomerInfoMenuItem();
                            contextMenuStrip1.Items.Add(tsmiEdit);
                        }

                        ToolStripMenuItem tsmiDelete = CreateDeleteCustomerInfoMenuItem();
                        contextMenuStrip1.Items.Add(tsmiDelete);
                    }
                    else
                    {
                        DataGridViewCustomerInfo.ClearSelection();
                    }
                }

                ToolStripSeparator tss = new ToolStripSeparator();
                contextMenuStrip1.Items.Add(tss);

                ToolStripMenuItem tsmiRefresh = CreateRefreshCustomerInfoMenuItem();
                contextMenuStrip1.Items.Add(tsmiRefresh);
            }
            catch (Exception ex)
            {
                MessageBox.Show(this, ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }