private void listBox1_SelectedIndexChangedobject sender EventArgs estring selectedMoNo = listBox1SelectedItemToString;string sql = select mo_no as 制令单号 mrp_no as 成品编号 sta_dd as 预计开工日期 end_dd as 结束日期 q
在listBox1的SelectedIndexChanged事件中添加代码,以确保双击事件后移除了选中项,并自动选中下一项。修改的代码如下:
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { if (listBox1.SelectedItem != null) { string selectedMoNo = listBox1.SelectedItem.ToString(); string sql = "select mo_no as '制令单号', mrp_no as '成品编号', sta_dd as '预计开工日期', end_dd as '结束日期', qty as '生产数量', qty_fin as '缴库数量', (select name from mf_bom where prd_no = mf_mo.mrp_no) as '生产成品' from mf_mo where mo_no = @MoNo";
using (SqlConnection connection = new SqlConnection(erpConnString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@MoNo", selectedMoNo);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
dataGridView1.DataSource = dataTable;
dataGridView1.Columns[0].Width = 150;
dataGridView1.Columns[1].Width = 150;
dataGridView1.Columns[2].Width = 150;
dataGridView1.Columns[3].Width = 150;
dataGridView1.Columns[4].Width = 120;
dataGridView1.Columns[5].Width = 120;
dataGridView1.Columns[6].Width = 280;
dataGridView1.Columns[4].DefaultCellStyle.ForeColor = Color.Red;
dataGridView1.Columns[5].DefaultCellStyle.ForeColor = Color.Green; //单独设置一列颜色
dataGridView1.Columns[4].DefaultCellStyle.Font = new Font(dataGridView1.Font.FontFamily, 12, FontStyle.Bold); // 单独设置一列字体
dataGridView1.Columns[5].DefaultCellStyle.Font = new Font(dataGridView1.Font.FontFamily, 12, FontStyle.Bold);
//dataGridView1.Columns[4].DefaultCellStyle.Font = new Font(dataGridView1.Font, FontStyle.Bold); // 单独设置
//dataGridView1.Columns[5].DefaultCellStyle.Font = new Font(dataGridView1.Font, FontStyle.Bold);
dataGridView1.DefaultCellStyle.Font = new Font(dataGridView1.DefaultCellStyle.Font.FontFamily, 12); // 总体设置字体
}
DrawChart();
DrawChart2();
// 添加选中项到listBox2
listBox2.Items.Add(selectedMoNo);
// 移除选中项
listBox1.Items.Remove(selectedMoNo);
// 自动选中下一项
if (listBox1.Items.Count > 0)
{
listBox1.SelectedIndex = 0;
}
}
}
原文地址: https://www.cveoy.top/t/topic/iNUC 著作权归作者所有。请勿转载和采集!