/// <summary> /// 列表 /// </summary> /// <param name="pageNum"></param> /// <param name="numPerPage"></param> /// <param name="model"></param> /// <returns></returns> public ActionResult Index(int?pageNum, int?numPerPage, Heat_shrinkf model) { int pageIndex = pageNum.HasValue ? pageNum.Value : 1; int pageSize = numPerPage.HasValue && numPerPage.Value > 0 ? numPerPage.Value : 20; int recordCount = 0; //(q) => q.id,排序的字段 Expression <Func <Heat_shrinkf, bool> > wherelambad = u => 1 == 1;//查询条件; if (model.HS_InTime != null && model.HS_InTime.ToString() != "0001-01-01 00:00:00") { wherelambad = wherelambad = u => u.HS_InTime == model.HS_InTime;//模糊查找 } if (!string.IsNullOrWhiteSpace(model.HS_Pstandard)) { wherelambad = wherelambad.And(u => u.HS_Pstandard == model.HS_Pstandard); } //true,升序,false降序 var data = Bll.GetPageEntities <DateTime>(pageIndex, pageSize, out recordCount, wherelambad, (q) => q.CreateTime, false); ViewData["pageIndex"] = pageIndex; ViewData["pageSize"] = pageSize; ViewData["recordCount"] = recordCount; ViewData["HS_InTime"] = model.HS_InTime != null && model.HS_InTime.ToString() != "0001-01-01 00:00:00" ? model.HS_InTime.ToString() : ""; ViewData["HS_Pstandard"] = model.HS_Pstandard; var list = data.ToList(); return(View(list)); }
/// <summary> /// 新增和编辑数据验证 /// </summary> /// <returns></returns> public ActionResult CheckAdd(Heat_shrinkf model) { string otype = model != null && model.ID == 0 ? "add" : "update"; var result = 0; Expression <Func <Heat_shrinkf, bool> > wherelambad = u => 1 == 1;//查询条件; if (otype == "add") { model.CreateTime = model.UpdateTime = DateTime.Now; model.CreateUser = model.UpdateUser = 1; result = Bll.Add(model); } else { model.UpdateTime = DateTime.Now; result = Bll.Update(model); } if (result != 0) { string msg = CommonMsg.SuccessAlert(200, "操作成功 ! ", "Heat_shrinkf", callbackType: "closeCurrent"); return(Content(msg)); } else { return(Content(CommonMsg.ErrorAlert(300, "操作失败"))); } }
/// <summary> /// 导出数据 /// </summary> /// <param name="OID"></param> public ActionResult ExportUserinfo(Heat_shrinkf model) { string ReturnMsg = ""; Expression <Func <Heat_shrinkf, bool> > wherelambad = u => 1 == 1;//查询条件; if (model.HS_InTime != null) { wherelambad = wherelambad = u => u.HS_InTime == model.HS_InTime; } if (!string.IsNullOrWhiteSpace(model.HS_Pstandard)) { wherelambad = wherelambad.And(u => u.HS_Pstandard == model.HS_Pstandard);// 多个条件使用and连接 } var Userdata = Bll.GetEntitysByStrwhere(wherelambad).ToList(); string[] FileData = null; if (Userdata != null) { if (ExportOrderAllToExcel(Userdata, ref ReturnMsg)) { FileData = ReturnMsg.Split(','); if (FileData != null && FileData.Length > 0) { string FilePath = FileData[1] != null ? FileData[1].ToString() : ""; if (System.IO.File.Exists(Server.MapPath(FilePath))) { return(File(Server.MapPath(FilePath), "application/octet-stream", DateTime.Now.ToString("yyyyMMddHHmmssfff") + "." + "xls")); } else { return(Content("该文件已丢失")); } } } else { FileData = ReturnMsg.Split(','); string FailMsg = ""; if (FileData != null && FileData.Length > 0) { FailMsg = FileData[1].ToString(); } return(Content(FailMsg)); } } return(Content("下载异常")); }
public int Update(Heat_shrinkf model) { return(Dal.Update(model)); }
public int Add(Heat_shrinkf model) { return(Dal.Add(model)); }