public ActionResult Edit(string id)
{
ViewBag.perm = GetPermission();
MIS_ProfessorOuterModel entity = m_BLL.GetById(id);
return(View(entity));
}
public ActionResult Details(string id)
{
ViewBag.perm = GetPermission();
MIS_ProfessorOuterModel model = m_BLL.GetById(id);
return(View(model));
}
/// <summary>
/// 根据ID获得一个实体
/// </summary>
/// <param name="id">id</param>
/// <returns>实体</returns>
public virtual MIS_ProfessorOuterModel GetById(string id)
{
if (IsExist(id))
{
MIS_ProfessorOuter entity = m_Rep.GetById(id);
MIS_ProfessorOuterModel model = new MIS_ProfessorOuterModel();
model.Id = entity.Id;
model.uid = entity.uid;
model.name = entity.name;
model.sex = entity.sex;
model.position = entity.position;
model.department = entity.department;
model.mobile = entity.mobile;
model.email = entity.email;
model.area = entity.area;
model.profession = entity.profession;
model.office = entity.office;
model.stuNumPG = entity.stuNumPG;
model.referee = entity.referee;
model.location = entity.location;
model.Account = entity.Account;
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 修改一个实体
/// </summary>
/// <param name="errors">持久的错误信息</param>
/// <param name="model">模型</param>
/// <returns>是否成功</returns>
public virtual bool Edit(ref ValidationErrors errors, MIS_ProfessorOuterModel model)
{
try
{
MIS_ProfessorOuter entity = m_Rep.GetById(model.Id);
if (entity == null)
{
errors.add(Suggestion.Disable);
return(false);
}
entity.Id = model.Id;
entity.uid = model.uid;
entity.name = model.name;
entity.sex = model.sex;
entity.position = model.position;
entity.department = model.department;
entity.mobile = model.mobile;
entity.email = model.email;
entity.area = model.area;
entity.profession = model.profession;
entity.office = model.office;
entity.stuNumPG = model.stuNumPG;
entity.referee = model.referee;
entity.location = model.location;
entity.Account = model.Account;
if (m_Rep.Edit(entity))
{
return(true);
}
else
{
errors.add(Suggestion.EditFail);
return(false);
}
}
catch (Exception ex)
{
errors.add(ex.Message);
ExceptionHandler.WriteException(ex);
//ExceptionHander.WriteException(ex);
return(false);
}
}
public JsonResult Edit(MIS_ProfessorOuterModel model)
{
if (model != null && ModelState.IsValid)
{
if (m_BLL.Edit(ref errors, model))
{
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id, "成功", "修改", "MIS_ProfessorOuter");
return(Json(JsonHandler.CreateMessage(1, Suggestion.EditSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + "," + ErrorCol, "失败", "修改", "MIS_ProfessorOuter");
return(Json(JsonHandler.CreateMessage(0, Suggestion.EditFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.EditFail)));
}
}
public List <MIS_ProfessorOuterModel> GetImportData(string fileName)
{
var excel = new ExcelQueryFactory(fileName);
//映射excel列名
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.uid, "证书编号");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.name, "姓名");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.stuNumPG, "意向人数");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.sex, "性别");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.position, "职称/职务");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.department, "单位");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.mobile, "手机");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.email, "邮箱");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.area, "熟悉的业务内容");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.profession, "所属行业");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.office, "办公地址");
var excelContent = excel.WorksheetRange <MIS_ProfessorOuterModel>("A2", "K100", "2016届");
List <MIS_ProfessorOuterModel> modelList = new List <MIS_ProfessorOuterModel>();
foreach (var row in excelContent)
{
var professor = new MIS_ProfessorOuterModel();
professor.Id = row.Id;
professor.uid = row.uid;
professor.name = row.name;
professor.sex = row.sex;
professor.position = row.position;
professor.department = row.department;
professor.mobile = row.mobile;
professor.email = row.email;
professor.area = row.area;
professor.profession = row.profession;
professor.office = row.office;
modelList.Add(professor);
}
return(modelList);
}
public bool CheckImportData(string fileName, ref List <MIS_ProfessorOuterModel> modelList, ref ValidationErrors errors)
{
try
{
var excel = new ExcelQueryFactory(fileName);
//映射excel列名
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.uid, "证书编号");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.name, "姓名");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.stuNumPG, "意向人数");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.sex, "性别");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.position, "职称/职务");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.department, "单位");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.mobile, "手机");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.email, "邮箱");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.area, "熟悉的业务内容");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.profession, "所属行业");
excel.AddMapping <MIS_ProfessorOuterModel>(r => r.office, "办公地址");
var excelContent = excel.WorksheetRange <MIS_ProfessorOuterModel>("A2", "K100", "2016届");
int rowIndex = 1;
foreach (var row in excelContent)
{
var errorMessage = new StringBuilder();
var professor = new MIS_ProfessorOuterModel();
professor.Id = row.Id;
professor.uid = row.uid;
professor.name = row.name;
professor.sex = row.sex;
professor.position = row.position;
professor.department = row.department;
professor.mobile = row.mobile;
professor.email = row.email;
professor.area = row.area;
professor.profession = row.profession;
professor.office = row.office;
if (professor.uid == null)
{
errorMessage.Append("证书编号 - 不能为空");
}
if (errorMessage.Length > 0)
{
errors.add(string.Format("第{0}行发现错误 :{1}{2}", rowIndex, errorMessage.ToString(), "<br />"));
}
else
{
modelList.Add(professor);
}
rowIndex++;
}
if (errors.Count() > 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
errors.add(ex.Message);
ExceptionHandler.WriteException(ex);
return(false);
}
}
public void SaveData(MIS_ProfessorOuterModel model)
{
m_BLL.Create(ref errors, model);
}
