private void GetDaybalanceList(SeasonInterest si)
{
DayBalance db = new DayBalance();
db.DB_ID = si.SI_ID;
db.DB_Time = si.SI_Time.Value.AddMonths(-3);//季度结息
ObservableCollection <DayBalance> tempList = new ObservableCollection <DayBalance>();
MoreInterestList.Clear();
foreach (DayBalance item in InterestClient.SelectJG_DayBalanceInfo(db))
{
if (item.DB_Time < selectedSeanson.SI_Time)
{
tempList.Add(item);
}
else
{
FundsRegulatoryClient.SqlTransSvr.DayBalance tranbalance = new FundsRegulatoryClient.SqlTransSvr.DayBalance();
tranbalance.DB_Balance = item.DB_Balance;
tranbalance.DB_InterestRate = item.DB_InterestRate;
tranbalance.DB_ID = item.DB_ID;
tranbalance.ID = item.ID;
MoreInterestList.Add(tranbalance);
}
}
DayBalanceList = tempList;
}
public bool Update_DbAndPF(DayBalance db, FundPayment obj, RefundTrade rt)
{
BaseDao.SqlMap.BeginTransaction();
daoPay.Update(obj);
daort.Add(rt);
daoday.Update(db);
try
{
BaseDao.SqlMap.CommitTransaction();
return(true);
}
catch
{
BaseDao.SqlMap.RollBackTransaction();
return(false);
}
}
public bool CreateAccountSIDB(JG_AccountManageInfo acc, SeasonInterest si, DayBalance db, int i)//1代表插入2 代表更新
{
BaseDao.SqlMap.BeginTransaction();
if (si != null)
{
if (i == 1)
{
daoacc.Add(acc); daoseasion.Add(si);
}
else
{
daoacc.Update(acc); daoseasion.Update(si);
}
}
else
{
if (i == 1)
{
daoacc.Add(acc);
}
else
{
daoacc.Update(acc);
}
}
if (db != null)
{
daoday.Add(db);
}
try
{
BaseDao.SqlMap.CommitTransaction();
return(true);
}
catch
{
BaseDao.SqlMap.RollBackTransaction();
return(false);
}
}
public bool Update_DbAndPF(DayBalance db, FundPayment obj, int i)//1 代表添加 2 代表更新
{
BaseDao.SqlMap.BeginTransaction();
if (i == 1)
{
daoPay.Add(obj);
}
else
{
daoPay.Update(obj);
}
daoday.Update(db);
try
{
BaseDao.SqlMap.CommitTransaction();
return(true);
}
catch
{
BaseDao.SqlMap.RollBackTransaction();
return(false);
}
}
public bool Update_DbAndDF(DayBalance db, DepositFund obj, int i)
{
BaseDao.SqlMap.BeginTransaction();
if (i == 1)
{
daoDeposit.Add(obj);
}
else
{
daoDeposit.Update(obj);
}
daoday.Update(db);
try
{
BaseDao.SqlMap.CommitTransaction();
return(true);
}
catch
{
BaseDao.SqlMap.RollBackTransaction();
return(false);
}
}
/// <summary>
/// 创建账户时插入季节、每日余额表
/// </summary>
/// <returns></returns>
public bool CreateAccountSIDB(FundsRegulatoryClient.SqlTransSvr.JG_AccountManageInfo acc, SeasonInterest si, DayBalance db, int i)
{
return(service.CreateAccountSIDB(acc, si, db, i));
}
/// <summary>
/// 获取所一个季度每天余额信息
/// </summary>
/// <returns></returns>
public ObservableCollection <InterestService.DayBalance> SelectJG_DayBalanceInfo(DayBalance db)
{
List <InterestService.DayBalance> temp = service.Select(db).ToList <InterestService.DayBalance>();
ObservableCollection <InterestService.DayBalance> oj = new ObservableCollection <InterestService.DayBalance>();
temp.ForEach(p => oj.Add(p));
return(oj);
}
public bool DeleteDayBalanceInfo(DayBalance del)
{
return(daoHelp.Delete(del));
}
public bool UpdateDayBalanceInfo(DayBalance upadte)
{
return(daoHelp.Update(upadte));
}
public bool AddDayBalanceInfo(DayBalance add)
{
return(daoHelp.Add(add));
}
public List <DayBalance> Select(DayBalance selectDB)
{
return(daoHelp.Select(selectDB).ToList <DayBalance>());
}
