public QueryResult GetFPCheckMaster(FPCheckQueryFilter query)
{
int totalCount;
return(new QueryResult()
{
Data = ObjectFactory <IFPCheckQueryDA> .Instance.Query(query, out totalCount),
TotalCount = totalCount
});
}
public virtual DataTable Query(FPCheckQueryFilter queryCriteria, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = queryCriteria.PagingInfo.SortBy;
pagingEntity.MaximumRows = queryCriteria.PagingInfo.PageSize;
pagingEntity.StartRowIndex = queryCriteria.PagingInfo.PageIndex * queryCriteria.PagingInfo.PageSize;
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryFPCheckMaster");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, " a.sysno ASC "))
{
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"a.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode",
QueryConditionOperatorType.Equal, "8601");
cmd.CommandText = sqlBuilder.BuildQuerySql();
cmd.SetParameterValue("@ChannelID", queryCriteria.ChannelID);
DataTable dt = cmd.ExecuteDataTable();
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
public FPCheck()
{
viewModel = new FPCheckVM();
queryRequest = new FPCheckQueryFilter();
InitializeComponent();
}
/// <summary>
/// 查询FP状态
/// </summary>
/// <param name="request"></param>
/// <param name="callback"></param>
public void Query(FPCheckQueryFilter request, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = "/CustomerService/FPCheckMaster/Query";
restClient.QueryDynamicData(relativeUrl, request, callback);
}
