/// <summary>
/// 根据query得到到货通知信息
/// </summary>
/// <param name="model"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="SortField"></param>
/// <param name="callback"></param>
public void GetProductNotifyByQuery(ProductNotifyQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
int priductId;
ProductNotifyQueryFilter query = new ProductNotifyQueryFilter();
query.Category1SysNo = model.Category1SysNo;
query.Category2SysNo = model.Category2SysNo;
query.Category3SysNo = model.Category3SysNo;
query.CustomserID = model.CustomserID;
query.Email = model.Email;
query.EndTime = model.EndTime;
query.PMSysNo = model.PMSysNo;
if (int.TryParse(model.ProductSysNo, out priductId))
{
query.ProductSysNo = priductId;
}
query.StartTime = model.StartTime;
query.Status = model.Status;
query.PageInfo = new PagingInfo
{
PageSize = PageSize,
PageIndex = PageIndex,
SortBy = SortField
};
restClient.QueryDynamicData(GetProductNotifyUrl, query, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
callback(obj, args);
});
}
public virtual QueryResult GetProductNotifyByQuery(ProductNotifyQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <IProductNotifyDA> .Instance.GetProductNotifyByQuery(query, out totalCount);
return(new QueryResult
{
Data = dataTable,
TotalCount = totalCount
});
}
public DataTable GetProductNotifyByQuery(ProductNotifyQueryFilter query, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetProductNotifyList");
dc.SetParameterValue("@C1SysNo1", query.Category1SysNo);
dc.SetParameterValue("@C2SysNo1", query.Category2SysNo);
dc.SetParameterValue("@C3SysNo1", query.Category3SysNo);
dc.SetParameterValue("@Status", query.Status);
dc.SetParameterValue("@ProductSysNo", query.ProductSysNo);
dc.SetParameterValue("@StartTime", query.StartTime);
dc.SetParameterValue("@EndTime", query.EndTime);
dc.SetParameterValue("@Email", query.Email);
dc.SetParameterValue("@CustomerID", query.CustomserID);
dc.SetParameterValue("@PMSysNo", query.PMSysNo);
dc.SetParameterValue("@PageSize", query.PageInfo.PageSize);
dc.SetParameterValue("@PageCurrent", query.PageInfo.PageIndex);
dc.SetParameterValue("@SortField", query.PageInfo.SortBy);
DataTable dt = new DataTable();
dt = dc.ExecuteDataTable(3, typeof(NotifyStatus));
totalCount = (int)dc.GetParameterValue("@TotalCount");
return(dt);
}
