public int UpdateStudentInfo(int clsid, ModelStudent ms)
{
string strError = "";
string sqlquery = "update Student set BatchID=@batchID,StudentName=@studentName,Gender=@gender,Birthday=@birthday,ClassID=@classID,StudentDep=@studentDep where StudentNo=@studentno";
SqlParameter[] sps = new SqlParameter[7];
sps[0] = new SqlParameter(@"batchID", ms.BatchID);
sps[1] = new SqlParameter("@studentName", ms.StudentName);
sps[2] = new SqlParameter("@gender", ms.Gender);
sps[3] = new SqlParameter("@birthday", ms.Birthday);
sps[4] = new SqlParameter("@classID", ms.ClassID);
sps[5] = new SqlParameter("@studentDep", ms.StudentDep);
sps[6] = new SqlParameter("@studentNo", ms.StudentNo);
int x = db.DBExecuteNonQuery(sqlquery, sps, out strError);
return(x);
}
public int AddStudent(ModelStudent ms)
{
string strError = "";
string sqlquery = "insert into Student values(@batchID,@studentNo,@studentName,@gender,@birthday,@classID,@studentDep)";
SqlParameter[] sps = new SqlParameter[7];
sps[0] = new SqlParameter("@batchID", ms.BatchID);
sps[1] = new SqlParameter("@studentNo", ms.StudentNo);
sps[2] = new SqlParameter("@studentName", ms.StudentName);
sps[3] = new SqlParameter("@gender", ms.Gender);
sps[4] = new SqlParameter("@birthday", ms.Birthday);
sps[5] = new SqlParameter("@classID", ms.ClassID);
sps[6] = new SqlParameter("@studentDep", ms.StudentDep);
int x = db.DBExecuteNonQuery(sqlquery, sps, out strError);
return(x);
}
