/// <summary> /// 添加专业表内容 /// </summary> /// <param name="S"></param> /// <returns></returns> public static bool SpecialAdd(SpecialtiesInfo S) { try { String sql = "insert into Specialties(Specialty_Name,Specialty_Description) values(@Specialty_Name,@Specialty_Description)"; SqlParameter[] para = { new SqlParameter("Specialty_Name", S.Specialty_Name), new SqlParameter("Specialty_Description", S.Specialty_Description), }; int i = DBHelper.ExecuteNonQuery(sql, para); if (i > 0) { return(true); } else { return(false); } } catch { return(false); } }
/// <summary> /// 修改专业信息 /// </summary> /// <param name="context"></param> public void SpUpdate(HttpContext context) { int Spid = int.Parse(context.Request["Spid"].ToString()); string Sption = context.Request["Sption"].ToString(); string SpName = context.Request["SpName"].ToString(); SpecialtiesInfo S = new SpecialtiesInfo(); S.Specialty_ID = Spid; S.Specialty_Name = SpName; S.Specialty_Description = Sption; bool b = BLL.Specialties_BLL.SpecialUpdate(S); string s = ""; if (b) { s = "1"; } else { s = "0"; } string json = JsonConvert.SerializeObject(s); context.Response.Write(json); }
/// <summary> /// 修改专业表内容 /// </summary> /// <param name="S"></param> /// <returns></returns> public static bool SpecialUpdate(SpecialtiesInfo S) { try { String sql = "update Specialties set Specialty_Name=@Specialty_Name,Specialty_Description=@Specialty_Description where Specialty_ID=@Specialty_ID"; SqlParameter[] para = { new SqlParameter("Specialty_Name", S.Specialty_Name), new SqlParameter("Specialty_Description", S.Specialty_Description), new SqlParameter("Specialty_ID", S.Specialty_ID) }; int i = DBHelper.ExecuteNonQuery(sql, para); if (i > 0) { return(true); } else { return(false); } } catch { return(false); } }
/// <summary> /// 添加专业表内容 /// </summary> /// <param name="S"></param> /// <returns></returns> public static bool SpecialAdd(SpecialtiesInfo S) { return(DAL.Specialties_DAL.SpecialAdd(S)); }