public bool Update_DbAndSI(DayBalance[] dblist, SeasonInterest obj, int i) //1 代表添加 2 代表更新
{
BaseDao.SqlMap.BeginTransaction();
if (i == 1)
{
daoseasion.Add(obj);
}
else
{
daoseasion.Update(obj);
}
foreach (DayBalance item in dblist)
{
daoday.Update(item);
}
try
{
BaseDao.SqlMap.CommitTransaction();
return(true);
}
catch
{
BaseDao.SqlMap.RollBackTransaction();
return(false);
}
}
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;
}
/// <summary>
/// 根据选中的账户读取所有季度结息表
/// </summary>
/// <param name="ami">选中的账户</param>
private void GetSeasonList(FundsRegulatoryClient.JG_AccountManageSrv.JG_AccountManageInfo ami)
{
SeasonInterest si = new SeasonInterest();
si.SI_ID = ami.AM_ID;
this.SeansonList = InterestClient.SelectJG_SeasonInterestInfo(si);
}
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);
}
}
/// <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>
/// <param name="db"></param>
/// <param name="i"></param>
/// <param name="obj"></param>
/// <returns></returns>
public bool Update_DbAndSI(List <FundsRegulatoryClient.SqlTransSvr.DayBalance> dblist, SeasonInterest obj, int i)//1 代表添加 2 代表更新
{
return(service.Update_DbAndSI(dblist.ToArray <FundsRegulatoryClient.SqlTransSvr.DayBalance>(), obj, i));
}
/// <summary>
/// 获取所有季度结息信息
/// </summary>
/// <returns></returns>
public ObservableCollection <InterestService.SeasonInterest> SelectJG_SeasonInterestInfo(SeasonInterest si)
{
ObservableCollection <InterestService.SeasonInterest> oj = null;
try
{
List <InterestService.SeasonInterest> temp = service.Select(si).ToList <InterestService.SeasonInterest>();
oj = new ObservableCollection <InterestService.SeasonInterest>();
temp.ForEach(p => oj.Add(p));
}
catch (Exception ex)
{
// throw new ArgumentNullException(ex.ToString());
}
return(oj);
}
public bool DeleteSeasonInterestInfo(SeasonInterest del)
{
return(SeasonInterestDao.Instance.Delete(del));
}
public bool UpdateSeasonInterestInfo(SeasonInterest update)
{
return(SeasonInterestDao.Instance.Update(update));
}
public bool AddSeasonInterestInfo(SeasonInterest add)
{
return(SeasonInterestDao.Instance.Add(add));
}
public List <SeasonInterest> Select(SeasonInterest selectDB)
{
return(SeasonInterestDao.Instance.Select(selectDB).ToList <SeasonInterest>());
}
//TODO:在此处添加命令
#endregion 命令定义
#region 命令方法
/// <summary>
/// 利息结算
/// </summary>
public void InterestCommandExecute()
{
bool ISinterest = false;
//if (!Check()) { return; }
if (!VMHelp.AskMessage("是否进行结息？"))
{
return;
}
if (DayBalanceList.Count < 1)
{
VMHelp.ShowMessage("当前余额表为空，无法结息", false);
return;
}
SeasonInterest si = new SeasonInterest();
si.SI_AccountNum = SelectedSeanson.SI_AccountNum;
si.SI_ID = SelectedSeanson.SI_ID;
DateTime?dt = FinancialRegulation.Tools.HelpClass.Current.SYSCONFIG.PayAccuralDate;
if (dt == null)
{
//if (dt < DateTime.Parse(DateTime.Now.ToShortDateString()))
//{
VMHelp.ShowMessage("请先设置结息日期", false);
return;
//}
}
else if (dt > DateTime.Parse(DateTime.Now.ToShortDateString()) || SelectedSeanson.SI_Time != dt.Value)
{
VMHelp.AskMessage("结息日期为" + VMHelp.SYSCONFIG.PayAccuralDate.Value.ToShortDateString() + "，不能进行结息");
return;
}
else
{
FundsRegulatoryClient.SysConfigClient client = FundsRegulatoryClient.SysConfigClient.Instance;
VMHelp.SYSCONFIG.PayAccuralDate = VMHelp.SYSCONFIG.PayAccuralDate.Value.AddMonths(3);
client.Update(VMHelp.SYSCONFIG);
}
ObservableCollection <DayBalance> temp = new ObservableCollection <DayBalance>();
ObservableCollection <FundsRegulatoryClient.SqlTransSvr.DayBalance> Tran_temp = new ObservableCollection <FundsRegulatoryClient.SqlTransSvr.DayBalance>();
decimal?money = 0;
foreach (DayBalance db in DayBalanceList)
{
db.DB_Interest = db.DB_InterestRate * db.DB_Balance / 365;
money += db.DB_Interest;
money = decimal.Parse(money.Value.ToString("f2"));
temp.Add(db);
FundsRegulatoryClient.SqlTransSvr.DayBalance Tran_db = new FundsRegulatoryClient.SqlTransSvr.DayBalance();
Tran_db.ID = db.ID;
Tran_db.DB_Interest = db.DB_Interest;
Tran_db.DB_InterestRate = db.DB_InterestRate;
Tran_temp.Add(Tran_db);
}
money = decimal.Parse(money.Value.ToString("f2"));
//结息时，将利息加到之后的余额上。
if (Tran_temp == null || Tran_temp.Count == 0)
{
return;
}
foreach (var item in MoreInterestList)
{
item.DB_Balance += money;
Tran_temp.Add(item);
}
DayBalanceList.Clear();
DayBalanceList = temp;
InterestAmount = money;
si.SI_Money = money;
si.SI_Time = SelectedSeanson.SI_Time;
si.SI_Memo = Memo;
si.SI_BankSerialNumber = VMHelp.ServiceNo;
si.SI_BankTellerID = VMHelp.UserCode;
si.SI_CertificateNum = VMHelp.BankCode + DateTime.Now.ToString("yyyyMMdd");
si.ID = SelectedSeanson.ID;
//利息消息
//Request07 request = new Request07();
//request.DepositNum = SelectedSeanson.SI_CertificateNum;
//request.BankCode = VMHelp.BankCode;
//request.BusinessCode = Tools.PublicData.InterestRecord;
//request.InterestAmount = money;
//request.ProjectCode = SelectedAccount.AccountInfo.AM_ProjectCode;
//request.RecordInstr = Memo;
////消息发送
//response = new Response07();
//try
//{
// response = SendMessage<Response07>(request, VMHelp.PointCode, VMHelp.UserCode);//发送Messageresponse.ReturnCode =="03"
//}
//catch (Exception ex)
//{
// SendExcetpion(ex);
// return;
//}
//if (response.ReturnCode != Tools.PublicData.ResponseSuccess)// && response.ReturnCode == Tools.PublicData.)
//{ VMHelp.ShowMessage(Tools.HelpClass.Current.MsgDIC[response.ReturnCode], false); return; }
//if (response.ReturnCode == Tools.PublicData.DepositSuccess && !VMHelp.AskMessage("缴款书已完成缴费,是否存数据库？"))
//{
// return;
//}
FundsRegulatoryClient.SqlTransSvr.SeasonInterest SI_temp = new FundsRegulatoryClient.SqlTransSvr.SeasonInterest();
SI_temp.SI_Money = si.SI_Money;
//SI_temp.SI_Time = si.SI_Time;
SI_temp.SI_Memo = si.SI_Memo;
SI_temp.SI_BankSerialNumber = si.SI_BankSerialNumber;//本系统产生的流水号
SI_temp.SI_BankTellerID = si.SI_BankTellerID;
SI_temp.SI_CertificateNum = si.SI_CertificateNum;
SI_temp.ID = SelectedSeanson.ID;
if (SelectedSeanson.SI_Time < DateTime.Parse(DateTime.Now.ToShortDateString()))
{
SI_temp.SI_Time = SelectedSeanson.SI_Time;
si.SI_Time = SelectedSeanson.SI_Time;
}
if (!TranClient.Update_DbAndSI(Tran_temp.ToList <FundsRegulatoryClient.SqlTransSvr.DayBalance>(), SI_temp, 2))
{
VMHelp.ShowMessage("结息失败", false);
return;
}
//foreach (DayBalance db in DayBalanceList)
//{
// InterestClient.UpdateJG_DayBalanceInfo(db);
//}
//InterestClient.UpdateJG_SeasonInterestInfo(si);
//季度结息新插入一条
int index = dg.SelectedIndex;
if (index > -1)
{
SeansonList[index] = si;
dg.SelectedIndex = index;
}
//插入一条季度结息
SeasonInterest Insert = new SeasonInterest();
Insert.ID = VMHelp.GUID;
Insert.SI_Time = DateTime.Parse(DateTime.Now.ToShortDateString()).AddMonths(3);
if (SelectedSeanson.SI_Time < DateTime.Parse(DateTime.Now.ToShortDateString()))
{
Insert.SI_Time = SelectedSeanson.SI_Time.Value.AddMonths(3);
FundsRegulatoryClient.SysConfigClient client = FundsRegulatoryClient.SysConfigClient.Instance;
VMHelp.SYSCONFIG.PayAccuralDate = Insert.SI_Time;
client.Update(VMHelp.SYSCONFIG);
}
Insert.SI_AccountNum = si.SI_AccountNum;
Insert.SI_ID = si.SI_ID;
this.SeansonList.Add(Insert);
InterestClient.AddJG_SeasonInterestInfo(Insert);
//if (ISinterest)
//{
//if (!VMHelp.AskMessage("是否将 " + VMHelp.SYSCONFIG.PayAccuralDate.Value.ToShortDateString() + " 设置为新的结息日期"))
//{
// return;
//}
// }
VMHelp.ShowMessage(true);
FlushExecute();
}