public static List <TeacherInfoView> GetTeacherInfoList()
{
var retList = new List <TeacherInfoView>();
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
var cmdText = string.Format("select uName, rDate, Sex, Tel, University, jTitle, Desp, Email from TeacherSets");
using (var cmd = new SqlCommand(cmdText, conn))
{
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var user = new TeacherInfoView();
user.UserName = Convert.ToString(reader.GetValue(0));
user.RegisteDate = Convert.ToDateTime(reader.GetValue(1));
user.Sex = Convert.ToString(reader.GetValue(2));
user.Tel = Convert.ToString(reader.GetValue(3));
user.University = Convert.ToInt32(reader.GetValue(4));
user.JobTitle = Convert.ToInt32(reader.GetValue(5));
user.Desp = Convert.ToString(reader.GetValue(6));
user.Email = Convert.ToString(reader.GetValue(7));
retList.Add(user);
}
conn.Close();
}
}
return(retList);
}
public ReturnState UpdateTeacherrInfo(TeacherInfoView model)
{
ReturnState result;
teacherClient.UpdateTeacherrInfo(model, out result, out specify);
return(result);
}
public static TeacherInfoView GetTeacherInfo(string email)
{
var user = new TeacherInfoView();
user.Email = email;
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
var cmdText = string.Format("select uName, rDate, Sex, Tel, University, jTitle, Desp from TeacherSets where Email = N'{0}'", email);
using (var cmd = new SqlCommand(cmdText, conn))
{
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
user.UserName = Convert.ToString(reader.GetValue(0));
user.RegisteDate = Convert.ToDateTime(reader.GetValue(1));
user.Sex = Convert.ToString(reader.GetValue(2));
user.Tel = Convert.ToString(reader.GetValue(3));
user.University = Convert.ToInt32(reader.GetValue(4));
user.JobTitle = Convert.ToInt32(reader.GetValue(5));
user.Desp = Convert.ToString(reader.GetValue(6));
}
conn.Close();
}
}
return(user);
}
public static bool UpdateUserInfo(TeacherInfoView model)
{
var result = false;
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
var cmdText = string.Format("update TeacherSets set uName = N'{1}', rDate = '{2}', Sex = N'{3}', Tel = N'{4}', University = {5}, jTitle = {6}, Desp = N'{7}' where Email = N'{0}'", model.Email, model.UserName, model.RegisteDate, model.Sex, model.Tel, model.University, model.JobTitle, model.Desp);
using (var cmd = new SqlCommand(cmdText, conn))
{
result = cmd.ExecuteNonQuery() > 0;
conn.Close();
}
}
return(result);
}
/// <summary>
/// 用户注册
/// </summary>
/// <param name="model">注册对象</param>
/// <returns></returns>
public static ReturnState AddTeacherInfo(TeacherInfoView model)
{
using (var conn = new SqlConnection(connectionString))
{
conn.Open();
var cmdText = string.Format("insert into TeacherSets values (N'{0}', N'{1}', '{2}', N'{3}', N'{4}', {5}, {6}, N'{7}')", model.Email, model.UserName, DateTime.Now, model.Sex, model.Tel, model.University, model.JobTitle, model.Desp);
using (var cmd = new SqlCommand(cmdText, conn))
{
var result = cmd.ExecuteNonQuery();
conn.Close();
if (result <= 0)
{
return(ReturnState.ReturnError);
}
}
}
return(ReturnState.ReturnOK);
}
public ReturnState UpdateTeacherrInfo(TeacherInfoView model)
{
return(TeacherOperator.UpdateUserInfo(model) ? ReturnState.ReturnOK : ReturnState.ReturnError);
}
public ReturnState AddTeacherInfo(TeacherInfoView model)
{
return(TeacherOperator.AddTeacherInfo(model));
}
