public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string billNo = Request.QueryString["billNo"]; System.Data.DataTable dt1 = InBillDetailService.GetInBillDetail(page, rows, billNo); System.Data.DataTable dt2 = InBillAllotService.AllotSearch(page, rows, billNo); string headText1 = "入库单据分配"; string headText2 = "入库单据分配明细"; string headFont = "微软雅黑"; Int16 headSize = 20; string colHeadFont = "Arial"; Int16 colHeadSize = 10; string[] HeaderFooder = { "……" //眉左 , "……" //眉中 , "……" //眉右 , "&D" //脚左 日期 , "……" //脚中 , "&P" //脚右 页码 }; System.IO.MemoryStream ms = THOK.Common.ExportExcel.ExportDT(dt1, dt2, headText1, headText2, headFont, headSize , 0, true, colHeadFont, colHeadSize, 0, true, 0, HeaderFooder, null, 0); return(new FileStreamResult(ms, "application/ms-excel")); }
public ActionResult AllotAdd(string billNo, long id, string cellCode, decimal allotQuantity) { string strResult = string.Empty; bool bResult = InBillAllotService.AllotAdd(billNo, id, cellCode, allotQuantity, out strResult); string msg = bResult ? "添加分配成功" : "添加分配失败"; return(Json(JsonMessageHelper.getJsonMessage(bResult, msg, strResult), "text", JsonRequestBehavior.AllowGet)); }
public ActionResult AllotCancel(string billNo) { string strResult = string.Empty; bool bResult = InBillAllotService.AllotCancel(billNo, out strResult); string msg = bResult ? "取消分配成功" : "取消分配失败"; return(Json(JsonMessageHelper.getJsonMessage(bResult, msg, strResult), "text", JsonRequestBehavior.AllowGet)); }
public ActionResult AllotDelete(string billNo, long id) { string strResult = string.Empty; bool bResult = InBillAllotService.AllotDelete(billNo, id, out strResult); string msg = bResult ? "删除分配明细成功" : "删除分配明细失败"; return(Json(JsonMessageHelper.getJsonMessage(bResult, msg, strResult), "text", JsonRequestBehavior.AllowGet)); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string billNo = Request.QueryString["billNo"]; ExportParam ep = new ExportParam(); ep.DT1 = InBillDetailService.GetInBillDetail(page, rows, billNo); ep.DT2 = InBillAllotService.AllotSearch(page, rows, billNo);; ep.HeadTitle1 = "入库单据分配"; ep.HeadTitle2 = "入库单据分配明细"; return(PrintService.Print(ep)); }
public ActionResult Search(string billNo, int page, int rows) { var result = InBillAllotService.Search(billNo, page, rows); return(Json(result, "text", JsonRequestBehavior.AllowGet)); }