/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, ScoreSetEntity entity) { try { service.SaveForm(keyValue, entity); } catch (Exception) { throw; } }
public string ImportData() { Operator user = ERCHTMS.Code.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)); int order = 1; for (int i = 0; i < dt.Rows.Count; i++) { order = i; //积分项目 string itemname = dt.Rows[i][0].ToString(); //积分类型 string itemtype = dt.Rows[i][1].ToString(); //积分标准值(分/次) string score = dt.Rows[i][2].ToString(); try { var item = new ScoreSetEntity { ItemName = itemname, ItemType = itemtype, Score = int.Parse(score), DeptCode = user.DeptCode, IsAuto = 0 }; scoresetbll.SaveForm("", item); } catch { error++; } } count = dt.Rows.Count; message = "共有" + count + "条记录,成功导入" + (count - error) + "条,失败" + error + "条"; message += "</br>" + falseMessage; } return(message); }
public ActionResult Save(string keyValue, ScoreSetEntity entity) { scoresetbll.SaveForm(keyValue, entity); return(Success("操作成功。")); }