/// <summary> /// 添加或编辑 /// </summary> /// <param name="model"></param> /// <returns></returns> public static JobInfo Create(JobInfo model) { if (model.Id == 0) { int id = JobManage.Insert(model); model.Id = id; } else { JobManage.Update(model); } return model; }
public ActionResult Create(JobInfo model) { bool errors = false; bool isAdd = model.Id == 0; if(string.IsNullOrEmpty(model.Title)){ errors = true; ModelState.AddModelError("Title","职位名称不能为空"); } if(!errors && ModelState.IsValid){ int id = JobService.Create(model).Id; ViewBag.Status = false; if(id>0){ ViewBag.Status = true; } } return View(model); }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Update(JobInfo model) { string strSQL = "UPDATE Job SET Title = @Title ,Introduction = @Introduction,WorkingPlace = @WorkingPlace,IsPublished = @IsPublished ,Sort = @Sort,IsHot = @IsHot,Number = @Number WHERE Id = @Id"; SqlParameter[] param = { new SqlParameter("Id",SqlDbType.Int), new SqlParameter("Title",SqlDbType.NVarChar), new SqlParameter("Introduction",SqlDbType.NVarChar), new SqlParameter("WorkingPlace",SqlDbType.NVarChar), new SqlParameter("IsPublished",SqlDbType.Int), new SqlParameter("Sort",SqlDbType.Int), new SqlParameter("IsHot",SqlDbType.Int), new SqlParameter("Number",SqlDbType.Int), }; param[0].Value = model.Id; param[1].Value = model.Title ?? string.Empty; param[2].Value = model.Introduction ?? string.Empty; param[3].Value = model.WorkingPlace ?? string.Empty; param[4].Value = model.IsPublished; param[5].Value = model.Sort; param[6].Value = model.IsHot; param[7].Value = model.Number; return Goodspeed.Library.Data.SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Insert(JobInfo model) { string strSQL = "INSERT INTO Job(Title,Introduction,WorkingPlace,IsPublished,Sort,IsHot,IsDeleted,CreateDateTime,Number) VALUES(@Title,@Introduction,@WorkingPlace,@IsPublished,@Sort,@IsHot,0,GETDATE(),@Number);SELECT @@IDENTITY;"; SqlParameter[] param = { new SqlParameter("Id",SqlDbType.Int), new SqlParameter("Title",SqlDbType.NVarChar), new SqlParameter("Introduction",SqlDbType.NVarChar), new SqlParameter("WorkingPlace",SqlDbType.NVarChar), new SqlParameter("IsPublished",SqlDbType.Int), new SqlParameter("Sort",SqlDbType.Int), new SqlParameter("IsHot",SqlDbType.Int), new SqlParameter("Number",SqlDbType.Int), }; param[0].Value = model.Id; param[1].Value = model.Title ?? string.Empty; param[2].Value = model.Introduction ?? string.Empty; param[3].Value = model.WorkingPlace ?? string.Empty; param[4].Value = model.IsPublished; param[5].Value = model.Sort; param[6].Value = model.IsHot; param[7].Value = model.Number; return Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text,strSQL,param)); }