/// <summary>
/// 根据关键字执行SelectT_CourseFaction模糊查询查询得到T_CourseFaction
/// </summary>
/// <param name="curIndex"></param>
/// <param name="dataLength"></param>
/// <param name="stuID"></param>
/// <param name="stuName"></param>
/// <param name="courseName"></param>
/// <param name="teachName"></param>
/// <returns></returns>
internal object ExecuteT_CourseFaction(int curIndex, int dataLength, string stuID, string stuName, string courseName, string teachName)
{
string t_sql = "SelectT_CourseFaction";
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@curIndex", SqlDbType.Int)
{
Value = curIndex
},
new SqlParameter("@dataLength", SqlDbType.Int)
{
Value = dataLength
},
new SqlParameter("@stuID", SqlDbType.VarChar)
{
Value = "%" + stuID + "%"
},
new SqlParameter("@stuName", SqlDbType.VarChar)
{
Value = "%" + stuName + "%"
},
new SqlParameter("@courseName", SqlDbType.VarChar)
{
Value = "%" + courseName + "%"
},
new SqlParameter("@teachName", SqlDbType.VarChar)
{
Value = "%" + teachName + "%"
}
};
SqlHelper sql = new SqlHelper();
List <T_CourseFaction> factions = null;
using (SqlDataReader reader = sql.ExecuteReader(t_sql, CommandType.StoredProcedure, pars)) {
if (reader.HasRows)
{
factions = new List <T_CourseFaction>();
while (reader.Read())
{
T_CourseFaction faction = new T_CourseFaction();
faction.ID = reader.GetInt32(0);
faction.StuID = reader.GetInt32(1);
faction.StuName = reader.GetString(2);
faction.CourseName = reader.GetString(3);
faction.TeacherName = reader.GetString(4);
faction.Faction = reader.IsDBNull(5)?0:float.Parse(reader.GetValue(5).ToString());
factions.Add(faction);
}
}
}
return(factions);
}
public FrmUpdateFaction(T_CourseFaction faction) : this()
{
this.faction = faction;
}
