public static string TeamMemberSelect(string operate, string userID, string schoolYear, string schoolCode, string actionType, string employeeID, string selected, string comment)
{
string sp1 = sp + ",@ActionType,@TeacherID,@Checked,@Comments";
ParameterSP3 parameter = new ParameterSP3 {
Operate = operate, UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode, ActionType = actionType, TeacherID = employeeID, Checked = selected, Comments = comment
};
return(GeneralDataAccess.TextValue(sp1, parameter));
// return PLFSiteTeam.Selected(operate, userID, schoolCode, schoolYear, actionType, employeeID, selected, comment);
}
public static string Selected(string operate, string userID, string schoolYear, string schoolCode, string actionType, string employeeID, string selected, string comment)
{
using (IDbConnection connection = new SqlConnection(conSTR))
{
string SP = sp + ",@ActionType,@TeacherID,@Checked,@Comments";
ParameterSP3 parameter = new ParameterSP3 {
Operate = operate, UserID = userID, SchoolYear = schoolYear, SchoolCode = schoolCode, ActionType = actionType, TeacherID = employeeID, Checked = selected, Comments = comment
};
var myResult = connection.QuerySingle <SingleString>(SP, parameter);
return(myResult.MyText);
}
}