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); }