public ActionResult SaveFormNorm(string keyValue, HseObserveNormEntity entity)
{
Operator user = OperatorProvider.Provider.Current();
try
{
if (entity.Id != keyValue)
{
entity.CREATEDATE = DateTime.Now;
entity.CREATEUSERDEPT = user.DeptName;
entity.CREATEUSERID = user.UserId;
entity.CREATEUSERNAME = user.UserName;
entity.CREATEUSERDEPTCODE = user.DeptCode;
entity.CREATEUSERORGCODE = user.OrganizeCode;
//entity.MODIFYDATE = DateTime.Now;
entity.MODIFYUSERID = user.UserId;
entity.MODIFYUSERNAME = user.UserName;
hseobservenormbll.SaveForm("", entity);
}
else
{
// entity.MODIFYDATE = DateTime.Now;
entity.MODIFYUSERID = user.UserId;
entity.MODIFYUSERNAME = user.UserName;
hseobservenormbll.SaveForm(entity.Id, entity);
}
return(Success("操作成功"));
}
catch (System.Exception ex)
{
return(Error(ex.Message));
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="keyValue"></param>
/// <param name="entity"></param>
public void SaveForm(string keyValue, HseObserveNormEntity entity)
{
service.SaveForm(keyValue, entity);
}
public string ImportCase()
{
Operator user = OperatorProvider.Provider.Current();
int error = 0;
string message = "请选择格式正确的文件再导入!";
string falseMessage = "";
int count = HttpContext.Request.Files.Count;
if (count > 0)
{
HttpPostedFileBase file = HttpContext.Request.Files[0];
if (string.IsNullOrEmpty(file.FileName))
{
return(message);
}
if (!(file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xls") || file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx")))
{
return(message);
}
string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName);
file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName));
DataTable dt = ExcelHelper.ExcelImport(Server.MapPath("~/Resource/temp/" + fileName));
Hashtable hast = new Hashtable();
List <HseObserveNormEntity> listEntity = new List <HseObserveNormEntity>();
HseObserveNormEntity Hse = new HseObserveNormEntity();
for (int i = 1; i < dt.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString()))
{
Hse = new HseObserveNormEntity();
Hse.Id = Guid.NewGuid().ToString();
Hse.CREATEDATE = DateTime.Now;
Hse.CREATEUSERDEPT = user.DeptName;
Hse.CREATEUSERID = user.UserId;
Hse.CREATEUSERNAME = user.UserName;
Hse.CREATEUSERDEPTCODE = user.DeptCode;
Hse.CREATEUSERORGCODE = user.OrganizeCode;
Hse.MODIFYDATE = DateTime.Now;
Hse.MODIFYUSERID = user.UserId;
Hse.MODIFYUSERNAME = user.UserName;
Hse.Name = dt.Rows[i][0].ToString();
Hse.Ocontent = dt.Rows[i][1].ToString();
listEntity.Add(Hse);
}
}
for (int j = 0; j < listEntity.Count; j++)
{
try
{
hseobservenormbll.SaveForm("", listEntity[j]);
}
catch (Exception ex)
{
error++;
}
}
count = listEntity.Count;
message = "共有" + count + "条记录,成功导入" + (count - error) + "条，失败" + error + "条";
message += "</br>" + falseMessage;
}
return(message);
}
