/// <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);
}