Esempio n. 1
0
 /// <summary>
 /// 添加或编辑
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public static ResumeInfo Create(ResumeInfo model) {
     if (model.Id == 0)
     {
         int id = ResumeManage.Insert(model);
         model.Id = id;
     }
     else { 
         //Update
     }
     return model;
 }
Esempio n. 2
0
        public ActionResult Apply(ResumeInfo model,FormCollection fc) {

            /*
             * 设置_CommmonLayout.cshtml中的变量
             */

            ViewBag.RootCategoryInfo = ViewBag.CurrentCategoryInfo = CategoryService.Get(GeneralConfig.JobRootId);

            int jobId = CECRequest.GetQueryInt("jobId",0);

            var jobInfo = JobService.Get(jobId);
            if(jobInfo.Id<=0){
                return Redirect("/job");
            }

            if(Request.HttpMethod.ToUpper() == "POST"){

                //生日
                model.Birthday = string.Format("{0}-{1}",fc["Year"],fc["Month"]);

                //籍贯
                string birthplace = string.Empty;
                string province = fc["Province"],city = fc["City"],town = fc["Town"];
                if(!string.IsNullOrEmpty(province)){
                    birthplace = province;
                    if(!string.IsNullOrEmpty(city)){
                        birthplace += "-" + city;
                        if(!string.IsNullOrEmpty(town)){
                            birthplace += "-" + town;
                        }
                    }
                }
                model.BirthPlace = birthplace;

                int id = ResumeService.Create(model).Id;
                bool status = false;
                if(id >0){
                    status = true;
                }
                //POST
                ViewBag.Status = status;    
            }

            ViewBag.JobInfo = jobInfo;
            return View(model);
        }
Esempio n. 3
0
 /// <summary>
 /// 插入
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public static int Insert(ResumeInfo model) {
     string strSQL = "INSERT INTO Resumes(Realname,Gender,Birthday,Email,[GUID],CreateDateTime,JobId,WorkExperience,Education,[Address],Phone,Family,Degree,Major,MaritalStatus,BirthPlace) VALUES(@RealName,@Gender,@Birthday,@Email,@GUID,GETDATE(),@JobId,@WorkExperience,@Education,@Address,@Phone,@Family,@Degree,@Major,@MaritalStatus,@BirthPlace);SELECT @@IDENTITY;";
     SqlParameter[] param = { 
                             new SqlParameter("Realname",SqlDbType.NVarChar),
                             new SqlParameter("Gender",SqlDbType.NVarChar),
                             new SqlParameter("Birthday",SqlDbType.NVarChar),
                             new SqlParameter("Email",SqlDbType.NVarChar),
                             new SqlParameter("GUID",SqlDbType.NVarChar),
                             new SqlParameter("JobId",SqlDbType.Int),
                             new SqlParameter("WorkExperience",SqlDbType.NVarChar),
                             new SqlParameter("Education",SqlDbType.NVarChar),
                             new SqlParameter("Address",SqlDbType.NVarChar),
                             new SqlParameter("Phone",SqlDbType.NVarChar),
                             new SqlParameter("Family",SqlDbType.NVarChar),
                             new SqlParameter("Degree",SqlDbType.NVarChar),
                             new SqlParameter("Major",SqlDbType.NVarChar),
                             new SqlParameter("MaritalStatus",SqlDbType.NVarChar),
                             new SqlParameter("BirthPlace",SqlDbType.NVarChar),
                         };
     param[0].Value = model.Realname ?? string.Empty;
     param[1].Value = model.Gender ?? "男";
     param[2].Value = model.Birthday ?? "1986-01-01";
     param[3].Value = model.Email ?? string.Empty;
     param[4].Value = model.GUID ?? Guid.NewGuid().ToString();
     param[5].Value = model.JobId;
     param[6].Value = model.WorkExperience ?? string.Empty;
     param[7].Value = model.Education ?? string.Empty;
     param[8].Value = model.Address ?? string.Empty;
     param[9].Value = model.Phone ?? string.Empty;
     param[10].Value = model.Family ?? string.Empty;
     param[11].Value = model.Degree ?? string.Empty;
     param[12].Value = model.Major ?? string.Empty;
     param[13].Value = model.MaritalStatus ?? string.Empty;
     param[14].Value = model.BirthPlace ?? string.Empty;
    return Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text,strSQL,param));
 }