在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;
        }
    }
}
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

原文地址: https://www.cveoy.top/t/topic/iNUC 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录