/// <summary>
/// FastReport報表
/// </summary>
/// <param name="orderID"></param>
/// <returns></returns>
public ActionResult FRPT_OrderItem(string orderID)
{
var data = new List <OrderItemExportEntity>();
var shop = ShopDataAccess.GetShopData(orderID);
var ShopInfo = $"店家：{shop.shopName} 店家電話：{shop.shopTEL}";
data = OrderItemDataAccess.GetExportList(orderID);
//var wr = new WebReport();
//wr.DesignReport = true;
//wr.DesignScriptCode = false;
//wr.Report.Load(Server.MapPath("~/Report/OrderItemList.frx"));
//wr.Width = 900;
//wr.Report.Dictionary.RegisterBusinessObject(data, "OrderItems", 1, true);
//wr.Report.Save(Server.MapPath("~/Report/OrderItemList.frx"));
//wr.Height = 800;
//wr.Report.RegisterData(data, "OrderItems");
//wr.Report.GetDataSource("OrderItems").Enabled = true;
//var db = wr.Report.FindObject("Data1") as DataBand;
//db.DataSource = wr.Report.GetDataSource("OrderItems");
//wr.Report.Dictionary.RegisterData(data, "OrderItems", true);
//(wr.Report.FindObject("Data1") as DataBand).DataSource = wr.Report.GetDataSource("OrderItems");
//wr.Report.SetParameterValue("ShopInfo", ShopInfo);
//ViewBag.WebReport = wr;
return(View());
}
/// <summary>
/// 取得所有使用者資料
/// </summary>
/// <returns></returns>
public ActionResult GetShopData(string sort, string order, int page, int rows, string shopName = null, string shopTEL = null)
{
var shops = ShopDataAccess.GetShopData(shopName, shopTEL);
var q = (order.ToUpper() == "ASC") ?
shops.OrderBy(x => x.shopName).ToList() :
shops.OrderByDescending(x => x.shopName).ToList();
var offset = rows * (page - 1);
q = q.Skip(offset).Take(rows).ToList();
var result = new { total = shops.Count, rows = q };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
var orderID = "75e81f79-07b5-4876-acd3-4fbc06e1bf6f";
var data = new List <OrderItemExportEntity>();
var shop = ShopDataAccess.GetShopData(orderID);
var ShopInfo = $"店家：{shop.shopName} 店家電話：{shop.shopTEL}";
data = OrderItemDataAccess.GetExportList(orderID);
var rpt = new XtraReport1();
rpt.Parameters["ShopInfo"].Value = ShopInfo;
rpt.DataSource = data;
return(View(rpt));
}
public void loadReport()
{
var orderID = "75e81f79-07b5-4876-acd3-4fbc06e1bf6f";
var data = new List <OrderItemExportEntity>();
var shop = ShopDataAccess.GetShopData(orderID);
var ShopInfo = $"店家：{shop.shopName} 店家電話：{shop.shopTEL}";
data = OrderItemDataAccess.GetExportList(orderID);
report1.Report.Load(@"D:\WorkingDir\LBOM\LBOM\Report\OrderItemList.frx");
report1.Report.Dictionary.RegisterBusinessObject(data, "OrderItems", 1, true);
report1.Report.SetParameterValue("ShopInfo", ShopInfo);
report1.Prepare(true);
report1.ShowPrepared();
}
/// <summary>
/// 取得店家資訊搜尋清單
/// </summary>
/// <param name="q"></param>
/// <returns></returns>
public ActionResult GetShopList(string q)
{
var shops = ShopDataAccess.GetShopData(shopName: q);
return(Json(shops, JsonRequestBehavior.AllowGet));
}
