public override void OnPageLoad(object sender, EventArgs e)
{
base.OnPageLoad(sender, e);
queryFilter = new VendorRMARefundQueryFilter();
queryVM = new VendorRMARefundQueryVM();
serviceFacade = new VendorRefundFacade(this);
LoadComboBoxData();
this.DataContext = queryVM;
SetAccessControl();
}
public QueryResult QueryVendorRMARefundList(VendorRMARefundQueryFilter request)
{
int totalCount = 0;
QueryResult returnResult = new QueryResult()
{
Data = ObjectFactory <IVendorRefundQueryDA> .Instance.QueryRMARefundList(request, out totalCount)
};
returnResult.TotalCount = totalCount;
return(returnResult);
}
private void QueryResultGrid_ExportAllClick(object sender, EventArgs e)
{
//权限控制:
if (!AuthMgr.HasFunctionPoint(AuthKeyConst.PO_VendorRefund_Export))
{
Window.Alert("对不起，你没有权限进行此操作!");
return;
}
//导出全部:
if (null != queryFilter)
{
VendorRMARefundQueryFilter exportQueryRequest = Newegg.Oversea.Silverlight.Utilities.UtilityHelper.DeepClone <VendorRMARefundQueryFilter>(queryFilter);
exportQueryRequest.PageInfo = new QueryFilter.Common.PagingInfo()
{
PageIndex = 0, PageSize = ConstValue.MaxRowCountLimit
};
foreach (DataGridColumn col in QueryResultGrid.Columns)
{
if (col.Visibility == Visibility.Collapsed)
{
if (col is Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn)
{
(col as Newegg.Oversea.Silverlight.Controls.Data.DataGridTextColumn).NeedExport = false;
}
else if (col is Newegg.Oversea.Silverlight.Controls.Data.DataGridTemplateColumn)
{
(col as Newegg.Oversea.Silverlight.Controls.Data.DataGridTemplateColumn).NeedExport = false;
}
}
}
ColumnSet columnSet = new ColumnSet(QueryResultGrid);
columnSet.Insert(1, "Status", ResVendorRMARefundQuery.GridHeader_Status);
serviceFacade.ExportExcelForVendorRMARefundList(exportQueryRequest, new ColumnSet[] { columnSet });
}
}
public DataTable QueryRMARefundList(VendorRMARefundQueryFilter queryFilter, out int totalCount)
{
DataTable dt = new DataTable();
PagingInfoEntity pagingInfo = new PagingInfoEntity()
{
SortField = queryFilter.PageInfo.SortBy,
StartRowIndex = queryFilter.PageInfo.PageIndex * queryFilter.PageInfo.PageSize,
MaximumRows = queryFilter.PageInfo.PageSize
};
CustomDataCommand command = null;
command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryVendorRefundMaster");
using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(command.CommandText, command, pagingInfo, "vrm.[SysNo] DESC"))
{
if (queryFilter.CreateDateFrom.HasValue)
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "vrm.CreateTime",
DbType.DateTime, "@CreateTime", QueryConditionOperatorType.MoreThanOrEqual, queryFilter.CreateDateFrom.Value);
}
if (queryFilter.CreateDateTo.HasValue)
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "vrm.CreateTime",
DbType.DateTime, "@CreateTimeTo", QueryConditionOperatorType.LessThan, queryFilter.CreateDateTo.Value.AddDays(1));
}
if (queryFilter.VendorSysNo.HasValue)
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "vrm.VendorSysNo",
DbType.Int32, "@VendorSysNo", QueryConditionOperatorType.Equal, queryFilter.VendorSysNo.Value);
}
if (!string.IsNullOrEmpty(queryFilter.VendorRefundSysNo))
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "vrm.SysNo",
DbType.String, "@SysNo", QueryConditionOperatorType.Equal, queryFilter.VendorRefundSysNo);
}
if (queryFilter.Status.HasValue)
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "vrm.Status",
DbType.Int32, "@Status", QueryConditionOperatorType.Equal, (int)queryFilter.Status.Value);
}
if (queryFilter.PayType.HasValue)
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "vrm.PayType",
DbType.Int32, "@PayType", QueryConditionOperatorType.Equal, (int)queryFilter.PayType.Value);
}
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "vrm.CompanyCode",
DbType.Int32, "@CompanyCode", QueryConditionOperatorType.Equal, queryFilter.CompanyCode);
System.Text.StringBuilder strSql = new System.Text.StringBuilder();
//TODO:PM List
if (queryFilter.PMSysNo.HasValue)
{
strSql.Append(" AND p.PMUserSysNo = " + queryFilter.PMSysNo.Value);
}
//else
//{
// if (condition.Condition.PMSysNoList.Count > 0)
// {
// strSql.Append(" AND p.PMUserSysNo IN ( ");
// for (int i = 0; i < condition.Condition.PMSysNoList.Count; i++)
// {
// if (i == 0)
// {
// strSql.Append(condition.Condition.PMSysNoList[i].ToString());
// }
// else
// {
// strSql.Append(" , " + condition.Condition.PMSysNoList[i].ToString());
// }
// }
// strSql.Append(" ) ");
// }
//}
if (queryFilter.ProductSysNo.HasValue)
{
strSql.Append(" AND p.SysNo = " + queryFilter.ProductSysNo.Value);
}
if (!string.IsNullOrEmpty(queryFilter.RMARegisterSysNo))
{
strSql.Append(" AND item.RegisterSysNo = " + queryFilter.RMARegisterSysNo);
}
command.CommandText = builder.BuildQuerySql().Replace("AppendSql", strSql.ToString());
EnumColumnList enumColumnList = new EnumColumnList();
enumColumnList.Add("Status", typeof(VendorRefundStatus));
enumColumnList.Add("PayType", typeof(VendorRefundPayType));
dt = command.ExecuteDataTable(enumColumnList);
totalCount = (int)command.GetParameterValue("@TotalCount");
return(dt);
}
}
public void ExportExcelForVendorRMARefundList(VendorRMARefundQueryFilter queryFilter, ColumnSet[] columns)
{
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
string relativeUrl = "POService/VendorRefund/QueryVendorRefundList";
restClient.ExportFile(relativeUrl, queryFilter, columns);
}
/// <summary>
/// 查询供应商退款单列表
/// </summary>
/// <param name="queryFilter"></param>
/// <param name="callback"></param>
public void QueryVendorRMARefundList(VendorRMARefundQueryFilter queryFilter, EventHandler<RestClientEventArgs<dynamic>> callback)
{
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
string relativeUrl = "POService/VendorRefund/QueryVendorRefundList";
restClient.QueryDynamicData(relativeUrl, queryFilter, callback);
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
queryFilter = EntityConverter <VendorRMARefundQueryVM, VendorRMARefundQueryFilter> .Convert(queryVM);
this.QueryResultGrid.Bind();
}
