/// <summary> /// 去除已存在的记录 /// </summary> /// <param name="list">待筛选记录列表</param> /// <remarks>作者:dfq 时间:2017-05-07</remarks> public void RemoveExistingRecord(List <Mod_Online_ApplicationTypeEntity> list) { List <Mod_Online_ApplicationTypeEntity> existList = GetList(); foreach (Mod_Online_ApplicationTypeEntity entity in existList) { for (int i = 0; i < list.Count; i++) { Mod_Online_ApplicationTypeEntity item = list[i]; if (item.AppTypeName.Trim() == entity.AppTypeName.Trim()) { list.RemoveAt(i); } } } }
/// <summary> /// 创建报考类型 /// </summary> protected void btnCreateApplicationType_Click(object sender, EventArgs e) { List <Mod_Online_ApplicationTypeEntity> list = new List <Mod_Online_ApplicationTypeEntity>(); string[] types = new string[] { "文科类", "理工科类", "英语类", "日语类", "艺术类", "体育类" }; foreach (string item in types) { Mod_Online_ApplicationTypeEntity model = new Mod_Online_ApplicationTypeEntity(); model.AppTypeId = StringHelper.GetGuid(); model.AppTypeName = item; list.Add(model); } Mod_Online_ApplicationTypeBiz typeBiz = new Mod_Online_ApplicationTypeBiz(); typeBiz.RemoveExistingRecord(list); if (typeBiz.Add(list)) { DialogHelper.ShowTipSuccessMsg("添加报考类型成功!", "", Page); } else { DialogHelper.ShowTipErrorMsg("添加报考类型失败!", "", Page); } }
/// <summary> /// Excel数据导入 /// </summary> /// <param name="yearId">年度</param> /// <param name="path">相对路径</param> /// <param name="user">当前登录人员</param> /// <returns>执行结果</returns> public bool ExcelImport(string yearId, string path, LoginEntity user) { bool isAdd = false; List <Mod_Online_YearPlan_DetailEntity> addList = new List <Mod_Online_YearPlan_DetailEntity>(); //待添加的列表 List <Mod_Online_YearPlan_Detail_MajorCodeEntity> detailMajorCodeAddList = new List <Mod_Online_YearPlan_Detail_MajorCodeEntity>(); //待添加的计划详细-代码详细 //2017年江苏省普通高校“专转本”专业计划表 Mod_Online_YearPlanEntity yearPlanModel = GetYearPlanModel(yearId); //获取年度计划实体 if (yearPlanModel == null) //添加 { isAdd = true; yearPlanModel = new Mod_Online_YearPlanEntity(); yearPlanModel.PlanId = StringHelper.GetGuid(); yearPlanModel.YearId = yearId.ToInt(); yearPlanModel.PlanName = string.Format("{0}年江苏省普通高校“专转本”专业计划表", yearId); } List <Mod_Online_ApplicationTypeEntity> applicationTypeAddList = new List <Mod_Online_ApplicationTypeEntity>(); //待添加的类型 List <Mod_Online_SchoolEntity> shcoolAddList = new List <Mod_Online_SchoolEntity>(); //待添加的学校列表 List <Mod_Online_School_MajorEntity> schoolMajorAddList = new List <Mod_Online_School_MajorEntity>(); //学校专业待添加列表 Mod_Online_ApplicationTypeBiz applicationTypeBiz = new Mod_Online_ApplicationTypeBiz(); Mod_Online_SchoolBiz schoolBiz = new Mod_Online_SchoolBiz(); //学校编号业务 Mod_Online_YearPlan_DetailBiz detailBiz = new Mod_Online_YearPlan_DetailBiz(); //详细业务 Mod_Online_School_MajorBiz schoolMajorBiz = new Mod_Online_School_MajorBiz(); //学校专业业务 Mod_Online_YearPlan_Detail_MajorCodeBiz detailMajorCodeBiz = new Mod_Online_YearPlan_Detail_MajorCodeBiz(); //专业要求业务 int publicSchool = 0; //公办 int privateSchool = 1; //私办 StringBuilder strShcoolName = new StringBuilder(); //学校名称 StringBuilder strSchoolMajorName = new StringBuilder(); //学校对应专业名称 StringBuilder strCodeId = new StringBuilder(); //专业课程要求代码 // string cmdText = @"SELECT [报考类别],[院校名称],[院校类型],[专业名称],[计划数],[投档分数],[对报考者专科阶段所学专业等要求],[专业课程要求],[备注] FROM [Sheet1$];"; string cmdText = @"SELECT [报考类别],[院校名称],[院校类型],[专业名称],[计划数],[对报考者专科阶段所学专业等要求],[专业课程要求],[备注] FROM [Sheet1$];"; List <Mod_Online_ApplicationTypeEntity> applicationTypeList = applicationTypeBiz.GetList();//获取类型列表 //更新的情况 List <Mod_Online_YearPlan_DetailEntity> planDetailList = null; if (!isAdd) { planDetailList = detailBiz.GetYearPlanList(yearPlanModel.PlanId);//获取类型列表 } using (OleDbDataReader dr = ExcelHelper.ReadExcel(FileHelper.GetMapPath(string.Format("~{0}", path)), cmdText)) { while (dr.Read()) { Mod_Online_YearPlan_DetailEntity model = new Mod_Online_YearPlan_DetailEntity(); model.DetailId = StringHelper.GetGuid(); model.PlanId = yearPlanModel.PlanId; model.YearId = yearPlanModel.YearId; #region 报考类型 model.AppTypeName = StringHelper.TrimString(dr["报考类别"].ToString()).Trim(); Mod_Online_ApplicationTypeEntity tempApplicationType = applicationTypeList.Find(x => x.AppTypeName.Trim() == model.AppTypeName); if (tempApplicationType != null) { model.AppTypeId = tempApplicationType.AppTypeId; } else { tempApplicationType = applicationTypeAddList.Find(x => x.AppTypeName.Trim() == model.AppTypeName);//查询已添加的类型中是否存在该类型 if (tempApplicationType != null) { model.AppTypeId = tempApplicationType.AppTypeId; } else { Mod_Online_ApplicationTypeEntity applicationType = new Mod_Online_ApplicationTypeEntity(); applicationType.AppTypeId = StringHelper.GetGuid(); applicationType.AppTypeName = model.AppTypeName; applicationTypeAddList.Add(applicationType); model.AppTypeId = applicationType.AppTypeId; } } #endregion //学校 model.SchoolName = StringHelper.TrimString(dr["院校名称"].ToString()).Trim(); model.SchoolType = StringHelper.TrimString(dr["院校类型"].ToString()).Trim() == "公办" ? publicSchool : privateSchool; strShcoolName.AppendFormat("'{0}',", model.SchoolName); //专业 model.SchoolMajorName = StringHelper.TrimString(dr["专业名称"].ToString()).Trim(); strSchoolMajorName.AppendFormat("'{0}',", model.SchoolMajorName); string numbers = StringHelper.TrimString(dr["计划数"].ToString()).Trim(); //计划数 model.PlanNumber = string.IsNullOrEmpty(numbers) ? 0 : numbers.ToInt(); //投档分数 //string castScore = StringHelper.TrimString(dr["投档分数"].ToString()).Trim(); //model.CastScore = string.IsNullOrEmpty(castScore) ? 0 : castScore.ToDouble(); model.CastScore = 0; string require = StringHelper.TrimString(dr["对报考者专科阶段所学专业等要求"].ToString()).Trim(); model.CandidateRequire = require; string[] requires = require.Split('、'); foreach (string item in requires) { Mod_Online_YearPlan_Detail_MajorCodeEntity detailMajorCode = new Mod_Online_YearPlan_Detail_MajorCodeEntity(); detailMajorCode.Id = StringHelper.GetGuid(); if (item.Split('H').Length > 1)//防止出现中外合作办学情况 { string[] codes = item.Split('H'); detailMajorCode.CodeId = string.Format("{0}H", codes[0]); detailMajorCode.CodeName = codes[1]; } else { detailMajorCode.CodeId = StringHelper.RemoveNotNumber(item); detailMajorCode.CodeName = StringHelper.RemoveNumber(item); } detailMajorCode.DetailId = model.DetailId; detailMajorCode.PlanId = model.PlanId; detailMajorCode.YearId = model.YearId; detailMajorCodeAddList.Add(detailMajorCode); strCodeId.AppendFormat("'{0}',", detailMajorCode.CodeId); } model.MajorRequire = StringHelper.TrimString(dr["专业课程要求"].ToString()).Trim(); model.Remarks = StringHelper.TrimString(dr["备注"].ToString()).Trim(); if (model.Remarks.Contains("退役士兵")) { model.ExtFlag = 1; } addList.Add(model); } } List <Mod_Online_SchoolEntity> tempShcoolList = schoolBiz.GetSchoolList(strShcoolName.ToString().Trim().TrimEnd(',')); List <Mod_Online_School_MajorEntity> tempShcoolMajorList = schoolMajorBiz.GetSchoolMajorList(strSchoolMajorName.ToString().Trim().TrimEnd(',')); foreach (Mod_Online_YearPlan_DetailEntity import in addList) { Mod_Online_SchoolEntity tempschool = tempShcoolList.Find(x => x.SchoolName == import.SchoolName); if (tempschool == null) { tempschool = shcoolAddList.Find(x => x.SchoolName == import.SchoolName);//从已添加的中查询,防止重复 if (tempschool == null) { tempschool = new Mod_Online_SchoolEntity(); tempschool.SchoolId = StringHelper.GetGuid(); tempschool.SchoolName = import.SchoolName; tempschool.SchoolType = import.SchoolType; shcoolAddList.Add(tempschool); } } import.SchoolType = tempschool.SchoolType; import.SchoolId = tempschool.SchoolId; Mod_Online_School_MajorEntity tempschoolMajor = tempShcoolMajorList.Find(x => x.SchoolName == import.SchoolName && x.SchoolMajorName == import.SchoolMajorName); if (tempschoolMajor == null) { //防止重复 tempschoolMajor = schoolMajorAddList.Find(x => x.SchoolName == import.SchoolName && x.SchoolMajorName == import.SchoolMajorName); if (tempschoolMajor == null) { tempschoolMajor = new Mod_Online_School_MajorEntity(); tempschoolMajor.SchoolMajorId = StringHelper.GetGuid(); tempschoolMajor.SchoolMajorName = import.SchoolMajorName; tempschoolMajor.SchoolId = import.SchoolId; tempschoolMajor.SchoolName = import.SchoolName; schoolMajorAddList.Add(tempschoolMajor); } } import.SchoolMajorId = tempschoolMajor.SchoolMajorId; } return(DBHelper.Transaction((dp, ex) => { if (applicationTypeAddList.Count > 0) { applicationTypeBiz.Add(applicationTypeAddList, dp); } if (shcoolAddList.Count > 0) { schoolBiz.Add(shcoolAddList, dp); } if (schoolMajorAddList.Count > 0) { schoolMajorBiz.Add(schoolMajorAddList, dp); } if (isAdd) { this.Add(yearPlanModel, dp); detailBiz.Add(addList, dp); detailMajorCodeBiz.Add(detailMajorCodeAddList, dp); } else { if (detailBiz.DelDetail(yearId, dp)) { detailBiz.Add(addList, dp); } if (detailMajorCodeBiz.DelDetailMajorCode(yearId, dp)) { detailMajorCodeBiz.Add(detailMajorCodeAddList, dp); } } }) > 0); }
/// <summary> /// 更新一条记录 /// </summary> /// <param name="entity">待更新的实体对象</param> /// <returns>true:更新成功 false:更新失败</returns> public virtual bool Update(Mod_Online_ApplicationTypeEntity entity) { SQL sql = SQL.Build("UPDATE Mod_Online_ApplicationType SET AppTypeName=?,StateFlag=?,OrderIndex=?,DeleteFlag=?,ExtFlag=? WHERE AppTypeId=?", entity.AppTypeName, entity.StateFlag, entity.OrderIndex, entity.DeleteFlag, entity.ExtFlag, entity.AppTypeId); return(SqlMap <Mod_Online_ApplicationTypeEntity> .ParseSql(sql).Execute() > 0); }
/// <summary> /// 添加一条记录 /// </summary> /// <param name="entity">待添加的实体对象</param> /// <returns>true:添加成功 false:添加失败</returns> public bool Add(Mod_Online_ApplicationTypeEntity entity, IDataProvider provider) { SQL sql = SQL.Build("INSERT INTO Mod_Online_ApplicationType(AppTypeId,AppTypeName,StateFlag,OrderIndex,DeleteFlag,ExtFlag) VALUES(?,?,?,?,?,?)", entity.AppTypeId, entity.AppTypeName, entity.StateFlag, entity.OrderIndex, entity.DeleteFlag, entity.ExtFlag); return(SqlMap <Mod_Online_ApplicationTypeEntity> .ParseSql(sql).Execute(provider) > 0); }
/// <summary> /// 删除一条记录 /// </summary> /// <param name="entity">待删除的实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public virtual bool Delete(Mod_Online_ApplicationTypeEntity entity) { SQL sql = SQL.Build("DELETE FROM Mod_Online_ApplicationType WHERE AppTypeId=?", entity.AppTypeId); return(SqlMap <Mod_Online_ApplicationTypeEntity> .ParseSql(sql).Execute() > 0); }