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));
}
