public override void OnPageLoad(object sender, EventArgs e)
{
base.OnPageLoad(sender, e);
eportVM = new EPortVM();
BindComboBoxData();
facade = new EPortFacade(this);
queryRequest = new EPortFilter();
this.DataContext = queryRequest;
}
public QueryResult QueryEport(EPortFilter request)
{
int totalCount = 0;
QueryResult returnResult = new QueryResult()
{
Data = ObjectFactory <IEPortDA> .Instance.QueryEPort(request, out totalCount)
};
returnResult.TotalCount = totalCount;
return(returnResult);
}
/// <summary>
/// 获取电子口岸列表
/// </summary>
/// <param name="vendorInfo"></param>
/// <returns></returns>
public DataTable QueryEPort(EPortFilter filter, out int totalCount)
{
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QeryEPortList");
PagingInfoEntity pagingInfo = new PagingInfoEntity()
{
SortField = filter.PageInfo.SortBy,
StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize,
MaximumRows = filter.PageInfo.PageSize
};
using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(
command.CommandText, command, pagingInfo, "c.InDate Desc"))
{
if (filter.SysNo > 0)
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"c.SysNo", DbType.Int32,
"@SysNo", QueryConditionOperatorType.Equal,
filter.SysNo);
}
if (!string.IsNullOrWhiteSpace(filter.Name))
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"c.ePortName", DbType.String,
"@ePortName", QueryConditionOperatorType.Equal,
filter.Name);
}
if (filter.TaxFreeLimit > 0)
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"c.TaxFreeLimit", DbType.Int32,
"@TaxFreeLimit", QueryConditionOperatorType.Equal,
filter.TaxFreeLimit);
}
// if (filter.CreateTime !=null)
// {
// builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
//"c.Indate", DbType.DateTime,
//"@Indate", QueryConditionOperatorType.Equal,
//filter.CreateTime);
// }
if (filter.DateFrom.HasValue)
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.Indate",
DbType.DateTime, "@DateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.DateFrom.Value);
}
if (filter.DataTo.HasValue)
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.Indate",
DbType.DateTime, "@DataTo", QueryConditionOperatorType.LessThanOrEqual, filter.DataTo.Value);
}
if (filter.Status != null)
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"c.[Status]", DbType.Int32,
"@Status", QueryConditionOperatorType.Equal,
filter.Status);
}
command.CommandText = builder.BuildQuerySql();
DataTable dt = command.ExecuteDataTable(new EnumColumnList {
{ "Status", typeof(EPortStatusENUM) },
{ "ShippingType", typeof(EPortShippingTypeENUM) }
});
totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(dt);
}
}
/// <summary>
/// 查询电子口岸列表
/// </summary>
/// <param name="request"></param>
/// <param name="callback"></param>
public void QueryEPortList(EPortFilter request, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = "/POService/EPort/QueryEport";
restClient.QueryDynamicData(relativeUrl, request, callback);
}
