/// <summary>
/// 转换导出的内容
/// </summary>
/// <param name="list"></param>
/// <param name="num"></param>
/// <param name="customer"></param>
/// <param name="enums"></param>
/// <returns></returns>
public override string[] GetImportExcelItem(PayBankExportItem item, decimal amount,
List <BankAccount> bankaccounts, List <Enumeration> enums,
BankAccount bka, bool isgurante = false)
{
string[] strlist =
{
"",
item.ContractNo.Trim(),
item.SavingUser.Trim(),
item.IdenNo.Trim(),
item.LoanCapital.ToString(),
item.FWF.ToString(),
item.DBF.ToString(),
item.FWFKS.ToString(),
item.BJ.ToString(),
item.LX.ToString(),
item.BXKS.ToString(),
item.FX.ToString(),
amount.ToString(),
item.LoanPeriod.ToString(),
item.ServiceRate.ToPercent(),
item.SavingCard.Trim(),
bka.AreaName.Trim(),
item.LoanTime.ToString("yyyy年MM月"),
item.BillMonth == null ?
DateTime.Now.Day < 21?DateTime.Now.AddMonths(-1).ToString("yyyy年MM月"): DateTime.Now.ToString("yyyy年MM月")
:item.BillMonth.Replace("/", "年") + "月"
};
return(strlist);
}
/// <summary>
/// 转换导出的内容
/// </summary>
/// <param name="list"></param>
/// <param name="num"></param>
/// <param name="customer"></param>
/// <param name="enums"></param>
/// <returns></returns>
public override string[] GetImportExcelItem(PayBankExportItem item, decimal amount,
List <BankAccount> bankaccounts, List <Enumeration> enums, BankAccount bka, bool isgurante = false)
{
string[] strlist =
{
"",
item.ContractNo.Trim(),
item.SavingUser.Trim(),
item.IdenNo.Trim(),
item.LoanCapital.ToString(),
item.BJ.ToString(),
item.LX.ToString(),
item.BXKS.ToString(),
item.FX.ToString(),
amount.ToString(),
item.InterestRate.ToPercent(),
item.LoanPeriod.ToString(),
item.SavingCard.Trim(),
bka.AreaName.Trim(),
item.LoanTime.ToString("yyyy年MM月"),
item.BillMonth.Trim().Replace("/", "年") + "月",
GetSpouse(item.DunLevel)
};
return(strlist);
}
/// <summary>
/// 模版格式
/// </summary>
/// <param name="bill"></param>
/// <param name="Amount"></param>
/// <returns></returns>
public override byte[] FomartTemplate(PayBankExportItem item, decimal Amount,
List <BankAccount> banks, BankAccount account, bool IsServ = false)
{
return(Encoding.GetEncoding("GBK").GetBytes(string.Format("{0}|{1}|{2}|\r\n"
, item.SavingCard.Trim()
, Amount
, item.SavingUser.Trim())));
}
/// <summary>
/// 模版格式
/// </summary>
/// <param name="bill"></param>
/// <param name="Amount"></param>
/// <returns></returns>
public override byte[] FomartTemplate(PayBankExportItem item, decimal amount,
List <BankAccount> banks, BankAccount account, bool IsServ = false)
{
return(Encoding.GetEncoding("GBK").GetBytes(string.Format("{0}|{1}|{2}|{3}\r\n"
, IsServ ? item.ConstructSedNo.Trim() ?? string.Empty
: item.ConstructionBankNo.Trim() ?? string.Empty
, item.SavingCard.Trim()
, item.SavingUser.Trim()
, amount
)));
}
public override byte[] FomartTemplate(PayBankExportItem item, decimal amount
, List <BankAccount> banks, BankAccount account, bool IsServ = false)
{
return(Encoding.GetEncoding("GBK").GetBytes(string.Format("{0}|{1}|{2}|{3}|{4}|{5}\r\n"
, item.SavingCard.Trim()
, item.SavingUser.Trim()
, amount
, item.ContractNo.Trim()
, GetSpouse(item.DunLevel)
, item.LoanCapital
)));
}
public override byte[] FomartTemplate(PayBankExportItem item, decimal amount
, List <BankAccount> banks, List <Customer> customers, BankAccount account, bool IsServ = false)
{
string mobile = customers.FirstOrDefault(o => o.IdenNo == item.IdenNo) == null ?
"" : customers.FirstOrDefault(o => o.IdenNo == item.IdenNo).Mobile;
return(Encoding.GetEncoding("GBK").GetBytes(
string.Format("{0}|{1}|{2}|{3}|{4}|{5}|{6}|{7}|{8}|{9}|{10}" + "\r\n"
, "RMB"
, ""
, account.ApplicationNo.Trim()
, account.AccountNumber.Trim()
, amount
, item.ContractNo.Trim()
, ""
, mobile.Trim()
, ""
, account.BankKey == "BANKLIST/GONGHANG" ? "是" : "否"
, item.SavingCard)));
}
/// <summary>
/// 转换导出的内容
/// </summary>
/// <param name="list"></param>
/// <param name="num"></param>
/// <param name="customer"></param>
/// <param name="enums"></param>
/// <returns></returns>
public override string[] GetImportExcelItem(PayBankExportItem item, decimal amount,
List <Customer> customer, List <BankAccount> bankaccounts, List <Enumeration> enums,
BankAccount bka, bool isgurante = false)
{
string mobile = customer.FirstOrDefault(o => o.IdenNo == item.IdenNo) == null ?
"" : customer.FirstOrDefault(o => o.IdenNo == item.IdenNo).Mobile;
string[] strlist =
{
"RMB",
"",
bka.ApplicationNo.Trim(),
bka.AccountNumber.Trim(),
amount.ToAmtString(),
item.ContractNo.Trim(),
"",
mobile.Trim(),
"",
bka.BankKey == "BANKLIST/GONGHANG"?"是":"否",
item.SavingCard.Trim()
};
return(strlist);
}
/// <summary>
/// 转换导出的内容
/// </summary>
/// <param name="list"></param>
/// <param name="num"></param>
/// <param name="customer"></param>
/// <param name="enums"></param>
/// <returns></returns>
public override string[] GetImportExcelItem(PayBankExportItem item, decimal amount,
List <BankAccount> bankaccounts, List <Enumeration> enums, BankAccount bka, bool isgurante = false)
{
string[] strlist =
{
"RMB",
"",
"工行",
item.SavingCard.Trim(),
item.IdenNo.Trim(),
item.SavingUser.Trim(),
bka.BankName.Trim(),
bka.ProvinceName.Trim(),
bka.AreaName.Trim(),
bka.AreaCode.Trim(),
bka.SavingCard.Trim(),
bka.ApplicationNo.Trim(),
enums.FirstOrDefault(p => p.FullKey == bka.CompanyKey).Name,
amount.ToString(),
//GetSpouse(item.DunLevel),
item.ContractNo, "","", "", "", ""
};
return(strlist);
}
public abstract string[] GetImportExcelItem(PayBankExportItem item, decimal amount,
List <BankAccount> bankaccounts, List <Enumeration> enums, BankAccount bankaccount, bool isgurante = false);
/// <summary>
/// 设置导出格式
/// </summary>
/// <param name="bill"></param>
/// <param name="Amount"></param>
/// <returns></returns>
public abstract byte[] FomartTemplate(PayBankExportItem item, decimal Amount,
List <BankAccount> banks, BankAccount account, bool IsServ = false);
