public QueryResult GetRMARegisterList(RMARegisterQueryFilter query)
{
int totalCount;
return(new QueryResult()
{
Data = ObjectFactory <ICallingLogQueryDA> .Instance.GetRMARegisterList(query, out totalCount),
TotalCount = totalCount
});
}
public virtual DataTable GetRMARegisterList(RMARegisterQueryFilter filter, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = filter.PagingInfo.SortBy;
pagingEntity.MaximumRows = filter.PagingInfo.PageSize;
pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize;
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetRMARegisterList");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "SysNo DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"B.RequestSysNo",
DbType.Int32,
"@RequestSysNo ",
QueryConditionOperatorType.Equal,
filter.RequestSysNo);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"A.ProductSysNo",
DbType.Int32,
"@ProductSysNo",
QueryConditionOperatorType.Equal,
filter.ProductSysNo
);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"A.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode",
QueryConditionOperatorType.Equal,
filter.CompanyCode);
cmd.CommandText = sqlBuilder.BuildQuerySql();
DataTable dt = cmd.ExecuteDataTable();
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
public RMAAdd()
{
filter = new RMARegisterQueryFilter();
InitializeComponent();
}
public void GetRMARegisterList(RMARegisterQueryFilter request, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = "/CustomerService/CallingLog/GetRMARegisterList";
restClient.QueryDynamicData(relativeUrl, request, callback);
}
