public string Add() { var model = new Implementation(); model.Id = Guid.NewGuid(); model.ClassName = Request["ClassName"]; model.Zhanduan = Request["Zhanduan"]; model.Subjects = Request["Subjects"]; model.IdNo = Request["IdNo"]; model.ExaminePosition = Request["ExaminePosition"]; model.StuName = Request["StuName"]; model.StuId = new Guid(Request["StuId"]); //var entity = unitOfWork.StudentBLL.GetEntityByID(model.StuId); //if (entity != null) //{ // model.StuNo = entity.StuNo; //} model.StuNo = Request["StuNo"]; model.IsValid = true; model.CreateId = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; model.CreateTime = DateTime.Now; unitOfWork.ImplementationBLL.InsertEntity(model); unitOfWork.Save(); return ""; }
private string DistributionImport(DataTable dt, out string msg) { msg = ""; try { if (dt != null) { foreach (DataRow row in dt.Rows) { var model = new Implementation(); model.StuNo = row["学员编号"].ToString(); model.StuName = row["姓名"].ToString(); model.IdNo = row["身份证号"].ToString(); model.ExaminePosition = row["考评岗位"].ToString(); model.ClassName = row["班级名称"].ToString(); model.Subjects = row["抽考项目"].ToString(); var stu = unitOfWork.StudentBLL.GetEntitys(m => m.StuNo == model.StuNo && m.Name == model.StuName); if (stu.Any()) { model.StuId = stu.ToArray()[0].Id; } model.IsValid = true; model.CreateTime = System.DateTime.Now; model.CreateId = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; model.Id = Guid.NewGuid(); //var entity = unitOfWork.StudentBLL.GetEntitys(m=>m.StuNo==model.StuNo&&m.IsValid); //if (entity != null) //{ // model //} unitOfWork.ImplementationBLL.InsertEntity(model); unitOfWork.Save(); } } } catch (Exception ex) { msg = "导入异常:" + ex.Message; Log.Error("StudentImport 异常:", ex); } return msg; }
private string DistributionImpImport(DataTable dt, out string msg) { msg = ""; try { if (dt != null) { foreach (DataRow row in dt.Rows) { //学员编号 姓名 身份证号 考评岗位 班级名称 所在站段 抽考项目 //考评项目1-编号 考评项目1-成绩 考评项目2-编号 考评项目2-成绩 考评项目3-编号 考评项目3-成绩 //考评项目4-编号 考评项目4-成绩 考评项目5-编号 考评项目5-成绩 考评项目6-编号 考评项目6-成绩 //总用时 总成绩 考评结果 备注 Implementation model; var stuno = row["学员编号"].ToString(); var entity = unitOfWork.ImplementationBLL.GetEntitys(m => m.StuNo == stuno); if (entity.Any()) { model = entity.ToArray()[0]; } else { model = new Implementation(); } model.StuNo = row["学员编号"].ToString(); model.StuName = row["姓名"].ToString(); var stu = unitOfWork.StudentBLL.GetEntitys(m => m.StuNo == model.StuNo && m.Name == model.StuName); if (stu.Any()) { model.StuId = stu.ToArray()[0].Id; } model.IdNo = row["身份证号"].ToString(); model.ExaminePosition = row["考评岗位"].ToString(); model.ClassName = row["班级名称"].ToString(); model.Zhanduan = row["所在站段"].ToString(); model.Subjects = row["抽考项目"].ToString(); var num = 0.0; var time = 0.0; model.Subject1No = row["考评项目1-编号"].ToString(); model.Subject1Score = row["考评项目1-成绩"].ToString(); model.Subject2No = row["考评项目2-编号"].ToString(); model.Subject2Score = row["考评项目2-成绩"].ToString(); model.Subject3No = row["考评项目3-编号"].ToString(); model.Subject3Score = row["考评项目3-成绩"].ToString(); model.Subject4No = row["考评项目4-编号"].ToString(); model.Subject4Score = row["考评项目4-成绩"].ToString(); model.Subject5No = row["考评项目5-编号"].ToString(); model.Subject5Score = row["考评项目5-成绩"].ToString(); model.Subject6No = row["考评项目6-编号"].ToString(); model.Subject6Score = row["考评项目6-成绩"].ToString(); //try //{ // if (!string.IsNullOrEmpty(model.YYJLScore)) // { // num = num + float.Parse(model.YYJLScore); // time = time + float.Parse(model.YYJLTime); // } // if (!string.IsNullOrEmpty(model.WYBScore)) // { // num = num + float.Parse(model.WYBScore); // time = time + float.Parse(model.WYBTime); // } // if (!string.IsNullOrEmpty(model.ZSDScore)) // { // num = num + float.Parse(model.ZSDScore); // time = time + float.Parse(model.ZSDTime); // } // if (!string.IsNullOrEmpty(model.BJGHScore)) // { // num = num + float.Parse(model.BJGHScore); // time = time + float.Parse(model.BJGHTime); // } // if (!string.IsNullOrEmpty(model.WYZZScroe)) // { // num = num + float.Parse(model.WYZZScroe); // time = time + float.Parse(model.WYZZTime); // } // if (!string.IsNullOrEmpty(model.YJTXScroe)) // { // num = num + float.Parse(model.YJTXScroe); // time = time + float.Parse(model.YJTXTime); // } //} //catch (Exception exception) //{ // Log.Error("DistributionImpImport 异常", exception); //} model.UseTime = row["总用时"].ToString(); model.Score = row["总成绩"].ToString(); model.ExamineResult = row["考评结果"].ToString(); model.Remark = row["备注"].ToString(); model.IsValid = true; model.CreateTime = System.DateTime.Now; model.CreateId = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; if (entity.Any()) { unitOfWork.ImplementationBLL.UpdateEntity(model); } else //新增 { model.Id = Guid.NewGuid(); unitOfWork.ImplementationBLL.InsertEntity(model); } unitOfWork.Save(); } } } catch (Exception ex) { msg = "导入异常:" + ex.Message; Log.Error("DistributionImpImport 异常:", ex); } return msg; }