/// <summary>
/// 查询Stock List
/// </summary>
/// <param name="queryFilter"></param>
/// <param name="callback"></param>
public void QueryStockList(StockQueryFilter queryFilter, EventHandler <RestClientEventArgs <List <StockInfo> > > callback)
{
queryFilter.CompanyCode = "8601";
string relativeUrl = "/InventoryService/Stock/QueryStockList";
restClient.Query <List <StockInfo> >(relativeUrl, queryFilter, callback);
}
public ActionResult Maintain()
{
var stockQueryFilter = new StockQueryFilter();
//获得自贸仓库 ContainKJT设置为true
stockQueryFilter.ContainKJT = false;//UserAuthHelper.GetCurrentUser().VendorStockType == Entity.Store.Vendor.VendorStockType.NEG;
stockQueryFilter.MerchantSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo;
stockQueryFilter.PageIndex = 0;
stockQueryFilter.PageSize = 100000;
var StockList = StockService.QueryStock(stockQueryFilter);
ViewBag.StockList = StockList.ResultList;
var shipTypeQueryFilter = new ShipTypeQueryFilter();
shipTypeQueryFilter.MerchantSysNo = 1;
shipTypeQueryFilter.PageIndex = 0;
shipTypeQueryFilter.PageSize = 100000;
var ShipTypeList = ShipTypeService.QueryShipType(shipTypeQueryFilter);
ViewBag.ShipTypeList = ShipTypeList.ResultList;
if (Request["sysno"] == null || int.Parse(Request["sysno"]) == 0)
{
ViewBag.StockShipTypeInfo = new StockShipTypeInfo();
}
else
{
ViewBag.StockShipTypeInfo = StockService.GetStockShipTypeInfo(int.Parse(Request["sysno"]));
}
return(View());
}
//
// GET: /StockShipType/
public ActionResult List()
{
var stockQueryFilter = new StockQueryFilter();
//获得自贸仓库 ContainKJT设置为true
stockQueryFilter.ContainKJT = false;//UserAuthHelper.GetCurrentUser().VendorStockType == Entity.Store.Vendor.VendorStockType.NEG;
stockQueryFilter.MerchantSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo;
stockQueryFilter.PageIndex = 0;
stockQueryFilter.PageSize = 100000;
var StockList = StockService.QueryStock(stockQueryFilter);
ViewBag.StockList = StockList.ResultList;
var shipTypeQueryFilter = new ShipTypeQueryFilter();
shipTypeQueryFilter.MerchantSysNo = 1;
shipTypeQueryFilter.PageIndex = 0;
shipTypeQueryFilter.PageSize = 100000;
var ShipTypeList = ShipTypeService.QueryShipType(shipTypeQueryFilter);
ViewBag.ShipTypeList = ShipTypeList.ResultList;
return(View());
}
public QueryResult QueryStock(StockQueryFilter request)
{
int totalCount;
var dataTable = ObjectFactory <IStockQueryDA> .Instance.QueryStock(request, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 获取渠道仓库列表
/// </summary>
/// <param name="CompanyCode"></param>
/// <returns>渠道仓库列表</returns>
public virtual List <StockInfo> QueryStockList(StockQueryFilter request)
{
DataCommand cmd = DataCommandManager.GetDataCommand("Inventory_QueryStockList");
cmd.SetParameterValue("@WebChannelSysNo", request.WebChannelID);
cmd.SetParameterValue("@WarehouseSysNo", request.WarehouseSysNo);
cmd.SetParameterValue("@CompanyCode", request.CompanyCode);
using (IDataReader reader = cmd.ExecuteDataReader())
{
return(DataMapper.GetEntityList <StockInfo, List <StockInfo> >(reader));
}
}
public void LoadStockByID(string StockID, EventHandler <RestClientEventArgs <dynamic> > callback)
{
StockQueryFilter filter = new StockQueryFilter();
filter.StockID = StockID;
filter.CompanyCode = "8601";//CPApplication.Current.CompanyCode;
filter.PagingInfo = new PagingInfo {
PageIndex = 0, PageSize = int.MaxValue
};
string relativeUrl = "/InventoryService/Stock/QueryStock";
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
/// <summary>
/// 获取某一个商家的有效仓库信息列表
/// </summary>
/// <param name="merchantSysNo"></param>
/// <param name="vendorStockType"></param>
/// <returns></returns>
public static List <StockInfoQueryRestult> GetStockList(int merchantSysNo, VendorStockType vendorStockType)
{
StockQueryFilter queryFilter = new StockQueryFilter()
{
PageIndex = 0,
PageSize = int.MaxValue,
Status = StockStatus.Actived,
SortFields = "s.SysNo DESC"
};
queryFilter.MerchantSysNo = merchantSysNo;
//所有商家都可以查看泰隆优选仓库
queryFilter.ContainKJT = true;
return(StockService.QueryStock(queryFilter).ResultList);
}
/// <summary>
/// 查询商家的仓库列表
/// </summary>
/// <param name="queryFilter"></param>
/// <returns></returns>
public static QueryResult <StockInfoQueryRestult> QueryStock(StockQueryFilter queryFilter)
{
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryStock");
using (var sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, queryFilter, string.IsNullOrEmpty(queryFilter.SortFields) ? "s.SysNo ASC" : queryFilter.SortFields))
{
if (!string.IsNullOrEmpty(queryFilter.StockID))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.StockID", DbType.String, "@StockID", QueryConditionOperatorType.Like, queryFilter.StockID);
}
if (queryFilter.SysNo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.SysNo", DbType.String, "@SysNo", QueryConditionOperatorType.Equal, queryFilter.SysNo.Value);
}
if (queryFilter.Status.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, queryFilter.Status.Value);
}
if (queryFilter.StockType.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.StockType", DbType.String, "@StockType", QueryConditionOperatorType.Equal, queryFilter.StockType.Value);
}
if (queryFilter.ContainKJT)
{
sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND,
string.Format("(s.MerchantSysNo = 1 OR s.MerchantSysNo = {0})", queryFilter.MerchantSysNo));
}
else
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.MerchantSysNo", DbType.Int32, "@MerchantSysNo", QueryConditionOperatorType.Equal, queryFilter.MerchantSysNo);
}
if (!string.IsNullOrEmpty(queryFilter.StockName))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.StockName", DbType.String, "@StockName", QueryConditionOperatorType.Like, queryFilter.StockName);
}
command.CommandText = sqlBuilder.BuildQuerySql();
List <StockInfoQueryRestult> resultList = command.ExecuteEntityList <StockInfoQueryRestult>();
int totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(new QueryResult <StockInfoQueryRestult>()
{
PageInfo = new PageInfo()
{
PageIndex = queryFilter.PageIndex, PageSize = queryFilter.PageSize, TotalCount = totalCount, SortBy = queryFilter.SortFields
}, ResultList = resultList
});
}
}
public void QueryStock(StockQueryVM model, EventHandler <RestClientEventArgs <dynamic> > callback)
{
StockQueryFilter filter = model.ConvertVM <StockQueryVM, StockQueryFilter>();
string relativeUrl = "/InventoryService/Stock/QueryStock";
restClient.QueryDynamicData(relativeUrl, filter,
(obj, args) =>
{
if (!args.FaultsHandle())
{
foreach (var item in args.Result.Rows)
{
item.IsChecked = false;
}
callback(obj, args);
}
});
}
/// <summary>
/// 查询商家的仓库列表
/// </summary>
/// <param name="queryFilter"></param>
/// <returns></returns>
public static QueryResult <StockInfoQueryRestult> QueryStock(StockQueryFilter queryFilter)
{
return(StockDA.QueryStock(queryFilter));
}
/// <summary>
/// 查询渠道仓库
/// </summary>
/// <returns></returns>
public virtual DataTable QueryStock(StockQueryFilter filter, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = SortFieldMapping(filter.PagingInfo.SortBy);
pagingEntity.MaximumRows = filter.PagingInfo.PageSize;
pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize;
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("Inventory_QueryStock");
using (var sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "a.SysNo DESC"))
{
bool isSysNo = false;
//编号格式验证
if (filter.StockSysNo != null && Regex.IsMatch(filter.StockSysNo, @"^[,\. ]*\d+[\d,\. ]*$"))
{
filter.StockSysNo = String.Join(",", filter.StockSysNo.Split(new char[] { '.', ',', ' ' }, StringSplitOptions.RemoveEmptyEntries));
isSysNo = true;
}
else
{
filter.StockSysNo = null;
}
if (filter.StockID != null && Regex.IsMatch(filter.StockID, @"^[, ]*\w+[\w-#, ]*$"))
{
filter.StockID = "'" + String.Join("','", filter.StockID.Split(new char[] { ',', ' ' }, StringSplitOptions.RemoveEmptyEntries)) + "'";
isSysNo = true;
}
else
{
filter.StockID = null;
}
if (isSysNo)
{
sb.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND);
sb.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND,
"a.SysNo", QueryConditionOperatorType.In, filter.StockSysNo);
sb.ConditionConstructor.AddSubQueryCondition(QueryConditionRelationType.AND,
"a.StockID", QueryConditionOperatorType.In, filter.StockID);
sb.ConditionConstructor.EndGroupCondition();
}
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.StockName", DbType.String, "@StockName",
QueryConditionOperatorType.LeftLike, filter.StockName);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.Status", DbType.AnsiStringFixedLength, "@StockStatus",
QueryConditionOperatorType.Equal, filter.StockStatus);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.WarehouseSysNo", DbType.Int32, "@WarehouseSysNo",
QueryConditionOperatorType.Equal, filter.WarehouseSysNo);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.WebChannelSysNo", DbType.Int32, "@WebChannelSysNo",
QueryConditionOperatorType.Equal, filter.WebChannelSysNo);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode",
QueryConditionOperatorType.Equal, filter.CompanyCode);
EnumColumnList enumColumnList = new EnumColumnList();
enumColumnList.Add("StockStatus", typeof(ValidStatus));
cmd.CommandText = sb.BuildQuerySql();
var resultData = cmd.ExecuteDataTable(enumColumnList);
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(resultData);
}
}
public List <StockInfo> QueryStockList(StockQueryFilter request)
{
return(ObjectFactory <IStockDA> .Instance.QueryStockList(request));
}
