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