public override void OnPageLoad(object sender, EventArgs e)
{
queryVM = new CostChangeQueryVM();
serviceFacade = new CostChangeFacade(this);
//vendorFacade = new VendorFacade(this);
queryFilter = new CostChangeQueryFilter()
{
PageInfo = new QueryFilter.Common.PagingInfo()
};
this.DataContext = queryVM;
LoadComboBoxData();
base.OnPageLoad(sender, e);
//if (null != this.Request.QueryString)
//{
// if (this.Request.QueryString.Keys.Contains("ProductSysNo"))
// {
// queryVM.ProductSysNo = this.Request.QueryString["ProductSysNo"];
// }
// if (this.Request.QueryString.Keys.Contains("QueryStatus"))
// {
// queryVM.StatusList = this.Request.QueryString["QueryStatus"];
// }
// if (this.Request.QueryString.Keys.Contains("POSysNo"))
// {
// POSysNo = this.Request.QueryString["POSysNo"];
// queryVM.POSysNoExtention = POSysNo;
// }
// btnSearch_Click(null, null);
//}
SetAccessControl();
}
/// <summary>
/// 查询成本变价单列表
/// </summary>
/// <param name="queryFilter"></param>
/// <param name="callback"></param>
public void QueryCostChange(CostChangeQueryFilter queryFilter, EventHandler <RestClientEventArgs <dynamic> > callback)
{
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
string relativeUrl = "POService/CostChange/QueryCostChangeList";
restClient.QueryDynamicData(relativeUrl, queryFilter, callback);
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
queryFilter = EntityConverter <CostChangeQueryVM, CostChangeQueryFilter> .Convert(queryVM);
////TODO:权限管理，这里给查询赋予最高权限:
//queryFilter.PMQueryType = PMQueryType.All;
this.QueryResultGrid.Bind();
}
public QueryResult QueryCostChangeList(CostChangeQueryFilter request)
{
int totalCount = 0;
QueryResult returnResult = new QueryResult()
{
Data = ObjectFactory <ICostChangeQueryDA> .Instance.QueryCostChangeList(request, out totalCount)
};
returnResult.TotalCount = totalCount;
return(returnResult);
}
public System.Data.DataTable QueryCostChangeList(CostChangeQueryFilter queryFilter, out int totalCount)
{
DataTable dt = new DataTable();
#region
var customCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryCostChangeList");
PagingInfoEntity pagingInfo = new PagingInfoEntity();
pagingInfo.SortField = queryFilter.PageInfo.SortBy;
pagingInfo.StartRowIndex = queryFilter.PageInfo.PageIndex * queryFilter.PageInfo.PageSize;
pagingInfo.MaximumRows = queryFilter.PageInfo.PageSize;
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(customCommand.CommandText, customCommand, pagingInfo, "c.SysNo DESC"))
{
if (queryFilter.VendorSysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"c.VendorSysNo", DbType.String, "@VendorSysNo",
QueryConditionOperatorType.Equal, queryFilter.VendorSysNo.Value);
}
if (queryFilter.PMSysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"c.PMSysNo", DbType.String, "@PMSysNo",
QueryConditionOperatorType.Equal, queryFilter.PMSysNo.Value);
}
if (!string.IsNullOrEmpty(queryFilter.Memo))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"c.Memo", DbType.String, "@Memo",
QueryConditionOperatorType.Like, queryFilter.Memo.Trim());
}
if (queryFilter.Status.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"c.Status", DbType.Int32, "@Status",
QueryConditionOperatorType.Equal, (int)queryFilter.Status.Value);
}
customCommand.CommandText = sqlBuilder.BuildQuerySql();
customCommand.SetParameterValue("@StartNumber", queryFilter.PageInfo.PageSize * queryFilter.PageInfo.PageIndex);
customCommand.SetParameterValue("@EndNumber", queryFilter.PageInfo.PageSize * queryFilter.PageInfo.PageIndex + queryFilter.PageInfo.PageSize);
var result = customCommand.ExecuteDataTable();
totalCount = Convert.ToInt32(customCommand.GetParameterValue("@TotalCount"));
return(result);
}
#endregion
}
