/// <summary>
/// 讀取專案經驗的Sheet
/// </summary>
/// <param name="sheet"></param>
/// <returns></returns>
private DataTable ReadProjectExperienceSheet(Worksheet sheet)
{
int row = 2; ////紀錄目前在哪一行
List <ProjectExperience> projectExperienceList = new List <ProjectExperience>();
while (!string.IsNullOrEmpty(sheet.Range["B" + row].Value.Trim()) && sheet.Range["B" + row].Value.Trim().Equals("公司名稱"))
{
ProjectExperience projectExperience = new ProjectExperience
{
Company = sheet.Range["C" + row].Value.Trim(),
Position = sheet.Range["H" + row].Value.Trim(),
};
row++;
projectExperience.Project_Name = sheet.Range["C" + row].Value.Trim();
projectExperience.Start_End_Date = sheet.Range["H" + row].Value.Trim();
row++;
projectExperience.OS = sheet.Range["C" + row].Value.Trim();
projectExperience.Language = sheet.Range["H" + row].Value.Trim();
row++;
projectExperience.Database = sheet.Range["C" + row].Value.Trim();
projectExperience.Tools = sheet.Range["H" + row].Value.Trim();
row++;
projectExperience.Description = sheet.Range["C" + row].Value.Trim();
row += 3;
projectExperienceList.Add(projectExperience);
}
if (projectExperienceList.Count == 0)
{
projectExperienceList.Add(new ProjectExperience());
}
return(projectExperienceList.ListToDataTable());
}
public void PopulatePersonProjects(Faker faker, Person person, IEnumerable <Project> projects)
{
if (person.Projects.Any() && faker.Random.Bool(0.3f))
{
person.Projects = faker.Random.ListItems(person.Projects);
}
foreach (var project in person.Projects.Any() ? faker.Random.ListItems(person.Projects) : Enumerable.Empty <ProjectExperience>())
{
project.Description = faker.Random.Bool(0.5f) ? faker.Lorem.Sentences() : project.Description;
project.RoleInProject = faker.Random.Bool(0.3f) ? faker.Name.JobType() : project.RoleInProject;
project.Status = faker.Random.Bool(0.3f) ? faker.PickRandom <PublishState>() : project.Status;
}
if (projects.Any())
{
var projectsList = projects.ToList();
var max = faker.Random.Bool(0.8f) ? Math.Min(projectsList.Count, 99) : projectsList.Count; // Maximal batch-size is 100 (going above this causes a HTTP 500)
var number = faker.Random.Int(1, max);
foreach (var project in faker.Random.ListItems(projectsList, number))
{
var projExp = ProjectExperience.Generate();
projExp.PersonKey = person.RowKey;
projExp.ProjectKey = project.RowKey;
person.Projects.Add(projExp);
}
}
}
public List <ProjectExperience> TestExcelProjectExperienceData()
{
List <ProjectExperience> projectExperienceList = new List <ProjectExperience>();
ProjectExperience projectExperience = new ProjectExperience
{
Company = "屏東科技大學",
Position = "學生",
Project_Name = "智慧水產養殖管理資訊系統",
Start_End_Date = "105/6/30~105/12/14",
OS = "win 10",
Language = "C#",
Database = "MS SQL",
Tools = "Visual Studio",
Description = "say something"
};
projectExperienceList.Add(projectExperience);
ProjectExperience projectExperience1 = new ProjectExperience
{
Company = string.Empty,
Position = string.Empty,
Project_Name = string.Empty,
Start_End_Date = string.Empty,
OS = string.Empty,
Language = string.Empty,
Database = string.Empty,
Tools = string.Empty,
Description = string.Empty
};
projectExperienceList.Add(projectExperience1);
return(projectExperienceList);
}
/// <summary>
/// 根据Id获取详情
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string GetById(string id)
{
ProjectExperience Model = m_BLL.GetById(id);
JavaScriptSerializer js = new JavaScriptSerializer();
string jsonStr = js.Serialize(Model);
return(jsonStr);
}
/// <summary>
/// 將專案經驗顯示出來
/// </summary>
/// <param name="project"></param>
public void SetProjectExperience(ProjectExperience project)
{
CompanyTxt.Text = project.Company;
ProjectNameTxt.Text = project.Project_Name;
OSTxt.Text = project.OS;
DatabaseTxt.Text = project.Database;
PositionTxt.Text = project.Position;
StartEndDateTxt.Text = project.Start_End_Date;
LanguageTxt.Text = project.Language;
ToolsTxt.Text = project.Tools;
DescriptionTxt.Text = project.Description;
}
/// <summary>
/// 创建一个项目经验
/// </summary>
/// <param name="validationErrors">返回的错误信息</param>
/// <param name="db">数据库上下文</param>
/// <param name="entity">一个项目经验</param>
/// <returns></returns>
public bool Create(ref ValidationErrors validationErrors, ProjectExperience entity)
{
try
{
repository.Create(entity);
return(true);
}
catch (Exception ex)
{
validationErrors.Add(ex.Message);
ExceptionsHander.WriteExceptions(ex);
}
return(false);
}
/// <summary>
/// 取得專案經驗的資料
/// </summary>
/// <returns></returns>
public ProjectExperience GetProjectExperience()
{
ProjectExperience project = new ProjectExperience
{
Company = CompanyTxt.Text,
Project_Name = ProjectNameTxt.Text,
OS = OSTxt.Text,
Database = DatabaseTxt.Text,
Position = PositionTxt.Text,
Start_End_Date = StartEndDateTxt.Text,
Language = LanguageTxt.Text,
Tools = ToolsTxt.Text,
Description = DescriptionTxt.Text,
};
return(project);
}
/// <summary>
/// 创建
/// </summary>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public Common.ClientResult.Result Post([FromBody] ProjectExperience entity)
{
Common.ClientResult.Result result = new Common.ClientResult.Result();
if (entity != null && ModelState.IsValid)
{
//string currentPerson = GetCurrentPerson();
//entity.CreateTime = DateTime.Now;
//entity.CreatePerson = currentPerson;
entity.Id = Result.GetNewId();
string returnValue = string.Empty;
if (m_BLL.Create(ref validationErrors, entity))
{
LogClassModels.WriteServiceLog(Suggestion.InsertSucceed + "，项目经验的信息的Id为" + entity.Id, "项目经验"
);//写入日志
result.Code = Common.ClientCode.Succeed;
result.Message = Suggestion.InsertSucceed;
return(result); //提示创建成功
}
else
{
if (validationErrors != null && validationErrors.Count > 0)
{
validationErrors.All(a =>
{
returnValue += a.ErrorMessage;
return(true);
});
}
LogClassModels.WriteServiceLog(Suggestion.InsertFail + "，项目经验的信息，" + returnValue, "项目经验"
);//写入日志
result.Code = Common.ClientCode.Fail;
result.Message = Suggestion.InsertFail + returnValue;
return(result); //提示插入失败
}
}
result.Code = Common.ClientCode.FindNull;
result.Message = Suggestion.InsertFail + "，请核对输入的数据的格式"; //提示输入的数据的格式不对
return(result);
}
/// <summary>
/// 根据ID获取数据模型
/// </summary>
/// <param name="id">编号</param>
/// <returns></returns>
public ProjectExperience Get(string id)
{
ProjectExperience item = m_BLL.GetById(id);
return(item);
}
