public ObservableCollection<EQMSItem> GetGenerList(string Type, string User, string EQMS_ID) { ObservableCollection<EQMSItem> list = new ObservableCollection<EQMSItem>(); this.spName = "***"; SqlParameter[] paras = new SqlParameter[3]; paras[0] = new SqlParameter("@Type", SqlDbType.VarChar, 50) { Value = Type }; paras[1] = new SqlParameter("@User", SqlDbType.VarChar, 50) { Value = User }; paras[2] = new SqlParameter("@ID", SqlDbType.VarChar, 50) { Value = ID }; DataTable dt = this.Execute(spName, null); for (int i = 0; i < dt.Rows.Count; i++) { list.Add(new EQMSItem() { UserID = dt.Rows[i]["UserID"].ToString(), }); } return list; } 我DAL层一开始这么写的,可是怎么返回五个list到BLL层?难道要执行5次存储???
或者在你的ViewModel层中 加载这5个list,赋值给具体变量,在xaml.cs中指定该页面的DataContext为你的ViewModel,在每个Combobox中使用ItemScoure=“{bing list}"
public ObservableCollection<EQMSItem> GetGenerList(string Type, string User, string EQMS_ID)
{
ObservableCollection<EQMSItem> list = new ObservableCollection<EQMSItem>();
this.spName = "***";
SqlParameter[] paras = new SqlParameter[3];
paras[0] = new SqlParameter("@Type", SqlDbType.VarChar, 50) { Value = Type };
paras[1] = new SqlParameter("@User", SqlDbType.VarChar, 50) { Value = User };
paras[2] = new SqlParameter("@ID", SqlDbType.VarChar, 50) { Value = ID }; DataTable dt = this.Execute(spName, null); for (int i = 0; i < dt.Rows.Count; i++)
{
list.Add(new EQMSItem()
{
UserID = dt.Rows[i]["UserID"].ToString(), });
} return list;
}
我DAL层一开始这么写的,可是怎么返回五个list到BLL层?难道要执行5次存储???
否则你的函数只能返回一个LIST,当然要执行5次了
原谅我这个小白,怎么定义List[]集合??