public static string teacher_info()
{
JavaScriptSerializer jss = new JavaScriptSerializer();
tea_Manage teaManage = new tea_Manage();
return jss.Serialize(teaManage.tea_Info(tno));
//return string.Format("欢迎你{0} {1}", sno, sname);
}
public static string teacher_edit(string tname, string sex, string room, string tel, string email, string title,
string education, string course, string research, string article, string demand, string institute)
{
teacher tea = new teacher();
tea.tno = tno;
tea.tname = tname;
tea.sex = sex;
tea.room = room;
tea.tel = tel;
tea.email = email;
tea.title = title;
tea.education = education;
tea.course = course;
tea.research = research;
tea.article = article;
tea.demand = demand;
tea.institute = institute;
tea_Manage teaManage = new tea_Manage();
return string.Format(teaManage.tea_Update(tea));
}
public static string teacher_del()
{
tea_Manage teaManage = new tea_Manage();
return string.Format(teaManage.tea_Delete(tno));
}
public Dictionary<string, string> vol_Select(string sno, string priority)
{
Dictionary<string, string> drow = new Dictionary<string, string>();
SqlConnection myConn = GetConnection();
myConn.Open();
string myStr = "select tno from volunteer where sno=@sno and priority=@priority";
SqlCommand myCmd = new SqlCommand(myStr, myConn);
myCmd.Parameters.AddWithValue("@sno", sno);
myCmd.Parameters.AddWithValue("@priority", priority);
SqlDataReader reader = myCmd.ExecuteReader();
if (reader.Read())
{
tea_Manage teaManage = new tea_Manage();
drow = teaManage.tea_Info(reader["tno"].ToString());
drow.Add("msg", "yes");
}
else
drow.Add("msg", "no");
myConn.Close();
return drow;
}
public static string teacher_select(string selectName, string selectValue)
{
JavaScriptSerializer jss = new JavaScriptSerializer();
tea_Manage teaManage = new tea_Manage();
return jss.Serialize(teaManage.tea_select(selectName.Trim(), selectValue.Trim()));
}
public static string teacher_insert(string tno, string tname)
{
tea_Manage teaManage = new tea_Manage();
return string.Format(teaManage.tea_Insert(tno, tname));
//return string.Format("欢迎你{0} {1}", sno, sname);
}
