public virtual void UpdateBillAgingView(BillAgingView entity)
{
Update(entity);
}
public virtual void DeleteBillAgingView(BillAgingView entity)
{
Delete(entity);
}
public virtual void UpdateBillAgingView(BillAgingView entity)
{
entityDao.UpdateBillAgingView(entity);
}
public virtual void CreateBillAgingView(BillAgingView entity)
{
Create(entity);
}
public virtual void CreateBillAgingView(BillAgingView entity)
{
entityDao.CreateBillAgingView(entity);
}
public virtual void DeleteBillAgingView(BillAgingView entity)
{
entityDao.DeleteBillAgingView(entity);
}
public virtual void DeleteBillAgingView(BillAgingView entity)
{
entityDao.DeleteBillAgingView(entity);
}
private void OnDetailClick(int id, int range)
{
BillAgingView billAgingView = TheBillAgingViewMgr.LoadBillAgingView(id);
DetachedCriteria selectCriteria = DetachedCriteria.For(typeof(ActingBillView));
DetachedCriteria selectCountCriteria = DetachedCriteria.For(typeof(ActingBillView))
.SetProjection(Projections.Count("Id"));
IDictionary <string, string> alias = new Dictionary <string, string>();
selectCriteria.CreateAlias("BillAddress", "ba");
selectCountCriteria.CreateAlias("BillAddress", "ba");
selectCriteria.CreateAlias("Item", "i");
selectCountCriteria.CreateAlias("Item", "i");
alias.Add("BillAddress", "ba");
alias.Add("Item", "i");
#region 账龄区间处理
DateTime dateTimeNow = DateTime.Now;
switch (range)
{
case 1:
selectCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-30)));
selectCountCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-30)));
break;
case 2:
selectCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-30)));
selectCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-60)));
selectCountCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-30)));
selectCountCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-60)));
break;
case 3:
selectCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-60)));
selectCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-90)));
selectCountCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-60)));
selectCountCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-90)));
break;
case 4:
selectCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-90)));
selectCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-120)));
selectCountCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-90)));
selectCountCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-120)));
break;
case 5:
selectCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-120)));
selectCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-150)));
selectCountCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-120)));
selectCountCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-150)));
break;
case 6:
selectCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-150)));
selectCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-180)));
selectCountCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-150)));
selectCountCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-180)));
break;
case 7:
selectCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-180)));
selectCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-210)));
selectCountCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-180)));
selectCountCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-210)));
break;
case 8:
selectCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-210)));
selectCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-360)));
selectCountCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-210)));
selectCountCriteria.Add(Expression.Ge("EffectiveDate", dateTimeNow.AddDays(-360)));
break;
case 9:
selectCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-360)));
selectCountCriteria.Add(Expression.Lt("EffectiveDate", dateTimeNow.AddDays(-360)));
break;
}
#endregion
selectCriteria.Add(Expression.Eq("i.Code", billAgingView.Item.Code));
selectCountCriteria.Add(Expression.Eq("i.Code", billAgingView.Item.Code));
selectCriteria.Add(Expression.Eq("ba.Code", billAgingView.BillAddress.Code));
selectCountCriteria.Add(Expression.Eq("ba.Code", billAgingView.BillAddress.Code));
DetailEvent((new object[] { selectCriteria, selectCountCriteria, alias }), null);
}
public virtual void UpdateBillAgingView(BillAgingView entity)
{
entityDao.UpdateBillAgingView(entity);
}
public virtual void CreateBillAgingView(BillAgingView entity)
{
entityDao.CreateBillAgingView(entity);
}
public virtual void DeleteBillAgingView(BillAgingView entity)
{
Delete(entity);
}
public virtual void UpdateBillAgingView(BillAgingView entity)
{
Update(entity);
}
public virtual void CreateBillAgingView(BillAgingView entity)
{
Create(entity);
}
