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