public FileResult ExportExcel(int page,int rows)//导出execl { //int page = int.Parse(Request["page"].ToString()); //int rows = int.Parse(Request["rows"].ToString()); int total = 0; string OrderNoOrGoodsCode = Request["txtOrdSubjectCode"]; string GoodsName = Request["txtGoodsName"]; DateTime CheckTimeS = Convert.ToDateTime( Request["CheckTimeS"]); DateTime CheckTimeE = Convert.ToDateTime(Request["CheckTimeE"]); VenderUser model = (VenderUser)Session["UserInfo"]; string where = " ph.flag in(20 ,40,90,100) "; //管理员测试数据放开 if (model.VUSERCODE != "system") { where += " and ph.venderid=" + model.VENDERID; } if (!string.IsNullOrEmpty(OrderNoOrGoodsCode)) { where += " and ph.sheetid='" + OrderNoOrGoodsCode + "'"; } if (!string.IsNullOrEmpty(GoodsName)) { where += " and gd.goodsname='" + GoodsName + "'"; } if (CheckTimeS != null) { where += " and ph.CheckDate> to_date('" + CheckTimeS + "','yyyy-mm-dd hh24:mi:ss')"; } if (CheckTimeE != null) { where += " and ph.CheckDate< to_date('" + CheckTimeE + "','yyyy-mm-dd hh24:mi:ss')"; } BPurchase ogc = new BPurchase(); List<Purchase> list = ogc.GetPurchaseList(page, rows, out total, where); var sbHtml = new StringBuilder(); sbHtml.Append("<table border='1' cellspacing='0' cellpadding='0'>"); sbHtml.Append("<tr>"); var lstTitle = new List<string> { "订单号", "商品编码", "商品名称", "规格", "单位", "包装层次", "包装单位", "包装数量", "包装整件数", "零数", "订货数量", "收货数量", "整件单价", "单价", "金额", "订单状态","下单时间", "制单人", "供应商", "备注" }; foreach (var item in lstTitle) { sbHtml.AppendFormat("<td style='font-size: 14px;text-align:center;background-color: #DCE0E2; font-weight:bold;' height='25'>{0}</td>", item); } sbHtml.Append("</tr>"); for (int i = 0; i < list.Count(); i++) { sbHtml.Append("<tr>"); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].SHEETID); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].GoodsCode); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].GOODSNAME); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].GoodsSpec); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].UnitName); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].PkgClassName); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].PkgUnitName); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].PkgNumber); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].PkgQty); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].BulkQty); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].QTY); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].RealQty); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].PkgCost); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].Cost); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].CostValue); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", FormatFlag(list[i].FLAG)); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].CheckDate); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].EDITOR); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].VenderName); sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", list[i].Remark); sbHtml.Append("</tr>"); } sbHtml.Append("</table>"); //第一种:使用FileContentResult byte[] fileContents = Encoding.Default.GetBytes(sbHtml.ToString()); return File(fileContents, "application/ms-excel", "fileContents.xls"); ////第二种:使用FileStreamResult //var fileStream = new MemoryStream(fileContents); //return File(fileStream, "application/ms-excel", "fileStream.xls"); ////第三种:使用FilePathResult ////服务器上首先必须要有这个Excel文件,然会通过Server.MapPath获取路径返回. //var fileName = Server.MapPath("~/Files/fileName.xls"); //return File(fileName, "application/ms-excel", "fileName.xls"); }
/// <summary> /// 查询 /// </summary> /// <param name="OrderNoOrGoodsCode"></param> /// <param name="GoodsName"></param> /// <param name="CheckTimeS"></param> /// <param name="CheckTimeE"></param> /// <returns></returns> public JsonResult Query(string OrderNoOrGoodsCode, string GoodsName, DateTime CheckTimeS, DateTime CheckTimeE) { int page = int.Parse(Request["page"].ToString()); int rows = int.Parse(Request["rows"].ToString()); int total = 0; VenderUser model = (VenderUser)Session["UserInfo"]; string where = " ph.flag in(20 ,40,90,100) "; //管理员测试数据放开 if (model.VUSERCODE != "system") { where += " and ph.venderid=" + model.VENDERID; } if (!string.IsNullOrEmpty(OrderNoOrGoodsCode)) { where += " and ph.sheetid='" + OrderNoOrGoodsCode + "'"; } if (!string.IsNullOrEmpty(GoodsName)) { where += " and gd.goodsname='" + GoodsName + "'"; } if (CheckTimeS != null) { where += " and ph.CheckDate> to_date('" + CheckTimeS + "','yyyy-mm-dd hh24:mi:ss')"; } if (CheckTimeE != null) { where += " and ph.CheckDate< to_date('" + CheckTimeE + "','yyyy-mm-dd hh24:mi:ss')"; } BPurchase ogc = new BPurchase(); var result = ogc.GetPurchaseList(page, rows, out total,where); Dictionary<string, object> json = new Dictionary<string, object>(); json.Add("total", total); json.Add("rows", result); return Json(json, JsonRequestBehavior.AllowGet); }