private void setGrdRate() { DataTable dt = new DataTable(); if (s.statusDiscount.Equals("1")) { dt = lc.srdb.selectBySale(s.Id); if (dt.Rows.Count <= 0) { dt = lc.selectRateAlltoSaleRate(); } } else { dgvRate.Visible = false; return; } dgvRate.Rows.Clear(); Font font = new Font("Microsoft Sans Serif", 12); dgvRate.SelectionMode = DataGridViewSelectionMode.CellSelect; dgvRate.RowCount = dt.Rows.Count; dgvRate.ColumnCount = 8; dgvRate.Columns[colRRow].Width = 50; dgvRate.Columns[colRDescription].Width = 150; dgvRate.Columns[colRRec].Width = 110; dgvRate.Columns[colSaleId].Width = 110; dgvRate.Columns[colRDiscount].Width = 100; dgvRate.Columns[colRLimit].Width = 120; dgvRate.Columns[colRId].Width = 80; dgvRate.Columns[colSRId].Width = 110; dgvRate.Columns[colRRow].HeaderText = "ลำดับ"; dgvRate.Columns[colSaleId].HeaderText = ""; dgvRate.Columns[colRDescription].HeaderText = "รายการ"; dgvRate.Columns[colRRec].HeaderText = "ซื้อ"; dgvRate.Columns[colRDiscount].HeaderText = "ส่วนลด"; dgvRate.Columns[colRLimit].HeaderText = "จำนวนอั้น"; dgvRate.Columns[colSRId].HeaderText = ""; dgvRate.Columns[colRId].HeaderText = "id";// dgvRate.Columns[colSaleId].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomRight; dgvRate.Columns[colRRec].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomRight; dgvRate.Columns[colRDiscount].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomRight; dgvRate.Columns[colSRId].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomRight; dgvRate.Columns[colRLimit].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomRight; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { dgvRate[colRRow, i].Value = (i + 1); dgvRate[colSaleId, i].Value = lc.cf.stringNull1(dt.Rows[i][lc.srdb.sr.SaleId]); dgvRate[colRDescription, i].Value = lc.cf.stringNull1(dt.Rows[i][lc.srdb.sr.Description]); dgvRate[colRRec, i].Value = dt.Rows[i][lc.srdb.sr.rec].ToString(); dgvRate[colRLimit, i].Value = String.Format("{0:#,###,###.00}", dt.Rows[i][lc.srdb.sr.limit1]); dgvRate[colRDiscount, i].Value = String.Format("{0:#,###,###.00}", dt.Rows[i][lc.srdb.sr.discount]); dgvRate[colRId, i].Value = dt.Rows[i][lc.srdb.sr.RateId].ToString(); dgvRate[colSRId, i].Value = dt.Rows[i][lc.srdb.sr.Id].ToString(); if ((i % 2) != 0) { dgvRate.Rows[i].DefaultCellStyle.BackColor = Color.LightSalmon; } } } dgvRate.RowHeadersVisible = false; dgvRate.Columns[colRId].Visible = false; dgvRate.Columns[colRRow].Visible = false; dgvRate.Columns[colSaleId].Visible = false; dgvRate.Columns[colSRId].Visible = false; dgvRate.Font = font; //setDataGrdThoo(); //setThooAmount(); }