public static List <ProductInStoreSimpleDto> GetSimpleList(int pageIndex, int pageSize)
{
var list = new List <ProductInStoreSimpleDto>();
var query = new DQueryDom(new JoinAlias(typeof(ProductInStore)));
query.Where.Conditions.Add(DQCondition.EQ("BillState", 单据状态.未审核));
query.Where.Conditions.Add(DQCondition.EQ("Domain_ID", DomainContext.Current.ID));
query.OrderBy.Expressions.Add(DQOrderByExpression.Create("ID", true));
query.Columns.Add(DQSelectColumn.Field("ID"));
query.Columns.Add(DQSelectColumn.Field("InStoreDate"));
query.Columns.Add(DQSelectColumn.Field("Store_Name"));
query.Range = new SelectRange(pageSize * pageIndex, pageSize);
using (var session = Dmo.NewSession())
{
using (var reader = session.ExecuteReader(query))
{
while (reader.Read())
{
var dto = new ProductInStoreSimpleDto();
dto.ID = (long)reader[0];
dto.InStoreDate = (DateTime)reader[1];
dto.Store_Name = (string)reader[2];
list.Add(dto);
}
}
}
return(list);
}
public static void AppUpdateByDetail(ProductInStoreSimpleDto dto)
{
var bl = BIFactory.Create <IProductInStoreBL>();
var dmo = bl.Load(dto.ID);
dmo.Store_ID = dto.Store_ID;
dmo.Department_ID = dto.Department_ID;
dmo.InStoreDate = dto.Date;
dmo.Remark = dto.Remark;
var fd = dmo.Details.FirstOrDefault(x => x.Goods_ID == dto.Goods_ID);
if (fd != null)
{
fd.SecondNumber = dto.SecondNumber;
fd.Number = fd.SecondNumber * fd.Goods_MainUnitRatio / fd.Goods_SecondUnitRatio;
}
bl.Update(dmo);
}
