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