List<QuestionMain> reQuestionMain = new List<QuestionMain>();
reQuestionMain= RunProcGetVO(sql,str);
int n= Convert.ToInt32(reQuestionMain.Count);
for(int i=0;i<n;i++)
{
QuestionChild singleQuestionChild = new QuestionChild();
singleQuestionChild.PK_Question = reQuestionMain[i].PK_Question.ToString();
List<QuestionChild> singleQuestionChilds = new QuestionChildDA().RunProcGetTable1(singleQuestionChild);
for (int b = 0; b < singleQuestionChilds.Count; b++)
{
singleQuestionChild.Destination = Convert.ToString(singleQuestionChilds[b].Destination);
singleQuestionChild.Operator = Convert.ToString(singleQuestionChilds[b].Operator);
singleQuestionChild.PK_Corp = Convert.ToString(singleQuestionChilds[b].PK_Corp);
singleQuestionChild.PK_Product = Convert.ToString(singleQuestionChilds[b].PK_Product);
singleQuestionChild.PK_QuesChild = Convert.ToString(singleQuestionChilds[b].PK_QuesChild);
...........
singleQuestionChild.U9 = Convert.ToString(singleQuestionChilds[b].U9);
singleQuestionChild.U10 = Convert.ToString(singleQuestionChilds[b].U10);
reQuestionMain[3].QuestionChild.Add(singleQuestionChild);
}
}
return reQuestionMain;
}为什么执行完之后List<QuestionMan>的每一条记录里的属性List<QuestinChild>的条数是一样的,我想要的结果是List<QuestinChild>的值是查询出来的结果,查询的结果肯定是不一样的啊?也就是说查询结果是什么,该属性的值就是什么的,帮忙看看!
reQuestionMain= RunProcGetVO(sql,str);
int n= Convert.ToInt32(reQuestionMain.Count);
for(int i=0;i<n;i++)
{
QuestionChild singleQuestionChild = new QuestionChild();
singleQuestionChild.PK_Question = reQuestionMain[i].PK_Question.ToString();
List<QuestionChild> singleQuestionChilds = new QuestionChildDA().RunProcGetTable1(singleQuestionChild);
for (int b = 0; b < singleQuestionChilds.Count; b++)
{
singleQuestionChild.Destination = Convert.ToString(singleQuestionChilds[b].Destination);
singleQuestionChild.Operator = Convert.ToString(singleQuestionChilds[b].Operator);
singleQuestionChild.PK_Corp = Convert.ToString(singleQuestionChilds[b].PK_Corp);
singleQuestionChild.PK_Product = Convert.ToString(singleQuestionChilds[b].PK_Product);
singleQuestionChild.PK_QuesChild = Convert.ToString(singleQuestionChilds[b].PK_QuesChild);
...........
singleQuestionChild.U9 = Convert.ToString(singleQuestionChilds[b].U9);
singleQuestionChild.U10 = Convert.ToString(singleQuestionChilds[b].U10);
reQuestionMain[3].QuestionChild.Add(singleQuestionChild);
}
}
return reQuestionMain;
}为什么执行完之后List<QuestionMan>的每一条记录里的属性List<QuestinChild>的条数是一样的,我想要的结果是List<QuestinChild>的值是查询出来的结果,查询的结果肯定是不一样的啊?也就是说查询结果是什么,该属性的值就是什么的,帮忙看看!
public IList<SysMenuEntity> MenuGetALL(string Parameters)
{
IList<SysMenuEntity> result = new List<SysMenuEntity>();
StringBuilder StrSql = new StringBuilder();
StrSql.AppendFormat(" SELECT * FROM Sys_Menu WHERE MenuName Like '%{0}%' ", Parameters); using (SqlDataReader SqlDatar = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, StrSql.ToString()))
{
SysMenuEntity MenuEntity;
while (SqlDatar.Read())
{
MenuEntity = this.SetMenuReader(SqlDatar);
result.Add(MenuEntity);
}
}
return result;
}
private SysMenuEntity SetMenuReader(SqlDataReader SqlDatar)
{
SysMenuEntity MenuEntity = new SysMenuEntity();
try
{
MenuEntity.Id = SqlDatar.GetInt32(0);
MenuEntity.MenuNo = SqlDatar.GetString(1);
MenuEntity.MeunName = SqlDatar.GetString(2);
MenuEntity.BLRoot = SqlDatar.GetBoolean(3);
MenuEntity.BLSubMenu = SqlDatar.GetBoolean(4);
MenuEntity.MenuTitle = SqlDatar.GetString(5);
MenuEntity.MenuIcoPath = SqlDatar.GetString(6);
MenuEntity.CreateUser = SqlDatar.GetString(8);
}
catch
{
throw;
}
return MenuEntity;
}
List <QuestionMain> reQuestionMain = new List <QuestionMain>();
reQuestionMain= RunProcGetVO(sql,str);
int n= Convert.ToInt32(reQuestionMain.Count);
for(int i=0;i <n;i++)
{
QuestionChild singleQuestionChild = new QuestionChild();
singleQuestionChild.PK_Question = reQuestionMain[i].PK_Question.ToString();
List <QuestionChild> singleQuestionChilds = new QuestionChildDA().RunProcGetTable1(singleQuestionChild);
reQuestionMain[i].QuestionChild.AddRange(singleQuestionChilds);
}
return reQuestionMain;
你这段代码实在是没看明白
singleQuestionChilds已经是泛型了
为什么还每个属性都要赋值给singleQuestionChild
直接添加进reQuestionMain不就得了么