/// <summary>
/// 添加
/// </summary>
/// <param name="teacher">教师实体</param>
/// <returns></returns>
/// 2015年12月3日17:56:50
public bool TeacherAdd(string sUserAccount, string sUserGender, string IDCard, string sPhone, string adress, string course)
{
T.Models.Stu_Teacher teacher = new Stu_Teacher();
teacher.teacherID = dal.GetMaxID();
teacher.teacherIDCard = IDCard;
teacher.teacherGender = sUserGender;
teacher.teacherAdress = adress;
teacher.teacherBeiYong = course;
teacher.teacherDate = DateTime.Now;
teacher.teacherIsDelete = false;
teacher.teacherName = sUserAccount;
teacher.teacherPhone = sPhone;
teacher.teacherReamrk = "1";
return(dal.TeacherAdd(teacher));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="teacher">教师实体</param>
/// <returns></returns>
/// 2015年12月3日17:56:50
public bool TeacherAdd(Stu_Teacher teacher)
{
if (teacher == null)
{
teacher = new Stu_Teacher();
return(false);
}
StringBuilder str = new StringBuilder();
str.Append(" insert into Stu_Teacher ");
str.Append(" (teacherID, teacherName, teacherGender, teacherPhone, teacherAdress, teacherReamrk, teacherIsDelete, teacherBeiYong,teacherDate) ");
str.Append(" values ");
str.Append(" ( @teacherID,@teacherName,@teacherGender,@teacherPhone,@teacherAdress,@teacherReamrk, @teacherIsDelete, @teacherBeiYong,@teacherDate ) ");
SqlParameter[] param =
{
new SqlParameter("@teacherID", SqlDbType.Int),
new SqlParameter("@teacherName", SqlDbType.NVarChar),
new SqlParameter("@teacherGender", SqlDbType.NVarChar),
new SqlParameter("@teacherPhone", SqlDbType.NVarChar),
new SqlParameter("@teacherAdress", SqlDbType.NVarChar),
new SqlParameter("@teacherReamrk", SqlDbType.NVarChar),
new SqlParameter("@teacherIsDelete", SqlDbType.Bit),
new SqlParameter("@teacherBeiYong", SqlDbType.NVarChar),
new SqlParameter("@teacherDate", SqlDbType.DateTime)
};
param[0].Value = teacher.teacherID;
param[1].Value = teacher.teacherName;
param[2].Value = teacher.teacherGender;
param[3].Value = teacher.teacherPhone;
param[4].Value = teacher.teacherAdress;
param[5].Value = teacher.teacherReamrk;
param[6].Value = teacher.teacherIsDelete;
param[7].Value = teacher.teacherBeiYong;
param[8].Value = DateTime.Now;
var row = SqlHelp.ExecuteNonQuery(str.ToString(), CommandType.Text, param);
if (row > 0)
{
return(true);
}
return(false);
}
