public string Add() { ControllerContext.HttpContext.Request.ContentEncoding = Encoding.GetEncoding("UTF-8"); ControllerContext.HttpContext.Response.ContentEncoding = Encoding.GetEncoding("UTF-8"); ControllerContext.HttpContext.Response.Charset = "UTF-8"; var ParentId = Request["ParentId"]; var ParentName = Request["ParentName"]; var TrainTypeNo = Request["TrainTypeNo"]; var TrainTypeName = Request["TrainTypeName"]; var TrainFormatNo = Request["TrainFormatNo"]; var TrainFormatName = Request["TrainFormatName"]; var TrainPrice = Request["TrainPrice"]; var TheYear = Request["TheYear"]; var ThePeriod = Request["ThePeriod"]; var StuTime = Request["StuTime"]; var GraduationTime = Request["GraduationTime"]; var ProfessionNo = Request["ProfessionNo"]; var ProfessionName = Request["ProfessionName"]; var HeadmasterId = Request["HeadmasterId"]; var HeadmasterName = Request["HeadmasterName"]; var HeadmasterTel = Request["HeadmasterTel"]; var StuResearchId = Request["StuResearchId"]; var StuResearchName = Request["StuResearchName"]; var Name = Request["Name"]; var Gender = Request["Gender"]; var GenderName = Request["GenderName"]; var StuNo = Request["StuNo"]; var education = Request["Education"]; var educationName = Request["EducationName"]; var workIdNo = Request["WorkIdNo"]; var tickNo = Request["TickNo"]; var cellPhoneNo = Request["CellPhoneNo"]; var post = Request["Post"]; var postName = Request["PostName"]; var stuTime = Request["StuTime"]; var luju = Request["Luju"]; var zhanduan = Request["zhanduan"]; var IdNo = Request["IdNo"]; var DeptName = Request["DeptName"]; var Ustatus = Request["Ustatus"]; var Score = Request["Score"]; var SecurityScore = Request["SecurityScore"]; var TheoryScore = Request["TheoryScore"]; var ImpScore = Request["ImpScore"]; var ReturnInfo = Request["ReturnInfo"]; var LeavePerson = Request["LeavePerson"]; var LeaveTime = Request["LeaveTime"]; var LeaveReason = Request["LeaveReason"]; var LeaveDays = Request["LeaveDays"]; var GraduationStatus = Request["GraduationStatus"]; var model = new Student(); model.Id = Guid.NewGuid(); model.ParentId = new Guid(ParentId); model.ParentName = ParentName; model.TrainTypeNo = TrainTypeNo; model.TrainTypeName = TrainTypeName; model.TrainFormatNo = TrainFormatNo; model.TrainFormatName = TrainFormatName; model.ParentName = ParentName; model.TrainPrice = TrainPrice; model.TheYear = TheYear; model.ThePeriod = ThePeriod; if (!string.IsNullOrEmpty(stuTime)) { model.StuTime = Convert.ToDateTime(StuTime); } if (!string.IsNullOrEmpty(GraduationTime)) { model.GraduationTime = Convert.ToDateTime(GraduationTime); } model.ProfessionNo = ProfessionNo; model.ProfessionName = ProfessionName; model.HeadmasterId = HeadmasterId; model.HeadmasterName = HeadmasterName; model.HeadmasterTel = HeadmasterTel; model.StuResearchId = StuResearchId; model.StuResearchName = StuResearchName; model.SecurityScore = SecurityScore; model.TheoryScore = TheoryScore; model.ImpScore = ImpScore; model.ReturnInfo = ReturnInfo; model.LeavePerson = LeavePerson; model.LeaveTime = LeaveTime; model.LeaveReason = LeaveReason; model.LeaveDays = LeaveDays; model.GraduationStatus = GraduationStatus; model.Gender = Gender; model.GenderName = GenderName; model.Education = education; model.EducationName = educationName; model.WorkIdNo = workIdNo; model.TickNo = tickNo; model.CellPhoneNo = cellPhoneNo; model.Name = Name; model.IdNo = IdNo; model.DeptName = DeptName; model.Ustatus = Ustatus; model.AllPath = DeptName; model.Post = post; model.PostName = postName; model.IsValid = true; model.IsExc = false; model.StuTime = Convert.ToDateTime(stuTime); model.StuNo = GetStuNo(model.ProfessionNo,model.StuTime,StuNo); model.CreateTime = System.DateTime.Now; model.CreateId = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; model.Luju = luju; model.Zhanduan = zhanduan; model.Score = Score; unitOfWork.StudentBLL.InsertEntity(model); unitOfWork.Save(); return ""; }
private string StudentImport(DataTable dt, out string msg) { msg = ""; try { if (dt != null) { foreach (DataRow row in dt.Rows) { var model = new Student(); model.Id = Guid.NewGuid(); var classinfo= SetClassInfo(row); model.ParentId = classinfo.Id; model.ParentName = classinfo.Name; model.Name = row["学员姓名"].ToString(); var result = unitOfWork.StudentBLL.GetEntitys(m => m.Name == model.Name && m.ParentName == model.ParentName && m.IsValid); if (result.Any()) //存在更新 { // continue; model = result.FirstOrDefault(); model.Gender = unitOfWork.SysCodeBLL.GetCodeFromName(row["性别"].ToString()); model.GenderName = string.IsNullOrEmpty(model.Gender) ? "" : row["性别"].ToString(); model.DeptName = row["单位及职务"].ToString(); model.Education = unitOfWork.SysCodeBLL.GetCodeFromName(row["学历"].ToString()); model.EducationName = string.IsNullOrEmpty(model.Education) ? "" : row["学历"].ToString(); model.IdNo = row["身份证号"].ToString(); model.WorkIdNo = row["工作证号"].ToString(); model.TickNo = row["公免票号"].ToString(); model.CellPhoneNo = row["手机号码"].ToString(); model.IsValid = true; model.IsExc = false; model.Luju = row["路局"].ToString(); model.Zhanduan = row["站段"].ToString(); model.Post = classinfo.ProfessionNo; model.PostName = classinfo.ProfessionName; model.TrainTypeNo = classinfo.TrainTypeName; model.TrainTypeName = classinfo.TrainTypeName; model.TrainFormatNo = classinfo.TrainFormatNo; model.TrainFormatName = classinfo.TrainFormatName; model.TrainPrice = classinfo.TrainPrice; model.TheYear = classinfo.TheYear; model.ThePeriod = classinfo.ThePeriod; if (classinfo.BeginTime != null) { model.StuTime = Convert.ToDateTime(classinfo.BeginTime); } if (classinfo.EndTime != null && classinfo.EndTime != DateTime.MinValue) { model.GraduationTime = classinfo.EndTime; } model.ProfessionNo = classinfo.ProfessionNo; model.ProfessionName = classinfo.ProfessionName; if (classinfo.HeadmasterId != null) { model.HeadmasterId = classinfo.HeadmasterId.ToString(); } model.HeadmasterName = classinfo.HeadmasterName; model.HeadmasterTel = classinfo.HeadmasterTel; model.StuResearchId = classinfo.DeptNo; model.StuResearchName = classinfo.DeptName; model.SecurityScore = row["安全成绩"].ToString(); model.TheoryScore = row["理论成绩"].ToString(); model.ImpScore = row["实作成绩"].ToString(); model.ReturnInfo = row["返程信息"].ToString(); model.LeavePerson = row["请假人员"].ToString(); model.LeaveTime = row["请假时间"].ToString(); model.LeaveReason = row["请假事由"].ToString(); model.LeaveDays = row["请假天数"].ToString(); model.GraduationStatus = row["结业状态"].ToString(); // model.Ustatus = (int) EnumStuInfoApprove.Non; model.CreateTime = System.DateTime.Now; model.CreateId = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; model.StuNo = GetStuNo(model.ProfessionNo, model.StuTime, row["学员编号"].ToString()); model.Score = row["综合考评"].ToString(); unitOfWork.StudentBLL.UpdateEntity(model); unitOfWork.Save(); } else { model.Gender = unitOfWork.SysCodeBLL.GetCodeFromName(row["性别"].ToString()); model.GenderName = string.IsNullOrEmpty(model.Gender) ? "" : row["性别"].ToString(); model.DeptName = row["单位及职务"].ToString(); model.Education = unitOfWork.SysCodeBLL.GetCodeFromName(row["学历"].ToString()); model.EducationName = string.IsNullOrEmpty(model.Education) ? "" : row["学历"].ToString(); model.IdNo = row["身份证号"].ToString(); model.WorkIdNo = row["工作证号"].ToString(); model.TickNo = row["公免票号"].ToString(); model.CellPhoneNo = row["手机号码"].ToString(); model.IsValid = true; model.IsExc = false; model.Luju = row["路局"].ToString(); model.Zhanduan = row["站段"].ToString(); //model.Post = unitOfWork.SysCodeBLL.GetCodeFromName(row["岗位工种"].ToString()); //model.PostName = string.IsNullOrEmpty(model.Post) ? "" : row["岗位工种"].ToString(); //model.TrainTypeNo = unitOfWork.SysCodeBLL.GetCodeFromName(row["培训类别"].ToString()); //model.TrainTypeName = string.IsNullOrEmpty(model.TrainTypeNo) ? "" : row["培训类别"].ToString(); //model.TrainFormatNo = unitOfWork.SysCodeBLL.GetCodeFromName(row["培训形式"].ToString()); //model.TrainFormatName = string.IsNullOrEmpty(model.TrainFormatNo) ? "" : row["培训形式"].ToString(); //model.TrainPrice = row["培训单价"].ToString(); //model.TheYear = row["年份"].ToString(); //model.ThePeriod = row["期数"].ToString(); //if (!string.IsNullOrEmpty(row["开班日期"].ToString())) //{ // model.StuTime = Convert.ToDateTime(row["开班日期"].ToString()); //} //if (!string.IsNullOrEmpty(row["结业日期"].ToString())) //{ // model.GraduationTime = Convert.ToDateTime(row["结业日期"].ToString()); //} //model.ProfessionNo = unitOfWork.SysCodeBLL.GetCodeFromName(row["专业"].ToString()); ; //model.ProfessionName = string.IsNullOrEmpty(model.ProfessionNo) ? "" : row["专业"].ToString(); //var name = row["班主任"].ToString(); //var headmaster = unitOfWork.HeadmasterBLL.GetEntitys(m => m.Name == name); //if (headmaster.Any()) //{ // model.HeadmasterId = headmaster.ToList()[0].Id.ToString(); // model.HeadmasterName = headmaster.ToList()[0].Name; //} //model.HeadmasterTel = row["班主任联系方式"].ToString(); //model.StuResearchId = unitOfWork.SysCodeBLL.GetCodeFromName(row["教研室"].ToString()); //model.StuResearchName = string.IsNullOrEmpty(model.StuResearchId) ? "" : row["教研室"].ToString(); model.Post = classinfo.ProfessionNo; model.PostName = classinfo.ProfessionName; model.TrainTypeNo = classinfo.TrainTypeName; model.TrainTypeName = classinfo.TrainTypeName; model.TrainFormatNo = classinfo.TrainFormatNo; model.TrainFormatName = classinfo.TrainFormatName; model.TrainPrice = classinfo.TrainPrice; model.TheYear = classinfo.TheYear; model.ThePeriod = classinfo.ThePeriod; if (classinfo.BeginTime != null) { model.StuTime = Convert.ToDateTime(classinfo.BeginTime); } if (classinfo.EndTime != null && classinfo.EndTime != DateTime.MinValue) { model.GraduationTime = classinfo.EndTime; } model.ProfessionNo = classinfo.ProfessionNo; model.ProfessionName = classinfo.ProfessionName; if (classinfo.HeadmasterId != null) { model.HeadmasterId = classinfo.HeadmasterId.ToString(); } model.HeadmasterName = classinfo.HeadmasterName; model.HeadmasterTel = classinfo.HeadmasterTel; model.StuResearchId = classinfo.DeptNo; model.StuResearchName = classinfo.DeptName; model.SecurityScore = row["安全成绩"].ToString(); model.TheoryScore = row["理论成绩"].ToString(); model.ImpScore = row["实作成绩"].ToString(); model.ReturnInfo = row["返程信息"].ToString(); model.LeavePerson = row["请假人员"].ToString(); model.LeaveTime = row["请假时间"].ToString(); model.LeaveReason = row["请假事由"].ToString(); model.LeaveDays = row["请假天数"].ToString(); model.GraduationStatus = row["结业状态"].ToString(); // model.Ustatus = (int) EnumStuInfoApprove.Non; model.CreateTime = System.DateTime.Now; model.CreateId = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; model.StuNo = GetStuNo(model.ProfessionNo, model.StuTime, row["学员编号"].ToString()); model.Score = row["综合考评"].ToString(); unitOfWork.StudentBLL.InsertEntity(model); unitOfWork.Save(); } } } } catch (Exception ex) { msg ="导入异常:"+ ex.Message; Log.Error("StudentImport 异常:", ex); } return msg; }