/// <summary>
/// 查询分类属性
/// </summary>
/// <param name="model"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="SortField"></param>
/// <param name="callback"></param>
public void QuerySellerProductRequest(SellerProductRequestQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
SellerProductRequestQueryFilter filter = model.ConvertVM <SellerProductRequestQueryVM, SellerProductRequestQueryFilter>();
filter.PagingInfo = new PagingInfo
{
PageSize = PageSize,
PageIndex = PageIndex,
SortBy = SortField
};
restClient.QueryDynamicData(GetRelativeUrl, filter,
(obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
if (!(args.Result == null || args.Result.Rows == null))
{
foreach (var item in args.Result.Rows)
{
item.IsChecked = false;
}
}
callback(obj, args);
}
);
}
public QueryResult QuerySellerProductRequest(SellerProductRequestQueryFilter request)
{
if (request == null)
{
throw new BizException(ResouceManager.GetMessageString("IM.SellerProductRequest", "SellerProductRequestCondtionIsNull"));
}
int totalCount;
var data = ObjectFactory <ISellerProductRequestQueryDA> .Instance.QuerySellerProductRequest(request, out totalCount);
var source = new QueryResult {
Data = data, TotalCount = totalCount
};
return(source);
}
public void ExportSellerProductRequestExcelFile(SellerProductRequestQueryVM vm, ColumnSet[] columns)
{
SellerProductRequestQueryFilter queryFilter = new SellerProductRequestQueryFilter();
queryFilter = vm.ConvertVM <SellerProductRequestQueryVM, SellerProductRequestQueryFilter>();
queryFilter.Type = SellerProductRequestType.NewCreated;
queryFilter.PagingInfo = new QueryFilter.Common.PagingInfo
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = string.Empty
};
restClient.ExportFile(GetRelativeUrl, queryFilter, columns);
}
public DataTable QuerySellerProductRequest(SellerProductRequestQueryFilter queryCriteria, out int totalCount)
{
var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QuerySellerProductRequest");
var pagingInfo = new PagingInfoEntity
{
SortField = queryCriteria.PagingInfo.SortBy,
StartRowIndex = queryCriteria.PagingInfo.PageIndex * queryCriteria.PagingInfo.PageSize,
MaximumRows = queryCriteria.PagingInfo.PageSize
};
using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "A.SysNo DESC"))
{
if (queryCriteria.C1SysNo != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"E.C1Sysno",
DbType.Int32, "@C1SysNo",
QueryConditionOperatorType.Equal,
queryCriteria.C1SysNo.Value);
}
if (queryCriteria.C2SysNo != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"E.Sysno",
DbType.Int32, "@C2SysNo",
QueryConditionOperatorType.Equal,
queryCriteria.C2SysNo.Value);
}
if (queryCriteria.C3SysNo != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"D.Sysno",
DbType.Int32, "@C3SysNo",
QueryConditionOperatorType.Equal,
queryCriteria.C3SysNo.Value);
}
if (queryCriteria.ProductSysNo != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"B.SysNo",
DbType.Int32, "@ProductSysNo",
QueryConditionOperatorType.Equal,
queryCriteria.ProductSysNo.Value);
}
if (!string.IsNullOrEmpty(queryCriteria.ProductID))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"B.ProductID",
DbType.String, "@ProductID",
QueryConditionOperatorType.Equal,
queryCriteria.ProductID);
}
if (queryCriteria.RequestStartDate != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"A.InDate",
DbType.DateTime, "@RequestStartDate",
QueryConditionOperatorType.MoreThanOrEqual,
queryCriteria.RequestStartDate.Value);
}
if (queryCriteria.RequestEndDate != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"A.InDate",
DbType.DateTime, "@RequestEndDate",
QueryConditionOperatorType.LessThan,
queryCriteria.RequestEndDate.Value);
}
if (!string.IsNullOrEmpty(queryCriteria.ProductName))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"A.ProductName ",
DbType.String, "@ProductName",
QueryConditionOperatorType.Like,
queryCriteria.ProductName);
}
if (!string.IsNullOrEmpty(queryCriteria.Auditor))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"A.Auditor",
DbType.String, "@Auditor",
QueryConditionOperatorType.Like,
queryCriteria.Auditor);
}
if (!string.IsNullOrEmpty(queryCriteria.EditUser))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"A.EditUser",
DbType.String, "@EditUser",
QueryConditionOperatorType.Like,
queryCriteria.EditUser);
}
if (!string.IsNullOrEmpty(queryCriteria.CommonSKUNumber))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"A.CommonSKUNumber",
DbType.String, "@CommonSKUNumber",
QueryConditionOperatorType.Like,
queryCriteria.CommonSKUNumber);
}
if (!queryCriteria.Status.ToString().Equals("0"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"A.Status",
DbType.String, "@Status",
QueryConditionOperatorType.Equal,
queryCriteria.Status);
}
if (!queryCriteria.Type.ToString().Equals("0"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"A.Type",
DbType.String, "@Type",
QueryConditionOperatorType.Equal,
queryCriteria.Type);
}
//else
//{
// sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
// "A.Type",
// DbType.String, "@Type",
// QueryConditionOperatorType.In,
// new List<object> { SellerProductRequestType.NewCreated, SellerProductRequestType.ParameterUpdate });
//}
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var enumList = new EnumColumnList {
{ "Status", typeof(SellerProductRequestStatus) }
, { "Type", typeof(SellerProductRequestType) }
, { "IsTakePictures", typeof(SellerProductRequestTakePictures) }
, { "IsConsign", typeof(VendorConsignFlag) }
, { "IsOfferInvoice", typeof(SellerProductRequestOfferInvoice) }
};
DataTable dt = dataCommand.ExecuteDataTable(enumList);
totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount"));
return(dt);
}
}
