public ucPopopKeHoachCT(ref List <TDVM_KHE_UOC> _objDanhSach, TDVM_KHE_UOC objKheUoc, TDVM_KHE_UOC_DSACH objKUOCVMDS)
: this()
{
System.Linq.Expressions.Expression <Func <TDVM_KHE_UOC, decimal?> > expressionKHGoc = kh => (kh.DSACH_KHOACHVM_CTIET.Sum(ds => ds.KH_TRA_GOC.GetValueOrDefault(0)));
GridViewExpressionColumn column = this.radDanhSachKheUoc.Columns["TongTienGoc"] as GridViewExpressionColumn;
column.Expression = expressionKHGoc;
System.Linq.Expressions.Expression <Func <TDVM_KHE_UOC, decimal?> > expressionKHLai = kh => (kh.DSACH_KHOACHVM_CTIET.Sum(ds => ds.KH_TRA_LAI.GetValueOrDefault(0)));
column = this.radDanhSachKheUoc.Columns["TongTienLai"] as GridViewExpressionColumn;
column.Expression = expressionKHLai;
System.Linq.Expressions.Expression <Func <TD_KHOACHVM_CT, decimal?> > expressionKH = kh => (kh.KH_TRA_GOC.IsNullOrEmpty() && kh.KH_TRA_LAI.IsNullOrEmpty() && kh.KH_TRA_PHI.IsNullOrEmpty() ? null : (decimal?)kh.KH_TRA_GOC.GetValueOrDefault(0) + kh.KH_TRA_LAI.GetValueOrDefault(0) + kh.KH_TRA_PHI.GetValueOrDefault(0));
column = this.raddgrLichTraNo.Columns["Cong"] as GridViewExpressionColumn;
column.Expression = expressionKH;
column = this.raddgrThucTraNo.Columns["CongKH"] as GridViewExpressionColumn;
column.Expression = expressionKH;
System.Linq.Expressions.Expression <Func <TD_KHOACHVM_CT, decimal?> > expressionTTTT = kh => (kh.TT_TRA_GOC.IsNullOrEmpty() && kh.TT_TRA_LAI.IsNullOrEmpty() && kh.TT_TRA_PHI.IsNullOrEmpty() ? null : (decimal?)kh.TT_TRA_GOC.GetValueOrDefault(0) + kh.TT_TRA_LAI.GetValueOrDefault(0) + kh.TT_TRA_PHI.GetValueOrDefault(0));
column = this.raddgrThucTraNo.Columns["CongTT"] as GridViewExpressionColumn;
column.Expression = expressionTTTT;
radDanhSachKheUoc.ItemsSource = null;
objDanhSach = _objDanhSach;
radDanhSachKheUoc.ItemsSource = objDanhSach;
KUOCVMDS = objKUOCVMDS;
if (!LObject.IsNullOrEmpty(objKheUoc))
{
_TDVMKHEUOC = objKheUoc;
raddgrThongTinLapLich.ItemsSource = _TDVMKHEUOC.DSACH_KHOACHVM;
raddgrLichTraNo.ItemsSource = _TDVMKHEUOC.DSACH_KHOACHVM_CTIET;
raddgrThucTraNo.ItemsSource = _TDVMKHEUOC.DSACH_KHOACHVM_CTIET;
}
}
private void RadGridView1_RowDetailsVisibilityChanged(object sender, Telerik.Windows.Controls.GridView.GridViewRowDetailsEventArgs e)
{
if (e.DetailsElement != null && e.Visibility == Visibility.Visible)
{
var item = (DeliverySearchEntity)e.Row.Item;
var gv = (RadGridView)e.DetailsElement;
if (gv.Tag == null)
{
gv.Tag = new object();
SysProcessView.UIHelper.TransferSizeToHorizontal(gv);
GridViewExpressionColumn expColumn = gv.Columns["colDiscountPrice"] as GridViewExpressionColumn;
expColumn.Expression = _expression;
}
//var sizeCol = gv.Columns.FirstOrDefault<Telerik.Windows.Controls.GridViewColumn>(o => o.Header.ToString() == "尺码");
//if (sizeCol != null)
//{
// int index = gv.Columns.IndexOf(sizeCol);
// gv.Columns.RemoveAt(index);
// foreach (var size in VMGlobal.Sizes)
// {
// var col = new GridViewDataColumn() { Header = size.Name, UniqueName = size.Name, DataMemberBinding = new Binding(size.Name) };
// gv.Columns.Insert(index, col);
// index++;
// }
//}
gv.ItemsSource = new BillReportHelper().TransferSizeToHorizontal <DistributionProductShow>(item.Details, propertyNamesForSum: new string[] { "Quantity", "SettlementPrice" });
//gv.ItemsSource = item.Details;
}
}
public DeliveryAggregation()
{
InitializeComponent();
SysProcessView.UIHelper.TransferSizeToHorizontal(RadGridView1);
Expression <Func <DataRow, decimal> > expression = prod => (decimal)prod["Price"] * (int)prod["Quantity"];
GridViewExpressionColumn expColumn = RadGridView1.Columns["colPriceSubTotal"] as GridViewExpressionColumn;
expColumn.Expression = expression;
}
public CONSQLView(IUnityContainer container, FormWindow window)
{
InitializeComponent();
ViewModel = new CONSQLViewModel(container, this);
ViewModel.Window = window;
Expression <Func <CONSQLSend, string> > expression = parm => parm.CONIntegratorConfiguration != null ? "Nro Conección: " + parm.CONIntegratorConfiguration.ConnectionNumber + " Servidor: " + parm.CONIntegratorConfiguration.Connection.Service + " DB: " + parm.CONIntegratorConfiguration.Connection.DB + " Usuario: " + parm.CONIntegratorConfiguration.Connection.Login :null;
GridViewExpressionColumn column = this.IntegratorConfigurationsGrid.Columns["ValueConnection"] as GridViewExpressionColumn;
column.Expression = expression;
}
public ShopProfit()
{
this.DataContext = _dataContext;
InitializeComponent();
this.TransferExpenseToHorizontal(RadGridView1);
Expression <Func <DataRow, decimal> > expression = prod => (decimal)prod["SaleMoney"] / (int)prod["SaleQuantity"];
GridViewExpressionColumn expColumn = RadGridView1.Columns["colAverage"] as GridViewExpressionColumn;
expColumn.Expression = expression;
}
public SubordinateGoodReturnAggregation()
{
this.DataContext = new SubordinateGoodReturnAggregationVM();
InitializeComponent();
SysProcessView.UIHelper.TransferSizeToHorizontal(RadGridView1);
Expression <Func <DataRow, decimal> > expression = prod => (decimal)prod["Price"] * (int)prod["Quantity"];
GridViewExpressionColumn expColumn = RadGridView1.Columns["colPriceSubTotal"] as GridViewExpressionColumn;
expColumn.Expression = expression;
}
public SubordinateOrderAggregationNew()
{
this.DataContext = _dataContext;
InitializeComponent();
SysProcessView.UIHelper.TransferSizeToHorizontal(RadGridView1);
Expression <Func <DataRow, decimal> > expression = prod => (decimal)prod["Price"] * (int)prod["Quantity"];
GridViewExpressionColumn colPriceSubTotal = RadGridView1.Columns["colPriceSubTotal"] as GridViewExpressionColumn;
colPriceSubTotal.Expression = expression;
}
public OrdersView()
{
InitializeComponent();
Expression <Func <Order, double> > expression = order => (from orderDetail in order.Details
select orderDetail.Quantity * orderDetail.UnitPrice *
(1 - orderDetail.Discount)).Sum();
GridViewExpressionColumn column = this.RadGridView1.Columns["TotalValue"] as GridViewExpressionColumn;
column.Expression = expression;
}
public RetailAggregation()
{
InitializeComponent();
SysProcessView.UIHelper.TransferSizeToHorizontal(RadGridView1);
Expression <Func <DataRow, decimal> > expression = prod => (decimal)prod["Price"] * (int)prod["Quantity"];
GridViewExpressionColumn expColumn = RadGridView1.Columns["colPriceSubTotal"] as GridViewExpressionColumn;
expColumn.Expression = expression;
Expression <Func <DataRow, decimal> > expDiscount = prod => (decimal)prod["CostMoney"] / ((decimal)prod["Price"] * (int)prod["Quantity"]);
GridViewExpressionColumn colDiscount = RadGridView1.Columns["colDiscount"] as GridViewExpressionColumn;
colDiscount.Expression = expDiscount;
}
public StoringAggregation()
{
this.DataContext = new StoringAggregationVM();
InitializeComponent();
SysProcessView.UIHelper.TransferSizeToHorizontal(RadGridView1);
Expression <Func <DataRow, decimal> > expression = prod => (decimal)prod["Price"] * (int)prod["Quantity"];
GridViewExpressionColumn expColumn = RadGridView1.Columns["colPriceSubTotal"] as GridViewExpressionColumn;
expColumn.Expression = expression;
//var dateFilters = new CompositeFilterDescriptor();
//dateFilters.FilterDescriptors.Add(new FilterDescriptor("CreateTime", FilterOperator.IsGreaterThanOrEqualTo, FilterDescriptor.UnsetValue, false));
//dateFilters.FilterDescriptors.Add(new FilterDescriptor("CreateTime", FilterOperator.IsLessThanOrEqualTo, FilterDescriptor.UnsetValue, false));
//billFilter.FilterDescriptors.Add(dateFilters);
}
public CONErrorView(IUnityContainer container)
{
InitializeComponent();
ViewModel = new CONErrorViewModel(container, this);
Expression <Func <CONError, string> > expression = parm => parm != null?parm.RecordType.ToString() + parm.SubRecordType.ToString() + parm.Version.ToString() : null;
GridViewExpressionColumn column = this.CONErrorViewGrid.Columns["ValueVersion"] as GridViewExpressionColumn;
column.Expression = expression;
Expression <Func <CONError, string> > expressionRecord = parm => parm != null?parm.Record.Company.ToString() + "-" + parm.Record.OperationCenter.ToString() + "-" + parm.Record.DocumentType.ToString() + "-" + parm.Record.DocumentNumber.ToString() : null;
GridViewExpressionColumn columnRecord = this.CONErrorViewGrid.Columns["ValueDocument"] as GridViewExpressionColumn;
columnRecord.Expression = expressionRecord;
}
private void RadGridView1_RowDetailsVisibilityChanged(object sender, Telerik.Windows.Controls.GridView.GridViewRowDetailsEventArgs e)
{
if (e.DetailsElement != null && e.Visibility == Visibility.Visible)
{
var item = (BillGoodReturnForSearch)e.Row.Item;
var gv = (RadGridView)e.DetailsElement;
if (gv.Tag == null)
{
gv.Tag = new object();
SysProcessView.UIHelper.TransferSizeToHorizontal(gv);
GridViewExpressionColumn expColumn = gv.Columns["colDiscountPrice"] as GridViewExpressionColumn;
expColumn.Expression = _expressionPD;
expColumn = gv.Columns["colDiscountPriceQuantity"] as GridViewExpressionColumn;
expColumn.Expression = _expressionPDQ;
}
gv.ItemsSource = new BillReportHelper().TransferSizeToHorizontal <DistributionProductShow>(item.Details);
}
}
public CONSQLExecuteView(IUnityContainer container)
{
InitializeComponent();
ViewModel = new CONSQLExecuteViewModel(container, this);
Expression <Func <CONSQLParameter, string> > expression = parm => parm.DateValue != null?parm.DateValue.ToString()
: parm.DefaultDateValue != null?EasyApp.Current.ListDefaultDateValues.FirstOrDefault(x => x.Int32Value == parm.DefaultDateValue).Name
: parm.Int32Value != null?parm.Int32Value.ToString()
: parm.StringValue;
GridViewExpressionColumn column = this.ParameterGrid.Columns["Value"] as GridViewExpressionColumn;
column.Expression = expression;
Expression <Func <CONSQLSend, string> > expressionSend = parm => parm.CONIntegratorConfiguration != null ? "Nro Conección: " + parm.CONIntegratorConfiguration.ConnectionNumber + " Servidor: " + parm.CONIntegratorConfiguration.Connection.Service + " DB: " + parm.CONIntegratorConfiguration.Connection.DB + " Usuario: " + parm.CONIntegratorConfiguration.Connection.Login : null;
GridViewExpressionColumn columnSend = this.IntegratorConfigurationsGrid.Columns["ValueConnection"] as GridViewExpressionColumn;
columnSend.Expression = expressionSend;
}
public SelfGoodReturnAggregation()
{
InitializeComponent();
SysProcessView.UIHelper.TransferSizeToHorizontal(RadGridView1);
Expression <Func <DataRow, decimal> > expression = prod => (decimal)prod["Price"] * (int)prod["Quantity"];
GridViewExpressionColumn expColumn = RadGridView1.Columns["colPriceSubTotal"] as GridViewExpressionColumn;
expColumn.Expression = expression;
ItemPropertyDefinition[] billConditions = new[] {
new ItemPropertyDefinition {
DisplayName = "开单日期", PropertyName = "CreateTime", PropertyType = typeof(DateTime)
},
new ItemPropertyDefinition {
DisplayName = "退货品牌", PropertyName = "BrandID", PropertyType = typeof(int)
},
new ItemPropertyDefinition {
DisplayName = "款号", PropertyName = "StyleCode", PropertyType = typeof(string)
}
};
billFilter.ItemPropertyDefinitions.AddRange(billConditions);
var dateFilters = new CompositeFilterDescriptor();
dateFilters.FilterDescriptors.Add(new FilterDescriptor("CreateTime", FilterOperator.IsGreaterThanOrEqualTo, FilterDescriptor.UnsetValue, false));
dateFilters.FilterDescriptors.Add(new FilterDescriptor("CreateTime", FilterOperator.IsLessThanOrEqualTo, FilterDescriptor.UnsetValue, false));
billFilter.FilterDescriptors.Add(dateFilters);
billFilter.FilterDescriptors.Add(new FilterDescriptor("StyleCode", FilterOperator.Contains, FilterDescriptor.UnsetValue, false));
billFilter.ItemPropertyDefinitions.Add(new ItemPropertyDefinition {
DisplayName = "出货仓库", PropertyName = "StorageID", PropertyType = typeof(int)
});
billFilter.ItemPropertyDefinitions.Add(new ItemPropertyDefinition {
DisplayName = "状态", PropertyName = "Status", PropertyType = typeof(bool)
});
}
public BillPrintTemplate(string title, RadGridView gv, object item)
{
InitializeComponent();
if (string.IsNullOrEmpty(title))
{
title = "单据明细";
}
tbTitle.Text = title;
//View.Extension.UIHelper.DoEvents();//强制刷新UI
List <BillPrintHeaderItem> headerItems = new List <BillPrintHeaderItem>();
foreach (var col in gv.Columns)
{
if (col.Header != null)//过滤没有列头（如标识列）的列
{
var colname = col.Header.ToString();
if (colname != "操作" && col is IExportableColumn && col.IsVisible)
{
var text = ((IExportableColumn)col).GetCellContent(item);
if (text == null)
{
text = "";
}
headerItems.Add(new BillPrintHeaderItem {
LabelString = colname, TextString = text.ToString()
});
}
}
}
icHeader.ItemsSource = headerItems;
var row = (GridViewRow)gv.ItemContainerGenerator.ContainerFromItem(item);//View.Extension.UIHelper.GetAncestor<GridViewRow>(sender as RadButton);
row.DetailsVisibility = Visibility.Visible;
var detailsPresenter = row.ChildrenOfType <DetailsPresenter>().FirstOrDefault();
// same as e.DetailsElement from gridView_RowDetailsVisibilityChanged
var gvDetails = (RadGridView)detailsPresenter.Content;
foreach (var column in gvDetails.Columns.OfType <Telerik.Windows.Controls.GridViewColumn>())
{
if (column.IsVisible)
{
if (column is GridViewDataColumn)
{
var newColumn = new GridViewDataColumn()
{
Header = column.Header
};
newColumn.DataMemberBinding = new System.Windows.Data.Binding(column.UniqueName);
gvData.Columns.Add(newColumn);
}
else if (column is GridViewExpressionColumn)
{
var newColumn = new GridViewExpressionColumn()
{
Header = column.Header
};
newColumn.Expression = ((GridViewExpressionColumn)column).Expression;
gvData.Columns.Add(newColumn);
}
}
}
gvData.ItemsSource = gvDetails.ItemsSource;
}
