private void readDept 读取ERP生产部门的值 执行SQL查询语句让cbx_p_cat显示已有的类别 DateTime selectedDate = dtpKanBanValueDate; 只获取日期部分 using SqlConnection connection =

要让查询到的dep值唯一性，可以使用DISTINCT关键字来筛选重复值。修改查询语句如下：

string query = "SELECT DISTINCT dep, (select name from dept where dep=mf_mo.dep) as name FROM mf_mo WHERE sta_dd = @selectedDate";