/// <summary>
/// 查询备案信息
/// </summary>
/// <returns></returns>
public ActionResult QueryProductEntryInfo()
{
ProductEntryInfoQueryFilter filter = BuildQueryFilterEntity <ProductEntryInfoQueryFilter>();
var user = UserAuthHelper.GetCurrentUser();
filter.SellerSysNo = user != null ? user.SellerSysNo : 0;
var result = ProductMaintainService.QueryProductEntryInfo(filter);
return(AjaxGridJson(result));
}
/// <summary>
/// 查询备案信息
/// </summary>
/// <param name="filter">查询条件</param>
/// <param name="dataCount">总记录数</param>
/// <returns></returns>
public static List <ProductEntryInfo> ProductEntryInfoQuery(ProductEntryInfoQueryFilter filter, out int dataCount)
{
List <ProductEntryInfo> result = new List <ProductEntryInfo>();
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryProductEntryInfo");
using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(command.CommandText, command, filter, !string.IsNullOrWhiteSpace(filter.SortFields) ? filter.SortFields : "P.SysNo DESC"))
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"P.MerchantSysNo", DbType.Int32,
"@SellerSysNo", QueryConditionOperatorType.Equal,
filter.SellerSysNo);
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"P.SysNo", DbType.Int32,
"@ProductSysNo", QueryConditionOperatorType.Equal,
filter.ProductSysNo);
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"P.ProductTitle", DbType.String,
"@ProductTitle", QueryConditionOperatorType.Like,
filter.ProductTitle);
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"Product_SKUNO", DbType.String,
"@ProductSKUNO", QueryConditionOperatorType.Like,
filter.ProductSKUNO);
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"Supplies_Serial_No", DbType.String,
"@SuppliesSerialNo", QueryConditionOperatorType.Like,
filter.SuppliesSerialNo);
if (!string.IsNullOrEmpty(filter.ManufactureDateBegin))
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"ManufactureDate", DbType.String,
"@ManufactureDateBegin", QueryConditionOperatorType.MoreThanOrEqual,
filter.ManufactureDateBegin);
}
if (!string.IsNullOrEmpty(filter.ManufactureDateEnd))
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"ManufactureDate", DbType.String,
"@ManufactureDateEnd", QueryConditionOperatorType.LessThan,
DateTime.Parse(filter.ManufactureDateEnd).AddDays(1).ToShortDateString());
}
if (filter.EntryStatus == 0)
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"ISNULL(EntryStatus, 0)", DbType.Int32,
"@EntryStatus1", QueryConditionOperatorType.Equal,
filter.EntryStatus);
}
else
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"EntryStatus", DbType.Int32,
"@EntryStatus", QueryConditionOperatorType.Equal,
filter.EntryStatus);
}
command.CommandText = builder.BuildQuerySql();
result = command.ExecuteEntityList <ProductEntryInfo>();
dataCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(result);
}
}
