/// <summary>
/// 选择志愿
/// </summary>
/// <returns>小组志愿列表更新所影响的行数</returns>
public int SelectVol(GroupTableData groupTableData)
{
string sql = @"update GroupTable set VolFirstId=@VolFirstId,VolSecondId=@VolSecondId,VolThirdId=@VolThirdId,Topic=@Topic where leaderno = @leaderno";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("@VolFirstId", SqlDbType.NVarChar),
new SqlParameter("@VolSecondId", SqlDbType.NVarChar),
new SqlParameter("@VolThirdId", SqlDbType.NVarChar),
new SqlParameter("@Topic", SqlDbType.NVarChar),
new SqlParameter("@leaderno", SqlDbType.NVarChar),
};
sqlParameters[0].Value = groupTableData.VolFirstId;
sqlParameters[1].Value = groupTableData.VolSecondId;
sqlParameters[2].Value = groupTableData.VolThirdId;
sqlParameters[3].Value = groupTableData.Topic;
sqlParameters[4].Value = groupTableData.Leaderno;
int res = SQLHelper.ExecuteNonQuery(sql, CommandType.Text, sqlParameters);
return(res);
}
/// <summary>
/// 选择志愿
/// </summary>
/// <returns>小组志愿列表更新所影响的行数</returns>
public int SelectVol(GroupTableData groupTableData)
{
return(ss.SelectVol(groupTableData));
}
