public bool creatall(ref ValidationErrors errors, JOBTestScoreModel model)
{
try
{
JOBTestScore entity = m_Rep.GetById(model.Id);
if (entity != null)
{
errors.Add(Suggestion.PrimaryRepeat);
return(false);
}
entity = new JOBTestScore();
entity.Id = model.Id;
entity.Name = model.Name;
entity.Score = model.Score;
entity.StudentId = model.StudentId;
if (m_Rep.Create(entity))
{
return(true);
}
else
{
errors.Add(Suggestion.InsertFail);
return(false);
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHander.WriteException(ex);
return(false);
}
}
public virtual bool Edit(ref ValidationErrors errors, JOBTestScoreModel model)
{
try
{
JOBTestScore entity = m_Rep.GetById(model.Id);
if (entity == null)
{
errors.Add(Suggestion.Disable);
return(false);
}
entity.Id = model.Id;
entity.Name = model.Name;
entity.StudentId = model.StudentId;
entity.Score = model.Score;
if (m_Rep.Edit(entity))
{
return(true);
}
else
{
errors.Add(Suggestion.NoDataChange);
return(false);
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHander.WriteException(ex);
return(false);
}
}
public void upload()
{
Stream uploadStream = null;
FileStream fs = null;
try
{
//文件上传，一次上传1M的数据，防止出现大文件无法上传
//file为input中name的值
HttpPostedFileBase postFileBase = Request.Files["file"];
uploadStream = postFileBase.InputStream;
int bufferLen = 1024;
byte[] buffer = new byte[bufferLen];
int contentLen = 0;
string fileName = Path.GetFileName(postFileBase.FileName);
//string baseUrl = Server.MapPath("/");
string uploadPath = "E:\\test\\";
string time = DateTime.Now.ToString("yyyyMMdd_hhmm_ssffff");
fs = new FileStream(uploadPath + time + fileName, FileMode.Create, FileAccess.ReadWrite);
while ((contentLen = uploadStream.Read(buffer, 0, bufferLen)) != 0)
{
fs.Write(buffer, 0, bufferLen);
fs.Flush();
}
if (null != fs)
{
fs.Close();
}
if (null != uploadStream)
{
uploadStream.Close();
}
//ole读取excel
oleDBExcelFileReader ole = new oleDBExcelFileReader();
DataSet ds = ole.ExcelFileRead(uploadPath + time + fileName);
//DataSet ds = ole.ExcelFileRead("E:\\score.xlsx");
foreach (DataRow dr in ds.Tables[0].Rows)
{
JOBTestScoreModel temp = new JOBTestScoreModel();
temp.Name = dr[0].ToString();
temp.StudentId = dr[1].ToString();
temp.Score = dr[2].GetInt();
itestbll.Create(ref errors, temp);
}
}
catch (Exception ex)
{
}
}
public virtual JOBTestScoreModel GetById(string id)
{
if (IsExists(id))
{
JOBTestScore entity = m_Rep.GetById(id);
JOBTestScoreModel model = new JOBTestScoreModel();
model.Id = entity.Id;
model.Name = entity.Name;
model.StudentId = entity.StudentId;
model.Score = entity.Score;
return(model);
}
else
{
return(null);
}
}
