/// <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());
}
public async Task GetAsync()
{
var handler = new OrderItemDataAccess(this.Context, Mapper());
var entity = OrderTestData.OrderItemDTO;
await handler.SaveAsync(entity);
var response = await handler.GetAsync(entity.Id);
Assert.IsTrue(response != null);
}
public async Task SaveAsync()
{
var handler = new OrderItemDataAccess(this.Context, Mapper());
var entity = OrderTestData.OrderItemDTO;
var result = await handler.SaveAsync(entity);
var outcome = result.Id != 0;
Assert.IsTrue(outcome);
}
public async Task GetAllAsync()
{
var handler = new OrderItemDataAccess(this.Context, Mapper());
var entity = OrderTestData.OrderItemDTO;
await handler.SaveAsync(entity);
var response = await handler.GetAllAsync();
var outcome = response.Count;
Assert.IsTrue(outcome == 1);
}
/// <summary>
/// 開啟報表檢視器
/// <para>若有明細就開啟，無資料則傳回錯誤</para>
/// </summary>
/// <param name="orderID"></param>
/// <returns></returns>
public ActionResult OpenReport(string orderID)
{
HttpStatusCodeResult status = null;
if (OrderItemDataAccess.IsOrderItemExist(orderID))
{
status = new HttpStatusCodeResult(HttpStatusCode.OK);
}
else
{
status = new HttpStatusCodeResult(HttpStatusCode.NotFound, "該訂單尚無訂購明細可匯出");
}
return(status);
}
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));
}
/// <summary>
/// 產生指定訂單編號的EXCEL匯出檔案
/// <para>本方法將會回傳狀態碼。</para>
/// <para>200：表示該訂單編號有資料可匯出，且已產生檔案存放在server端的Session["OrderItemExcel"]，請進一步呼叫ExportExcel動作以取回。</para>
/// <para>404：表示該訂單編號沒有資料可匯出。</para>
/// </summary>
/// <param name="orderID"></param>
/// <returns></returns>
public ActionResult GenExportExcel(string orderID)
{
HttpStatusCodeResult status = null;
if (!OrderItemDataAccess.IsOrderItemExist(orderID))
{
status = new HttpStatusCodeResult(HttpStatusCode.NotFound, "No ordr item data can be exported.");
}
else
{
status = new HttpStatusCodeResult(HttpStatusCode.OK);
//Session["OrderItemExcel"] = ExcelHelper.OrderItemListToExcelContent(orderID);
}
return(status);
}
public async Task UpdateAsync()
{
var handler = new OrderItemDataAccess(this.Context, Mapper());
var entity = OrderTestData.OrderItemDTO;
var originalOrderItem = entity;
await handler.SaveAsync(entity);
var productHandler = new ProductDataAccess(this.Context, Mapper());
var product = ProductTestData.ProductDTO;
await productHandler.SaveAsync(product);
entity.ProductId = product.Id;
var response = await handler.UpdateAsync(entity);
var outcome = response.ProductId.Equals(originalOrderItem.ProductId);
Assert.IsTrue(outcome);
}
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="orderItems"></param>
/// <returns></returns>
public ActionResult NewOrderItemDatas(List <OrderItemDataEntity> orderItems)
{
var isSuccess = true;
var errorMsg = string.Empty;
orderItems.ForEach(x =>
{
x.orderItemID = Guid.NewGuid().ToString();
x.orderItemLoginuserID = UserInfo.loginuserID;
});
try
{ OrderItemDataAccess.AddOrderItemData(orderItems); }
catch (Exception ex)
{
errorMsg = ex.Message.Replace("\n", "");
isSuccess = false;
}
return(Json(new { isSuccess = isSuccess, errorMsg = errorMsg }, JsonRequestBehavior.AllowGet));
}
