/// <summary>
/// 添加留学规时间规划
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int addArrangeTime(JiaJiModels.ApplyModel.ArrangeTime model)
{
try
{
string sql = "insert into arrangetime(ArrangeMonth,ArrangeContent,CountryID,EducationID,ShowID) Values('" + model.ArrangeMonth + "','" + model.ArrangeContent + "'," + model.CountryID + "," + model.EducationID + "," + model.ShowID + ")";
int h = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null);
return(h);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 修改留学规时间规划
/// </summary>
/// <returns></returns>
public int UpdArrangeTime(JiaJiModels.ApplyModel.ArrangeTime model)
{
try
{
string sql = "update arrangetime set ArrangeMonth = '" + model.ArrangeMonth + "', ArrangeContent = '" + model.ArrangeContent + "',CountryID=" + model.CountryID + ",EducationID=" + model.EducationID + ",ShowID=" + model.ShowID + " where ArrangeID=" + model.ArrangeID + " ";
int h = MySqlDB.nonquery(sql, System.Data.CommandType.Text, null);
return(h);
}
catch (Exception ex)
{
return(0);
}
}
public JsonResult addApply(JiaJiModels.ApplyModel.ArrangeTime infor)
{
try
{
var i = new JiaJiBLL.ApplyBLL().addArrangeTime(infor);
if (i > 0)
{
return(Json(new { Success = true, Message = "添加成功" }));
}
else
{
return(Json(new { Success = false, Message = "添加失败" }));
}
}
catch
{
return(Json(new { Success = false, Message = "添加失败" }));
}
}
public JsonResult editApply(JiaJiModels.ApplyModel.ArrangeTime model)
{
try
{
int id = model.ArrangeID;
var i = new JiaJiBLL.ApplyBLL().UpdArrangeTime(model);
if (i > 0)
{
return(Json(new { Success = true, Message = "修改成功" }));
}
else
{
return(Json(new { Success = false, Message = "修改失败" }));
}
}
catch
{
return(Json(new { Success = false, Message = "修改失败" }));
}
}
