예제 #1
0
        //修改职称
        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);
        }
예제 #2
0
        //保存职称
        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);
        }
예제 #3
0
파일: jbzcBLL.cs 프로젝트: newzl/examsou
 /// <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);//添加
         }
     }
 }
예제 #4
0
 public JsonResult save(Models.jobinfo m)
 {
     m.companyID = Utility.adminLogin.companyID;
     BLL.jbzcBLL.save(m);
     return(Json(1, JsonRequestBehavior.AllowGet));
 }