你作为一个C#程序员。我现在需求是通过sql mo_no from mf_mo where sta_dd=系统日期查询到的mo_no则添加进listBox1中当查询结束后则根据listBox1中的所有mo_no做为条件进行查询 select depnamemo_nosta_ddcls_dd from mf_mo where mo_no=listbox中的所有mo_no把查询结果展示在datagri

你可以使用以下代码来实现你的需求：

// 查询并将mo_no添加到listBox1中
string query = "SELECT mo_no FROM mf_mo WHERE sta_dd = @sysDate";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlCommand command = new SqlCommand(query, connection);
    command.Parameters.AddWithValue("@sysDate", DateTime.Now.Date);
    SqlDataReader reader = command.ExecuteReader();
    while (reader.Read())
    {
        listBox1.Items.Add(reader["mo_no"].ToString());
    }
    reader.Close();
}

// 使用listBox1中的所有mo_no作为条件查询数据并展示在dataGridView1中
string selectQuery = "SELECT dep, name, mo_no, sta_dd, cls_dd FROM mf_mo WHERE mo_no IN ({0})";
string moNos = string.Join(",", listBox1.Items.Cast<string>().Select(item => $"'{item}'"));
selectQuery = string.Format(selectQuery, moNos);
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter(selectQuery, connection);
    DataTable dataTable = new DataTable();
    adapter.Fill(dataTable);
    dataGridView1.DataSource = dataTable;
}

// 设置dataGridView1的样式
dataGridView1.DefaultCellStyle.Font = new Font("宋体", 12);
dataGridView1.DefaultCellStyle.ForeColor = Color.Green;
dataGridView1.DefaultCellStyle.BackColor = Color.Yellow;
dataGridView1.Rows[0].Selected = true;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.ReadOnly = true;

请确保将connectionString替换为你的SQL Server连接字符串