//private void combCustomerLive_DrawItem(object sender, DrawItemEventArgs e) //{ // e.DrawBackground(); // e.DrawFocusRectangle(); // e.Graphics.DrawString(((DataRowView)combCustomerLive.Items[e.Index]).Row[combCustomerLive.DisplayMember].ToString(), e.Font, new SolidBrush(e.ForeColor), e.Bounds, new System.Drawing.StringFormat()); //} private void dgvCustomerLive_CellClick(object sender, DataGridViewCellEventArgs e) { DataGridView dgv = sender as DataGridView; if (e.RowIndex >= 0 && e.ColumnIndex >= 0) { customerLive.cusID = dgv.Rows[e.RowIndex].Cells[0].Value.ToString(); customerLive.floorNum = dgv.Rows[e.RowIndex].Cells[1].Value.ToString(); customerLive.roomID = dgv.Rows[e.RowIndex].Cells[2].Value.ToString(); customerLive.startLiveTime = DateTime.Parse(dgv.Rows[e.RowIndex].Cells[3].Value.ToString()); customerLive.proEndLiveTime = DateTime.Parse(dgv.Rows[e.RowIndex].Cells[4].Value.ToString()); customerLive.endLiveTime = DateTime.Parse(dgv.Rows[e.RowIndex].Cells[5].Value.ToString()); customerLive.isAccount = dgv.Rows[e.RowIndex].Cells[6].Value.ToString() == "是" ? 1 : 0; } else { customerLive = new Model.CustomerLive(); if (sortOrder == 0) { dgv.Sort(dgv.Columns[e.ColumnIndex], ListSortDirection.Descending); sortOrder++; } else { dgv.Sort(dgv.Columns[e.ColumnIndex], ListSortDirection.Ascending); sortOrder--; } } }
private void SearchCustomerLive(string sqlString) { customerLive = new Model.CustomerLive(); DataSet ds = new BLL.CustomerLive().GetListCustomerLive(sqlString); if (ds.Tables["ds"].Rows.Count == 0) { MessageBox.Show("查无结果!", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { dgvCustomerLive.DataSource = ds.Tables["ds"]; int columnNumber = dgvCustomerLive.ColumnCount; foreach (DataGridViewColumn col in dgvCustomerLive.Columns) { col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; col.SortMode = DataGridViewColumnSortMode.NotSortable; col.FillWeight = 100 / columnNumber; } dgvCustomerLive.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvCustomerLive.AllowUserToAddRows = false; dgvCustomerLive.RowHeadersVisible = false; dgvCustomerLive.ReadOnly = true; } }
public void LoadData_CustomerLiveInfo() { customerLive = new Model.CustomerLive(); dsCustomerLive = new BLL.CustomerLive().GetListCustomerLive(""); dgvCustomerLive.DataSource = dsCustomerLive.Tables["ds"]; int columnNumber = dgvCustomerLive.ColumnCount; foreach (DataGridViewColumn col in dgvCustomerLive.Columns) { col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; col.SortMode = DataGridViewColumnSortMode.NotSortable; col.FillWeight = 100 / columnNumber; } dgvCustomerLive.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvCustomerLive.AllowUserToAddRows = false; dgvCustomerLive.RowHeadersVisible = false; dgvCustomerLive.ReadOnly = true; }