/// <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));
}
