/// <summary>
/// 台帐报表
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List <InventoryBookEntity> GetList(InventoryBookEntity entity, ref PageInfo pageInfo)
{
entity.IncludeAll();
entity.OrderBy(a => a.ProductNum, EOrderBy.ASC);
AdminEntity adminEntity = new AdminEntity();
adminEntity.Include(a => new { UserName = a.UserName });
entity.Left <AdminEntity>(adminEntity, new Params <string, string>()
{
Item1 = "CreateUser", Item2 = "UserCode"
});
int rowCount = 0;
List <InventoryBookEntity> listResult = this.InventoryBook.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);
pageInfo.RowCount = rowCount;
return(listResult);
}
public static InventoryBook_CE ToCE(InventoryBookEntity item)
{
InventoryBook_CE target = new InventoryBook_CE();
target.ID = item.ID;
target.ProductNum = item.ProductNum;
target.BarCode = item.BarCode;
target.ProductName = item.ProductName;
target.Num = item.Num;
target.Type = item.Type;
target.ContactOrder = item.ContactOrder;
target.FromLocalNum = item.FromLocalNum;
target.ToLocalNum = item.ToLocalNum;
target.StoreNum = item.StoreNum;
target.CreateTime = item.CreateTime;
target.CreateUser = item.CreateUser;
return(target);
}
/// <summary>
/// 查询台账记录分页
/// </summary>
/// <returns></returns>
public ActionResult GetList()
{
string CompanyID = WebUtil.GetFormValue <string>("CompanyID", string.Empty);
string BarCode = WebUtil.GetFormValue <string>("BarCode", string.Empty);
string ProductName = WebUtil.GetFormValue <string>("ProductName", string.Empty);
string BatchNum = WebUtil.GetFormValue <string>("BatchNum", string.Empty);
int Type = WebUtil.GetFormValue <int>("Type", 0);
string FromStorageNum = WebUtil.GetFormValue <string>("FromStorageNum");
string OrderNum = WebUtil.GetFormValue <string>("OrderNum");
string ContactOrder = WebUtil.GetFormValue <string>("ContactOrder");
string BeginTime = WebUtil.GetFormValue <string>("BeginTime");
string EndTime = WebUtil.GetFormValue <string>("EndTime");
int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 0);
int PageSize = WebUtil.GetFormValue <int>("PageSize", 0);
InventoryBookEntity entity = new InventoryBookEntity();
entity.CompanyID = CompanyID;
entity.BarCode = BarCode;
entity.ProductName = ProductName;
entity.BatchNum = BatchNum;
entity.Type = Type;
entity.FromStorageNum = FromStorageNum;
entity.OrderNum = OrderNum;
entity.ContactOrder = ContactOrder;
entity.BeginTime = BeginTime;
entity.EndTime = EndTime;
PageInfo pageInfo = new PageInfo()
{
PageIndex = PageIndex, PageSize = PageSize
};
InventoryBookProvider provider = new InventoryBookProvider(CompanyID);
List <InventoryBookEntity> listResult = provider.GetList(entity, ref pageInfo);
DataListResult <InventoryBookEntity> dataResult = new DataListResult <InventoryBookEntity>();
dataResult.Code = (int)EResponseCode.Success;
dataResult.Result = listResult;
dataResult.Message = "响应成功";
dataResult.PageInfo = pageInfo;
return(Content(JsonHelper.SerializeObject(dataResult)));
}
/// <summary>
/// 查询台账记录
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List <InventoryBookEntity> GetList(InventoryBookEntity entity, ref PageInfo pageInfo)
{
entity.IncludeAll();
entity.OrderBy(a => a.ID, EOrderBy.DESC);
entity.Where(a => a.CompanyID == this.CompanyID);
if (entity.BarCode.IsNotEmpty())
{
entity.And("BarCode", ECondition.Like, "%" + entity.BarCode + "%");
}
if (entity.ProductName.IsNotEmpty())
{
entity.And("ProductName", ECondition.Like, "%" + entity.ProductName + "%");
}
if (entity.BatchNum.IsNotEmpty())
{
entity.And("BatchNum", ECondition.Like, "%" + entity.BatchNum + "%");
}
if (entity.Type > 0)
{
entity.And(a => a.Type == entity.Type);
}
if (entity.OrderNum.IsNotEmpty())
{
entity.And("OrderNum", ECondition.Like, "%" + entity.OrderNum + "%");
}
if (entity.ContactOrder.IsNotEmpty())
{
entity.And(item => item.ContactOrder == entity.ContactOrder);
}
if (entity.FromStorageNum.IsNotEmpty())
{
entity.And(item => item.FromStorageNum == entity.FromStorageNum);
}
if (entity.BeginTime.IsNotEmpty())
{
DateTime begin = ConvertHelper.ToType <DateTime>(entity.BeginTime, DateTime.Now.AddDays(-30)).Date;
entity.And(a => a.CreateTime >= begin);
}
if (entity.EndTime.IsNotEmpty())
{
DateTime end = ConvertHelper.ToType <DateTime>(entity.EndTime, DateTime.Now).AddDays(1).Date;
entity.And(a => a.CreateTime < end);
}
int rowCount = 0;
List <InventoryBookEntity> listResult = this.InventoryBook.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);
pageInfo.RowCount = rowCount;
if (!listResult.IsNullOrEmpty())
{
List <LocationEntity> listLocation = new LocationProvider(this.CompanyID).GetList();
listLocation = listLocation == null ? new List <LocationEntity>() : listLocation;
ProductProvider provider = new ProductProvider(this.CompanyID);
foreach (InventoryBookEntity item in listResult)
{
if (item.FromLocalNum.IsNotEmpty())
{
LocationEntity location = listLocation.FirstOrDefault(a => a.LocalNum == item.FromLocalNum);
item.FromLocalName = location != null ? location.LocalName : string.Empty;
item.FromStorageName = location != null ? location.StorageName : string.Empty;
}
if (item.ToLocalNum.IsNotEmpty())
{
LocationEntity location = listLocation.FirstOrDefault(a => a.LocalNum == item.ToLocalNum);
item.ToLocalName = location != null ? location.LocalName : string.Empty;
item.ToStorageName = location != null ? location.StorageName : string.Empty;
}
ProductEntity product = provider.GetProduct(item.ProductNum);
if (product != null)
{
item.Size = product.Size;
item.UnitName = product.UnitName;
}
}
}
return(listResult);
}
