/// <summary>
/// 得到一个对象实体
/// </summary>
public tabResumeModel GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" from tabResume ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
tabResumeModel model = new tabResumeModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(ModelHandler <tabResumeModel> .FillModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
void funResumeOutLine(int ResumeID)
{
try
{
#region
WinFormControlHelper.AddLog(rtbLog, "开始操作" + ResumeID, "");
int count = 0;
string _where = "";
string _order = " id desc";
//获取详情
tabResumeModel modelRm = tabResumeBLL.GetInstance().GetModel(ResumeID);
_where = string.Format(" id={0} ", modelRm.ParentID);
tabUserModel modelUsr = tabUserBLL.GetInstance().GetModel(_where, 0);
if (modelUsr.IsNull())
{
modelUsr = new tabUserModel();
}
_where = string.Format(" ParentID={0} ", modelRm.id);
List <tabExperienceEduModel> lsmodelEdu = tabExperienceEduBLL.GetInstance().GetModelList(20, 1, _where, _order, out count);
if (lsmodelEdu.IsNull())
{
lsmodelEdu = new List <tabExperienceEduModel>();
}
List <tabExperienceWorkModel> lsmodelWork = tabExperienceWorkBLL.GetInstance().GetModelList(20, 1, _where, _order, out count);
if (lsmodelWork.IsNull())
{
lsmodelWork = new List <tabExperienceWorkModel>();
}
List <tabExperienceProjectModel> lsmodelProject = tabExperienceProjectBLL.GetInstance().GetModelList(20, 1, _where, _order, out count);
if (lsmodelProject.IsNull())
{
lsmodelProject = new List <tabExperienceProjectModel>();
}
//组合成新的模型
bool IsExist = false;
_where = string.Format(" ResumeID={0} ", modelRm.id);
tabResumeOutlineModel modelRmOtln = tabResumeOutlineBLL.GetInstance().GetModel(_where, 0);
IsExist = modelRmOtln.IsNotNull();
if (!IsExist)
{
modelRmOtln = new tabResumeOutlineModel();
}
#region
modelRmOtln.ResumeID = modelRm.id;
modelRmOtln.ResumeNo = modelRm.ResumeNo;
modelRmOtln.ResumeName = modelRm.ResumeName;
modelRmOtln.HopeAddress = modelRm.HopeAddress;
modelRmOtln.HopeIndustry = modelRm.HopeIndustry;
modelRmOtln.HopePosition = modelRm.HopePosition;
modelRmOtln.HopeSalary = modelRm.HopeSalary;
modelRmOtln.RealName = modelUsr.RealName;
modelRmOtln.Birthday = modelUsr.Birthday;
modelRmOtln.Mobile = modelUsr.Mobile;
modelRmOtln.Email = modelUsr.Email;
modelRmOtln.Sex = modelUsr.Sex;
string strSkill = modelRm.Other + " ";
#region
modelRmOtln.School = "";
modelRmOtln.Major = "";
foreach (tabExperienceEduModel model in lsmodelEdu)
{
modelRmOtln.School += model.SchoolName + " ";
modelRmOtln.Major += model.ProfessionalName + " ";
}
#endregion
#region
foreach (tabExperienceWorkModel model in lsmodelWork)
{
strSkill += model.PositionDuties + " " + model.WorkPerformance + " ";
}
#endregion
#region
foreach (tabExperienceProjectModel model in lsmodelProject)
{
strSkill += model.ProjectDesc + " " + model.ProjectPerformance + " ";
}
#endregion
#region Skill
//
List <string> lsSkill = PanGuSegmentHelper.SegmentToStringList(strSkill); //分词
hsCVSkill = new HashSet <string>();
foreach (string key in lsSkill) //加入集合
{
hsCVSkill.Add(key);
hsCVJDSkillFull.Add(key);
}
//获得交集
hsCVSkill.IntersectWith(hsCVJDKeyWord);
//转化成字符串
strSkill = "";
foreach (string str in hsCVSkill)
{
strSkill += str + " ";
}
modelRmOtln.Skill = strSkill;
WinFormControlHelper.AddLog(rtbLog, modelRmOtln.ResumeName, modelRmOtln.Skill);
#endregion
#endregion
//插入或更新
if (IsExist)
{
tabResumeOutlineBLL.GetInstance().Update(modelRmOtln);
}
else
{
tabResumeOutlineBLL.GetInstance().Add(modelRmOtln);
}
#endregion
}
catch (Exception ex)
{
WinFormControlHelper.AddLog(rtbLog, "funResumeOutLine", ex.Message);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tabResumeModel model, List <string> ChangedFields)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tabResume set ");
strSql.Append(" ResumeNo = @ResumeNo , ");
strSql.Append(" ResumeName = @ResumeName , ");
strSql.Append(" UserID = @UserID , ");
strSql.Append(" IsMe = @IsMe , ");
strSql.Append(" IsDisplayRealName = @IsDisplayRealName , ");
strSql.Append(" CurPosition = @CurPosition , ");
strSql.Append(" CurSalary = @CurSalary , ");
strSql.Append(" CurComapny = @CurComapny , ");
strSql.Append(" CurIndustry = @CurIndustry , ");
strSql.Append(" CurStatus = @CurStatus , ");
strSql.Append(" CurAddress = @CurAddress , ");
strSql.Append(" HopeAddress = @HopeAddress , ");
strSql.Append(" HopePosition = @HopePosition , ");
strSql.Append(" HopeIndustry = @HopeIndustry , ");
strSql.Append(" HopeSalary = @HopeSalary , ");
strSql.Append(" HunterComment = @HunterComment , ");
strSql.Append(" ResumeInitFile = @ResumeInitFile , ");
strSql.Append(" ResumePDFFile = @ResumePDFFile , ");
strSql.Append(" Other = @Other , ");
strSql.Append(" Price = @Price , ");
strSql.Append(" SourceUrl = @SourceUrl , ");
strSql.Append(" SourceText = @SourceText , ");
strSql.Append(" Tags = @Tags , ");
strSql.Append(" Lang = @Lang , ");
strSql.Append(" AppID = @AppID , ");
strSql.Append(" Version = @Version , ");
strSql.Append(" RandomNo = @RandomNo , ");
strSql.Append(" ParentID = @ParentID , ");
strSql.Append(" Remark = @Remark , ");
strSql.Append(" LableText = @LableText , ");
strSql.Append(" ExJson = @ExJson , ");
strSql.Append(" Status = @Status , ");
strSql.Append(" OrderNo = @OrderNo , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" ModifyDate = @ModifyDate , ");
strSql.Append(" CreateUser = @CreateUser , ");
strSql.Append(" ModifyUser = @ModifyUser ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@ResumeNo", SqlDbType.NVarChar, 50),
new SqlParameter("@ResumeName", SqlDbType.NVarChar, 50),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@IsMe", SqlDbType.Bit, 1),
new SqlParameter("@IsDisplayRealName", SqlDbType.Bit, 1),
new SqlParameter("@CurPosition", SqlDbType.NVarChar, 50),
new SqlParameter("@CurSalary", SqlDbType.Decimal, 9),
new SqlParameter("@CurComapny", SqlDbType.NVarChar, 50),
new SqlParameter("@CurIndustry", SqlDbType.NVarChar, 50),
new SqlParameter("@CurStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@CurAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@HopeAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@HopePosition", SqlDbType.NVarChar, 50),
new SqlParameter("@HopeIndustry", SqlDbType.NVarChar, 50),
new SqlParameter("@HopeSalary", SqlDbType.Decimal, 9),
new SqlParameter("@HunterComment", SqlDbType.NVarChar, -1),
new SqlParameter("@ResumeInitFile", SqlDbType.Int, 4),
new SqlParameter("@ResumePDFFile", SqlDbType.Int, 4),
new SqlParameter("@Other", SqlDbType.NVarChar, -1),
new SqlParameter("@Price", SqlDbType.Int, 4),
new SqlParameter("@SourceUrl", SqlDbType.NVarChar, 200),
new SqlParameter("@SourceText", SqlDbType.NVarChar, 50),
new SqlParameter("@Tags", SqlDbType.NVarChar, 50),
new SqlParameter("@Lang", SqlDbType.NVarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@AppID", SqlDbType.NVarChar, 100),
new SqlParameter("@Version", SqlDbType.NVarChar, 100),
new SqlParameter("@RandomNo", SqlDbType.NVarChar, 200),
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, -1),
new SqlParameter("@LableText", SqlDbType.NVarChar, -1),
new SqlParameter("@ExJson", SqlDbType.NVarChar, -1),
new SqlParameter("@Status", SqlDbType.NVarChar, -1),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@CreateDate", SqlDbType.NVarChar, 200),
new SqlParameter("@ModifyDate", SqlDbType.NVarChar, 200),
new SqlParameter("@CreateUser", SqlDbType.Int, 4),
new SqlParameter("@ModifyUser", SqlDbType.Int, 4)
};
parameters[0].Value = model.ResumeNo;
parameters[1].Value = model.ResumeName;
parameters[2].Value = model.UserID;
parameters[3].Value = model.IsMe;
parameters[4].Value = model.IsDisplayRealName;
parameters[5].Value = model.CurPosition;
parameters[6].Value = model.CurSalary;
parameters[7].Value = model.CurComapny;
parameters[8].Value = model.CurIndustry;
parameters[9].Value = model.CurStatus;
parameters[10].Value = model.CurAddress;
parameters[11].Value = model.HopeAddress;
parameters[12].Value = model.HopePosition;
parameters[13].Value = model.HopeIndustry;
parameters[14].Value = model.HopeSalary;
parameters[15].Value = model.HunterComment;
parameters[16].Value = model.ResumeInitFile;
parameters[17].Value = model.ResumePDFFile;
parameters[18].Value = model.Other;
parameters[19].Value = model.Price;
parameters[20].Value = model.SourceUrl;
parameters[21].Value = model.SourceText;
parameters[22].Value = model.Tags;
parameters[23].Value = model.Lang;
parameters[24].Value = model.id;
parameters[25].Value = model.AppID;
parameters[26].Value = model.Version;
parameters[27].Value = model.RandomNo;
parameters[28].Value = model.ParentID;
parameters[29].Value = model.Remark;
parameters[30].Value = model.LableText;
parameters[31].Value = model.ExJson;
parameters[32].Value = model.Status;
parameters[33].Value = model.OrderNo;
parameters[34].Value = model.CreateDate;
parameters[35].Value = model.ModifyDate;
parameters[36].Value = model.CreateUser;
parameters[37].Value = model.ModifyUser;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tabResumeModel model)
{
model.Version = model.Version.IsNotNullOrEmpty()? model.Version: "1";
model.RandomNo = model.RandomNo.IsNotNullOrEmpty()? model.RandomNo: Guid.NewGuid().ToString("N");
model.Status = model.Status.IsNotNullOrEmpty()? model.Status: "1";
model.OrderNo = model.OrderNo > 0? model.OrderNo: 1;
model.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.ModifyDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tabResume(");
strSql.Append("ResumeNo,ResumeName,UserID,IsMe,IsDisplayRealName,CurPosition,CurSalary,CurComapny,CurIndustry,CurStatus,CurAddress,HopeAddress,HopePosition,HopeIndustry,HopeSalary,HunterComment,ResumeInitFile,ResumePDFFile,Other,Price,SourceUrl,SourceText,Tags,Lang,AppID,Version,RandomNo,ParentID,Remark,LableText,ExJson,Status,OrderNo,CreateDate,ModifyDate,CreateUser,ModifyUser");
strSql.Append(") values (");
strSql.Append("@ResumeNo,@ResumeName,@UserID,@IsMe,@IsDisplayRealName,@CurPosition,@CurSalary,@CurComapny,@CurIndustry,@CurStatus,@CurAddress,@HopeAddress,@HopePosition,@HopeIndustry,@HopeSalary,@HunterComment,@ResumeInitFile,@ResumePDFFile,@Other,@Price,@SourceUrl,@SourceText,@Tags,@Lang,@AppID,@Version,@RandomNo,@ParentID,@Remark,@LableText,@ExJson,@Status,@OrderNo,@CreateDate,@ModifyDate,@CreateUser,@ModifyUser");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ResumeNo", SqlDbType.NVarChar, 50),
new SqlParameter("@ResumeName", SqlDbType.NVarChar, 50),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@IsMe", SqlDbType.Bit, 1),
new SqlParameter("@IsDisplayRealName", SqlDbType.Bit, 1),
new SqlParameter("@CurPosition", SqlDbType.NVarChar, 50),
new SqlParameter("@CurSalary", SqlDbType.Decimal, 9),
new SqlParameter("@CurComapny", SqlDbType.NVarChar, 50),
new SqlParameter("@CurIndustry", SqlDbType.NVarChar, 50),
new SqlParameter("@CurStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@CurAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@HopeAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@HopePosition", SqlDbType.NVarChar, 50),
new SqlParameter("@HopeIndustry", SqlDbType.NVarChar, 50),
new SqlParameter("@HopeSalary", SqlDbType.Decimal, 9),
new SqlParameter("@HunterComment", SqlDbType.NVarChar, -1),
new SqlParameter("@ResumeInitFile", SqlDbType.Int, 4),
new SqlParameter("@ResumePDFFile", SqlDbType.Int, 4),
new SqlParameter("@Other", SqlDbType.NVarChar, -1),
new SqlParameter("@Price", SqlDbType.Int, 4),
new SqlParameter("@SourceUrl", SqlDbType.NVarChar, 200),
new SqlParameter("@SourceText", SqlDbType.NVarChar, 50),
new SqlParameter("@Tags", SqlDbType.NVarChar, 50),
new SqlParameter("@Lang", SqlDbType.NVarChar, 50),
new SqlParameter("@AppID", SqlDbType.NVarChar, 100),
new SqlParameter("@Version", SqlDbType.NVarChar, 100),
new SqlParameter("@RandomNo", SqlDbType.NVarChar, 200),
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, -1),
new SqlParameter("@LableText", SqlDbType.NVarChar, -1),
new SqlParameter("@ExJson", SqlDbType.NVarChar, -1),
new SqlParameter("@Status", SqlDbType.NVarChar, -1),
new SqlParameter("@OrderNo", SqlDbType.Int, 4),
new SqlParameter("@CreateDate", SqlDbType.NVarChar, 200),
new SqlParameter("@ModifyDate", SqlDbType.NVarChar, 200),
new SqlParameter("@CreateUser", SqlDbType.Int, 4),
new SqlParameter("@ModifyUser", SqlDbType.Int, 4)
};
parameters[0].Value = model.ResumeNo;
parameters[1].Value = model.ResumeName;
parameters[2].Value = model.UserID;
parameters[3].Value = model.IsMe;
parameters[4].Value = model.IsDisplayRealName;
parameters[5].Value = model.CurPosition;
parameters[6].Value = model.CurSalary;
parameters[7].Value = model.CurComapny;
parameters[8].Value = model.CurIndustry;
parameters[9].Value = model.CurStatus;
parameters[10].Value = model.CurAddress;
parameters[11].Value = model.HopeAddress;
parameters[12].Value = model.HopePosition;
parameters[13].Value = model.HopeIndustry;
parameters[14].Value = model.HopeSalary;
parameters[15].Value = model.HunterComment;
parameters[16].Value = model.ResumeInitFile;
parameters[17].Value = model.ResumePDFFile;
parameters[18].Value = model.Other;
parameters[19].Value = model.Price;
parameters[20].Value = model.SourceUrl;
parameters[21].Value = model.SourceText;
parameters[22].Value = model.Tags;
parameters[23].Value = model.Lang;
parameters[24].Value = model.AppID;
parameters[25].Value = model.Version;
parameters[26].Value = model.RandomNo;
parameters[27].Value = model.ParentID;
parameters[28].Value = model.Remark;
parameters[29].Value = model.LableText;
parameters[30].Value = model.ExJson;
parameters[31].Value = model.Status;
parameters[32].Value = model.OrderNo;
parameters[33].Value = model.CreateDate;
parameters[34].Value = model.ModifyDate;
parameters[35].Value = model.CreateUser;
parameters[36].Value = model.ModifyUser;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tabResumeModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tabResumeModel model)
{
return(dal.Add(model));
}
