public void ProcessRequest(HttpContext context)
{
try
{
string strJson = System.Web.HttpContext.Current.Server.UrlDecode(context.Request.Form.ToString());
LabMS.Model.CourseJson json = (LabMS.Model.CourseJson)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(strJson,
typeof(LabMS.Model.CourseJson));
ExtendBLL.Course course = new ExtendBLL.Course();
if (course.Exists(" Course_Code = @Code",new System.Data.SqlClient.SqlParameter("@Code",json.Code)))
{
throw new Exception("课程号已经存在");
}
LabMS.BLL.ProCourse proCourse = new LabMS.BLL.ProCourse();
LabMS.Model.Course courseModel = new LabMS.Model.Course();//课程
LabMS.Model.ProCourse proCourseModel = new LabMS.Model.ProCourse();//专业课程
courseModel.Course_Code = json.Code;
courseModel.Course_ExprientHouse = json.Hour;
courseModel.Course_Name = json.Name;
courseModel.CourseType = json.Type;
courseModel.EnglishName = json.EnglishName;
courseModel.Course_House =json.CourseHouse.ToString();//课时
courseModel.ID = course.Add(courseModel);
proCourseModel.Cou_ID = courseModel.ID;//取出课程ID，存专业课程表
foreach (LabMS.Model.MajorJson major in json.Majors)
{
proCourseModel.ProID = major.ID;
proCourse.Add(proCourseModel);
}
context.Response.ContentType = "application/json";
context.Response.Write("{success: true}");
}
catch (Exception ex)
{
context.Response.ContentType = "application/json";
context.Response.Write("{error: true, msg: '" + System.Web.HttpContext.Current.Server.UrlEncode(ex.Message) + "'}");
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.ProCourse GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,Cou_ID,ProID from ProCourse ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
LabMS.Model.ProCourse model=new LabMS.Model.ProCourse();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["ID"].ToString()!="")
{
model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if(ds.Tables[0].Rows[0]["Cou_ID"].ToString()!="")
{
model.Cou_ID=int.Parse(ds.Tables[0].Rows[0]["Cou_ID"].ToString());
}
if(ds.Tables[0].Rows[0]["ProID"].ToString()!="")
{
model.ProID=int.Parse(ds.Tables[0].Rows[0]["ProID"].ToString());
}
return model;
}
else
{
return null;
}
}
public void ProcessRequest(HttpContext context)
{
try
{
string strJson = System.Web.HttpContext.Current.Server.UrlDecode(context.Request.Form.ToString());
LabMS.Model.CourseJson json = (LabMS.Model.CourseJson)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(strJson,
typeof(LabMS.Model.CourseJson));
ExtendBLL.Course course = new ExtendBLL.Course();
LabMS.BLL.ProCourse proCourse = new LabMS.BLL.ProCourse();
LabMS.Model.Course courseModel = new LabMS.Model.Course();//课程
LabMS.Model.ProCourse proCourseModel = new LabMS.Model.ProCourse();//专业课程
courseModel.ID = json.ID;
courseModel.Course_Code = json.Code;
courseModel.Course_ExprientHouse = json.Hour;
courseModel.Course_Name = json.Name;
courseModel.CourseType = json.Type;
courseModel.EnglishName = json.EnglishName;
courseModel.Course_House = json.CourseHouse.ToString();//课时
course.Update(courseModel);
proCourseModel.Cou_ID = courseModel.ID;//取出课程ID，存专业课程表
#region 没有选择专业，把数据库中存在的专业都删掉
if (json.Majors.Count == 0)
{
int Cou_ID=int.Parse(proCourseModel.Cou_ID.Value.ToString());
if (course.GetListCount (Cou_ID) == 0)
{
}
else
{
if (course.DeleteProCourseByCouseID(Cou_ID) != true)
{
throw new Exception("删除课程出错！");
}
}
}
#endregion
else
{
//把原来的删掉，重新加入
string str = "Delete from ProCourse where Cou_ID="+proCourseModel.Cou_ID;
Maticsoft.DBUtility.DbHelperSQL.ExecuteSql(str);
foreach (LabMS.Model.MajorJson major in json.Majors)
{
proCourseModel.ProID = major.ID;
proCourse.Add(proCourseModel);
}
}
context.Response.ContentType = "application/json";
context.Response.Write("{success: true}");
}
catch (Exception ex)
{
context.Response.ContentType = "application/json";
context.Response.Write("{error: true, msg: '" + System.Web.HttpContext.Current.Server.UrlEncode(ex.Message) + "'}");
}
}
