private Entity.HRResume GetResume(string sql, SqlParameter[] param) { Entity.HRResume model = new Entity.HRResume(); using (DbDataReader dr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, param)) { while (dr.Read()) { model.Address = dr["Address"].ToString(); model.Birthday = Utils.StrToDate(dr["Birthday"].ToString()); model.CardID = dr["CardID"].ToString(); model.City = dr["City"].ToString(); model.CompanyExpect = dr["CompanyExpect"].ToString(); model.ComputerLevel = dr["ComputerLevel"].ToString(); model.CurrentSalary = dr["CurrentSalary"].ToString(); model.Degree = dr["Degree"].ToString(); model.EducationalBackground = dr["EducationalBackground"].ToString(); model.EMail = dr["EMail"].ToString(); model.EnglishLevel = dr["EnglishLevel"].ToString(); model.Gender = dr["Gender"].ToString(); model.Height = Utils.ParseInt(dr["Height"].ToString(), 0); model.Hobbies = dr["Hobbies"].ToString(); model.ID = Utils.ParseInt(dr["ID"].ToString(), 0); model.Industry = dr["Industry"].ToString(); model.InformationWay = dr["InformationWay"].ToString(); model.IsRead = Utils.ParseBool(dr["IsRead"].ToString()); model.IsRoom = Utils.ParseBool(dr["IsRoom"].ToString()); model.Marriage = dr["Marriage"].ToString(); model.MemberName = dr["MemberName"].ToString(); model.Mobile = dr["Mobile"].ToString(); model.Nation = dr["Nation"].ToString(); model.NativePlace = dr["NativePlace"].ToString(); model.Photo = dr["Photo"].ToString(); model.Post = dr["Post"].ToString(); model.PostExpect = dr["PostExpect"].ToString(); model.QQ = dr["QQ"].ToString(); model.ReportDate = Utils.StrToDate(dr["ReportDate"].ToString()); model.RequiresSalary = dr["RequiresSalary"].ToString(); model.SkillsExpertise = dr["SkillsExpertise"].ToString(); model.Speciality = dr["Speciality"].ToString(); model.Specialty = dr["Specialty"].ToString(); model.Tel = dr["Tel"].ToString(); model.Train = dr["Train"].ToString(); model.Universities = dr["Universities"].ToString(); model.UserName = dr["UserName"].ToString(); model.Weight = Utils.ParseInt(dr["Weight"].ToString(), 0); model.WorkDescription = dr["WorkDescription"].ToString(); model.WorkExperience = dr["WorkExperience"].ToString(); model.WorkYear = Utils.ParseInt(dr["WorkYear"].ToString(), 0); model.ZipCode = dr["ZipCode"].ToString(); } } return(model); }
//添加成功返回影响行数和ID号码,失败返回失败错误描述 //成功arr[0]=1;arr[1]=ID //失败arr[0]=错误描述,arr[1]=0 public string[] CreateItem(Entity.HRResume model) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("Address", model.Address.ToString()); dic.Add("Birthday", model.Birthday.ToString()); dic.Add("CardID", model.CardID.ToString()); dic.Add("City", model.City.ToString()); dic.Add("CompanyExpect", model.CompanyExpect.ToString()); dic.Add("ComputerLevel", model.ComputerLevel.ToString()); dic.Add("CurrentSalary", model.CurrentSalary.ToString()); dic.Add("Degree", model.Degree.ToString()); dic.Add("EducationalBackground", model.EducationalBackground.ToString()); dic.Add("EMail", model.EMail.ToString()); dic.Add("EnglishLevel", model.EnglishLevel.ToString()); dic.Add("Gender", model.Gender.ToString()); dic.Add("Height", model.Height.ToString()); dic.Add("Hobbies", model.Hobbies.ToString()); dic.Add("Industry", model.Industry.ToString()); dic.Add("InformationWay", model.InformationWay.ToString()); dic.Add("IsDel", model.IsDel.ToString()); dic.Add("IsRead", model.IsRead.ToString()); dic.Add("IsRoom", model.IsRoom.ToString()); dic.Add("Marriage", model.Marriage.ToString()); dic.Add("MemberName", model.MemberName.ToString()); dic.Add("Mobile", model.Mobile.ToString()); dic.Add("Nation", model.Nation.ToString()); dic.Add("NativePlace", model.NativePlace.ToString()); dic.Add("NodeCode", model.NodeCode.ToString()); dic.Add("Photo", model.Photo.ToString()); dic.Add("Post", model.Post.ToString()); dic.Add("PostExpect", model.PostExpect.ToString()); dic.Add("QQ", model.QQ.ToString()); dic.Add("ReportDate", model.ReportDate.ToString()); dic.Add("RequiresSalary", model.RequiresSalary.ToString()); dic.Add("SiteID", model.SiteID.ToString()); dic.Add("SkillsExpertise", model.SkillsExpertise.ToString()); dic.Add("Speciality", model.Speciality.ToString()); dic.Add("Specialty", model.Specialty.ToString()); dic.Add("Tel", model.Tel.ToString()); dic.Add("Train", model.Train.ToString()); dic.Add("Universities", model.Universities.ToString()); dic.Add("UserName", model.UserName.ToString()); dic.Add("Weight", model.Weight.ToString()); dic.Add("WorkDescription", model.WorkDescription.ToString()); dic.Add("WorkExperience", model.WorkExperience.ToString()); dic.Add("WorkYear", model.WorkYear.ToString()); dic.Add("ZipCode", model.ZipCode.ToString()); return(InfoHelper.Add("K_HRResume", dic)); }