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