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); }