/// <summary>
/// 有则更新无则插入绑定数据
/// </summary>
/// <param name="bankAccountBindInfo"></param>
/// <returns></returns>
public bool InsertCompanyBankAccountBind(CompanyBankAccountBindInfo bankAccountBindInfo)
{
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL_INSERT, new
{
CompanyId = bankAccountBindInfo.CompanyId,
FilialeId = bankAccountBindInfo.FilialeId,
BankAccounts = bankAccountBindInfo.BankAccounts,
AccountsNumber = bankAccountBindInfo.AccountsNumber,
WebSite = bankAccountBindInfo.WebSite,
}) > 0);
}
}
/// <summary>
/// 有则更新无则插入绑定数据
/// </summary>
/// <param name="bankAccountBindInfo"></param>
/// <returns></returns>
public bool InsertCompanyBankAccountBindWithFiliale(CompanyBankAccountBindInfo bankAccountBindInfo)
{
const string SQL = @"IF EXISTS (SELECT FilialeId FROM CompanyBankAccounts WHERE CompanyId=@CompanyId AND FilialeId=@FilialeId)
BEGIN
UPDATE CompanyBankAccounts SET BankAccountsId=@BankAccountsId WHERE CompanyId=@CompanyId AND FilialeId=@FilialeId
END
ELSE
BEGIN
INSERT INTO CompanyBankAccounts(CompanyId,FilialeId,BankAccountsId) VALUES (@CompanyId,@FilialeId,@BankAccountsId)
END;";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL, new
{
CompanyId = bankAccountBindInfo.CompanyId,
FilialeId = bankAccountBindInfo.FilialeId,
BankAccountsId = bankAccountBindInfo.BankAccountsId,
}) > 0);
}
}
