/// <summary> /// 根据子公司编号获取导出扣款指令配置 /// </summary> /// <param name="serid"></param> /// <returns></returns> private Dictionary <int, DeductCommand> GetDeductCommand(int serid) { var dic = new Dictionary <int, DeductCommand>(); string sql = "SELECT * FROM [dbo].[DeductCommand] WHERE ServiceSideID = {0}".StringFormat(serid); PayBankDal dal = new PayBankDal(); var list = dal.GetDeductCommand(sql); foreach (var cmd in list) { dic.Add(cmd.LendingSideID, cmd); } return(dic); }
/// <summary> /// 根据子公司编号获取导出扣款文件名 /// </summary> /// <param name="serid"></param> /// <returns></returns> private Dictionary <int, string> GetTitles(int serid, string lockkey) { var dic = new Dictionary <int, string>(); string sql = "SELECT * FROM [dbo].[DeductCommand] WHERE ServiceSideID = {0}".StringFormat(serid); PayBankDal dal = new PayBankDal(); var list = dal.GetDeductCommand(sql); List <BankAccount> lstBankAccount = Singleton <BankAccountsCache> .Instance.BankAccounts; foreach (var cmd in list) { dic.Add(cmd.LendingSideID, lstBankAccount.FirstOrDefault (p => p.BankAccountID == cmd.LendingSideID).AccountNumber + "_" + lockkey); } return(dic); }