public void PostImportExcel()
{
string _fileExt = string.Empty;
int _code = 0;
string _message = string.Empty;
try
{
HttpPostedFile _uploadFiles = Request.Files["uploadFile"] as HttpPostedFile;
if (_uploadFiles == null || _uploadFiles.FileName.Length < 3)
{
_message = "您没有选择要上传的文件！";
_code = -4;
}
else
{
_fileExt = Path.GetExtension(_uploadFiles.FileName).ToLower(); //获取文件扩展名
String[] _allowedExt = { ".xls", ".xlsx" }; //允许上传的文件格式
if (!_allowedExt.Contains(_fileExt))
{
_message = "您上传的格式为" + _fileExt + ", 本统只接受扩展名为" + string.Join("、", _allowedExt) + "格式文件";
_code = -3;
}
else if (_uploadFiles.ContentLength == 0)
{
_message = "上传的内容为空！";
_code = -2;
}
else if (_uploadFiles.ContentLength > 1024 * 1024 * 8)
{
_message = "您上传的文件超过了8M！";
_code = -1;
}
}
if (_code == 0)
{
string _fileName = ShortFileNameUtil.ShortFileName(Guid.NewGuid().ToString()) + _fileExt;
string _virtualPath = "/UploadFiles/registrationXls/";
string _physicalPath = HttpContext.Server.MapPath(_virtualPath);
if (!Directory.Exists(_physicalPath))
{
Directory.CreateDirectory(_physicalPath);
}
string _fullPath = _physicalPath + _fileName;
_uploadFiles.SaveAs(_fullPath);
DataTable _employeeData = JNyuluUtils.ImportExcel(_fullPath);
int _i = 0;
StringBuilder _result = new StringBuilder();
_result.AppendLine("上传路径为：" + _virtualPath + _fileName);
_result.AppendLine("Excel解析日志记录：");
foreach (DataRow dr in _employeeData.Rows)
{
_i++;
try
{
//["学籍号"] ["学生姓名"] dr["报名时间"] dr["班级"] dr["原校"] dr["原来年级"] dr["金额"] dr["备注"]
string _name = dr["学籍号"].ToString() + "";
if (!string.IsNullOrEmpty(_name))
{
Employee _employee = _employeeService.GetEmployeeByName(_name);
if (_employee != null)
{
string _gradeName = dr["原来年级"].ToString() + "";
Grade _grade = _gradeService.GetGradeByName(_gradeName);
if (_grade != null)
{
int _stID = 0;
string _schoolTermName = dr["班级"].ToString();
SchoolTerm _schoolTerm = _schoolTermService.GetBaseSchoolTermByName(_schoolTermName);
if (_schoolTerm != null)
{
_stID = _schoolTerm.ID;
}
int _schoolFee = 0;
int.TryParse(dr["金额"].ToString(), out _schoolFee);
Registration _registration = new Registration();
_registration.EmployeeID = _employee.ID;
_registration.SchoolName = dr["原校"].ToString() + "";
_registration.GradeID = _grade.ID;
_registration.GradeName = _grade.Name;
_registration.STID = _stID;
_registration.SchoolFee = _schoolFee;
_registration.Remark = dr["备注"].ToString() + "";
DateTime _recordDate = DateTime.Today;
if (DateTime.TryParse(dr["报名时间"].ToString() + "", out _recordDate))
{
_registration.RecordDate = _recordDate;
}
else
{
LogHelper.Info("记录[" + _i + "]考试时间格式错误");
_result.AppendLine("记录[" + _i + "]考试时间格式错误");
continue;
}
_code = _registrationService.InsertRegistration(_registration);
}
else
{
LogHelper.Error("记录[" + _i + "]原来年级" + _gradeName + "不存在");
_result.AppendLine("记录[" + _i + "]原来年级" + _gradeName + "不存在");
}
}
else
{
LogHelper.Error("记录[" + _i + "]学籍号" + _name + "不存在，您必须选注册学籍号");
_result.AppendLine("记录[" + _i + "]学籍号" + _name + "不存在，您必须选注册学籍号");
}
}
else
{
LogHelper.Error("记录[" + _i + "] 中的学籍号不能为空");
_result.AppendLine("记录[" + _i + "] 中的学籍号不能为空");
}
}
catch (Exception ex)
{
LogHelper.Error("记录[" + _i + "]导入出错 " + ex.ToString());
_result.AppendLine("记录[" + _i + "]导入出错 " + ex.ToString());
continue;
}
_i++;
}
_message = _result.ToString();
}
}
catch (Exception ex)
{
_code = -1;
_message = ex.Message;
}
finally
{
RenderText("{code: " + _code + ",message: '" + _message + "'}");
CancelLayout();
}
}
public void PostImportExcel()
{
string _fileExt = string.Empty;
int _code = 0;
string _message = string.Empty;
try
{
HttpPostedFile _uploadFiles = Request.Files["uploadFile"] as HttpPostedFile;
if (_uploadFiles == null || _uploadFiles.FileName.Length < 3)
{
_message = "您没有选择要上传的文件！";
_code = -4;
}
else
{
_fileExt = Path.GetExtension(_uploadFiles.FileName).ToLower(); //获取文件扩展名
String[] _allowedExt = { ".xls", ".xlsx" }; //允许上传的文件格式
if (!_allowedExt.Contains(_fileExt))
{
_message = "您上传的格式为" + _fileExt + ", 本统只接受扩展名为" + string.Join("、", _allowedExt) + "格式文件";
_code = -3;
}
else if (_uploadFiles.ContentLength == 0)
{
_message = "上传的内容为空！";
_code = -2;
}
else if (_uploadFiles.ContentLength > 1024 * 1024 * 8)
{
_message = "您上传的文件超过了8M！";
_code = -1;
}
}
if (_code == 0)
{
string _fileName = ShortFileNameUtil.ShortFileName(Guid.NewGuid().ToString()) + _fileExt;
string _virtualPath = "/UploadFiles/syllabusXls/";
string _physicalPath = HttpContext.Server.MapPath(_virtualPath);
if (!Directory.Exists(_physicalPath))
{
Directory.CreateDirectory(_physicalPath);
}
string _fullPath = _physicalPath + _fileName;
_uploadFiles.SaveAs(_fullPath);
DataTable _employeeData = JNyuluUtils.ImportExcel(_fullPath);
int _i = 0;
StringBuilder _result = new StringBuilder();
_result.AppendLine("上传路径为：" + _virtualPath + _fileName);
_result.AppendLine("Excel解析日志记录：");
foreach (DataRow dr in _employeeData.Rows)
{
try
{
//dr["班级"] dr["学籍号"] dr["学生姓名"] dr["课程表路径"];
string _name = dr["学籍号"].ToString() + "";
Employee _employee = _employeeService.GetEmployeeByName(_name);
if (_employee == null)
{
LogHelper.Info("记录[" + _i + "]学籍:" + _name + " 不存在");
_result.AppendLine("记录[" + _i + "]学籍:" + _name + " 不存在");
continue;
}
int _stID = 0;
string _schoolTermName = dr["班级"].ToString() + "";
SchoolTerm _schoolTerm = _schoolTermService.GetBaseSchoolTermByName(_schoolTermName);
if (_schoolTerm == null)
{
LogHelper.Info("记录[" + _i + "]班级:" + _schoolTermName + " 不存在");
_result.AppendLine("记录[" + _i + "]班级:" + _schoolTermName + " 不存在");
continue;
}
if (_employee.ID > 0 && _stID > 0)
{
Syllabus _syllabus = new Syllabus();
_syllabus.EmployeeID = _employee.ID;
_syllabus.STID = _stID;
_syllabus.SyllabusUrl = _virtualPath + dr["课程表路径"].ToString() + "";
IList <Syllabus> _syllabusList = _syllabusService.GetBaseSyllabus(_syllabus);
if (_syllabusList.Count > 0)
{
_code = _syllabusList[0].ID;
_syllabusService.UpdateSyllabus(_syllabus);
}
else
{
_code = _syllabusService.InsertSyllabus(_syllabus);
}
if (_code > 0)
{
LogHelper.Info("记录[" + _i + "]导入成功");
_result.AppendLine("记录[" + _i + "]导入成功");
}
_code = _syllabus.ID;
}
}
catch (Exception ex)
{
_result.AppendLine(ex.ToString());
LogHelper.Error(ex.ToString());
continue;
}
_i++;
}
_message = _result.ToString();
}
}
catch (Exception ex)
{
_code = -1;
_message = ex.Message;
}
finally
{
RenderText("{code: " + _code + ",message: \"" + _message.Replace(@"\", @"\\") + "\"}");
CancelLayout();
}
}
public void PostImportExcel()
{
string _fileExt = string.Empty;
int _code = 0;
string _message = string.Empty;
try
{
HttpPostedFile _uploadFiles = Request.Files["uploadFile"] as HttpPostedFile;
if (_uploadFiles == null || _uploadFiles.FileName.Length < 3)
{
_message = "您没有选择要上传的文件！";
_code = -4;
}
else
{
_fileExt = Path.GetExtension(_uploadFiles.FileName).ToLower(); //获取文件扩展名
String[] _allowedExt = { ".xls", ".xlsx" }; //允许上传的文件格式
if (!_allowedExt.Contains(_fileExt))
{
_message = "您上传的格式为" + _fileExt + ", 本统只接受扩展名为" + string.Join("、", _allowedExt) + "格式文件";
_code = -3;
}
else if (_uploadFiles.ContentLength == 0)
{
_message = "上传的内容为空！";
_code = -2;
}
else if (_uploadFiles.ContentLength > 1024 * 1024 * 8)
{
_message = "您上传的文件超过了8M！";
_code = -1;
}
}
if (_code == 0)
{
string _fileName = ShortFileNameUtil.ShortFileName(Guid.NewGuid().ToString()) + _fileExt;
string _virtualPath = "/UploadFiles/scheNoticeXls/";
string _physicalPath = HttpContext.Server.MapPath(_virtualPath);
if (!Directory.Exists(_physicalPath))
{
Directory.CreateDirectory(_physicalPath);
}
string _fullPath = _physicalPath + _fileName;
_uploadFiles.SaveAs(_fullPath);
DataTable _employeeData = JNyuluUtils.ImportExcel(_fullPath);
int _i = 0;
StringBuilder _result = new StringBuilder();
_result.AppendLine("上传路径为：" + _virtualPath + _fileName);
_result.AppendLine("Excel解析日志记录：");
foreach (DataRow dr in _employeeData.Rows)
{
try
{
//dr["电话"] dr["姓名"] dr["内容"]
string _userName = dr["电话"].ToString() + "";
string _trueName = dr["姓名"].ToString() + "";
string _context = dr["内容"].ToString() + "";
if (!string.IsNullOrEmpty(_userName) && !string.IsNullOrEmpty(_trueName) && !string.IsNullOrEmpty(_context))
{
ScheNotice _scheNotice = new ScheNotice();
_scheNotice.UserName = _userName;
_scheNotice.TrueName = _trueName;
_scheNotice.Context = _context;
{
_code = _scheNoticeService.InsertScheNotice(_scheNotice);
}
if (_code > 0)
{
LogHelper.Info("记录[" + _i + "]导入成功");
_result.AppendLine("记录[" + _i + "]导入成功");
}
_code = _scheNotice.ID;
}
}
catch (Exception ex)
{
_result.AppendLine(ex.ToString());
LogHelper.Error(ex.ToString());
continue;
}
_i++;
}
_message = _result.ToString();
}
}
catch (Exception ex)
{
_code = -1;
_message = ex.Message;
}
finally
{
RenderText("{code: " + _code + ",message: \"" + _message.Replace(@"\", @"\\") + "\"}");
CancelLayout();
}
}
public void PostImportExcel()
{
string _fileExt = string.Empty;
int _code = 0;
string _message = string.Empty;
try
{
HttpPostedFile _uploadFiles = Request.Files["uploadFile"] as HttpPostedFile;
if (_uploadFiles == null || _uploadFiles.FileName.Length < 3)
{
_message = "您没有选择要上传的文件！";
_code = -4;
}
else
{
_fileExt = Path.GetExtension(_uploadFiles.FileName).ToLower(); //获取文件扩展名
String[] _allowedExt = { ".xls", ".xlsx" }; //允许上传的文件格式
if (!_allowedExt.Contains(_fileExt))
{
_message = "您上传的格式为" + _fileExt + ", 本统只接受扩展名为" + string.Join("、", _allowedExt) + "格式文件";
_code = -3;
}
else if (_uploadFiles.ContentLength == 0)
{
_message = "上传的内容为空！";
_code = -2;
}
else if (_uploadFiles.ContentLength > 1024 * 1024 * 8)
{
_message = "您上传的文件超过了8M！";
_code = -1;
}
}
if (_code == 0)
{
string _fileName = ShortFileNameUtil.ShortFileName(Guid.NewGuid().ToString()) + _fileExt;
string _virtualPath = "/UploadFiles/reportCardXls/";
string _physicalPath = HttpContext.Server.MapPath(_virtualPath);
if (!Directory.Exists(_physicalPath))
{
Directory.CreateDirectory(_physicalPath);
}
string _fullPath = _physicalPath + _fileName;
_uploadFiles.SaveAs(_fullPath);
DataTable _employeeData = JNyuluUtils.ImportExcel(_fullPath);
int _i = 0;
StringBuilder _result = new StringBuilder();
_result.AppendLine("上传路径为：" + _virtualPath + _fileName);
_result.AppendLine("导入记录数为:" + _employeeData.Rows.Count + " , Excel解析日志记录：");
foreach (DataRow dr in _employeeData.Rows)
{
_i++;
try
{
//dr["班级"] dr["学籍号"] dr["学生姓名"] dr["考试时间"] dr["试卷路径"];
string _name = dr["学籍号"].ToString() + "";
Employee _employee = _employeeService.GetEmployeeByName(_name);
if (_employee == null)
{
LogHelper.Info("记录[" + _i + "]学籍:" + _name + " 不存在");
_result.AppendLine("记录[" + _i + "]学籍:" + _name + " 不存在");
continue;
}
string _schoolTermName = dr["班级"].ToString() + "";
SchoolTerm _schoolTerm = _schoolTermService.GetBaseSchoolTermByName(_schoolTermName);
if (_schoolTerm == null)
{
LogHelper.Info("记录[" + _i + "]班级:" + _schoolTermName + " 不存在");
_result.AppendLine("记录[" + _i + "]班级:" + _schoolTermName + " 不存在");
continue;
}
_result.AppendLine("记录[" + _i + "] employeeID:[" + _employee.ID + "] 班级ID:[" + _schoolTerm.ID + "]");
if (_employee.ID > 0 && _schoolTerm.ID > 0)
{
ReportCard _reportCard = new ReportCard();
_reportCard.EmployeeID = _employee.ID;
_reportCard.STID = _schoolTerm.ID;
DateTime _examDate = DateTime.Today;
if (DateTime.TryParse(dr["考试时间"].ToString() + "", out _examDate))
{
_reportCard.ExamDate = _examDate;
}
else
{
LogHelper.Info("记录[" + _i + "]考试时间格式错误");
_result.AppendLine("记录[" + _i + "]考试时间格式错误");
continue;
}
string _testPaper = dr["试卷路径"].ToString() + "";
if (!string.IsNullOrEmpty(_testPaper))
{
_reportCard.TestPaperUrl = "/UploadFiles/testPaperFiles/" + _testPaper;
}
IDictionary _hash = new Hashtable();
_hash.Add("EmployeeID", _reportCard.EmployeeID);
_hash.Add("STID", _reportCard.STID);
_hash.Add("TestPaperUrl", _reportCard.TestPaperUrl);
IList <ReportCard> _reportCardList = _reportCardService.GetReportCard(_hash);
_result.AppendLine("记录[" + _i + "](" + _reportCard.TestPaperUrl + ") _reportCardList.Count:" + _reportCardList.Count);
if (_reportCardList.Count > 0)
{
_reportCard.ID = _reportCardList[0].ID;
_code = _reportCardService.UpdateReportCard(_reportCard);
}
else
{
_reportCard.ID = _reportCardService.InsertReportCard(_reportCard);
}
_result.AppendLine("记录[" + _i + "] _reportCard.ID:" + _reportCard.ID);
_code = _reportCard.ID;
}
}
catch (Exception ex)
{
_result.AppendLine(ex.ToString());
LogHelper.Error(ex.ToString());
continue;
}
}
_message = _result.ToString();
}
}
catch (Exception ex)
{
_code = -1;
_message = ex.Message;
}
finally
{
RenderText("{code: " + _code + ",message: \"" + _message.Replace(@"\", @"\\") + "\"}");
CancelLayout();
}
}
public void PostImportExcel()
{
string _fileExt = string.Empty;
int _code = 0;
string _message = string.Empty;
try
{
HttpPostedFile _uploadFiles = Request.Files["uploadFile"] as HttpPostedFile;
if (_uploadFiles == null || _uploadFiles.FileName.Length < 3)
{
_message = "您没有选择要上传的文件！";
_code = -4;
}
else
{
_fileExt = Path.GetExtension(_uploadFiles.FileName).ToLower(); //获取文件扩展名
String[] _allowedExt = { ".xls", ".xlsx" }; //允许上传的文件格式
if (!_allowedExt.Contains(_fileExt))
{
_message = "您上传的格式为" + _fileExt + ", 本统只接受扩展名为" + string.Join("、", _allowedExt) + "格式文件";
_code = -3;
}
else if (_uploadFiles.ContentLength == 0)
{
_message = "上传的内容为空！";
_code = -2;
}
else if (_uploadFiles.ContentLength > 1024 * 1024 * 8)
{
_message = "您上传的文件超过了8M！";
_code = -1;
}
}
if (_code == 0)
{
string _fileName = ShortFileNameUtil.ShortFileName(Guid.NewGuid().ToString()) + _fileExt;
string _virtualPath = "/UploadFiles/employeeXls/";
string _physicalPath = HttpContext.Server.MapPath(_virtualPath);
if (!Directory.Exists(_physicalPath))
{
Directory.CreateDirectory(_physicalPath);
}
string _fullPath = _physicalPath + _fileName;
_uploadFiles.SaveAs(_fullPath);
DataTable _employeeData = JNyuluUtils.ImportExcel(_fullPath);
int _i = 0;
StringBuilder _result = new StringBuilder();
_result.AppendLine("上传路径为：" + _virtualPath + _fileName);
_result.AppendLine("Excel解析日志记录：");
foreach (DataRow dr in _employeeData.Rows)
{
_i++;
try
{
//["学籍号"] dr["学生姓名"] dr["家长手机"] dr["家庭电话"] dr["备注"]
string _name = dr["学籍号"].ToString() + "";
if (!string.IsNullOrEmpty(_name))
{
Employee _employee = _employeeService.GetEmployeeByName(_name);
if (_employee == null)
{
_employee = new Employee();
_employee.UserType = 0;
_employee.Name = _name;
_employee.TrueName = dr["学生姓名"].ToString() + "";
string _phone = dr["家庭电话"].ToString() + "";
if (_phone.IndexOf("e+") > 0)
{
_phone = (double.Parse(_phone)).ToString();
}
_employee.Phone = _phone;
LogHelper.Info(dr["家长手机"].GetType().ToString() + " " + dr["家长手机"]);
string _mobile = dr["家长手机"].ToString() + "";
if (_mobile.IndexOf("e+") > 0)
{
_mobile = (double.Parse(_mobile)).ToString();
}
_employee.Mobile = _mobile;
_employee.PassWord = _mobile; //初始密码设为用户的手机号
_employee.Permission = 0;
_employee.ID = _employeeService.InsertEmployee(_employee);
}
}
else
{
LogHelper.Error("记录[" + _i + "] 中的学籍号不能为空");
_result.AppendLine("记录[" + _i + "] 中的学籍号不能为空");
}
}
catch (Exception ex)
{
LogHelper.Error("记录[" + _i + "]导入出错 " + ex.ToString());
_result.AppendLine("记录[" + _i + "]导入出错 " + ex.ToString());
continue;
}
_i++;
}
_message = _result.ToString();
}
}
catch (Exception ex)
{
_code = -1;
_message = ex.Message;
}
finally
{
RenderText("{code: " + _code + ",message: \"" + _message.Replace(@"\", @"\\") + "\"}");
CancelLayout();
}
}
