/// <summary> /// ����Ա��ӽ�ʦ�û� /// </summary> /// <param name="mTeacher">����ӵĽ�ʦ����</param> /// <returns>�Ƿ���ӳɹ����ɹ���true,ʧ����false</returns> public bool AddTeacher(TeacherInfo mTeacher) { SqlParameter[] parms = { new SqlParameter("@userName",mTeacher.StrUserName), new SqlParameter("@pwd",mTeacher.StrPassword), new SqlParameter("@name",mTeacher.StrTeacherName), new SqlParameter("@identityID",mTeacher.StrIdentityId) }; bool isSuccess = false; int affectedRows = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringSTEduSys, CommandType.StoredProcedure, "SP_AddTeacher", parms); if (affectedRows > 0) { isSuccess = true; } return isSuccess; }
/// <summary> /// ����Ա��ӽ�ʦ�û� /// </summary> /// <param name="mTeacher">����ӵĽ�ʦ����</param> /// <returns>�Ƿ���ӳɹ����ɹ���true,ʧ����false</returns> public bool AddTeacher(TeacherInfo mTeacher) { return dal.AddTeacher(mTeacher); }
public TeacherInfo GetTeacherByUserName(string userName) { SqlParameter param = new SqlParameter("@username", userName); TeacherInfo t = new TeacherInfo(); SqlDataReader r = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringSTEduSys, CommandType.StoredProcedure, "[SP_GetTeacherByUserName]", param); if (r.Read()) { t.ITeacherId = Convert.ToInt32(r["ID"]); t.StrIdentityId = Convert.ToString(r["identityID"]); t.StrPassword = Convert.ToString(r["pwd"]); t.StrTeacherName = Convert.ToString(r["name"]); t.StrUserName = Convert.ToString(r["username"]); } return t; }
// �佣����ӣ�2009-9-11 /// <summary> /// ���ݽ�ʦ�����֤�ŵõ���ʦ /// </summary> /// <param name="strIdentityID">��ʦ�����֤��</param> /// <returns>��ʦ</returns> public TeacherInfo GetTeacherByIdentityID(string strIdentityID) { SqlParameter param = new SqlParameter("@identityID", strIdentityID); TeacherInfo tch = new TeacherInfo(); SqlDataReader reader = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringSTEduSys, CommandType.StoredProcedure, "[SP_GetTeacherByIdentity]", param); if (reader.Read()) { tch.ITeacherId = Convert.ToInt32(reader["ID"]); tch.StrIdentityId = strIdentityID; tch.StrPassword = Convert.ToString(reader["pwd"]); tch.StrTeacherName = Convert.ToString(reader["name"]); tch.StrUserName = Convert.ToString(reader["UserName"]); } return tch; }