//
// POST: /SortingLowerLimit/Delete/
public ActionResult Delete(string id)
{
bool bResult = SortingLowerlimitService.Delete(id);
string msg = bResult ? "删除成功" : "删除失败";
return(Json(JsonMessageHelper.getJsonMessage(bResult, msg, null), "text", JsonRequestBehavior.AllowGet));
}
//
// POST: /SortingLowerLimit/Edit/
public ActionResult Edit(SortingLowerlimit sortLowerlimin)
{
bool bResult = SortingLowerlimitService.Save(sortLowerlimin);
string msg = bResult ? "修改成功" : "修改失败";
return(Json(JsonMessageHelper.getJsonMessage(bResult, msg, null), "text", JsonRequestBehavior.AllowGet));
}
public FileStreamResult CreateExcelToClient()
{
int page = 0, rows = 0;
string sortingLineCode = Request.QueryString["sortingLineCode"];
string sortingLineName = Request.QueryString["sortingLineName"];
string productName = Request.QueryString["productName"];
string productCode = Request.QueryString["productCode"];
string isActive = Request.QueryString["IsActive"];
System.Data.DataTable dt = SortingLowerlimitService.GetSortingLowerlimit(page, rows, sortingLineCode, sortingLineName, productName, productCode, isActive);
string headText = "备货区下限设置";
string headFont = "微软雅黑"; Int16 headSize = 20;
string colHeadFont = "Arial"; Int16 colHeadSize = 10;
string[] HeaderFooder =
{
"……" //眉左
, "……" //眉中
, "……" //眉右
, "&D" //脚左 日期
, "……" //脚中
, "&P" //脚右 页码
};
System.IO.MemoryStream ms = THOK.Common.ExportExcel.ExportDT(dt, null, headText, null, headFont, headSize
, 0, true, colHeadFont, colHeadSize, 0, true, 0, HeaderFooder, null, 0);
return(new FileStreamResult(ms, "application/ms-excel"));
}
//
// GET: /SortingLowerLimit/Details/
public ActionResult Details(int page, int rows, FormCollection collection)
{
string sortingLineCode = collection["sortingLineCode"] ?? "";
string productCode = collection["productCode"] ?? "";
string sortingLineName = collection["sortingLineName"] ?? "";
string productName = collection["productName"] ?? "";
string IsActive = collection["IsActive"] ?? "";
var sortOrder = SortingLowerlimitService.GetDetails(page, rows, sortingLineCode, sortingLineName, productName, productCode, IsActive);
return(Json(sortOrder, "text", JsonRequestBehavior.AllowGet));
}
public FileStreamResult CreateExcelToClient()
{
int page = 0, rows = 0;
string sortingLineCode = Request.QueryString["sortingLineCode"];
string sortingLineName = Request.QueryString["sortingLineName"];
string productName = Request.QueryString["productName"];
string productCode = Request.QueryString["productCode"];
string isActive = Request.QueryString["IsActive"];
ExportParam ep = new ExportParam();
ep.DT1 = SortingLowerlimitService.GetSortingLowerlimit(page, rows, sortingLineCode, sortingLineName, productName, productCode, isActive);
ep.HeadTitle1 = "备货区下限设置";
return(PrintService.Print(ep));
}
