//修改职称 public void updatezc(Models.jobinfo m) { string sql = "update JobInfo set jobName=@jobName,levelID=@levelID,valid=@valid where ID=@ID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@jobName", m.name), new SqlParameter("@levelID", m.jbid), new SqlParameter("@valid", m.valid), new SqlParameter("@ID", m.id) }; SqlHelper.ExcuteNonQuery(sql, param); }
//保存职称 public void savezc(Models.jobinfo m) { string sql = "insert into JobInfo(companyID,jobName,levelID,valid)values(@companyID,@jobName,@levelID,@valid)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@companyID", m.companyID), new SqlParameter("@jobName", m.name), new SqlParameter("@levelID", m.jbid), new SqlParameter("@valid", m.valid) }; SqlHelper.ExcuteNonQuery(sql, param); }
/// <summary> /// 保存职称 /// </summary> /// <param name="m"></param> public static void save(Models.jobinfo m) { using (DAL.jbzcDAL dal = new DAL.jbzcDAL()) { if (m.id > 0) { dal.updatezc(m);//修改 } else { dal.savezc(m);//添加 } } }
public JsonResult save(Models.jobinfo m) { m.companyID = Utility.adminLogin.companyID; BLL.jbzcBLL.save(m); return(Json(1, JsonRequestBehavior.AllowGet)); }