void barBtnExportXls_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var vw =new FASControls.Views.ExportDataView();
vw.ExportDataTable("exec P_ERP_ExpProPrice");
}
private void btnCtl2_Click(object sender, EventArgs e)
{
string ware = string.Empty;
var ds = Ultra.FASControls.BusControls.WareHouseGridEdit.GetNotVirtualWare();
if (null != ds && ds.Count < 2 && ds.Count > 0)
{
ware = ds.FirstOrDefault().WareName;
}
else
{
var vw = new Ultra.FASControls.Views.ChoseWareView();
if (vw.ShowDialog() == System.Windows.Forms.DialogResult.OK)
ware = vw.WareName;
}
var ets = SerNoCaller.Calr_Inventory.Get(" where WareName = @0 ", ware);
Dictionary<string, string> dic = new Dictionary<string, string> {
{UltraDbEntity.T_ERP_Inventory.Meta_WareName,"仓库"}
,{UltraDbEntity.T_ERP_Inventory.Meta_AreaName,"区域"}
,{UltraDbEntity.T_ERP_Inventory.Meta_LocName,"库位"}
,{UltraDbEntity.T_ERP_Inventory.Meta_OuterIid,"商品编码"}
,{UltraDbEntity.T_ERP_Inventory.Meta_OuterSkuId,"规格编码"}
,{UltraDbEntity.T_ERP_Inventory.Meta_ItemName,"商品"}
,{UltraDbEntity.T_ERP_Inventory.Meta_SkuProperties,"规格"}
,{UltraDbEntity.T_ERP_Inventory.Meta_Qty,"原库存数"}
,{UltraDbEntity.T_ERP_Inventory.Meta_Remark,"盘点数"}
};
Ultra.FASControls.Views.ExportDataView evw = new FASControls.Views.ExportDataView();
evw.Export<UltraDbEntity.T_ERP_Inventory>(ets, dic);
}
