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