/// <summary>
/// 导出
/// </summary>
private void btnExportData_Click(object sender, System.EventArgs e)
{
try
{
if (Request["RadioGroup"] == null || Request["RadioGroup"].Length < 0)
{
this.ShowMsg("请选择要导出数据", false);
return;
}
PurchaseOrderItemQuery purchaseOrderItemQuery = new PurchaseOrderItemQuery
{
PageSize = 9999999,
PageIndex = 1,
SortOrder = SortAction.Desc,
SortBy = "CreateTime",
POId = int.Parse(Request["RadioGroup"].ToString())
};
DbQueryResult purchaseOrder = PurchaseOrderHelper.GetPurchaseOrderItemList(purchaseOrderItemQuery);
System.Data.DataTable dtPO = purchaseOrder.Data as DataTable;
if (dtPO != null && dtPO.Rows.Count > 0)
{
GetExcelReport(dtPO, Globals.MapPath("/config/ProductListTemplate.xls"));
}
else
{
this.ShowMsg("未查询到数据", false);
}
}
catch (Exception ex)
{
this.ShowMsg("导出失败" + ex.Message, false);
}
}
/// <summary>
/// 初始化绑定商品数据
/// </summary>
/// <param name="sortBy"></param>
/// <param name="sortOrder"></param>
private void BindProducts(string sortBy, SortAction sortOrder)
{
this.LoadParameters();
PurchaseOrderItemQuery purchaseOrderItemQuery = new PurchaseOrderItemQuery
{
POId = this.POId,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortOrder = sortOrder,
SortBy = sortBy,
ProductName = this.productsName,
BarCode = this.barCode,
};
Globals.EntityCoding(purchaseOrderItemQuery, true);
DbQueryResult purchaseOrder = PurchaseOrderHelper.GetPurchaseOrderItemList(purchaseOrderItemQuery);
this.rpPOItem.DataSource = purchaseOrder.Data;
this.rpPOItem.DataBind();
//获取采购单总数量，采购单总金额（最上面或者最底下加整个明细的加总）
DataSet ds = PurchaseOrderHelper.GetPOTotalQuyAndAmount(this.POId);
//ExpectQuantity,OriginalCurrencyTotalPrice,TotalSalePrice
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
lblTotal.Text = string.Format("合计：采购单总数量：{0}; 采购单原币总金额：{1}; 采购单销售总金额：{2};", ds.Tables[0].Rows[0][0], ds.Tables[0].Rows[0][1], ds.Tables[0].Rows[0][2]);
}
this.pager1.TotalRecords = (this.pager.TotalRecords = purchaseOrder.TotalRecords);
}
/// <summary>
/// 获取采购订单明细
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static DbQueryResult GetPurchaseOrderItemList(PurchaseOrderItemQuery purchaseOrderItemQuery)
{
return(new PurchaseOrderDao().GetPurchaseOrderItemList(purchaseOrderItemQuery));
}
