/// <summary>
/// 添加未交费记录
/// </summary>
public override void OKExecute()
{
// 判断是否查询并且正确
if (!IsSearch)
{
VMHelp.ShowMessage("未进行缴款凭证编号的查询，不可提交", false);
return;
}
DepositFund temp = new DepositFund();
temp.BusinessCode = FinancialRegulation.Tools.PublicData.QueryFundDeposit;
temp.DepositNum = SearchInfo.DepositID;
temp.DepositAccount = CurrentObj.DepositAccount;
//temp.FirmName = CurrentObj.FirmName;
temp.DepositType = CurrentObj.DepositType;
temp.DepositAmount = CurrentObj.DepositAmount;
temp.PurchaserName = CurrentObj.PurchaserName;
temp.PurchaserID = CurrentObj.PurchaserID;
temp.ProjectCode = CurrentObj.ProjectCode;
// temp.DepositTime = DateTime.Parse(VMHelp.NowTime);
temp.CheckTime = DateTime.Parse(VMHelp.NowTime);
temp.DepositState = Tools.PublicData.DepositB;
temp.BankSiteID = VMHelp.PointCode;
temp.BankTellerID = VMHelp.UserCode;//柜员号
temp.FirmName = CurrentObj.FirmName;
temp.ID = VMHelp.GUID;
if (!deClient.Add(temp))
{
VMHelp.ShowMessage("信息存储失败", false);
}
OBModels.Add(temp);
windowOK();
}
public ReverseTrade(DepositFund df, ObservableCollection <DepositFund> models)
{
InitializeComponent();
ViewModel.Fund.ReverseTradeVM vm = new ViewModel.Fund.ReverseTradeVM(df, models);
//vm.windowClose = CloseWindow;
//vm.windowOK = OpenNewWindow;
this.DataContext = vm;
}
/// <summary>
/// 结息
/// </summary>
/// <returns></returns>
public bool PayAccrual(DepositFund accrual)
{
if (accrual == null)
{
throw new NullReferenceException("结息对象为空");
}
// accrual._DE_cklb = "1";//存款类别 1 类别
//accrual._DE_ckxz = "9";//存款性质 9 结息
return(Add(accrual)); //添加
}
/// <summary>
/// 查询结息
/// </summary>
/// <param name="m">筛选实例</param>
/// <returns>对象集合</returns>
public List <DepositFund> SelectPayAccrual()
{
//资金性质 9 结息 存款类别1 存款
DepositFund info = new DepositFund()
{
// _DE_ckxz = "9",
//_DE_cklb = "1"
};
return(service.Selectn(info).ToList <DepositFund>());
}
public override BaseMessageResponse MeaasgeOperate()
{
BaseMessageResponse responseMsg = GetReponseMessage();
responseMsg.SerialNo = FundsRegulatoryClient.BasicFunctionClient.Current.GetSerialNo().ToString();
responseMsg.BusinessTime = FundsRegulatoryClient.BasicFunctionClient.Current.GetServerTime().ToString(Common.SysConst.BUSINESSDATEFORMATE);
JG_AdjustInfo jaInfo = new JG_AdjustInfo();
DepositFund jdInfo = new DepositFund();
JG_SpvProtocol jgInfo = new JG_SpvProtocol();
jgInfo.SP_QYZH = ReceiveAccount;
jaInfo.JA_Xybh = FundsRegulatoryClient.JG_SpvProtocolClient.Instance.Select(jgInfo)[0].SP_XYBH;
if (jaInfo.JA_FmXybh == "" || jaInfo.JA_FmXybh == null)
{
responseMsg.ExceptionCode = "02";
responseMsg.ExceptionMessage = "收款账户错误!";
}
jgInfo.SP_QYZH = PaymentAccount;
jaInfo.JA_FmXybh = FundsRegulatoryClient.JG_SpvProtocolClient.Instance.Select(jgInfo)[0].SP_XYBH;
if (jaInfo.JA_Xybh == "" || jaInfo.JA_Xybh == null)
{
responseMsg.ExceptionCode = "03";
responseMsg.ExceptionMessage = "付款账户错误!";
}
// jdInfo._DE_cklsh = DepositNo;
jaInfo.JA_ID = Guid.NewGuid().ToString();
//jaInfo.JA_Xybh = PactNo;
//jaInfo.JA_FmXybh = FundsRegulatoryClient.JG_DepositClient.Instance.Select(jdInfo)[0]._DE_xybh;
// jaInfo.JA_FmID = FundsRegulatoryClient.JG_DepositClient.Instance.Select(jdInfo)[0]._DE_ID;
jaInfo.JA_FmCklsh = DepositNo;
if (jaInfo.JA_FmID == "" || jaInfo.JA_FmID == null)
{
responseMsg.ExceptionCode = "04";
responseMsg.ExceptionMessage = "存款流水号错误!";
}
else
{
if (FundsRegulatoryClient.JG_AdjustClient.Current.UpdateJG_AdjustByCklsh(jaInfo))
{
responseMsg.ExceptionCode = "01";
}
}
return(responseMsg);
}
public bool Update_DbAndDF(DayBalance db, DepositFund obj, RefundTrade rt)
{
BaseDao.SqlMap.BeginTransaction();
daoDeposit.Update(obj);
daort.Add(rt);
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>
/// <param name="db"></param>
/// <param name="i"></param>
/// <param name="obj"></param>
/// <returns></returns>
public bool Update_DbAndDF(FundsRegulatoryClient.SqlTransSvr.DayBalance db, RefundTrade rt, DepositFund obj)
{
return(service.Update_DbAndDF(db, obj, rt));
}
public FundInfoAddToEdit(Message.NewMessage.Response.Response02 DepositResponse, DepositFund df, ObservableCollection <DepositFund> models)
{
InitializeComponent();
ViewModel.FundInfoEditVM vm = new ViewModel.FundInfoEditVM(DepositResponse, df, models);
//vm.windowClose = CloseWindow;
//vm.windowOK = OpenNewWindow;
this.DataContext = vm;
}
public bool Update(DepositFund o)
{
return(daoHelp.Update(o));
}
/// <summary>
/// 查看特定对象 存款
/// </summary>
/// <param name="m">筛选实例</param>
/// <returns>对象集合</returns>
public List <DepositFund> Select(DepositFund m)
{
return(service.Select(m).ToList <DepositFund>());
}
/// <summary>
/// 删除对象 存款
/// </summary>
/// <param name="m"></param>
/// <returns>完成状态</returns>
public bool Delete(DepositFund m)
{
return(service.Delete(m));
}
/// <summary>
/// 更新对象 存款
/// </summary>
/// <param name="m">更新的对象</param>
/// <returns>完成状态</returns>
public bool Update(DepositFund m)
{
return(service.Update(m));
}
/// <summary>
/// 添加对象 存款
/// </summary>
/// <param name="m"></param>
/// <returns>完成状态</returns>
public bool Add(DepositFund m)
{
return(service.Add(m));
}
public bool Add(DepositFund o)
{
return(daoHelp.Add(o));
}
/// <summary>
///更新每日余额和存款表的数据库事务
/// </summary>
/// <param name="db"></param>
/// <param name="i"></param>
/// <param name="obj"></param>
/// <returns></returns>
public bool Update_DbAndDF(FundsRegulatoryClient.SqlTransSvr.DayBalance db, DepositFund obj, int i)
{
return(service.Update_DbAndDF(db, obj, i));
}
public bool Delete(DepositFund o)
{
return(daoHelp.Delete(o));
}
/// <summary>
/// 更新当日余额,存款表状态，支付表状态,添加退票信息
/// </summary>
/// <returns></returns>
private bool DayBalanceAndRefundAndState()
{
FundsRegulatoryClient.JG_AccountManageSrv.JG_AccountManageInfo ami = new FundsRegulatoryClient.JG_AccountManageSrv.JG_AccountManageInfo();
FundsRegulatoryClient.JG_AccountManageClient accountClient = FundsRegulatoryClient.JG_AccountManageClient.Instance;
FundsRegulatoryClient.InterestManageClient InterestClient = FundsRegulatoryClient.InterestManageClient.Instance;
// FundsRegulatoryClient.RefundTradeClient refundClient=fun
ami.AM_JgAccount = CurrentObj.AccountName;
ObservableCollection <FundsRegulatoryClient.JG_AccountManageSrv.JG_AccountManageInfo> acc = accountClient.Select(ami);
if (acc.Count < 1)
{
VMHelp.ShowMessage("账户不存在", false);
return(false);
}
FundsRegulatoryClient.InterestService.DayBalance db = new FundsRegulatoryClient.InterestService.DayBalance();
FundsRegulatoryClient.SqlTransSvr.DayBalance sqldb = new FundsRegulatoryClient.SqlTransSvr.DayBalance();
sqldb.DB_ID = db.DB_ID = acc[0].AM_ID;
// db.DB_AccountNum = model.DepositAccount;
sqldb.DB_Time = db.DB_Time = DateTime.Parse(DateTime.Now.ToShortDateString());
ObservableCollection <FundsRegulatoryClient.InterestService.DayBalance> dblist = new ObservableCollection <FundsRegulatoryClient.InterestService.DayBalance>();
dblist = InterestClient.SelectJG_DayBalanceInfo(db);
if (dblist.Count > 0)
{
FundsRegulatoryClient.SqlTransSvr.RefundTrade temp = new FundsRegulatoryClient.SqlTransSvr.RefundTrade();
// CurrentObj.ID = temp.ID = VMHelp.GUID;
temp.BussinessCode = FinancialRegulation.Tools.PublicData.Refund;
temp.SerialNum = VMHelp.ServiceNo;
temp.BankCode = VMHelp.BankCode;
CurrentObj.Bankwebsite = temp.Bankwebsite = VMHelp.PointCode;
CurrentObj.AccountTeller = temp.AccountTeller = VMHelp.UserCode;
CurrentObj.RefundTime = temp.RefundTime = DateTime.Now;
temp.AccountName = CurrentObj.AccountName;
temp.BankSerialNum = CurrentObj.BankSerialNum;
temp.PaymentID = CurrentObj.PaymentID;
temp.RefundInstr = CurrentObj.RefundInstr;
temp.RefundAmount = CurrentObj.RefundAmount;
temp.RT_Type = RefundType;
if (CurrentObj.BussinessCode == FinancialRegulation.Tools.PublicData.FundDeposit)
{
sqldb.DB_Balance = db.DB_Balance = dblist[0].DB_Balance;
sqldb.DB_InterestRate = db.DB_InterestRate = dblist[0].DB_InterestRate;
sqldb.DB_Balance = db.DB_Balance = db.DB_Balance - CurrentObj.RefundAmount;
sqldb.ID = db.ID = dblist[0].ID;
temp.AccountID = acc[0].AM_ID;
DepositFund dftemp = (DepositFund)UpdatePayOrDeposit(1);
temp.ID = VMHelp.GUID;
if (sqlTran.Update_DbAndDF(sqldb, temp, dftemp))
{
return(true);
}
else
{
return(false);
}
}
else
{
sqldb.DB_Balance = db.DB_Balance = dblist[0].DB_Balance;
sqldb.DB_InterestRate = db.DB_InterestRate = dblist[0].DB_InterestRate;
sqldb.DB_Balance = db.DB_Balance = db.DB_Balance + CurrentObj.RefundAmount;
sqldb.ID = db.ID = dblist[0].ID;
temp.AccountID = acc[0].AM_ID;
FundPayment fptemp = (FundPayment)UpdatePayOrDeposit(2);
temp.ID = VMHelp.GUID;
if (sqlTran.Update_DbAndPF(sqldb, fptemp, temp))
{
return(true);
}
else
{
return(false);
}
}
}
else
{
return(false);
}
}
public List <DepositFund> Selectn(DepositFund info)
{
return(daoHelp.Selectn(info) as List <DepositFund>);
}
public List <DepositFund> Select(DepositFund o)
{
return(daoHelp.Select(o) as List <DepositFund>);
}
public FundInfoEditVM(Response02 DepositResponse, DepositFund df, ObservableCollection <DepositFund> Models)
{
this.DepositResponse = DepositResponse;
this.df = df;
this.Models = Models;
}
public ReverseTradeVM(DepositFund df, ObservableCollection <DepositFund> Models)
{
this.ReverseResponse = new Response06();
this.df = df;
this.Models = Models;
}
