//添加选岗宣讲
public void SchoolAdduery(HttpContext context)
{
int Sid = int.Parse(context.Request["Sid"].ToString());
int Spid = int.Parse(context.Request["Spid"].ToString());
string PreachDate = context.Request["PreachDate"].ToString();
string OverDay = context.Request["OverDay"].ToString();
SelectStationPeriodsInfo S = new SelectStationPeriodsInfo();
S.School_ID = Sid;
S.Specialty_ID = Spid;
S.SSP_PreachDate = PreachDate;
S.SSP_OverDay = OverDay;
string str = "";
bool b = BLL.ProviceS_BLL.SchoolAdduery(S);
if (b)
{
str = "1";
}
else
{
str = "0";
}
string json = JsonConvert.SerializeObject(str);
context.Response.Write(json);
}
/// <summary>
/// 添加选岗信息
/// </summary>
public static bool SchoolAdduery(SelectStationPeriodsInfo S)
{
string sql = "insert into SelectStationPeriods(School_ID,Specialty_ID,SSP_PreachDate,SSP_OverDay) values(@School_ID,@Specialty_ID,@SSP_PreachDate,@SSP_OverDay)";
SqlParameter[] para =
{
new SqlParameter("School_ID", S.School_ID),
new SqlParameter("Specialty_ID", S.Specialty_ID),
new SqlParameter("SSP_PreachDate", S.SSP_PreachDate),
new SqlParameter("SSP_OverDay", S.SSP_OverDay)
};
int dt = DBHelper.ExecuteNonQuery(sql, para);
if (dt > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加选岗信息
/// </summary>
public static bool SchoolAdduery(SelectStationPeriodsInfo S)
{
return(DAL.ProviceS_DAL.SchoolAdduery(S));
}
