oracle 小于 索引,请问大神们如何取得 OracleParameter []数组 索引小于5的OracleParameter []数组...

public TupleStuParam(EntTest model)

{string sql = string.Empty;

OracleParameter [] param=newOracleParameter[model.GetType().GetProperties().Count()];int index = 0;if (!string.IsNullOrEmpty(model.Id.ToString()))

{//sql += string.Format(" id=:{0}, ", EntTest.DB_ID);

param[index] = new OracleParameter(":" +EntTest.DB_ID, model.Id);

index++;

}if (!string.IsNullOrEmpty(model.Name))

{

sql+= string.Format("name=:{0},",EntTest.DB_NAME);

param[index]= new OracleParameter(":"+EntTest.DB_NAME,model.Name);

index++;

}if (!string.IsNullOrEmpty(model.Age.ToString()))

{

sql+= string.Format("age=:{0},",EntTest.DB_AGE);

param[index]= new OracleParameter(":"+EntTest.DB_AGE,model.Age);

index++;

}if (!string.IsNullOrEmpty(model.Sex))

{

sql+= string.Format("sex=:{0},",EntTest.DB_SEX);

param[index]= new OracleParameter(":"+EntTest.DB_SEX,model.Sex);

index++;

}if (!string.IsNullOrEmpty(model.Address))

{

sql+= string.Format("address=:{0},",EntTest.DB_ADDRESS);

param[index]= new OracleParameter(":"+EntTest.DB_ADDRESS, model.Sex);

index++;

}if (!string.IsNullOrEmpty(model.Hobby))

{

sql+= string.Format("hobby=:{0},",EntTest.DB_HOBBY);

param[index]= new OracleParameter(":"+EntTest.DB_HOBBY, model.Hobby);

index++;

}if (!string.IsNullOrEmpty(model.Class))

{

sql+= string.Format("class=:{0},",EntTest.DB_CLASS);

param[index]= new OracleParameter(":"+EntTest.DB_CLASS, model.Class);

index++;

}if (!string.IsNullOrEmpty(model.UpdateTime.ToString()))

{

sql+= string.Format("update_time=:{0},",EntTest.DB_UPDATE_TIME);

param[index]= new OracleParameter(":"+EntTest.DB_UPDATE_TIME, model.UpdateTime);

index++;

}if (!string.IsNullOrEmpty(model.UpdateUser))

{

sql+= string.Format("update_user=:{0},", EntTest.DB_UPDATE_USER);

param[index]= new OracleParameter(":" +EntTest.DB_UPDATE_USER, model.UpdateUser);

index++;

}if (!string.IsNullOrEmpty(model.CreateTime.ToString()))

{

sql+= string.Format("create_time=:{0},", EntTest.DB_CREATE_TIME);

param[index]= new OracleParameter(":" +EntTest.DB_CREATE_TIME, model.CreateTime);

index++;

}if (!string.IsNullOrEmpty(model.CreateUser))

{

sql+= string.Format("create_user=:{0},", EntTest.DB_CREATE_USER);

param[index]= new OracleParameter(":" +EntTest.DB_CREATE_USER, model.CreateUser);

index++;

}

sql=sql.Remove(sql.LastIndexOf(","),1);//OracleParameter[] s=param.ToArray().Select()(p=>p!=null);

return new Tuple(sql,param);

}