private void frmPhieuCan_Load(object sender, EventArgs e)
{
String sSQL = "SELECT phieu_can,lan_can,trong_luong FROM PhieuCanChiTiet";
NdataFunc ndata = new NdataFunc();
sqlDataAdapter = ndata.getSqlDataAdapter(sSQL);
sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter);
dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
bindingSource = new BindingSource();
bindingSource.DataSource = dataTable;
dgvPhieuCanChiTiet.DataSource = bindingSource;
dgvPhieuCanChiTiet.Columns[0].HeaderText = "PHIẾU CÂN";
dgvPhieuCanChiTiet.Columns[0].Visible = false;
dgvPhieuCanChiTiet.Columns[1].HeaderText = "LẦN CÂN";
dgvPhieuCanChiTiet.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPhieuCanChiTiet.Columns[2].Width = 110;
dgvPhieuCanChiTiet.Columns[2].HeaderText = "TRỌNG LƯỢNG";
dgvPhieuCanChiTiet.Columns[2].Width = 180;
// if you want to hide Identity column
//dgvPhieuCanChiTiet.Columns[0].Visible = false;
txtLanCan.Text = lanCan.ToString();
}
private void initPhieuCanChiTiet(string soPhieu)
{
try
{
String sSQL = "SELECT phieu_can,lan_can,trong_luong,lot,status FROM PhieuCanChiTiet WHERE phieu_can=N'" + soPhieu + "'";
NdataFunc ndata = new NdataFunc();
sqlDataAdapter = ndata.getSqlDataAdapter(sSQL);
sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter);
dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
bindingSource = new BindingSource();
bindingSource.DataSource = dataTable;
dgvPhieuCanChiTiet.DataSource = bindingSource;
dgvPhieuCanChiTiet.Columns[0].HeaderText = "PHIẾU CÂN";
dgvPhieuCanChiTiet.Columns[0].Visible = false;
dgvPhieuCanChiTiet.Columns[0].DefaultCellStyle.ForeColor = Color.Gray;
dgvPhieuCanChiTiet.Columns[1].HeaderText = "LẦN CÂN";
dgvPhieuCanChiTiet.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPhieuCanChiTiet.Sort(dgvPhieuCanChiTiet.Columns[1], ListSortDirection.Descending);
dgvPhieuCanChiTiet.Columns[2].HeaderText = "TRỌNG LƯỢNG";
dgvPhieuCanChiTiet.Columns[2].Width = 160;
dgvPhieuCanChiTiet.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvPhieuCanChiTiet.Columns[3].HeaderText = "LOT";
dgvPhieuCanChiTiet.Columns[3].Width = 160;
dgvPhieuCanChiTiet.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvPhieuCanChiTiet.Columns[3].Visible = true;
dgvPhieuCanChiTiet.Columns[4].HeaderText = "LOẠI BỎ";
dgvPhieuCanChiTiet.Columns[4].Width = 68;
dgvPhieuCanChiTiet.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn();
//checkColumn.Name = "chkCancel";
//checkColumn.HeaderText = "LOẠI BỎ";
//checkColumn.Width = 68;
//checkColumn.ReadOnly = false;
//checkColumn.FillWeight = 10;
//dgvPhieuCanChiTiet.Columns.Add(checkColumn);
}
catch (Exception ex) { }
// if you want to hide Identity column
//dgvPhieuCanChiTiet.Columns[0].Visible = false;
txtLanCan.Text = lanCan.ToString();
}
